sql/core_domain.sql

[Pman.Core] / sql / core_domain.sql

diff --git a/sql/core_domain.sql b/sql/core_domain.sql
index f991b99..5fb5ecf 100644 (file)
--- a/sql/core_domain.sql
+++ b/sql/core_domain.sql
@@ -2,7 +2,9 @@
 CREATE TABLE core_domain (
   id int(11) NOT NULL auto_increment,
   PRIMARY KEY  (id)
-);
+) ENGINE=innodb CHARSET=utf8mb4  CHARSET=utf8 ;
 
 
-ALTER TABLE core_domain ADD COLUMN domain VARCHAR(256) NOT NULL DEFAULT '';
\ No newline at end of file
+ALTER TABLE core_domain ADD COLUMN domain VARCHAR(255) NOT NULL DEFAULT '';
+
+CREATE UNIQUE INDEX ui_domain ON core_domain (domain);
\ No newline at end of file