From 34ac351e82a4e774b5c0bc3380b0ff90cb5a486d Mon Sep 17 00:00:00 2001
From: Lukas Fleischer <archlinux@cryptocrack.de>
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 <archlinux@cryptocrack.de>
---
 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

