1
2
3
4
5
6
7
8
9
10
| USE yami_bbc;
| ALTER TABLE `tz_combo`
| MODIFY COLUMN `status` tinyint(0) NOT NULL COMMENT '状态 -1：已删除 0：关闭 1:进行中 2:未开始' AFTER `shop_id`;
|
| ALTER TABLE `tz_combo_prod`
| MODIFY COLUMN `status` tinyint(0) NOT NULL DEFAULT 1 COMMENT '状态 -1：删除 0：失效 1：正常 2: 未开始' AFTER `least_num`;
|
| USE xxl_job;
| INSERT INTO `xxl_job_info`(`job_group`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `schedule_type`, `schedule_conf`, `misfire_strategy`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`)
| VALUES (2, '开启到了活动时间未开启的套餐活动', '2022-09-29 16:27:28', '2022-09-29 17:22:21', 'admin', '', 'CRON', '0 * * * * ? *', 'DO_NOTHING', 'FIRST', 'enableCombo', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-09-29 16:27:28', '', 0, 0, 0);
|
|
