X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_domain.sql;h=468c975f0ac1005a4de44a9517e8525b6439c76b;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hp=4dbf039dba7deb29b6ffaa44632528140136a484;hpb=297e960d0379cec716021747514b7c3eec972ab0;p=Pman.Core

diff --git a/sql/core_domain.sql b/sql/core_domain.sql
index 4dbf039d..468c975f 100644
--- a/sql/core_domain.sql
+++ b/sql/core_domain.sql
@@ -2,9 +2,9 @@
 CREATE TABLE core_domain (
   id int(11) NOT NULL auto_increment,
   PRIMARY KEY  (id)
-);
+) ENGINE=innodb DEFAULT  CHARSET=utf8 ;
+-- need to specify engine set, otherwise the unique index get's borked.
 
+ALTER TABLE core_domain ADD COLUMN domain VARCHAR(255) NOT NULL DEFAULT '';
 
-ALTER TABLE core_domain ADD COLUMN domain VARCHAR(256) NOT NULL DEFAULT '';
-
-CREATE UNIQUE INDEX ui_domain ON core_domain (domain)
\ No newline at end of file
+CREATE UNIQUE INDEX ui_domain ON core_domain (domain);
\ No newline at end of file