started working on the login

1 files changed, 3 insertions, 2 deletions

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 662552f..ab00845 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)
 );