boyue2025/boyue_jnpf
3
0
Fork 0
mirror of https://gitee.com/myxzgzs/boyue_jnpf.git synced 2025-08-08 07:12:42 +08:00
Code Issues Packages Projects Releases Wiki Activity
boyue_jnpf/sql_init/SQLServer/jnpf_xxljob_init.sql
luoyu a565d464e0 Initial commit
2025-06-30 09:38:03 +08:00

1067 lines
28 KiB
Transact-SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- ----------------------------
-- 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
Reference in New Issue View Git Blame Copy Permalink