From 40ccf77ca0c6745d8b75e925e915cdf51a924312 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Sun, 27 Feb 2011 16:16:40 +0100 Subject: Define "PackageComments.DelUsersID" as "NULL". Signed-off-by: Lukas Fleischer --- UPGRADING | 3 +++ 1 file changed, 3 insertions(+) (limited to 'UPGRADING') diff --git a/UPGRADING b/UPGRADING index 72274793..4a6aec4b 100644 --- a/UPGRADING +++ b/UPGRADING @@ -25,6 +25,9 @@ ALTER TABLE TU_VoteInfo ALTER TABLE TU_Votes ADD FOREIGN KEY (VoteID) REFERENCES TU_VoteInfo(ID) ON DELETE CASCADE, ADD FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE; +ALTER TABLE PackageComments + MODIFY DelUsersID INTEGER UNSIGNED NULL DEFAULT NULL; +UPDATE PackageComments SET DelUsersID = NULL WHERE DelUsersID = 0; ---- From 1.7.0 to 1.8.0 -- cgit v1.2.3-24-g4f1b