jnpf-database/SQLServer/jnpf_xxljob_init.sql

/*
 Navicat Premium Data Transfer

 Source Server         : Local_Oracle - Sys
 Source Server Type    : Oracle
 Source Server Version : 110200
 Source Host           : localhost:1521
 Source Schema         : JNPF_XXJOB_INIT_345

 Target Server Type    : Oracle
 Target Server Version : 110200
 File Encoding         : 65001

 Date: 12/12/2022 15:42:30
*/


-- ----------------------------
-- Table structure for BASE_HANDLERNAME
-- ----------------------------

CREATE TABLE "BASE_HANDLERNAME" (
  "F_ID" NVARCHAR2(50) NOT NULL,
  "F_HANDLERNAME" NVARCHAR2(50),
  "F_EXECUTOR" NVARCHAR2(50)
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "BASE_HANDLERNAME"."F_ID" IS '主键';
COMMENT ON COLUMN "BASE_HANDLERNAME"."F_HANDLERNAME" IS '任务名称';
COMMENT ON COLUMN "BASE_HANDLERNAME"."F_EXECUTOR" IS '执行器名称';

-- ----------------------------
-- Records of BASE_HANDLERNAME
-- ----------------------------

-- ----------------------------
-- Table structure for BASE_TIMETASK
-- ----------------------------

CREATE TABLE "BASE_TIMETASK" (
  "F_ID" NVARCHAR2(50) NOT NULL,
  "F_ENCODE" NVARCHAR2(50),
  "F_FULLNAME" NVARCHAR2(100),
  "F_EXECUTETYPE" NVARCHAR2(50),
  "F_EXECUTECONTENT" NCLOB,
  "F_EXECUTECYCLEJSON" NCLOB,
  "F_LASTRUNTIME" DATE,
  "F_NEXTRUNTIME" DATE,
  "F_RUNCOUNT" NUMBER(11,0),
  "F_DESCRIPTION" NCLOB,
  "F_SORTCODE" NUMBER(20,0),
  "F_ENABLEDMARK" NUMBER(11,0),
  "F_CREATORTIME" DATE,
  "F_CREATORUSERID" NVARCHAR2(50),
  "F_LASTMODIFYTIME" DATE,
  "F_LASTMODIFYUSERID" NVARCHAR2(50),
  "F_DELETEMARK" NUMBER(11,0),
  "F_DELETETIME" DATE,
  "F_DELETEUSERID" NVARCHAR2(50),
  "F_EXECUTORNAME" NVARCHAR2(50),
  "F_TENANTID" NVARCHAR2(50)
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "BASE_TIMETASK"."F_ID" IS '自然主键';
COMMENT ON COLUMN "BASE_TIMETASK"."F_ENCODE" IS '任务编码';
COMMENT ON COLUMN "BASE_TIMETASK"."F_FULLNAME" IS '任务名称';
COMMENT ON COLUMN "BASE_TIMETASK"."F_EXECUTETYPE" IS '执行类型';
COMMENT ON COLUMN "BASE_TIMETASK"."F_EXECUTECONTENT" IS '执行内容';
COMMENT ON COLUMN "BASE_TIMETASK"."F_EXECUTECYCLEJSON" IS '执行周期';
COMMENT ON COLUMN "BASE_TIMETASK"."F_LASTRUNTIME" IS '最后运行时间';
COMMENT ON COLUMN "BASE_TIMETASK"."F_NEXTRUNTIME" IS '下次运行时间';
COMMENT ON COLUMN "BASE_TIMETASK"."F_RUNCOUNT" IS '运行次数';
COMMENT ON COLUMN "BASE_TIMETASK"."F_DESCRIPTION" IS '描述';
COMMENT ON COLUMN "BASE_TIMETASK"."F_SORTCODE" IS '排序';
COMMENT ON COLUMN "BASE_TIMETASK"."F_ENABLEDMARK" IS '有效标志';
COMMENT ON COLUMN "BASE_TIMETASK"."F_CREATORTIME" IS '创建时间';
COMMENT ON COLUMN "BASE_TIMETASK"."F_CREATORUSERID" IS '创建用户';
COMMENT ON COLUMN "BASE_TIMETASK"."F_LASTMODIFYTIME" IS '修改时间';
COMMENT ON COLUMN "BASE_TIMETASK"."F_LASTMODIFYUSERID" IS '修改用户';
COMMENT ON COLUMN "BASE_TIMETASK"."F_DELETEMARK" IS '删除标志';
COMMENT ON COLUMN "BASE_TIMETASK"."F_DELETETIME" IS '删除时间';
COMMENT ON COLUMN "BASE_TIMETASK"."F_DELETEUSERID" IS '删除用户';
COMMENT ON COLUMN "BASE_TIMETASK"."F_EXECUTORNAME" IS '执行器名称';
COMMENT ON COLUMN "BASE_TIMETASK"."F_TENANTID" IS '租户id';
COMMENT ON TABLE "BASE_TIMETASK" IS '定时任务';

-- ----------------------------
-- Records of BASE_TIMETASK
-- ----------------------------

-- ----------------------------
-- Table structure for BASE_TIMETASKLOG
-- ----------------------------

CREATE TABLE "BASE_TIMETASKLOG" (
  "F_ID" NVARCHAR2(50) NOT NULL,
  "F_TASKID" NVARCHAR2(50),
  "F_RUNTIME" DATE,
  "F_RUNRESULT" NUMBER(11,0),
  "F_DESCRIPTION" NCLOB
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "BASE_TIMETASKLOG"."F_ID" IS '自然主键';
COMMENT ON COLUMN "BASE_TIMETASKLOG"."F_TASKID" IS '定时任务主键';
COMMENT ON COLUMN "BASE_TIMETASKLOG"."F_RUNTIME" IS '执行时间';
COMMENT ON COLUMN "BASE_TIMETASKLOG"."F_RUNRESULT" IS '执行结果';
COMMENT ON COLUMN "BASE_TIMETASKLOG"."F_DESCRIPTION" IS '执行说明';
COMMENT ON TABLE "BASE_TIMETASKLOG" IS '定时任务记录';

-- ----------------------------
-- Records of BASE_TIMETASKLOG
-- ----------------------------

-- ----------------------------
-- Table structure for XXL_JOB_GROUP
-- ----------------------------

CREATE TABLE "XXL_JOB_GROUP" (
  "ID" NVARCHAR2(50) NOT NULL,
  "APP_NAME" NVARCHAR2(64) NOT NULL,
  "TITLE" NVARCHAR2(64) NOT NULL,
  "ADDRESS_TYPE" NUMBER(4,0) NOT NULL,
  "ADDRESS_LIST" NCLOB,
  "UPDATE_TIME" DATE
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "XXL_JOB_GROUP"."APP_NAME" IS '执行器AppName';
COMMENT ON COLUMN "XXL_JOB_GROUP"."TITLE" IS '执行器名称';
COMMENT ON COLUMN "XXL_JOB_GROUP"."ADDRESS_TYPE" IS '执行器地址类型：0=自动注册、1=手动录入';
COMMENT ON COLUMN "XXL_JOB_GROUP"."ADDRESS_LIST" IS '执行器地址列表，多地址逗号分隔';

-- ----------------------------
-- Records of XXL_JOB_GROUP
-- ----------------------------
INSERT INTO "XXL_JOB_GROUP" VALUES ('8', 'xxl-job-executor-sample1', 'xxl-job-executor-sample1', '0', 'http://192.168.20.116:9999/', TO_DATE('2022-12-12 15:41:09', 'SYYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for XXL_JOB_INFO
-- ----------------------------

CREATE TABLE "XXL_JOB_INFO" (
  "ID" NVARCHAR2(50) NOT NULL,
  "JOB_GROUP" NVARCHAR2(50) NOT NULL,
  "JOB_DESC" NVARCHAR2(255) NOT NULL,
  "ADD_TIME" DATE,
  "UPDATE_TIME" DATE,
  "AUTHOR" NVARCHAR2(64),
  "ALARM_EMAIL" NVARCHAR2(255),
  "SCHEDULE_TYPE" NVARCHAR2(50) NOT NULL,
  "SCHEDULE_CONF" NVARCHAR2(128),
  "MISFIRE_STRATEGY" NVARCHAR2(50) NOT NULL,
  "EXECUTOR_ROUTE_STRATEGY" NVARCHAR2(50),
  "EXECUTOR_HANDLER" NVARCHAR2(255),
  "EXECUTOR_PARAM" NCLOB,
  "EXECUTOR_BLOCK_STRATEGY" NVARCHAR2(50),
  "EXECUTOR_TIMEOUT" NUMBER(11,0) NOT NULL,
  "EXECUTOR_FAIL_RETRY_COUNT" NUMBER(11,0) NOT NULL,
  "GLUE_TYPE" NVARCHAR2(50) NOT NULL,
  "GLUE_SOURCE" NCLOB,
  "GLUE_REMARK" NVARCHAR2(128),
  "GLUE_UPDATETIME" DATE,
  "CHILD_JOBID" NVARCHAR2(255),
  "TRIGGER_STATUS" NUMBER(4,0) NOT NULL,
  "TRIGGER_LAST_TIME" NUMBER(20,0) NOT NULL,
  "TRIGGER_NEXT_TIME" NUMBER(20,0) NOT NULL,
  "TENANTID" NVARCHAR2(50),
  "TASKID" NVARCHAR2(50)
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "XXL_JOB_INFO"."JOB_GROUP" IS '执行器主键ID';
COMMENT ON COLUMN "XXL_JOB_INFO"."AUTHOR" IS '作者';
COMMENT ON COLUMN "XXL_JOB_INFO"."ALARM_EMAIL" IS '报警邮件';
COMMENT ON COLUMN "XXL_JOB_INFO"."SCHEDULE_TYPE" IS '调度类型';
COMMENT ON COLUMN "XXL_JOB_INFO"."SCHEDULE_CONF" IS '调度配置，值含义取决于调度类型';
COMMENT ON COLUMN "XXL_JOB_INFO"."MISFIRE_STRATEGY" IS '调度过期策略';
COMMENT ON COLUMN "XXL_JOB_INFO"."EXECUTOR_ROUTE_STRATEGY" IS '执行器路由策略';
COMMENT ON COLUMN "XXL_JOB_INFO"."EXECUTOR_HANDLER" IS '执行器任务handler';
COMMENT ON COLUMN "XXL_JOB_INFO"."EXECUTOR_PARAM" IS '执行器任务参数';
COMMENT ON COLUMN "XXL_JOB_INFO"."EXECUTOR_BLOCK_STRATEGY" IS '阻塞处理策略';
COMMENT ON COLUMN "XXL_JOB_INFO"."EXECUTOR_TIMEOUT" IS '任务执行超时时间，单位秒';
COMMENT ON COLUMN "XXL_JOB_INFO"."EXECUTOR_FAIL_RETRY_COUNT" IS '失败重试次数';
COMMENT ON COLUMN "XXL_JOB_INFO"."GLUE_TYPE" IS 'GLUE类型';
COMMENT ON COLUMN "XXL_JOB_INFO"."GLUE_SOURCE" IS 'GLUE源代码';
COMMENT ON COLUMN "XXL_JOB_INFO"."GLUE_REMARK" IS 'GLUE备注';
COMMENT ON COLUMN "XXL_JOB_INFO"."GLUE_UPDATETIME" IS 'GLUE更新时间';
COMMENT ON COLUMN "XXL_JOB_INFO"."CHILD_JOBID" IS '子任务ID，多个逗号分隔';
COMMENT ON COLUMN "XXL_JOB_INFO"."TRIGGER_STATUS" IS '调度状态：0-停止，1-运行';
COMMENT ON COLUMN "XXL_JOB_INFO"."TRIGGER_LAST_TIME" IS '上次调度时间';
COMMENT ON COLUMN "XXL_JOB_INFO"."TRIGGER_NEXT_TIME" IS '下次调度时间';
COMMENT ON COLUMN "XXL_JOB_INFO"."TENANTID" IS '租户编码';
COMMENT ON COLUMN "XXL_JOB_INFO"."TASKID" IS '任务id';

-- ----------------------------
-- Records of XXL_JOB_INFO
-- ----------------------------

-- ----------------------------
-- Table structure for XXL_JOB_LOCK
-- ----------------------------

CREATE TABLE "XXL_JOB_LOCK" (
  "LOCK_NAME" NVARCHAR2(50) NOT NULL
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "XXL_JOB_LOCK"."LOCK_NAME" IS '锁名称';

-- ----------------------------
-- Records of XXL_JOB_LOCK
-- ----------------------------
INSERT INTO "XXL_JOB_LOCK" VALUES ('schedule_lock');

-- ----------------------------
-- Table structure for XXL_JOB_LOG
-- ----------------------------

CREATE TABLE "XXL_JOB_LOG" (
  "ID" NVARCHAR2(50) NOT NULL,
  "JOB_GROUP" NVARCHAR2(50) NOT NULL,
  "JOB_ID" NVARCHAR2(50) NOT NULL,
  "EXECUTOR_ADDRESS" NVARCHAR2(255),
  "EXECUTOR_HANDLER" NVARCHAR2(255),
  "EXECUTOR_PARAM" NCLOB,
  "EXECUTOR_SHARDING_PARAM" NVARCHAR2(20),
  "EXECUTOR_FAIL_RETRY_COUNT" NUMBER(11,0) NOT NULL,
  "TRIGGER_TIME" DATE,
  "TRIGGER_CODE" NUMBER(11,0) NOT NULL,
  "TRIGGER_MSG" NCLOB,
  "HANDLE_TIME" DATE,
  "HANDLE_CODE" NUMBER(11,0) NOT NULL,
  "HANDLE_MSG" NCLOB,
  "ALARM_STATUS" NUMBER(4,0) NOT NULL
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "XXL_JOB_LOG"."JOB_GROUP" IS '执行器主键ID';
COMMENT ON COLUMN "XXL_JOB_LOG"."JOB_ID" IS '任务，主键ID';
COMMENT ON COLUMN "XXL_JOB_LOG"."EXECUTOR_ADDRESS" IS '执行器地址，本次执行的地址';
COMMENT ON COLUMN "XXL_JOB_LOG"."EXECUTOR_HANDLER" IS '执行器任务handler';
COMMENT ON COLUMN "XXL_JOB_LOG"."EXECUTOR_PARAM" IS '执行器任务参数';
COMMENT ON COLUMN "XXL_JOB_LOG"."EXECUTOR_SHARDING_PARAM" IS '执行器任务分片参数，格式如 1/2';
COMMENT ON COLUMN "XXL_JOB_LOG"."EXECUTOR_FAIL_RETRY_COUNT" IS '失败重试次数';
COMMENT ON COLUMN "XXL_JOB_LOG"."TRIGGER_TIME" IS '调度-时间';
COMMENT ON COLUMN "XXL_JOB_LOG"."TRIGGER_CODE" IS '调度-结果';
COMMENT ON COLUMN "XXL_JOB_LOG"."TRIGGER_MSG" IS '调度-日志';
COMMENT ON COLUMN "XXL_JOB_LOG"."HANDLE_TIME" IS '执行-时间';
COMMENT ON COLUMN "XXL_JOB_LOG"."HANDLE_CODE" IS '执行-状态';
COMMENT ON COLUMN "XXL_JOB_LOG"."HANDLE_MSG" IS '执行-日志';
COMMENT ON COLUMN "XXL_JOB_LOG"."ALARM_STATUS" IS '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败';

-- ----------------------------
-- Records of XXL_JOB_LOG
-- ----------------------------

-- ----------------------------
-- Table structure for XXL_JOB_LOGGLUE
-- ----------------------------

CREATE TABLE "XXL_JOB_LOGGLUE" (
  "ID" NVARCHAR2(50) NOT NULL,
  "JOB_ID" NVARCHAR2(50) NOT NULL,
  "GLUE_TYPE" NVARCHAR2(50),
  "GLUE_SOURCE" NCLOB,
  "GLUE_REMARK" NVARCHAR2(128) NOT NULL,
  "ADD_TIME" DATE,
  "UPDATE_TIME" DATE
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "XXL_JOB_LOGGLUE"."JOB_ID" IS '任务，主键ID';
COMMENT ON COLUMN "XXL_JOB_LOGGLUE"."GLUE_TYPE" IS 'GLUE类型';
COMMENT ON COLUMN "XXL_JOB_LOGGLUE"."GLUE_SOURCE" IS 'GLUE源代码';
COMMENT ON COLUMN "XXL_JOB_LOGGLUE"."GLUE_REMARK" IS 'GLUE备注';

-- ----------------------------
-- Records of XXL_JOB_LOGGLUE
-- ----------------------------

-- ----------------------------
-- Table structure for XXL_JOB_LOG_REPORT
-- ----------------------------

CREATE TABLE "XXL_JOB_LOG_REPORT" (
  "ID" NVARCHAR2(50) NOT NULL,
  "TRIGGER_DAY" DATE,
  "RUNNING_COUNT" NUMBER(11,0) NOT NULL,
  "SUC_COUNT" NUMBER(11,0) NOT NULL,
  "FAIL_COUNT" NUMBER(11,0) NOT NULL,
  "UPDATE_TIME" DATE
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "XXL_JOB_LOG_REPORT"."TRIGGER_DAY" IS '调度-时间';
COMMENT ON COLUMN "XXL_JOB_LOG_REPORT"."RUNNING_COUNT" IS '运行中-日志数量';
COMMENT ON COLUMN "XXL_JOB_LOG_REPORT"."SUC_COUNT" IS '执行成功-日志数量';
COMMENT ON COLUMN "XXL_JOB_LOG_REPORT"."FAIL_COUNT" IS '执行失败-日志数量';

-- ----------------------------
-- Records of XXL_JOB_LOG_REPORT
-- ----------------------------
INSERT INTO "XXL_JOB_LOG_REPORT" VALUES ('1602187341432389633', TO_DATE('2022-12-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '0', '0', '0', NULL);
INSERT INTO "XXL_JOB_LOG_REPORT" VALUES ('1602187341746962434', TO_DATE('2022-12-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '0', '0', '0', NULL);
INSERT INTO "XXL_JOB_LOG_REPORT" VALUES ('1602187342342553602', TO_DATE('2022-12-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '0', '0', '0', NULL);

-- ----------------------------
-- Table structure for XXL_JOB_REGISTRY
-- ----------------------------

CREATE TABLE "XXL_JOB_REGISTRY" (
  "ID" NVARCHAR2(50) NOT NULL,
  "REGISTRY_GROUP" NVARCHAR2(50) NOT NULL,
  "REGISTRY_KEY" NVARCHAR2(255) NOT NULL,
  "REGISTRY_VALUE" NVARCHAR2(255) NOT NULL,
  "UPDATE_TIME" DATE
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of XXL_JOB_REGISTRY
-- ----------------------------

-- ----------------------------
-- Table structure for XXL_JOB_USER
-- ----------------------------

CREATE TABLE "XXL_JOB_USER" (
  "ID" NVARCHAR2(50) NOT NULL,
  "USERNAME" NVARCHAR2(50) NOT NULL,
  "PASSWORD" NVARCHAR2(50) NOT NULL,
  "ROLE" NUMBER(4,0) NOT NULL,
  "PERMISSION" NVARCHAR2(255)
)
TABLESPACE "JNPF_TAB_SPACE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "XXL_JOB_USER"."USERNAME" IS '账号';
COMMENT ON COLUMN "XXL_JOB_USER"."PASSWORD" IS '密码';
COMMENT ON COLUMN "XXL_JOB_USER"."ROLE" IS '角色：0-普通用户、1-管理员';
COMMENT ON COLUMN "XXL_JOB_USER"."PERMISSION" IS '权限：执行器ID列表，多个逗号分割';

-- ----------------------------
-- Records of XXL_JOB_USER
-- ----------------------------
INSERT INTO "XXL_JOB_USER" VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '1', NULL);

-- ----------------------------
-- Primary Key structure for table BASE_HANDLERNAME
-- ----------------------------
ALTER TABLE "BASE_HANDLERNAME" ADD CONSTRAINT "SYS_C0020185" PRIMARY KEY ("F_ID");

-- ----------------------------
-- Checks structure for table BASE_HANDLERNAME
-- ----------------------------
ALTER TABLE "BASE_HANDLERNAME" ADD CONSTRAINT "SYS_C0020144" CHECK ("F_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table BASE_TIMETASK
-- ----------------------------
ALTER TABLE "BASE_TIMETASK" ADD CONSTRAINT "SYS_C0020188" PRIMARY KEY ("F_ID");

-- ----------------------------
-- Checks structure for table BASE_TIMETASK
-- ----------------------------
ALTER TABLE "BASE_TIMETASK" ADD CONSTRAINT "SYS_C0020150" CHECK ("F_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table BASE_TIMETASKLOG
-- ----------------------------
ALTER TABLE "BASE_TIMETASKLOG" ADD CONSTRAINT "SYS_C0020186" PRIMARY KEY ("F_ID");

-- ----------------------------
-- Checks structure for table BASE_TIMETASKLOG
-- ----------------------------
ALTER TABLE "BASE_TIMETASKLOG" ADD CONSTRAINT "SYS_C0020145" CHECK ("F_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table XXL_JOB_GROUP
-- ----------------------------
ALTER TABLE "XXL_JOB_GROUP" ADD CONSTRAINT "SYS_C0020187" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table XXL_JOB_GROUP
-- ----------------------------
ALTER TABLE "XXL_JOB_GROUP" ADD CONSTRAINT "SYS_C0020146" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_GROUP" ADD CONSTRAINT "SYS_C0020147" CHECK ("APP_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_GROUP" ADD CONSTRAINT "SYS_C0020148" CHECK ("TITLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_GROUP" ADD CONSTRAINT "SYS_C0020149" CHECK ("ADDRESS_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table XXL_JOB_INFO
-- ----------------------------
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020191" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table XXL_JOB_INFO
-- ----------------------------
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020151" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020152" CHECK ("JOB_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020153" CHECK ("JOB_DESC" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020154" CHECK ("SCHEDULE_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020155" CHECK ("MISFIRE_STRATEGY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020156" CHECK ("EXECUTOR_TIMEOUT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020157" CHECK ("EXECUTOR_FAIL_RETRY_COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020158" CHECK ("GLUE_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020159" CHECK ("TRIGGER_STATUS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020160" CHECK ("TRIGGER_LAST_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_INFO" ADD CONSTRAINT "SYS_C0020161" CHECK ("TRIGGER_NEXT_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table XXL_JOB_LOCK
-- ----------------------------
ALTER TABLE "XXL_JOB_LOCK" ADD CONSTRAINT "SYS_C0020189" PRIMARY KEY ("LOCK_NAME");

-- ----------------------------
-- Checks structure for table XXL_JOB_LOCK
-- ----------------------------
ALTER TABLE "XXL_JOB_LOCK" ADD CONSTRAINT "SYS_C0020162" CHECK ("LOCK_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table XXL_JOB_LOG
-- ----------------------------
ALTER TABLE "XXL_JOB_LOG" ADD CONSTRAINT "SYS_C0020194" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table XXL_JOB_LOG
-- ----------------------------
ALTER TABLE "XXL_JOB_LOG" ADD CONSTRAINT "SYS_C0020170" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG" ADD CONSTRAINT "SYS_C0020171" CHECK ("JOB_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG" ADD CONSTRAINT "SYS_C0020172" CHECK ("JOB_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG" ADD CONSTRAINT "SYS_C0020173" CHECK ("EXECUTOR_FAIL_RETRY_COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG" ADD CONSTRAINT "SYS_C0020174" CHECK ("TRIGGER_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG" ADD CONSTRAINT "SYS_C0020175" CHECK ("HANDLE_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG" ADD CONSTRAINT "SYS_C0020176" CHECK ("ALARM_STATUS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table XXL_JOB_LOG
-- ----------------------------
CREATE INDEX "I_HANDLE_CODE"
  ON "XXL_JOB_LOG" ("HANDLE_CODE" ASC)
  LOGGING
  TABLESPACE "JNPF_TAB_SPACE"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "I_JOB_ID"
  ON "XXL_JOB_LOG" ("TRIGGER_TIME" ASC, "JOB_ID" ASC)
  LOGGING
  TABLESPACE "JNPF_TAB_SPACE"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "I_TRIGGER_TIME"
  ON "XXL_JOB_LOG" ("TRIGGER_TIME" ASC)
  LOGGING
  TABLESPACE "JNPF_TAB_SPACE"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table XXL_JOB_LOGGLUE
-- ----------------------------
ALTER TABLE "XXL_JOB_LOGGLUE" ADD CONSTRAINT "SYS_C0020190" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table XXL_JOB_LOGGLUE
-- ----------------------------
ALTER TABLE "XXL_JOB_LOGGLUE" ADD CONSTRAINT "SYS_C0020163" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOGGLUE" ADD CONSTRAINT "SYS_C0020164" CHECK ("JOB_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOGGLUE" ADD CONSTRAINT "SYS_C0020165" CHECK ("GLUE_REMARK" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table XXL_JOB_LOG_REPORT
-- ----------------------------
ALTER TABLE "XXL_JOB_LOG_REPORT" ADD CONSTRAINT "SYS_C0020195" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table XXL_JOB_LOG_REPORT
-- ----------------------------
ALTER TABLE "XXL_JOB_LOG_REPORT" ADD CONSTRAINT "SYS_C0020177" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG_REPORT" ADD CONSTRAINT "SYS_C0020178" CHECK ("RUNNING_COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG_REPORT" ADD CONSTRAINT "SYS_C0020179" CHECK ("SUC_COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_LOG_REPORT" ADD CONSTRAINT "SYS_C0020180" CHECK ("FAIL_COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table XXL_JOB_LOG_REPORT
-- ----------------------------
CREATE UNIQUE INDEX "I_TRIGGER_DAY"
  ON "XXL_JOB_LOG_REPORT" ("TRIGGER_DAY" ASC)
  LOGGING
  TABLESPACE "JNPF_TAB_SPACE"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table XXL_JOB_REGISTRY
-- ----------------------------
ALTER TABLE "XXL_JOB_REGISTRY" ADD CONSTRAINT "SYS_C0020193" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table XXL_JOB_REGISTRY
-- ----------------------------
ALTER TABLE "XXL_JOB_REGISTRY" ADD CONSTRAINT "SYS_C0020181" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_REGISTRY" ADD CONSTRAINT "SYS_C0020182" CHECK ("REGISTRY_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_REGISTRY" ADD CONSTRAINT "SYS_C0020183" CHECK ("REGISTRY_KEY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_REGISTRY" ADD CONSTRAINT "SYS_C0020184" CHECK ("REGISTRY_VALUE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table XXL_JOB_REGISTRY
-- ----------------------------
CREATE INDEX "I_G_K_V"
  ON "XXL_JOB_REGISTRY" ("REGISTRY_GROUP" ASC, "REGISTRY_VALUE" ASC, "REGISTRY_KEY" ASC)
  LOGGING
  TABLESPACE "JNPF_TAB_SPACE"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table XXL_JOB_USER
-- ----------------------------
ALTER TABLE "XXL_JOB_USER" ADD CONSTRAINT "SYS_C0020192" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table XXL_JOB_USER
-- ----------------------------
ALTER TABLE "XXL_JOB_USER" ADD CONSTRAINT "SYS_C0020166" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_USER" ADD CONSTRAINT "SYS_C0020167" CHECK ("USERNAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_USER" ADD CONSTRAINT "SYS_C0020168" CHECK ("PASSWORD" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "XXL_JOB_USER" ADD CONSTRAINT "SYS_C0020169" CHECK ("ROLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table XXL_JOB_USER
-- ----------------------------
CREATE UNIQUE INDEX "I_USERNAME"
  ON "XXL_JOB_USER" ("USERNAME" ASC)
  LOGGING
  TABLESPACE "JNPF_TAB_SPACE"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);