summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
diff options
context:
space:
mode:
authoreric <eric>2004-09-20 23:59:27 +0200
committereric <eric>2004-09-20 23:59:27 +0200
commit63fe7babb2d7e25e82968fe084391b56d4ec2c75 (patch)
tree4a53821c1bcf855437edad7a43b545f35082b901 /support/schema/aur-schema.sql
parentcb820450f89ea0c55c96a9a43e3a5a921bbdf765 (diff)
downloadaur-63fe7babb2d7e25e82968fe084391b56d4ec2c75.tar.gz
aur-63fe7babb2d7e25e82968fe084391b56d4ec2c75.tar.xz
added upload comments/history, still need to finish the actual db calls
Diffstat (limited to 'support/schema/aur-schema.sql')
-rw-r--r--support/schema/aur-schema.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index fde8b95e..b6f7a67d 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
+);
+