diff options
Diffstat (limited to 'app')
| -rw-r--r-- | app/Module/FamilyTreeFavorites/Schema/Migration2.php | 4 | ||||
| -rw-r--r-- | app/Module/FamilyTreeNews/Schema/Migration2.php | 4 | ||||
| -rw-r--r-- | app/Schema/Migration2.php | 2 |
3 files changed, 5 insertions, 5 deletions
diff --git a/app/Module/FamilyTreeFavorites/Schema/Migration2.php b/app/Module/FamilyTreeFavorites/Schema/Migration2.php index cbaed3c483..2b152a2f5a 100644 --- a/app/Module/FamilyTreeFavorites/Schema/Migration2.php +++ b/app/Module/FamilyTreeFavorites/Schema/Migration2.php @@ -37,8 +37,8 @@ class Migration2 implements MigrationInterface { try { Database::exec( "ALTER TABLE `##favorite`" . - " ADD FOREIGN KEY favorite_fk1 (user_id ) REFERENCES `##user` (user_id) ON DELETE CASCADE," . - " ADD FOREIGN KEY favorite_fk2 (gedcom_id) REFERENCES `##gedcom` (gedcom_id) ON DELETE CASCADE" + " ADD FOREIGN KEY `##favorite_fk1` (user_id ) REFERENCES `##user` (user_id) ON DELETE CASCADE," . + " ADD FOREIGN KEY `##favorite_fk2` (gedcom_id) REFERENCES `##gedcom` (gedcom_id) ON DELETE CASCADE" ); } catch (PDOException $ex) { // Already updated? diff --git a/app/Module/FamilyTreeNews/Schema/Migration2.php b/app/Module/FamilyTreeNews/Schema/Migration2.php index 7e1a4efe93..d962c0feee 100644 --- a/app/Module/FamilyTreeNews/Schema/Migration2.php +++ b/app/Module/FamilyTreeNews/Schema/Migration2.php @@ -36,8 +36,8 @@ class Migration2 implements MigrationInterface { try { Database::exec( "ALTER TABLE `##news`" . - " ADD FOREIGN KEY news_fk1 (user_id ) REFERENCES `##user` (user_id) ON DELETE CASCADE," . - " ADD FOREIGN KEY news_fk2 (gedcom_id) REFERENCES `##gedcom` (gedcom_id) ON DELETE CASCADE" + " ADD FOREIGN KEY `##news_fk1` (user_id ) REFERENCES `##user` (user_id) ON DELETE CASCADE," . + " ADD FOREIGN KEY `##news_fk2` (gedcom_id) REFERENCES `##gedcom` (gedcom_id) ON DELETE CASCADE" ); } catch (PDOException $ex) { // Already updated? diff --git a/app/Schema/Migration2.php b/app/Schema/Migration2.php index 10ddff6688..a738583149 100644 --- a/app/Schema/Migration2.php +++ b/app/Schema/Migration2.php @@ -37,7 +37,7 @@ class Migration2 implements MigrationInterface { " imported BOOLEAN NOT NULL DEFAULT FALSE," . " PRIMARY KEY (gedcom_chunk_id)," . " KEY ix1 (gedcom_id, imported)," . - " FOREIGN KEY fk1 (gedcom_id) REFERENCES `##gedcom` (gedcom_id)" . + " FOREIGN KEY `##gedcom_chunk_fk1` (gedcom_id) REFERENCES `##gedcom` (gedcom_id)" . ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); |