DROP TABLE IF EXISTS "XXL_JOB"."XXL_JOB_USER"; CREATE TABLE "XXL_JOB"."XXL_JOB_USER" ( "ID" INT IDENTITY(2,1) NOT NULL, "USERNAME" VARCHAR(50) NOT NULL, "PASSWORD" VARCHAR(50) NOT NULL, "ROLE" TINYINT NOT NULL, "PERMISSION" VARCHAR(255) NULL ); DROP TABLE IF EXISTS "XXL_JOB"."XXL_JOB_REGISTRY"; CREATE TABLE "XXL_JOB"."XXL_JOB_REGISTRY" ( "ID" INT IDENTITY(1,1) NOT NULL, "REGISTRY_GROUP" VARCHAR(50) NOT NULL, "REGISTRY_KEY" VARCHAR(255) NOT NULL, "REGISTRY_VALUE" VARCHAR(255) NOT NULL, "UPDATE_TIME" TIMESTAMP(0) NULL ); DROP TABLE IF EXISTS "XXL_JOB"."XXL_JOB_LOGGLUE"; CREATE TABLE "XXL_JOB"."XXL_JOB_LOGGLUE" ( "ID" INT IDENTITY(1,1) NOT NULL, "JOB_ID" INT NOT NULL, "GLUE_TYPE" VARCHAR(50) NULL, "GLUE_SOURCE" CLOB NULL, "GLUE_REMARK" VARCHAR(128) NOT NULL, "ADD_TIME" TIMESTAMP(0) NULL, "UPDATE_TIME" TIMESTAMP(0) NULL ); DROP TABLE IF EXISTS "XXL_JOB"."XXL_JOB_LOG_REPORT"; CREATE TABLE "XXL_JOB"."XXL_JOB_LOG_REPORT" ( "ID" INT IDENTITY(1,1) NOT NULL, "TRIGGER_DAY" TIMESTAMP(0) NULL, "RUNNING_COUNT" INT DEFAULT 0 NOT NULL, "SUC_COUNT" INT DEFAULT 0 NOT NULL, "FAIL_COUNT" INT DEFAULT 0 NOT NULL ); DROP TABLE IF EXISTS "XXL_JOB"."XXL_JOB_LOG"; CREATE TABLE "XXL_JOB"."XXL_JOB_LOG" ( "ID" BIGINT IDENTITY(1,1) NOT NULL, "JOB_GROUP" INT NOT NULL, "JOB_ID" INT NOT NULL, "EXECUTOR_ADDRESS" VARCHAR(255) NULL, "EXECUTOR_HANDLER" VARCHAR(255) NULL, "EXECUTOR_PARAM" VARCHAR(512) NULL, "EXECUTOR_SHARDING_PARAM" VARCHAR(20) NULL, "EXECUTOR_FAIL_RETRY_COUNT" INT DEFAULT 0 NOT NULL, "TRIGGER_TIME" TIMESTAMP(0) NULL, "TRIGGER_CODE" INT NOT NULL, "TRIGGER_MSG" TEXT NULL, "HANDLE_TIME" TIMESTAMP(0) NULL, "HANDLE_CODE" INT NOT NULL, "HANDLE_MSG" TEXT NULL, "ALARM_STATUS" TINYINT DEFAULT 0 NOT NULL ); DROP TABLE IF EXISTS "XXL_JOB"."XXL_JOB_LOCK"; CREATE TABLE "XXL_JOB"."XXL_JOB_LOCK" ( "LOCK_NAME" VARCHAR(50) NOT NULL ); DROP TABLE IF EXISTS "XXL_JOB"."XXL_JOB_INFO"; CREATE TABLE "XXL_JOB"."XXL_JOB_INFO" ( "ID" INT IDENTITY(2,1) NOT NULL, "JOB_GROUP" INT NOT NULL, "JOB_CRON" VARCHAR(128) NOT NULL, "JOB_DESC" VARCHAR(255) NOT NULL, "ADD_TIME" TIMESTAMP(0) NULL, "UPDATE_TIME" TIMESTAMP(0) NULL, "AUTHOR" VARCHAR(64) NULL, "ALARM_EMAIL" VARCHAR(255) NULL, "EXECUTOR_ROUTE_STRATEGY" VARCHAR(50) NULL, "EXECUTOR_HANDLER" VARCHAR(255) NULL, "EXECUTOR_PARAM" VARCHAR(512) NULL, "EXECUTOR_BLOCK_STRATEGY" VARCHAR(50) NULL, "EXECUTOR_TIMEOUT" INT DEFAULT 0 NOT NULL, "EXECUTOR_FAIL_RETRY_COUNT" INT DEFAULT 0 NOT NULL, "GLUE_TYPE" VARCHAR(50) NOT NULL, "GLUE_SOURCE" CLOB NULL, "GLUE_REMARK" VARCHAR(128) NULL, "GLUE_UPDATETIME" TIMESTAMP(0) NULL, "CHILD_JOBID" VARCHAR(255) NULL, "TRIGGER_STATUS" TINYINT DEFAULT 0 NOT NULL, "TRIGGER_LAST_TIME" BIGINT DEFAULT 0 NOT NULL, "TRIGGER_NEXT_TIME" BIGINT DEFAULT 0 NOT NULL ); DROP TABLE IF EXISTS "XXL_JOB"."XXL_JOB_GROUP"; CREATE TABLE "XXL_JOB"."XXL_JOB_GROUP" ( "ID" INT IDENTITY(2,1) NOT NULL, "APP_NAME" VARCHAR(64) NOT NULL, "TITLE" VARCHAR(20) NOT NULL, "ORDER" INT NOT NULL, "ADDRESS_TYPE" TINYINT DEFAULT 0 NOT NULL, "ADDRESS_LIST" VARCHAR(512) NULL ); ALTER TABLE "XXL_JOB"."XXL_JOB_USER" ADD CONSTRAINT PRIMARY KEY ("ID"); ALTER TABLE "XXL_JOB"."XXL_JOB_USER" ADD CONSTRAINT "I_USERNAME" UNIQUE ("USERNAME"); ALTER TABLE "XXL_JOB"."XXL_JOB_REGISTRY" ADD CONSTRAINT PRIMARY KEY ("ID"); ALTER TABLE "XXL_JOB"."XXL_JOB_LOGGLUE" ADD CONSTRAINT PRIMARY KEY ("ID"); ALTER TABLE "XXL_JOB"."XXL_JOB_LOG_REPORT" ADD CONSTRAINT PRIMARY KEY ("ID"); ALTER TABLE "XXL_JOB"."XXL_JOB_LOG_REPORT" ADD CONSTRAINT "I_TRIGGER_DAY" UNIQUE ("TRIGGER_DAY"); ALTER TABLE "XXL_JOB"."XXL_JOB_LOG" ADD CONSTRAINT PRIMARY KEY ("ID"); ALTER TABLE "XXL_JOB"."XXL_JOB_LOCK" ADD CONSTRAINT PRIMARY KEY ("LOCK_NAME"); ALTER TABLE "XXL_JOB"."XXL_JOB_INFO" ADD CONSTRAINT PRIMARY KEY ("ID"); ALTER TABLE "XXL_JOB"."XXL_JOB_GROUP" ADD CONSTRAINT PRIMARY KEY ("ID"); CREATE UNIQUE INDEX "PRIMARY" ON "XXL_JOB"."XXL_JOB_USER" ("ID"); COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_USER"."USERNAME" IS '账号'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_USER"."PASSWORD" IS '密码'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_USER"."ROLE" IS '角色：0-普通用户、1-管理员'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_USER"."PERMISSION" IS '权限：执行器ID列表，多个逗号分割'; CREATE INDEX "I_G_K_V" ON "XXL_JOB"."XXL_JOB_REGISTRY" ("REGISTRY_GROUP", "REGISTRY_KEY", "REGISTRY_VALUE"); COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOGGLUE"."JOB_ID" IS '任务，主键ID'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOGGLUE"."GLUE_TYPE" IS 'GLUE类型'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOGGLUE"."GLUE_SOURCE" IS 'GLUE源代码'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOGGLUE"."GLUE_REMARK" IS 'GLUE备注'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG_REPORT"."TRIGGER_DAY" IS '调度-时间'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG_REPORT"."RUNNING_COUNT" IS '运行中-日志数量'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG_REPORT"."SUC_COUNT" IS '执行成功-日志数量'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG_REPORT"."FAIL_COUNT" IS '执行失败-日志数量'; CREATE INDEX "I_HANDLE_CODE" ON "XXL_JOB"."XXL_JOB_LOG" ("HANDLE_CODE"); CREATE INDEX "I_TRIGGER_TIME" ON "XXL_JOB"."XXL_JOB_LOG" ("TRIGGER_TIME"); COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."JOB_GROUP" IS '执行器主键ID'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."JOB_ID" IS '任务，主键ID'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."EXECUTOR_ADDRESS" IS '执行器地址，本次执行的地址'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."EXECUTOR_HANDLER" IS '执行器任务handler'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."EXECUTOR_PARAM" IS '执行器任务参数'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."EXECUTOR_SHARDING_PARAM" IS '执行器任务分片参数，格式如 1/2'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."EXECUTOR_FAIL_RETRY_COUNT" IS '失败重试次数'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."TRIGGER_TIME" IS '调度-时间'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."TRIGGER_CODE" IS '调度-结果'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."TRIGGER_MSG" IS '调度-日志'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."HANDLE_TIME" IS '执行-时间'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."HANDLE_CODE" IS '执行-状态'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."HANDLE_MSG" IS '执行-日志'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOG"."ALARM_STATUS" IS '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_LOCK"."LOCK_NAME" IS '锁名称'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."JOB_GROUP" IS '执行器主键ID'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."JOB_CRON" IS '任务执行CRON'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."AUTHOR" IS '作者'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."ALARM_EMAIL" IS '报警邮件'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."EXECUTOR_ROUTE_STRATEGY" IS '执行器路由策略'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."EXECUTOR_HANDLER" IS '执行器任务handler'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."EXECUTOR_PARAM" IS '执行器任务参数'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."EXECUTOR_BLOCK_STRATEGY" IS '阻塞处理策略'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."EXECUTOR_TIMEOUT" IS '任务执行超时时间，单位秒'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."EXECUTOR_FAIL_RETRY_COUNT" IS '失败重试次数'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."GLUE_TYPE" IS 'GLUE类型'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."GLUE_SOURCE" IS 'GLUE源代码'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."GLUE_REMARK" IS 'GLUE备注'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."GLUE_UPDATETIME" IS 'GLUE更新时间'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."CHILD_JOBID" IS '子任务ID，多个逗号分隔'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."TRIGGER_STATUS" IS '调度状态：0-停止，1-运行'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."TRIGGER_LAST_TIME" IS '上次调度时间'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_INFO"."TRIGGER_NEXT_TIME" IS '下次调度时间'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_GROUP"."APP_NAME" IS '执行器AppName'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_GROUP"."TITLE" IS '执行器名称'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_GROUP"."ORDER" IS '排序'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_GROUP"."ADDRESS_TYPE" IS '执行器地址类型：0=自动注册、1=手动录入'; COMMENT ON COLUMN "XXL_JOB"."XXL_JOB_GROUP"."ADDRESS_LIST" IS '执行器地址列表，多地址逗号分隔'; SET IDENTITY_INSERT "XXL_JOB"."xxl_job_group" ON; INSERT INTO "XXL_JOB"."xxl_job_group"(id, app_name, title, "order", address_type, address_list) VALUES (15, 'phoenix', '新单体执行器', 1, 0, '10.42.1.211:7079'), (17, 'phoenix-posting', '单体过账Posting', 1, 0, '10.42.1.205:7227'); SET IDENTITY_INSERT "XXL_JOB"."xxl_job_group" OFF; SET IDENTITY_INSERT XXL_JOB.XXL_JOB_INFO ON; INSERT INTO "XXL_JOB"."xxl_job_info"(id, job_group, job_cron, job_desc, add_time, update_time, author, alarm_email, 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 (36, 15, '0 0 18 * * ?', '每天更新工位生产日历', '2021-12-21 13:28:38', '2022-01-17 09:26:55', 'qizheng.sun', '', 'FIRST', 'workstationCalendarJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-21 13:28:38', '', 1, 1653559200000, 1653645600000), (40, 17, '0 0/6 * * * ?', '聚合工位原始采集数据', '2021-12-22 18:35:21', '2022-01-17 10:07:55', 'POSTING', '', 'FIRST', 'workStationAggregateJobHandler', '', 'DISCARD_LATER', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-22 18:35:21', '', 1, 1653566040000, 1653566400000), (41, 17, '0 56 23 * * ?', '构建明日生产日历时间切片缓存', '2021-12-22 18:36:55', '2022-01-14 10:37:18', 'POSTING', '', 'FIRST', 'productionTimeCacheJobHandler', '', 'DISCARD_LATER', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-22 18:36:55', '', 1, 1653559800000, 1653646200000), (42, 17, '0 30 23 * * ?', '构建工位状态明日班次固定点', '2021-12-22 18:38:25', '2022-01-14 10:36:59', 'POSTING', '', 'FIRST', 'stateFixPointJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-22 18:38:25', '', 1, 1653559500000, 1653645900000), (48, 15, '0 56 23 * * ?', '生产日历切片缓存', '2022-03-23 18:32:50', '2022-03-23 18:39:03', 'wenchao.long', '', 'FIRST', 'calendarCacheJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-03-23 18:32:50', '', 1, 1653494160000, 1653580560000), (49, 15, '0/5 * * * * ?', '同步当前时间全量参数', '2022-07-16 11:06:46', '2022-07-16 11:06:46', 'wenchao.long', '', 'FIRST', 'allDmpCollectDataJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-07-16 11:06:46', '', 1, 0, 0), (44, 15, '0 0 0 * * ?', '保养计划定时任务', '2022-03-02 15:07:10', '2022-03-02 15:07:36', 'jiangxiaodong', '', 'FIRST', 'maintainPlanJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-03-02 15:07:10', '', 1, 1653494400000, 1653580800000), (50, 15, '0 30 8 * * ?', '逾期通知定时任务', '2022-08-26 13:17:03', '2022-08-26 15:15:53', 'haolv', '', 'FIRST', 'maintain-overdueJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-26 13:17:03', '', 1, 1661585400000, 1661587200000), (51, 15, '0 30 8 * * ?', '预警通知定时任务', '2022-08-26 13:18:07', '2022-08-26 15:15:50', 'haolv', '', 'FIRST', 'maintenance-warningJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-26 13:18:07', '', 1, 1661585400000, 1661587200000); SET IDENTITY_INSERT XXL_JOB.XXL_JOB_INFO OFF; INSERT INTO "XXL_JOB"."xxl_job_lock"(lock_name) VALUES ('schedule_lock'); INSERT INTO "XXL_JOB"."xxl_job_registry"(registry_group, registry_key, registry_value, update_time) VALUES ('EXECUTOR', 'phoenix-posting', '10.42.1.205:7227', '2022-03-24 16:52:49'), ('EXECUTOR', 'phoenix', '10.42.1.211:7079', '2022-03-24 16:52:59'); INSERT INTO "XXL_JOB"."xxl_job_user"(username, password, role, permission) VALUES ('admin', 'e10adc3949ba59abbe56e057f20f883e', 1, NULL); SET IDENTITY_INSERT XXL_JOB.XXL_JOB_INFO ON; INSERT INTO xxl_job.xxl_job_info (id, job_group, job_cron, job_desc, add_time, update_time, author, alarm_email, 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 (53, 15, '0/2 * * * * ?', 'fms实时数据推送', '2022-08-29 10:13:30', '2022-08-29 10:13:30', 'XXL', '', 'FIRST', 'fmsPushDataJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-29 10:13:30', '', 1, 1661761462000, 1661761464000); INSERT INTO xxl_job.xxl_job_info (id, job_group, job_cron, job_desc, add_time, update_time, author, alarm_email, 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 (54, 17, '0/10 * * * * ?', '定时扫描状态反馈执行记录', '2022-09-07 17:12:02', '2022-09-15 13:19:56', 'POSTING', '', 'FIRST', 'feedbackAnalyseJobHandler', '', 'DISCARD_LATER', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-09-07 17:12:02', '', 1, 1663312480000, 1663312490000); SET IDENTITY_INSERT XXL_JOB.XXL_JOB_INFO OFF; -- 定时清除dmp日志任务 SET IDENTITY_INSERT XXL_JOB.XXL_JOB_INFO ON; INSERT INTO xxl_job.xxl_job_info (id, job_group, job_cron, job_desc, add_time, update_time, author, alarm_email, 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 (55, 15, '0 0 2 L 3/3 ? ', 'DMP日志定期清除任务', '2022-10-11 19:45:11', '2022-10-11 19:45:47', 'wangshaofei', '', 'FIRST', 'dmpLogRegularCleanJobHandler', '3', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-10-11 19:45:11', '', 0, 0, 0); SET IDENTITY_INSERT XXL_JOB.XXL_JOB_INFO OFF;