From 38eda65735e81d2774759a2aa6e9922c7131f830 Mon Sep 17 00:00:00 2001
From: eric <eric>
Date: Mon, 21 Jun 2004 19:36:54 +0000
Subject: working on the accounts stuff

---
 support/schema/aur-schema.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'support/schema/aur-schema.sql')

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index ab008458..8ed407c7 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),
-- 
cgit v1.2.3-24-g4f1b

