mysql/mysql struct

[huxiangquan]

db struct:

create table if not exists base_color (id int(11) auto_increment not null ,
enable bit(1) default 'b' 1 '' COMMENT 'enable：1true,0false' not null ,
primary key (id)) ENGINE = InnoDB default CHARSET = utf8 collate = utf8_general_ci COMMENT = 'basecolor'

ERROR.log: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1''

Right syntax is :

enable bit(1) default b'1'

[qianyiwen2019]

please paste the origin sql to create the table in source mysql.