summaryrefslogtreecommitdiffstats
path: root/schema
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-06-25 09:29:07 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2014-06-25 11:34:31 +0200
commitfc1db28c9b1b13c5b9e6baf6d24963081f18f017 (patch)
treed4adc2a358772396febfbc3a9f7c7e8a25536d20 /schema
parent8260111bcce49b73bd4973ae80296c913af2631d (diff)
downloadaurweb-fc1db28c9b1b13c5b9e6baf6d24963081f18f017.tar.xz
Allow for closing package requests
This allows Trusted Users to close package requests via the request list. Also, entries are now sorted such that open requests are shown before closed requests. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'schema')
-rw-r--r--schema/aur-schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 88f9974..486beef 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -308,6 +308,7 @@ CREATE TABLE PackageRequests (
UsersID INTEGER UNSIGNED NULL DEFAULT NULL,
Comments TEXT NOT NULL DEFAULT '',
RequestTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
+ Status TINYINT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (ID),
INDEX (UsersID),
INDEX (PackageBaseID),