summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorjchu <jchu>2004-12-15 00:59:13 +0000
committerjchu <jchu>2004-12-15 00:59:13 +0000
commit19a4354a592c50dc6abcdda1c81666eda2f154c8 (patch)
tree0d75eb19aa90bebfe8c9aab61857460792456c5b /support/schema
parent5148d63d476d69f634bcb58743e0d470a3ac9fca (diff)
downloadaurweb-19a4354a592c50dc6abcdda1c81666eda2f154c8.tar.xz
added a url path and fs path to the contents and took out filename
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql5
1 files changed, 2 insertions, 3 deletions
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
);