From aae43d9ad6fc83d04a4975f27392c1422dfa0ec4 Mon Sep 17 00:00:00 2001
From: eric <eric>
Date: Sat, 5 Mar 2005 20:39:36 +0000
Subject: started working on package comments

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

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

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 0b07038e..c2cd08b6 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -180,13 +180,13 @@ CREATE TABLE PackageContents (
 	FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
 );
 
--- Record comments for users submitting packages to AUR/unsupported
+-- Record comments for packages
 --
-CREATE TABLE PackageUploadHistory (
+CREATE TABLE PackageComments (
 	PackageID INTEGER UNSIGNED NOT NULL,
 	UsersID INTEGER UNSIGNED NOT NULL,
 	Comments TEXT NOT NULl DEFAULT '',
-	UploadTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
+	CommentTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
 	INDEX (UsersID),
 	INDEX (PackageID),
 	FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
-- 
cgit v1.2.3-24-g4f1b

