aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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`)