[PR #52] [MERGED] DB-Schema: Add Foreign Keys for faster queries #59

New issue

Closed

opened 2026-02-27 09:12:48 +03:00 by kerem · 0 comments

kerem commented

2026-02-27 09:12:48 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/maelstrom-cms/odin/pull/52
Author: @dweissengruber
Created: 3/4/2021
Status: ✅ Merged
Merged: 3/22/2021
Merged by: @OwenMelbz

Base: master ← Head: mysql_performance_improvements

📝 Commits (4)

e68e465 ✔️ DB-Schema: Add Foreign Keys for faster queries
65d45ea 🐛 Fix website_id datatype
d8fd59b ✨ Update migration, ensure increment
df85954 Revert "✨ Update migration, ensure increment"

📊 Changes

1 file changed (+104 additions, -0 deletions)

View changed files

➕ database/migrations/2021_03_04_095453_add_foreign_keys.php (+104 -0)

📄 Description

Reduce mysql query execution time drastically by utilizing foreign keys.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/maelstrom-cms/odin/pull/52 **Author:** [@dweissengruber](https://github.com/dweissengruber) **Created:** 3/4/2021 **Status:** ✅ Merged **Merged:** 3/22/2021 **Merged by:** [@OwenMelbz](https://github.com/OwenMelbz) **Base:** `master` ← **Head:** `mysql_performance_improvements` --- ### 📝 Commits (4) - [`e68e465`](https://github.com/maelstrom-cms/odin/commit/e68e46541f62e8ca2ab348eab8ab69ac37bca0e1) ✔️ DB-Schema: Add Foreign Keys for faster queries - [`65d45ea`](https://github.com/maelstrom-cms/odin/commit/65d45ea787decc1c329c72689669d5f11740161b) 🐛 Fix website_id datatype - [`d8fd59b`](https://github.com/maelstrom-cms/odin/commit/d8fd59b7390e32f70dadebb7e00ea709434ab004) ✨ Update migration, ensure increment - [`df85954`](https://github.com/maelstrom-cms/odin/commit/df859541abb8ffd7f657acf099ab05c956d4f1d3) Revert "✨ Update migration, ensure increment" ### 📊 Changes **1 file changed** (+104 additions, -0 deletions) <details> <summary>View changed files</summary> ➕ `database/migrations/2021_03_04_095453_add_foreign_keys.php` (+104 -0) </details> ### 📄 Description Reduce mysql query execution time drastically by utilizing foreign keys. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>