From 63fe7babb2d7e25e82968fe084391b56d4ec2c75 Mon Sep 17 00:00:00 2001
From: eric <eric>
Date: Mon, 20 Sep 2004 21:59:27 +0000
Subject: added upload comments/history, still need to finish the actual db
 calls

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

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

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index fde8b95..b6f7a67 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -174,3 +174,16 @@ CREATE TABLE PackageContents (
 	FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
 );
 
+-- Record comments for users submitting packages to AUR/unsupported
+--
+CREATE TABLE PackageUploadHistory (
+	PackageID INTEGER UNSIGNED NOT NULL,
+	UsersID INTEGER UNSIGNED NOT NULL,
+	Comments TEXT NOT NULl DEFAULT '',
+	UploadTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
+	INDEX (UsersID),
+	INDEX (PackageID),
+	FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
+	FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
+);
+
-- 
cgit v1.3.1

