X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_domain.sql;h=c22e29b7d44ee71fdaaad860b8f4c5f7204a9d95;hb=284aa667fe9e9041826621d1b8d2246c1a1097c6;hp=5fb5ecf968279b4d1ffc7342d4f0f8d64653775b;hpb=e4e27425b4828af3643837eabb0d7c2a99efedf7;p=Pman.Core 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 '';