Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
examcloud-DevOps
/
examcloud-upgrade
2
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 2ff30a371e
Branche Tagy
examcloud-upgra...
/
upgrade-202001
/
baisc.sql

baisc.sql 4.0 KB
História Raw

1234567891011121314151617181920212223 
  1. ----------------------------------------------------------------后端服务启动前执行-----------------------------------------------------------------------------------------
    2. 

  2. truncate table `ec_b_app`;
    3. 

  3. 

  4. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (1, '2018-06-12 15:08:22', '2018-06-12 15:08:25', 'B', 'EC-CORE-BASIC', '123456', 'basic', 1000000);
    5. 

  5. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (2, '2018-06-12 15:08:52', '2018-06-12 15:08:55', 'E', 'EC-CORE-EXAMWORK', '123456', 'examwork', 1000000);
    6. 

  6. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (3, '2018-06-12 15:08:22', '2018-06-12 15:08:25', 'Q', 'EC-CORE-QUESTION', '123456', 'question', 1000000);
    7. 

  7. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (4, '2018-06-12 15:08:22', '2018-06-12 15:08:25', 'OE', 'EC-CORE-OE-ADMIN', '123456', 'oe-admin', 1000000);
    8. 

  8. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (5, '2018-06-12 15:08:22', '2018-06-12 15:08:25', 'OES', 'EC-CORE-OE-STUDENT', '123456', 'oe-student', 1000000);
    9. 

  9. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (6, '2018-06-19 12:37:48', '2018-06-19 12:37:50', 'OET', 'EC-CORE-OE-TASK', '123456', 'oe-task', 1000000);
    10. 

  10. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (7, '2018-12-06 11:48:13', '2018-12-06 11:48:13', 'WS', 'EC-WEBSOCKET', '123456', 'websocket', 1000000);
    11. 

  11. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (8, '2019-05-05 12:54:56', '2019-05-05 12:54:59', 'LM', 'EC-LOGIC-MARKING', '123456', 'logic-marking', 1000000);
    12. 

  12. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (9, '2019-05-05 12:56:23', '2019-05-05 12:56:26', 'M', 'EC-CORE-MARKING', '123456', 'marking', 1000000);
    13. 

  13. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (10, '2019-05-05 12:56:55', '2019-05-05 12:56:57', 'T', 'EC-TASK', '123456', 'task', 1000000);
    14. 

  14. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (11, '2019-05-05 12:57:12', '2019-05-05 12:57:14', 'EX', 'EC-EXCHANGE', '123456', 'exchange', 1000000);
    15. 

  15. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (12, '2019-05-05 12:57:49', '2019-05-05 12:57:51', 'P', 'EC-CORE-PRINT', '123456', 'print', 1000000);
    16. 

  16. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (13, '2019-05-05 12:58:27', '2019-05-05 12:58:29', 'API', 'EC-APP-API', '123456', 'app-api', 1000000);
    17. 

  17. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (14, '2019-05-05 14:34:16', '2019-05-05 14:34:18', 'D', 'EC-EXCHANGE-DOCK', '123456', 'exchange-dock', 1000000);
    18. 

  18. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (15, '2019-11-01 13:57:22', '2019-11-01 13:57:25', 'R', 'EC-CORE-REPORTS', '123456', 'reports', 1000000);
    19. 

  19. INSERT INTO `ec_b_app`(`id`, `creation_time`, `update_time`, `code`, `name`, `secret_key`, `simple_name`, `time_range`) VALUES (16, '2019-11-01 13:58:04', '2019-11-01 13:58:07', 'BRG', 'EC-BRIDGE', '123456', 'bridge', 1000000);
    20. 

  20. 

  21. ----------------------------------------------------------------后端服务启动后执行------------------------------------------------------------------------------------------
    22. 

  22. 

  23.