diff options
| author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-08-11 14:54:12 +0000 |
|---|---|---|
| committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-08-11 14:54:12 +0000 |
| commit | 3affeda9d085fd10ddff77e5948b8b76694103c5 (patch) | |
| tree | ed054e6529c887a9ce2202efbf780461d1172ab7 /engine/schema/mysql.sql | |
| parent | cc93696b3677a701ea48015592cb86c87a638365 (diff) | |
| download | elgg-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/mysql.sql')
| -rw-r--r-- | engine/schema/mysql.sql | 1 |
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`)
|