diff options
Diffstat (limited to 'UPGRADING')
-rw-r--r-- | UPGRADING | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -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: |