diff options
author | eric <eric> | 2004-09-20 21:59:27 +0000 |
---|---|---|
committer | eric <eric> | 2004-09-20 21:59:27 +0000 |
commit | 63fe7babb2d7e25e82968fe084391b56d4ec2c75 (patch) | |
tree | 4a53821c1bcf855437edad7a43b545f35082b901 /support/schema/aur-schema.sql | |
parent | cb820450f89ea0c55c96a9a43e3a5a921bbdf765 (diff) |
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.sql | 13 |
1 files changed, 13 insertions, 0 deletions
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 +); + |