From 284aa667fe9e9041826621d1b8d2246c1a1097c6 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 31 Oct 2018 14:52:07 +0800 Subject: [PATCH] sql/core_domain.sql --- sql/core_domain.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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 ''; -- 2.39.2