summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
diff options
context:
space:
mode:
authoreric <eric>2004-06-28 21:37:02 +0200
committereric <eric>2004-06-28 21:37:02 +0200
commit4b80bc34ffb738ef3cd1a7944e8716d3e8140565 (patch)
treed371144998ca570b0808be07ff10c3a697a37bac /support/schema/aur-schema.sql
parentefcca46f26247ee69b33cb1effb0d34077817a80 (diff)
downloadaur-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.sql2
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,