diff options
author | Dan McGee <dan@archlinux.org> | 2011-10-21 16:03:41 -0500 |
---|---|---|
committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-10-24 17:57:53 +0200 |
commit | a21739aae5daece7098652a0f7f8b7fd36b8fcc6 (patch) | |
tree | 76f0e08d8316008f60d9b4179f5fa09ae51f0666 /support/schema | |
parent | e6ecdcc835e9a612e5c5842867c01f0efdceb789 (diff) |
Add LastLogin column to Users table
Signed-off-by: Dan McGee <dan@archlinux.org>
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 544ed94..6c8feca 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -32,6 +32,7 @@ CREATE TABLE Users ( LangPreference VARCHAR(5) NOT NULL DEFAULT 'en', IRCNick VARCHAR(32) NOT NULL DEFAULT '', LastVoted BIGINT UNSIGNED NOT NULL DEFAULT 0, + LastLogin BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (ID), UNIQUE (Username), UNIQUE (Email), |