summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authoreric <eric>2004-06-21 19:36:54 +0000
committereric <eric>2004-06-21 19:36:54 +0000
commit38eda65735e81d2774759a2aa6e9922c7131f830 (patch)
tree9b7f2268ad85d4638a1ee8ff4e2690ba5bb25255 /support/schema
parent84e15d0463726fe03b0cdb5a690621330034e737 (diff)
downloadaurweb-38eda65735e81d2774759a2aa6e9922c7131f830.tar.xz
working on the accounts stuff
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql2
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),