summaryrefslogtreecommitdiff
path: root/support/schema
diff options
context:
space:
mode:
authoreric <eric>2005-03-20 18:54:20 +0000
committereric <eric>2005-03-20 18:54:20 +0000
commit7fccb8b634118a2f4f92220b194dc74273b15957 (patch)
tree4b55e81a25f3005abaf3cd7cdc5b0de8316a541f /support/schema
parent9d69979bb9e8498ac1ac6b4d08fb6b3ba9042cdc (diff)
added comments/category editing, and closed #2280
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql2
1 files changed, 2 insertions, 0 deletions
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,