Changeset 1242 in subversion for trunk/roundcubemail/SQL/mysql5.initial.sql

Timestamp:

Apr 3, 2008 7:03:54 AM (5 years ago)

Author:

alec

Message:

#1484854

File:

• trunk/roundcubemail/SQL/mysql5.initial.sql (modified) (1 diff)

trunk/roundcubemail/SQL/mysql5.initial.sql

@@ -30 +30 @@
  `language` varchar(5) NOT NULL DEFAULT 'en',
  `preferences` text,
- PRIMARY KEY(`user_id`)
+ PRIMARY KEY(`user_id`),
+ INDEX `username_index` (`username`),
+ INDEX `alias_index` (`alias`)
 ) TYPE=INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;