From 19a4354a592c50dc6abcdda1c81666eda2f154c8 Mon Sep 17 00:00:00 2001
From: jchu <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/schema/aur-schema.sql')

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-54-g00ecf

