diff options
| author | eric <eric> | 2004-06-19 22:19:42 +0200 |
|---|---|---|
| committer | eric <eric> | 2004-06-19 22:19:42 +0200 |
| commit | 30aea4ec8cfee1ffc8786955ecb012ef73a68b73 (patch) | |
| tree | d4eacdc75f16fc8d9c5080325ee6fecda36a9366 /support/schema | |
| parent | f478d7204f23cbf23d7149cd8694a3e74211ae9f (diff) | |
| download | aur-30aea4ec8cfee1ffc8786955ecb012ef73a68b73.tar.gz aur-30aea4ec8cfee1ffc8786955ecb012ef73a68b73.tar.xz | |
started working on the login
Diffstat (limited to 'support/schema')
| -rw-r--r-- | support/schema/aur-schema.sql | 5 |
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) ); |