jnpf-database-v6x/SQLServer/jnpf_xxljob_init.sql

-- ----------------------------
-- Table structure for base_handlername
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[base_handlername]') AND type IN ('U'))
	DROP TABLE [dbo].[base_handlername]
GO

CREATE TABLE [dbo].[base_handlername] (
  [F_Id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [F_HandlerName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_Executor] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[base_handlername] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'base_handlername',
'COLUMN', N'F_Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'base_handlername',
'COLUMN', N'F_HandlerName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器名称',
'SCHEMA', N'dbo',
'TABLE', N'base_handlername',
'COLUMN', N'F_Executor'
GO


-- ----------------------------
-- Records of base_handlername
-- ----------------------------

-- ----------------------------
-- Table structure for base_timetask
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[base_timetask]') AND type IN ('U'))
	DROP TABLE [dbo].[base_timetask]
GO

CREATE TABLE [dbo].[base_timetask] (
  [F_Id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [F_EnCode] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_FullName] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_ExecuteType] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_ExecuteContent] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_ExecuteCycleJson] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_LastRunTime] datetime  NULL,
  [F_NextRunTime] datetime  NULL,
  [F_RunCount] int  NULL,
  [F_Description] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_SortCode] bigint  NULL,
  [F_EnabledMark] int  NULL,
  [F_CreatorTime] datetime  NULL,
  [F_CreatorUserId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_LastModifyTime] datetime  NULL,
  [F_LastModifyUserId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_DeleteMark] int  NULL,
  [F_DeleteTime] datetime  NULL,
  [F_DeleteUserId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_ExecutorName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_TenantId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[base_timetask] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'自然主键',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务编码',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_EnCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_FullName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行类型',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_ExecuteType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行内容',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_ExecuteContent'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行周期',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_ExecuteCycleJson'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后运行时间',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_LastRunTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'下次运行时间',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_NextRunTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'运行次数',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_RunCount'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_Description'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_SortCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'有效标志',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_EnabledMark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_CreatorTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建用户',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_CreatorUserId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_LastModifyTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改用户',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_LastModifyUserId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标志',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_DeleteMark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除时间',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_DeleteTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除用户',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_DeleteUserId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器名称',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_ExecutorName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'租户id',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask',
'COLUMN', N'F_TenantId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'定时任务',
'SCHEMA', N'dbo',
'TABLE', N'base_timetask'
GO


-- ----------------------------
-- Records of base_timetask
-- ----------------------------

-- ----------------------------
-- Table structure for base_timetasklog
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[base_timetasklog]') AND type IN ('U'))
	DROP TABLE [dbo].[base_timetasklog]
GO

CREATE TABLE [dbo].[base_timetasklog] (
  [F_Id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [F_TaskId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_RunTime] datetime  NULL,
  [F_RunResult] int  NULL,
  [F_Description] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[base_timetasklog] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'自然主键',
'SCHEMA', N'dbo',
'TABLE', N'base_timetasklog',
'COLUMN', N'F_Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'定时任务主键',
'SCHEMA', N'dbo',
'TABLE', N'base_timetasklog',
'COLUMN', N'F_TaskId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行时间',
'SCHEMA', N'dbo',
'TABLE', N'base_timetasklog',
'COLUMN', N'F_RunTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行结果',
'SCHEMA', N'dbo',
'TABLE', N'base_timetasklog',
'COLUMN', N'F_RunResult'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行说明',
'SCHEMA', N'dbo',
'TABLE', N'base_timetasklog',
'COLUMN', N'F_Description'
GO

EXEC sp_addextendedproperty
'MS_Description', N'定时任务记录',
'SCHEMA', N'dbo',
'TABLE', N'base_timetasklog'
GO


-- ----------------------------
-- Records of base_timetasklog
-- ----------------------------

-- ----------------------------
-- Table structure for xxl_job_group
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[xxl_job_group]') AND type IN ('U'))
	DROP TABLE [dbo].[xxl_job_group]
GO

CREATE TABLE [dbo].[xxl_job_group] (
  [id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [app_name] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [title] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [address_type] tinyint  NOT NULL,
  [address_list] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime  NULL
)
GO

ALTER TABLE [dbo].[xxl_job_group] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器AppName',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_group',
'COLUMN', N'app_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器名称',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_group',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器地址类型：0=自动注册、1=手动录入',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_group',
'COLUMN', N'address_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器地址列表，多地址逗号分隔',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_group',
'COLUMN', N'address_list'
GO


-- ----------------------------
-- Records of xxl_job_group
-- ----------------------------
INSERT INTO [dbo].[xxl_job_group] ([id], [app_name], [title], [address_type], [address_list], [update_time]) VALUES (N'8', N'xxl-job-executor-sample1', N'xxl-job-executor-sample1', N'0', N'http://192.168.20.116:9999/', N'2022-12-12 15:35:37')
GO


-- ----------------------------
-- Table structure for xxl_job_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[xxl_job_info]') AND type IN ('U'))
	DROP TABLE [dbo].[xxl_job_info]
GO

CREATE TABLE [dbo].[xxl_job_info] (
  [id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [job_group] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [job_desc] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [add_time] datetime  NULL,
  [update_time] datetime  NULL,
  [author] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [alarm_email] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [schedule_type] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [schedule_conf] nvarchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [misfire_strategy] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [executor_route_strategy] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [executor_handler] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [executor_param] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [executor_block_strategy] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [executor_timeout] int  NOT NULL,
  [executor_fail_retry_count] int  NOT NULL,
  [glue_type] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [glue_source] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [glue_remark] nvarchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [glue_updatetime] datetime  NULL,
  [child_jobid] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [trigger_status] tinyint  NOT NULL,
  [trigger_last_time] bigint  NOT NULL,
  [trigger_next_time] bigint  NOT NULL,
  [tenantId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [taskId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[xxl_job_info] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器主键ID',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'job_group'
GO

EXEC sp_addextendedproperty
'MS_Description', N'作者',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'author'
GO

EXEC sp_addextendedproperty
'MS_Description', N'报警邮件',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'alarm_email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度类型',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'schedule_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度配置，值含义取决于调度类型',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'schedule_conf'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度过期策略',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'misfire_strategy'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器路由策略',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'executor_route_strategy'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器任务handler',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'executor_handler'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器任务参数',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'executor_param'
GO

EXEC sp_addextendedproperty
'MS_Description', N'阻塞处理策略',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'executor_block_strategy'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务执行超时时间，单位秒',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'executor_timeout'
GO

EXEC sp_addextendedproperty
'MS_Description', N'失败重试次数',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'executor_fail_retry_count'
GO

EXEC sp_addextendedproperty
'MS_Description', N'GLUE类型',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'glue_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'GLUE源代码',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'glue_source'
GO

EXEC sp_addextendedproperty
'MS_Description', N'GLUE备注',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'glue_remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'GLUE更新时间',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'glue_updatetime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'子任务ID，多个逗号分隔',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'child_jobid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度状态：0-停止，1-运行',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'trigger_status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'上次调度时间',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'trigger_last_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'下次调度时间',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'trigger_next_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'租户编码',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'tenantId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务id',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_info',
'COLUMN', N'taskId'
GO


-- ----------------------------
-- Records of xxl_job_info
-- ----------------------------

-- ----------------------------
-- Table structure for xxl_job_lock
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[xxl_job_lock]') AND type IN ('U'))
	DROP TABLE [dbo].[xxl_job_lock]
GO

CREATE TABLE [dbo].[xxl_job_lock] (
  [lock_name] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[xxl_job_lock] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'锁名称',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_lock',
'COLUMN', N'lock_name'
GO


-- ----------------------------
-- Records of xxl_job_lock
-- ----------------------------
INSERT INTO [dbo].[xxl_job_lock] ([lock_name]) VALUES (N'schedule_lock')
GO


-- ----------------------------
-- Table structure for xxl_job_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[xxl_job_log]') AND type IN ('U'))
	DROP TABLE [dbo].[xxl_job_log]
GO

CREATE TABLE [dbo].[xxl_job_log] (
  [id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [job_group] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [job_id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [executor_address] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [executor_handler] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [executor_param] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [executor_sharding_param] nvarchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [executor_fail_retry_count] int  NOT NULL,
  [trigger_time] datetime  NULL,
  [trigger_code] int  NOT NULL,
  [trigger_msg] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [handle_time] datetime  NULL,
  [handle_code] int  NOT NULL,
  [handle_msg] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [alarm_status] tinyint  NOT NULL
)
GO

ALTER TABLE [dbo].[xxl_job_log] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器主键ID',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'job_group'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务，主键ID',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'job_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器地址，本次执行的地址',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'executor_address'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器任务handler',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'executor_handler'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器任务参数',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'executor_param'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行器任务分片参数，格式如 1/2',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'executor_sharding_param'
GO

EXEC sp_addextendedproperty
'MS_Description', N'失败重试次数',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'executor_fail_retry_count'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度-时间',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'trigger_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度-结果',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'trigger_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度-日志',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'trigger_msg'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行-时间',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'handle_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行-状态',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'handle_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行-日志',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'handle_msg'
GO

EXEC sp_addextendedproperty
'MS_Description', N'告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log',
'COLUMN', N'alarm_status'
GO


-- ----------------------------
-- Records of xxl_job_log
-- ----------------------------

-- ----------------------------
-- Table structure for xxl_job_log_report
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[xxl_job_log_report]') AND type IN ('U'))
	DROP TABLE [dbo].[xxl_job_log_report]
GO

CREATE TABLE [dbo].[xxl_job_log_report] (
  [id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [trigger_day] datetime  NULL,
  [running_count] int  NOT NULL,
  [suc_count] int  NOT NULL,
  [fail_count] int  NOT NULL,
  [update_time] datetime  NULL
)
GO

ALTER TABLE [dbo].[xxl_job_log_report] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度-时间',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log_report',
'COLUMN', N'trigger_day'
GO

EXEC sp_addextendedproperty
'MS_Description', N'运行中-日志数量',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log_report',
'COLUMN', N'running_count'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行成功-日志数量',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log_report',
'COLUMN', N'suc_count'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行失败-日志数量',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_log_report',
'COLUMN', N'fail_count'
GO


-- ----------------------------
-- Records of xxl_job_log_report
-- ----------------------------
INSERT INTO [dbo].[xxl_job_log_report] ([id], [trigger_day], [running_count], [suc_count], [fail_count], [update_time]) VALUES (N'1602187341432389633', N'2022-12-12 00:00:00', N'0', N'0', N'0', NULL)
GO

INSERT INTO [dbo].[xxl_job_log_report] ([id], [trigger_day], [running_count], [suc_count], [fail_count], [update_time]) VALUES (N'1602187341746962434', N'2022-12-11 00:00:00', N'0', N'0', N'0', NULL)
GO

INSERT INTO [dbo].[xxl_job_log_report] ([id], [trigger_day], [running_count], [suc_count], [fail_count], [update_time]) VALUES (N'1602187342342553602', N'2022-12-10 00:00:00', N'0', N'0', N'0', NULL)
GO


-- ----------------------------
-- Table structure for xxl_job_logglue
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[xxl_job_logglue]') AND type IN ('U'))
	DROP TABLE [dbo].[xxl_job_logglue]
GO

CREATE TABLE [dbo].[xxl_job_logglue] (
  [id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [job_id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [glue_type] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [glue_source] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [glue_remark] nvarchar(128) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [add_time] datetime  NULL,
  [update_time] datetime  NULL
)
GO

ALTER TABLE [dbo].[xxl_job_logglue] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务，主键ID',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_logglue',
'COLUMN', N'job_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'GLUE类型',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_logglue',
'COLUMN', N'glue_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'GLUE源代码',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_logglue',
'COLUMN', N'glue_source'
GO

EXEC sp_addextendedproperty
'MS_Description', N'GLUE备注',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_logglue',
'COLUMN', N'glue_remark'
GO


-- ----------------------------
-- Records of xxl_job_logglue
-- ----------------------------

-- ----------------------------
-- Table structure for xxl_job_registry
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[xxl_job_registry]') AND type IN ('U'))
	DROP TABLE [dbo].[xxl_job_registry]
GO

CREATE TABLE [dbo].[xxl_job_registry] (
  [id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [registry_group] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [registry_key] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [registry_value] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [update_time] datetime  NULL
)
GO

ALTER TABLE [dbo].[xxl_job_registry] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of xxl_job_registry
-- ----------------------------

-- ----------------------------
-- Table structure for xxl_job_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[xxl_job_user]') AND type IN ('U'))
	DROP TABLE [dbo].[xxl_job_user]
GO

CREATE TABLE [dbo].[xxl_job_user] (
  [id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [username] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [password] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [role] tinyint  NOT NULL,
  [permission] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[xxl_job_user] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'账号',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_user',
'COLUMN', N'username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_user',
'COLUMN', N'password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色：0-普通用户、1-管理员',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_user',
'COLUMN', N'role'
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限：执行器ID列表，多个逗号分割',
'SCHEMA', N'dbo',
'TABLE', N'xxl_job_user',
'COLUMN', N'permission'
GO


-- ----------------------------
-- Records of xxl_job_user
-- ----------------------------
INSERT INTO [dbo].[xxl_job_user] ([id], [username], [password], [role], [permission]) VALUES (N'1', N'admin', N'e10adc3949ba59abbe56e057f20f883e', N'1', NULL)
GO


-- ----------------------------
-- Primary Key structure for table base_handlername
-- ----------------------------
ALTER TABLE [dbo].[base_handlername] ADD CONSTRAINT [PK__base_han__2C6EC7231A712B29] PRIMARY KEY CLUSTERED ([F_Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table base_timetask
-- ----------------------------
ALTER TABLE [dbo].[base_timetask] ADD CONSTRAINT [PK__base_tim__2C6EC723059944A9] PRIMARY KEY CLUSTERED ([F_Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table base_timetasklog
-- ----------------------------
ALTER TABLE [dbo].[base_timetasklog] ADD CONSTRAINT [PK__base_tim__2C6EC72317A1B4F9] PRIMARY KEY CLUSTERED ([F_Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table xxl_job_group
-- ----------------------------
ALTER TABLE [dbo].[xxl_job_group] ADD CONSTRAINT [PK__xxl_job___3213E83FF127DBC2] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table xxl_job_info
-- ----------------------------
ALTER TABLE [dbo].[xxl_job_info] ADD CONSTRAINT [PK__xxl_job___3213E83FC3E92D83] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table xxl_job_lock
-- ----------------------------
ALTER TABLE [dbo].[xxl_job_lock] ADD CONSTRAINT [PK__xxl_job___7BE7AEAB5CE868F7] PRIMARY KEY CLUSTERED ([lock_name])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table xxl_job_log
-- ----------------------------
CREATE NONCLUSTERED INDEX [I_trigger_time]
ON [dbo].[xxl_job_log] (
  [trigger_time] ASC
)
GO

CREATE NONCLUSTERED INDEX [I_handle_code]
ON [dbo].[xxl_job_log] (
  [handle_code] ASC
)
GO

CREATE NONCLUSTERED INDEX [I_job_id]
ON [dbo].[xxl_job_log] (
  [job_id] ASC,
  [trigger_time] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table xxl_job_log
-- ----------------------------
ALTER TABLE [dbo].[xxl_job_log] ADD CONSTRAINT [PK__xxl_job___3213E83FBE4F2C1D] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table xxl_job_log_report
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [i_trigger_day]
ON [dbo].[xxl_job_log_report] (
  [trigger_day] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table xxl_job_log_report
-- ----------------------------
ALTER TABLE [dbo].[xxl_job_log_report] ADD CONSTRAINT [PK__xxl_job___3213E83FF8C8F0E0] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table xxl_job_logglue
-- ----------------------------
ALTER TABLE [dbo].[xxl_job_logglue] ADD CONSTRAINT [PK__xxl_job___3213E83FB1FFEB48] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table xxl_job_registry
-- ----------------------------
CREATE NONCLUSTERED INDEX [i_g_k_v]
ON [dbo].[xxl_job_registry] (
  [registry_group] ASC,
  [registry_key] ASC,
  [registry_value] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table xxl_job_registry
-- ----------------------------
ALTER TABLE [dbo].[xxl_job_registry] ADD CONSTRAINT [PK__xxl_job___3213E83F6EB65FEF] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table xxl_job_user
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [i_username]
ON [dbo].[xxl_job_user] (
  [username] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table xxl_job_user
-- ----------------------------
ALTER TABLE [dbo].[xxl_job_user] ADD CONSTRAINT [PK__xxl_job___3213E83F42BE27C5] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO