aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authormarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-08-11 14:54:12 +0000
committermarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-08-11 14:54:12 +0000
commit3affeda9d085fd10ddff77e5948b8b76694103c5 (patch)
treeed054e6529c887a9ce2202efbf780461d1172ab7 /engine/schema
parentcc93696b3677a701ea48015592cb86c87a638365 (diff)
downloadelgg-3affeda9d085fd10ddff77e5948b8b76694103c5.tar.gz
elgg-3affeda9d085fd10ddff77e5948b8b76694103c5.tar.bz2
Usernames now unique
git-svn-id: https://code.elgg.org/elgg/trunk@1833 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql1
1 files changed, 1 insertions, 0 deletions
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`)