summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorjchu <jchu>2004-12-15 02:28:19 +0100
committerjchu <jchu>2004-12-15 02:28:19 +0100
commit7549ca2d967e5146892b86b3334278c2591d3379 (patch)
treeb6112adf884cfd91b602eb705be5e457796e11d7 /support/schema
parent9d0a31c25e618660cf61a84565dae45581db57ae (diff)
downloadaur-7549ca2d967e5146892b86b3334278c2591d3379.tar.gz
aur-7549ca2d967e5146892b86b3334278c2591d3379.tar.xz
added a url path and fs path to the packages table
Diffstat (limited to 'support/schema')
-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 630b6788..318d7271 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -116,6 +116,8 @@ CREATE TABLE Packages (
SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- who submitted it?
MaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- User
AURMaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- TU/Dev
+ FSPath CHAR(256) NOT NULL,
+ URLPath CHAR(255) NOT NULL,
PRIMARY KEY (ID),
UNIQUE (Name),
INDEX (CategoryID),