diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-02-27 16:16:40 +0100 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-02-27 16:20:02 +0100 |
| commit | 40ccf77ca0c6745d8b75e925e915cdf51a924312 (patch) | |
| tree | 53bb39caebf188f509bbdce6b735f6868db91658 /UPGRADING | |
| parent | ac632980c3789cd99a80d61861b8820ddad14704 (diff) | |
| download | aurweb-40ccf77ca0c6745d8b75e925e915cdf51a924312.tar.gz aurweb-40ccf77ca0c6745d8b75e925e915cdf51a924312.zip | |
Define "PackageComments.DelUsersID" as "NULL".
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'UPGRADING')
| -rw-r--r-- | UPGRADING | 3 |
1 files changed, 3 insertions, 0 deletions
@@ -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 |