From 34ac351e82a4e774b5c0bc3380b0ff90cb5a486d Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Tue, 1 Feb 2011 15:16:29 +0100 Subject: 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 --- support/schema/aur-schema.sql | 11 ----------- 1 file changed, 11 deletions(-) (limited to 'support/schema/aur-schema.sql') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 269612b..cb5ea42 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 ( -- cgit v1.3.1