X9K8P5aQ

1How to specify index name on unique field in mysql
2CREATE TABLE IF NOT EXISTS ".$prefix."users (
3          id int(11) NOT NULL AUTO_INCREMENT,
4          username varchar(50) UNIQUE NOT NULL,
5          PRIMARY KEY (id)
6        ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
7	
8CREATE TABLE IF NOT EXISTS ".$prefix."users (
9      id int(11) NOT NULL AUTO_INCREMENT,
10      username varchar(50) NOT NULL,
11      PRIMARY KEY (id),
12      UNIQUE $unique_index_name (username)
13    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
14	
15create table x1 (x int unique);
16create table x2 (x int unique);