From 7fccb8b634118a2f4f92220b194dc74273b15957 Mon Sep 17 00:00:00 2001
From: eric <eric>
Date: Sun, 20 Mar 2005 18:54:20 +0000
Subject: added comments/category editing, and closed #2280

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

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

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 2d70dae..0656f0e 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -183,11 +183,13 @@ CREATE TABLE PackageContents (
 -- Record comments for packages
 --
 CREATE TABLE PackageComments (
+	ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 	PackageID INTEGER UNSIGNED NOT NULL,
 	UsersID INTEGER UNSIGNED NOT NULL,
 	Comments TEXT NOT NULl DEFAULT '',
 	CommentTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
 	DelUsersID INTEGER UNSIGNED NOT NULL DEFAULT 0,
+	PRIMARY KEY (ID),
 	INDEX (UsersID),
 	INDEX (PackageID),
 	FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
-- 
cgit v1.2.3-70-g09d2

