From 0478a0a2dade87e9bce71e9839b791c67fddfdc8 Mon Sep 17 00:00:00 2001 From: Marcel Korpel Date: Fri, 18 Sep 2015 23:12:13 +0200 Subject: Fix type of FlaggerUID in table PackageBases Signed-off-by: Marcel Korpel Signed-off-by: Lukas Fleischer --- upgrading/4.1.0.txt | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'upgrading') diff --git a/upgrading/4.1.0.txt b/upgrading/4.1.0.txt index e9545ffb..439562f7 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; ---- -- cgit v1.2.3-24-g4f1b