diff options
author | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-05-27 15:27:43 +0200 |
---|---|---|
committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-05-27 15:28:07 +0200 |
commit | e5463c962c95361b1f107a7b46cb90c9ad80ff24 (patch) | |
tree | 28a4033fe45ba6658a9aca255e506e7b5fd99a87 | |
parent | d7f0b25e51ff966d78ba77a149a4a8c99d081c9d (diff) | |
download | aurweb-e5463c962c95361b1f107a7b46cb90c9ad80ff24.tar.xz |
UPGRADING: Add missing column to the instructions
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
-rw-r--r-- | UPGRADING | 5 |
1 files changed, 3 insertions, 2 deletions
@@ -50,8 +50,9 @@ CREATE TABLE PackageBases ( 4. Migrate data from Packages to PackageBases: ---- -INSERT INTO PackageBases SELECT ID, Name, CategoryID, NumVotes, OutOfDateTS, - SubmittedTS, ModifiedTS, SubmitterUID, MaintainerUID FROM Packages; +INSERT INTO PackageBases + SELECT ID, Name, CategoryID, NumVotes, OutOfDateTS, SubmittedTS, + ModifiedTS, SubmitterUID, MaintainerUID, NULL FROM Packages; ---- 5. Delete unneeded foreign keys from Packages: |