diff options
| author | eric <eric> | 2004-06-21 19:36:54 +0000 |
|---|---|---|
| committer | eric <eric> | 2004-06-21 19:36:54 +0000 |
| commit | 38eda65735e81d2774759a2aa6e9922c7131f830 (patch) | |
| tree | 9b7f2268ad85d4638a1ee8ff4e2690ba5bb25255 /support/schema | |
| parent | 84e15d0463726fe03b0cdb5a690621330034e737 (diff) | |
working on the accounts stuff
Diffstat (limited to 'support/schema')
| -rw-r--r-- | support/schema/aur-schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index ab00845..8ed407c 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -22,6 +22,7 @@ CREATE TABLE Users ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, AccountTypeID TINYINT UNSIGNED NOT NULL DEFAULT 1, Suspended TINYINT UNSIGNED NOT NULL DEFAULT 0, + Username CHAR(32) NOT NULL, Email CHAR(64) NOT NULL, Passwd CHAR(32) NOT NULL, RealName CHAR(64) NOT NULL DEFAULT '', @@ -30,6 +31,7 @@ CREATE TABLE Users ( LastVoted BIGINT UNSIGNED NOT NULL DEFAULT 0, NewPkgNotify TINYINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (ID), + UNIQUE (Username), UNIQUE (Email), INDEX (AccountTypeID), INDEX (NewPkgNotify), |