From 3affeda9d085fd10ddff77e5948b8b76694103c5 Mon Sep 17 00:00:00 2001
From: marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Mon, 11 Aug 2008 14:54:12 +0000
Subject: Usernames now unique

git-svn-id: https://code.elgg.org/elgg/trunk@1833 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index e0d9de879..fbd5a9dfa 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -136,6 +136,7 @@ CREATE TABLE `prefix_users_entity` (
   `prev_last_login` int(11) NOT NULL default '0',
   
   PRIMARY KEY  (`guid`),
+  UNIQUE KEY (`username`),
   KEY `password` (`password`),
   FULLTEXT KEY `name` (`name`),
   FULLTEXT KEY (`name`,`username`)
-- 
cgit v1.2.3

