summaryrefslogtreecommitdiff
path: root/upgrading/4.1.0.txt
diff options
context:
space:
mode:
authorMarcel Korpel <marcel.korpel@gmail.com>2015-09-18 23:12:13 +0200
committerLukas Fleischer <lfleischer@archlinux.org>2015-09-19 15:19:16 +0200
commit0478a0a2dade87e9bce71e9839b791c67fddfdc8 (patch)
treec199ba43cb5cad277a2248c1c3eba407845ef825 /upgrading/4.1.0.txt
parent9cae17ff7c4eeb7af66e06ba38de3b64d08dec2f (diff)
Fix type of FlaggerUID in table PackageBases
Signed-off-by: Marcel Korpel <marcel.korpel@gmail.com> Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading/4.1.0.txt')
-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;
----