From: Alan Knowles <alan@roojs.com>
Date: Wed, 31 Oct 2018 06:52:07 +0000 (+0800)
Subject: sql/core_domain.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=284aa667fe9e9041826621d1b8d2246c1a1097c6

sql/core_domain.sql
---

diff --git a/sql/core_domain.sql b/sql/core_domain.sql
index 5fb5ecf9..c22e29b7 100644
--- a/sql/core_domain.sql
+++ b/sql/core_domain.sql
@@ -2,8 +2,8 @@
 CREATE TABLE core_domain (
   id int(11) NOT NULL auto_increment,
   PRIMARY KEY  (id)
-) ENGINE=innodb CHARSET=utf8mb4  CHARSET=utf8 ;
-
+) ENGINE=innodb DEFAULT  CHARSET=utf8 ;
+-- need to specify engine set, as 
 
 ALTER TABLE core_domain ADD COLUMN domain VARCHAR(255) NOT NULL DEFAULT '';