diff options
author | eric <eric> | 2004-06-28 21:37:02 +0200 |
---|---|---|
committer | eric <eric> | 2004-06-28 21:37:02 +0200 |
commit | 4b80bc34ffb738ef3cd1a7944e8716d3e8140565 (patch) | |
tree | d371144998ca570b0808be07ff10c3a697a37bac /support/schema/aur-schema.sql | |
parent | efcca46f26247ee69b33cb1effb0d34077817a80 (diff) | |
download | aur-4b80bc34ffb738ef3cd1a7944e8716d3e8140565.tar.gz aur-4b80bc34ffb738ef3cd1a7944e8716d3e8140565.tar.xz |
re-working pkgsearch, NumVotes add to Packages table
Diffstat (limited to 'support/schema/aur-schema.sql')
-rw-r--r-- | support/schema/aur-schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 9c5d920a..876cf285 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -110,6 +110,7 @@ CREATE TABLE Packages ( URL CHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", Source CHAR(255) NOT NULL DEFAULT "/dev/null", LocationID TINYINT UNSIGNED NOT NULL, + NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDate TINYINT UNSIGNED DEFAULT 0, SubmittedTS BIGINT UNSIGNED NOT NULL, SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, @@ -119,6 +120,7 @@ CREATE TABLE Packages ( INDEX (CategoryID), INDEX (LocationID), INDEX (OutOfDate), + INDEX (NumVotes), INDEX (SubmitterUID), INDEX (MaintainerUID), FOREIGN KEY (CategoryID) REFERENCES PackageCategories(ID) ON DELETE NO ACTION, |