SET SESSION sql_mode = 'STRICT_ALL_TABLES,ANSI_QUOTES';

CREATE TABLE test1 (

    id BIGINT(10) NOT NULL auto_increment,

    col1 TINYINT(1) NOT NULL,

    col2 TINYINT(1) NOT NULL,

    col3 TINYINT(1) NOT NULL,

    CONSTRAINT PRIMARY KEY (id)

);

ALTER TABLE test1 ADD CONSTRAINT "test1_col3_constraint" CHECK (col3 IN (0,1));

ALTER TABLE test1 ADD CONSTRAINT `test1_col2_constraint` CHECK (col2 IN (0,1));

ALTER TABLE test1 ADD CONSTRAINT test1_col1_constraint CHECK (col1 IN (0,1));