diff options
| author | pjmattal <pjmattal> | 2004-12-15 01:47:17 +0000 |
|---|---|---|
| committer | pjmattal <pjmattal> | 2004-12-15 01:47:17 +0000 |
| commit | 294c14e7bb5a7c880821f145376d1d125662f4dc (patch) | |
| tree | 8ee507bdc7a8ee35b8f416b236134419e0d7b692 /support/schema | |
| parent | 19086f4f022cca17db33b608e09853a7e024eda0 (diff) | |
| download | aurweb-294c14e7bb5a7c880821f145376d1d125662f4dc.tar.xz | |
renumber none to one, hide none from category/location dropdowns
Diffstat (limited to 'support/schema')
| -rw-r--r-- | support/schema/aur-schema.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index c775af1..13e83d1 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -67,7 +67,7 @@ CREATE TABLE PackageCategories ( Category CHAR(32) NOT NULL, PRIMARY KEY (ID) ); -INSERT INTO PackageCategories (ID, Category) VALUES (0, 'none'); +INSERT INTO PackageCategories (Category) VALUES ('none'); INSERT INTO PackageCategories (Category) VALUES ('daemons'); INSERT INTO PackageCategories (Category) VALUES ('devel'); INSERT INTO PackageCategories (Category) VALUES ('editors'); @@ -94,12 +94,12 @@ CREATE TABLE PackageLocations ( Location CHAR(32) NOT NULL, PRIMARY KEY (ID) ); -INSERT INTO PackageLocations (ID, Location) VALUES (0, 'none'); -INSERT INTO PackageLocations (ID, Location) VALUES (1, 'Unsupported'); -INSERT INTO PackageLocations (ID, Location) VALUES (2, 'AUR'); -INSERT INTO PackageLocations (ID, Location) VALUES (3, 'Current'); -INSERT INTO PackageLocations (ID, Location) VALUES (4, 'Extra'); -INSERT INTO PackageLocations (ID, Location) VALUES (5, 'Unstable'); +INSERT INTO PackageLocations (Location) VALUES ('none'); +INSERT INTO PackageLocations (Location) VALUES ('Unsupported'); +INSERT INTO PackageLocations (Location) VALUES ('AUR'); +INSERT INTO PackageLocations (Location) VALUES ('Current'); +INSERT INTO PackageLocations (Location) VALUES ('Extra'); +INSERT INTO PackageLocations (Location) VALUES ('Unstable'); -- Information about the actual packages @@ -108,13 +108,13 @@ CREATE TABLE Packages ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, Name CHAR(32) NOT NULL, Version CHAR(32) NOT NULL DEFAULT '', - CategoryID TINYINT UNSIGNED NOT NULL, + CategoryID TINYINT UNSIGNED NOT NULL DEFAULT 1, Description CHAR(128) NOT NULL DEFAULT "An Arch Package", URL CHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", DummyPkg TINYINT UNSIGNED NOT NULL DEFAULT 0, -- 1=>dummy FSPath CHAR(255) NOT NULL DEFAULT '', URLPath CHAR(255) NOT NULL DEFAULT '', - LocationID TINYINT UNSIGNED NOT NULL, + LocationID TINYINT UNSIGNED NOT NULL DEFAULT 1, NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDate TINYINT UNSIGNED DEFAULT 0, SubmittedTS BIGINT UNSIGNED NOT NULL, |