summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--UPGRADING6
1 files changed, 3 insertions, 3 deletions
diff --git a/UPGRADING b/UPGRADING
index 71b3d1d..a45c970 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -86,11 +86,11 @@ ALTER TABLE Packages
7. Add package base references to the Packages table:
----
+ALTER TABLE Packages ADD COLUMN PackageBaseID INTEGER UNSIGNED NULL;
+UPDATE Packages SET PackageBaseID = ID;
ALTER TABLE Packages
- ADD COLUMN PackageBaseID INTEGER UNSIGNED NULL,
+ MODIFY PackageBaseID INTEGER UNSIGNED NOT NULL,
ADD FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE;
-UPDATE Packages SET PackageBaseID = ID;
-ALTER TABLE Packages MODIFY PackageBaseID INTEGER UNSIGNED NOT NULL;
----
8. Delete foreign keys from PackageVotes, PackageComments and CommentNotify: