diff options
| author | pjmattal <pjmattal> | 2004-12-15 01:33:12 +0000 |
|---|---|---|
| committer | pjmattal <pjmattal> | 2004-12-15 01:33:12 +0000 |
| commit | 252afad9fc0c46089b327a1315580a342cbc87c0 (patch) | |
| tree | 6584678cf105deb47d6c85e7a8c00b54b61e3690 /support/schema | |
| parent | 7549ca2d967e5146892b86b3334278c2591d3379 (diff) | |
| download | aurweb-252afad9fc0c46089b327a1315580a342cbc87c0.tar.xz | |
tweaks to package functions and schema
Diffstat (limited to 'support/schema')
| -rw-r--r-- | support/schema/aur-schema.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 318d727..ef3a9e3 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -67,6 +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 ('daemons'); INSERT INTO PackageCategories (Category) VALUES ('devel'); INSERT INTO PackageCategories (Category) VALUES ('editors'); @@ -93,6 +94,7 @@ 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'); @@ -109,6 +111,9 @@ CREATE TABLE Packages ( CategoryID TINYINT UNSIGNED NOT NULL, 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, NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDate TINYINT UNSIGNED DEFAULT 0, @@ -122,6 +127,7 @@ CREATE TABLE Packages ( UNIQUE (Name), INDEX (CategoryID), INDEX (LocationID), + INDEX (DummyPkg), INDEX (OutOfDate), INDEX (NumVotes), INDEX (SubmitterUID), @@ -169,8 +175,8 @@ CREATE TABLE PackageVotes ( -- CREATE TABLE PackageContents ( PackageID INTEGER UNSIGNED NOT NULL, - FSPath CHAR(256) NOT NULL, - URLPath CHAR(255) NOT NULL, + FSPath CHAR(255) NOT NULL DEFAULT '', + URLPath CHAR(255) NOT NULL DEFAULT '', FileSize BIGINT UNSIGNED NOT NULL default 0, INDEX (PackageID), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE |