summaryrefslogtreecommitdiffstats
path: root/UPGRADING
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2011-02-27 16:16:40 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-27 16:20:02 +0100
commit40ccf77ca0c6745d8b75e925e915cdf51a924312 (patch)
tree53bb39caebf188f509bbdce6b735f6868db91658 /UPGRADING
parentac632980c3789cd99a80d61861b8820ddad14704 (diff)
downloadaurweb-40ccf77ca0c6745d8b75e925e915cdf51a924312.tar.xz
Define "PackageComments.DelUsersID" as "NULL".
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'UPGRADING')
-rw-r--r--UPGRADING3
1 files changed, 3 insertions, 0 deletions
diff --git a/UPGRADING b/UPGRADING
index 7227479..4a6aec4 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