summaryrefslogtreecommitdiffstats
path: root/UPGRADING
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2011-01-31 11:18:15 -0600
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-01 12:41:08 +0100
commit7f5af61c884b53a75a2b7f8b5146465f14a71f6b (patch)
tree52a959e9a9a7e940339906532a1f68a99595b4af /UPGRADING
parent492c8c668f1edb708e49bcafbacb22c58e2877a5 (diff)
downloadaurweb-7f5af61c884b53a75a2b7f8b5146465f14a71f6b.tar.xz
Drop PackageLocations table and references
We don't need this anymore since all packages managed here are well...managed here. Rip out all of the places we were using this field, many of which depended on the magic value '2' anyway. On the display side of things, we had a column that was always showing 'unsupported' that is now gone, and you can no longer sort by this column. Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'UPGRADING')
-rw-r--r--UPGRADING3
1 files changed, 2 insertions, 1 deletions
diff --git a/UPGRADING b/UPGRADING
index 2d3434f..e5dc527 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -9,7 +9,8 @@ From 1.7.0 to 1.8.0
----
ALTER TABLE Packages ADD OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL;
UPDATE Packages SET OutOfDateTS = UNIX_TIMESTAMP() WHERE OutOfDate = 1;
-ALTER TABLE Packages DROP OutOfDate, DROP URLPath;
+ALTER TABLE Packages DROP OutOfDate, DROP URLPath, DROP LocationID;
+DROP TABLE PackageLocations;
----
2. You will need to update all packages which are stored in the incoming dir as