From 7549ca2d967e5146892b86b3334278c2591d3379 Mon Sep 17 00:00:00 2001 From: jchu Date: Wed, 15 Dec 2004 01:28:19 +0000 Subject: added a url path and fs path to the packages table --- support/schema/aur-schema.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'support/schema') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 630b678..318d727 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), -- cgit v1.2.3-54-g00ecf