CREATE TABLE ec_b_login_rule ( id BIGINT(20) NOT NULL AUTO_INCREMENT, creation_time DATETIME NOT NULL, update_time DATETIME NOT NULL, root_org_id BIGINT(20) NOT NULL, white BIT(1) NOT NULL, PRIMARY KEY (id), KEY IDX_B_LR_010001 (root_org_id) ) ENGINE = INNODB DEFAULT CHARSET = utf8; INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time) VALUES (17196, b'1', now(), now()); INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time) VALUES (17682, b'1', now(), now()); INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time) VALUES (17426, b'1', now(), now()); INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time) VALUES (17351, b'1', now(), now()); INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time) VALUES (16923, b'1', now(), now());