summaryrefslogtreecommitdiffstats
path: root/upgrading
diff options
context:
space:
mode:
Diffstat (limited to 'upgrading')
-rw-r--r--upgrading/4.1.0.txt5
1 files changed, 3 insertions, 2 deletions
diff --git a/upgrading/4.1.0.txt b/upgrading/4.1.0.txt
index e9545ff..439562f 100644
--- a/upgrading/4.1.0.txt
+++ b/upgrading/4.1.0.txt
@@ -13,6 +13,7 @@ package out-of-date:
----
ALTER TABLE PackageBases
- ADD COLUMN FlaggerUID BIGINT UNSIGNED NULL DEFAULT NULL,
- ADD COLUMN FlaggerComment VARCHAR(255) NOT NULL;
+ ADD COLUMN FlaggerUID INTEGER UNSIGNED NULL DEFAULT NULL,
+ ADD COLUMN FlaggerComment VARCHAR(255) NOT NULL,
+ ADD FOREIGN KEY (FlaggerUID) REFERENCES Users(ID) ON DELETE SET NULL;
----