From 993fcb7811d763368a6940730d3870b0013623c0 Mon Sep 17 00:00:00 2001
From: eric <eric>
Date: Thu, 1 Jul 2004 22:20:09 +0000
Subject: still working on pkgsearch.php::do_Details

---
 support/schema/aur-schema.sql | 19 ++++++++++++++++++-
 1 file changed, 18 insertions(+), 1 deletion(-)

(limited to 'support/schema/aur-schema.sql')

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index dd02310..fde8b95 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -108,7 +108,6 @@ CREATE TABLE Packages (
 	CategoryID TINYINT UNSIGNED NOT NULL,
 	Description CHAR(128) NOT NULL DEFAULT "An Arch Package",
 	URL CHAR(255) NOT NULL DEFAULT "http://www.archlinux.org",
-	Source CHAR(255) NOT NULL DEFAULT "/dev/null",
 	LocationID TINYINT UNSIGNED NOT NULL,
 	NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0,
 	OutOfDate TINYINT UNSIGNED DEFAULT 0,
@@ -133,6 +132,24 @@ CREATE TABLE Packages (
 );
 
 
+-- Track which dependencies a package has
+--
+CREATE TABLE PackageDepends (
+	PackageID INTEGER UNSIGNED NOT NULL,
+	DepPkgID INTEGER UNSIGNED NOT NULL,
+	INDEX (PackageID)
+);
+
+
+-- Track which sources a package has
+--
+CREATE TABLE PackageSources (
+	PackageID INTEGER UNSIGNED NOT NULL,
+	Source CHAR(255) NOT NULL DEFAULT "/dev/null",
+	INDEX (PackageID)
+);
+
+
 -- Track votes for packages
 --
 CREATE TABLE PackageVotes (
-- 
cgit v1.2.3-70-g09d2