[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    [synchrotron] sql: Fix foreign key.
From:       Andreas Cord-Landwehr <cordlandwehr () kde ! org>
Date:       2016-06-30 18:40:17
Message-ID: E1bIgsr-00013I-Uc () code ! kde ! org
[Download RAW message or body]

Git commit 4b558e6ae8c94298dc69ea82b940e0f8c0f46cfd by Andreas Cord-Landwehr.
Committed on 30/06/2016 at 17:53.
Pushed by cordlandwehr into branch 'master'.

Fix foreign key.

M  +1    -1    sql/mysql.sql

http://commits.kde.org/synchrotron/4b558e6ae8c94298dc69ea82b940e0f8c0f46cfd

diff --git a/sql/mysql.sql b/sql/mysql.sql
index 25240ac..8df8ff9 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -57,7 +57,7 @@ CREATE TABLE content
     externalPackage     BOOL    NOT NULL DEFAULT FALSE,
     CONSTRAINT content_pk PRIMARY KEY (id, provider),
     FOREIGN KEY (provider) REFERENCES providers(id) ON DELETE CASCADE,
-    FOREIGN KEY (category) REFERENCES providers(id) ON DELETE SET NULL
+    FOREIGN KEY (category) REFERENCES categories(id) ON DELETE SET NULL
 ) ENGINE=INNODB;
 
 -- DROP TABLE accesscounts;

[prev in list] [next in list] [prev in thread] [next in thread]