summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2012-03-22 09:27:44 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2012-03-24 10:34:32 +0100
commit985795a21000ea92bcc9e817ddc3a17c380b1ed1 (patch)
tree5e54bf2ed7a8dd0ad774c5ffb7ae1cba880202c3 /support/schema
parent0a1e1729d970049ade6ebc84558500e23bc10ed7 (diff)
downloadaurweb-985795a21000ea92bcc9e817ddc3a17c380b1ed1.tar.xz
Add field for PGP key in profile information
This is handy for verifying the PGP key of new Trusted Users. Also, this could potentially used as a basis to allow signed package uploads in the future. Implements FS#29028. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 6c8feca..726fd2f 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -31,6 +31,7 @@ CREATE TABLE Users (
RealName VARCHAR(64) NOT NULL DEFAULT '',
LangPreference VARCHAR(5) NOT NULL DEFAULT 'en',
IRCNick VARCHAR(32) NOT NULL DEFAULT '',
+ PGPKey VARCHAR(40) NULL DEFAULT NULL,
LastVoted BIGINT UNSIGNED NOT NULL DEFAULT 0,
LastLogin BIGINT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (ID),