2 CREATE TABLE core_domain (
3 id int(11) NOT NULL auto_increment,
5 ) ENGINE=innodb DEFAULT CHARSET=utf8 ;
6 -- need to specify engine set, otherwise the unique index get's borked.
8 ALTER TABLE core_domain ADD COLUMN domain VARCHAR(255) NOT NULL DEFAULT '';
10 CREATE UNIQUE INDEX ui_domain ON core_domain (domain);