summaryrefslogtreecommitdiff
path: root/UPGRADING
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2011-02-27 17:12:43 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-27 19:46:19 +0100
commit1e3fa38de5f940fef474fc3961c70b357b976308 (patch)
tree3474eadc3354f5312f245425deb9a2bf1fe64114 /UPGRADING
parent84c2491e63ef2797084f9378674d3e38248b7c24 (diff)
Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL".
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'UPGRADING')
-rw-r--r--UPGRADING5
1 files changed, 5 insertions, 0 deletions
diff --git a/UPGRADING b/UPGRADING
index 56ab119..392090d 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -28,6 +28,11 @@ ALTER TABLE TU_Votes
ALTER TABLE PackageComments
MODIFY DelUsersID INTEGER UNSIGNED NULL DEFAULT NULL;
UPDATE PackageComments SET DelUsersID = NULL WHERE DelUsersID = 0;
+ALTER TABLE Packages
+ MODIFY SubmitterUID INTEGER UNSIGNED NULL DEFAULT NULL,
+ MODIFY MaintainerUID INTEGER UNSIGNED NULL DEFAULT NULL;
+UPDATE Packages SET SubmitterUID = NULL WHERE SubmitterUID = 0;
+UPDATE Packages SET MaintainerUID = NULL WHERE MaintainerUID = 0;
----
3. (optional) If you converted your database from MyISAM to InnoDB during the