summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authoreric <eric>2004-06-19 22:19:42 +0200
committereric <eric>2004-06-19 22:19:42 +0200
commit30aea4ec8cfee1ffc8786955ecb012ef73a68b73 (patch)
treed4eacdc75f16fc8d9c5080325ee6fecda36a9366 /support/schema
parentf478d7204f23cbf23d7149cd8694a3e74211ae9f (diff)
downloadaur-30aea4ec8cfee1ffc8786955ecb012ef73a68b73.tar.gz
aur-30aea4ec8cfee1ffc8786955ecb012ef73a68b73.tar.xz
started working on the login
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql5
1 files changed, 3 insertions, 2 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 662552f4..ab008458 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -20,7 +20,7 @@ INSERT INTO AccountTypes (ID, AccountType) VALUES (3, 'Developer');
--
CREATE TABLE Users (
ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
- AccountTypeID TINYINT UNSIGNED NOT NULL DEFAULT 1,
+ AccountTypeID TINYINT UNSIGNED NOT NULL DEFAULT 1,
Suspended TINYINT UNSIGNED NOT NULL DEFAULT 0,
Email CHAR(64) NOT NULL,
Passwd CHAR(32) NOT NULL,
@@ -46,7 +46,8 @@ CREATE TABLE Sessions (
UsersID INTEGER UNSIGNED NOT NULL,
SessionID CHAR(32) NOT NULL,
LastUpdateTS BIGINT UNSIGNED NOT NULL,
- FOREIGN KEY (UsersID) REFERENCES Users(ID)
+ FOREIGN KEY (UsersID) REFERENCES Users(ID),
+ UNIQUE (SessionID)
);