examcloud-upgrade/upgrade-202006/basic.sql

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());