From 19a4354a592c50dc6abcdda1c81666eda2f154c8 Mon Sep 17 00:00:00 2001 From: jchu Date: Wed, 15 Dec 2004 00:59:13 +0000 Subject: added a url path and fs path to the contents and took out filename --- support/schema/aur-schema.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'support') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 7079622..630b678 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -167,11 +167,10 @@ CREATE TABLE PackageVotes ( -- CREATE TABLE PackageContents ( PackageID INTEGER UNSIGNED NOT NULL, - FileName CHAR(32) NOT NULL, - Path CHAR(255) NOT NULL, + FSPath CHAR(256) NOT NULL, + URLPath CHAR(255) NOT NULL, FileSize BIGINT UNSIGNED NOT NULL default 0, INDEX (PackageID), - INDEX (FileName), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE ); -- cgit v1.2.3-70-g09d2