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

1067 lines
28 KiB
MySQL
Raw Permalink Normal View History

Initial commit
2025-06-30 09:38:03 +08:00
-- ----------------------------
-- 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 Copy Permalink