diff options
Diffstat (limited to 'support/schema')
| -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 +); + |