basic.sql 912 B

1234567891011121314151617181920212223
  1. CREATE TABLE ec_b_login_rule
  2. (
  3. id BIGINT(20) NOT NULL AUTO_INCREMENT,
  4. creation_time DATETIME NOT NULL,
  5. update_time DATETIME NOT NULL,
  6. root_org_id BIGINT(20) NOT NULL,
  7. white BIT(1) NOT NULL,
  8. PRIMARY KEY (id),
  9. KEY IDX_B_LR_010001 (root_org_id)
  10. ) ENGINE = INNODB
  11. DEFAULT CHARSET = utf8;
  12. INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time)
  13. VALUES (17196, b'1', now(), now());
  14. INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time)
  15. VALUES (17682, b'1', now(), now());
  16. INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time)
  17. VALUES (17426, b'1', now(), now());
  18. INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time)
  19. VALUES (17351, b'1', now(), now());
  20. INSERT INTO ec_b_login_rule (root_org_id, white, creation_time, update_time)
  21. VALUES (16923, b'1', now(), now());