summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2011-02-01 15:16:29 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-01 15:16:29 +0100
commit34ac351e82a4e774b5c0bc3380b0ff90cb5a486d (patch)
tree312cbe27a4577745e849214bb72a5f36a75aa3ae /support/schema/aur-schema.sql
parent366ea03118dcd06047dc178d0c8c620af8612530 (diff)
downloadaur-34ac351e82a4e774b5c0bc3380b0ff90cb5a486d.tar.gz
aur-34ac351e82a4e774b5c0bc3380b0ff90cb5a486d.tar.xz
Drop "PackageContents" table and references.
We don't even touch source tarballs anymore - except for extracting the PKGBUILD, so this is no longer needed. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'support/schema/aur-schema.sql')
-rw-r--r--support/schema/aur-schema.sql11
1 files changed, 0 insertions, 11 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 269612bd..cb5ea423 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -151,17 +151,6 @@ CREATE TABLE PackageVotes (
);
CREATE UNIQUE INDEX VoteUsersIDPackageID ON PackageVotes (UsersID, PackageID);
--- The individual files and their file system location.
---
-CREATE TABLE PackageContents (
- PackageID INTEGER UNSIGNED NOT NULL,
- FSPath CHAR(255) NOT NULL DEFAULT '',
- URLPath CHAR(255) NOT NULL DEFAULT '',
- FileSize BIGINT UNSIGNED NOT NULL default 0,
- INDEX (PackageID),
- FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
-);
-
-- Record comments for packages
--
CREATE TABLE PackageComments (