diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2012-03-22 09:27:44 +0100 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2012-03-24 10:34:32 +0100 |
| commit | 985795a21000ea92bcc9e817ddc3a17c380b1ed1 (patch) | |
| tree | 5e54bf2ed7a8dd0ad774c5ffb7ae1cba880202c3 /support/schema | |
| parent | 0a1e1729d970049ade6ebc84558500e23bc10ed7 (diff) | |
| download | aurweb-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.sql | 1 |
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), |