# WebQuartz

**Repository Path**: ghost_lin/WebQuartz

## Basic Information

- **Project Name**: WebQuartz
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-02-01
- **Last Updated**: 2026-02-05

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 定时任务

```sql
-- [dbo].[AccessIPAuth] definition

-- Drop table

-- DROP TABLE [dbo].[AccessIPAuth];

CREATE TABLE [dbo].[AccessIPAuth] (
	[ID] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[AllowIP] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[AllowMAC] nvarchar(100) COLLATE [ci_x_icu] NULL,
	[CreateTime] datetime NOT NULL,
	[Describe] nvarchar(200) COLLATE [ci_x_icu] NULL,
	CONSTRAINT [AccessIPAuth_pkey] PRIMARY KEY (ID)
);
COMMENT ON TABLE [dbo].[AccessIPAuth] IS 'IP白名单';

-- Column comments

COMMENT ON COLUMN [dbo].[AccessIPAuth].[ID] IS '主键';
COMMENT ON COLUMN [dbo].[AccessIPAuth].[AllowIP] IS '白名单IP';
COMMENT ON COLUMN [dbo].[AccessIPAuth].[AllowMAC] IS '白名单物理地址';
COMMENT ON COLUMN [dbo].[AccessIPAuth].[CreateTime] IS '创建时间';
COMMENT ON COLUMN [dbo].[AccessIPAuth].[Describe] IS '简述';

-- [dbo].[QRTZ_BLOB_TRIGGERS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_BLOB_TRIGGERS];

CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[BLOB_DATA] image NULL
);


-- [dbo].[QRTZ_CALENDARS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_CALENDARS];

CREATE TABLE [dbo].[QRTZ_CALENDARS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[CALENDAR_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[CALENDAR] image NOT NULL
);


-- [dbo].[QRTZ_CRON_TRIGGERS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_CRON_TRIGGERS];

CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[CRON_EXPRESSION] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[TIME_ZONE_ID] varchar(80) COLLATE [ci_x_icu] NULL
);


-- [dbo].[QRTZ_FIRED_TRIGGERS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_FIRED_TRIGGERS];

CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[ENTRY_ID] varchar(95) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[INSTANCE_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[FIRED_TIME] bigint NOT NULL,
	[SCHED_TIME] bigint NOT NULL,
	[PRIORITY] int NOT NULL,
	[STATE] varchar(16) COLLATE [ci_x_icu] NOT NULL,
	[JOB_NAME] varchar(200) COLLATE [ci_x_icu] NULL,
	[JOB_GROUP] varchar(200) COLLATE [ci_x_icu] NULL,
	[IS_NONCONCURRENT] varchar(1) COLLATE [ci_x_icu] NULL,
	[REQUESTS_RECOVERY] varchar(1) COLLATE [ci_x_icu] NULL
);


-- [dbo].[QRTZ_JOB_DETAILS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_JOB_DETAILS];

CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[JOB_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[JOB_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[DESCRIPTION] varchar(250) COLLATE [ci_x_icu] NULL,
	[JOB_CLASS_NAME] varchar(250) COLLATE [ci_x_icu] NOT NULL,
	[IS_DURABLE] varchar(1) COLLATE [ci_x_icu] NOT NULL,
	[IS_NONCONCURRENT] varchar(1) COLLATE [ci_x_icu] NOT NULL,
	[IS_UPDATE_DATA] varchar(1) COLLATE [ci_x_icu] NOT NULL,
	[REQUESTS_RECOVERY] varchar(1) COLLATE [ci_x_icu] NOT NULL,
	[JOB_DATA] image NULL
);


-- [dbo].[QRTZ_LOCKS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_LOCKS];

CREATE TABLE [dbo].[QRTZ_LOCKS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[LOCK_NAME] varchar(40) COLLATE [ci_x_icu] NOT NULL
);


-- [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS];

CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL
);


-- [dbo].[QRTZ_SCHEDULER_STATE] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_SCHEDULER_STATE];

CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[INSTANCE_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[LAST_CHECKIN_TIME] bigint NOT NULL,
	[CHECKIN_INTERVAL] bigint NOT NULL
);


-- [dbo].[QRTZ_SIMPLE_TRIGGERS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS];

CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[REPEAT_COUNT] bigint NOT NULL,
	[REPEAT_INTERVAL] bigint NOT NULL,
	[TIMES_TRIGGERED] bigint NOT NULL
);


-- [dbo].[QRTZ_SIMPROP_TRIGGERS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS];

CREATE TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[STR_PROP_1] varchar(512) COLLATE [ci_x_icu] NULL,
	[STR_PROP_2] varchar(512) COLLATE [ci_x_icu] NULL,
	[STR_PROP_3] varchar(512) COLLATE [ci_x_icu] NULL,
	[INT_PROP_1] int NULL,
	[INT_PROP_2] int NULL,
	[LONG_PROP_1] bigint NULL,
	[LONG_PROP_2] bigint NULL,
	[DEC_PROP_1] numeric(13,4) NULL,
	[DEC_PROP_2] numeric(13,4) NULL,
	[BOOL_PROP_1] varchar(1) COLLATE [ci_x_icu] NULL,
	[BOOL_PROP_2] varchar(1) COLLATE [ci_x_icu] NULL
);


-- [dbo].[QRTZ_TRIGGERS] definition

-- Drop table

-- DROP TABLE [dbo].[QRTZ_TRIGGERS];

CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
	[SCHED_NAME] varchar(120) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[JOB_NAME] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[JOB_GROUP] varchar(200) COLLATE [ci_x_icu] NOT NULL,
	[DESCRIPTION] varchar(250) COLLATE [ci_x_icu] NULL,
	[NEXT_FIRE_TIME] bigint NULL,
	[PREV_FIRE_TIME] bigint NULL,
	[PRIORITY] int NULL,
	[TRIGGER_STATE] varchar(16) COLLATE [ci_x_icu] NOT NULL,
	[TRIGGER_TYPE] varchar(8) COLLATE [ci_x_icu] NOT NULL,
	[START_TIME] bigint NOT NULL,
	[END_TIME] bigint NULL,
	[CALENDAR_NAME] varchar(200) COLLATE [ci_x_icu] NULL,
	[MISFIRE_INSTR] smallint NULL,
	[JOB_DATA] image NULL
);


-- [dbo].[SysJob] definition

-- Drop table

-- DROP TABLE [dbo].[SysJob];

CREATE TABLE [dbo].[SysJob] (
	[ID] nvarchar(36) COLLATE [ci_x_icu] NOT NULL,
	[JobName] nvarchar(100) COLLATE [ci_x_icu] NOT NULL,
	[JobGroup] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[ExecutionType] int NOT NULL,
	[HttpMethods] int NULL,
	[UrlOrSQL] nvarchar(max) COLLATE [ci_x_icu] NOT NULL,
	[CronExpression] nvarchar(100) COLLATE [ci_x_icu] NOT NULL,
	[JobStatus] int NOT NULL,
	[JobRemark] nvarchar(500) COLLATE [ci_x_icu] NULL,
	[CreateTime] datetime NULL,
	[ModifyTime] datetime NULL,
	[HttpHeaders] nvarchar(500) COLLATE [ci_x_icu] NULL,
	[HttpBody] nvarchar(1000) COLLATE [ci_x_icu] NULL,
	CONSTRAINT [SysJob_pkey] PRIMARY KEY (ID)
);


-- [dbo].[Users] definition

-- Drop table

-- DROP TABLE [dbo].[Users];

CREATE TABLE [dbo].[Users] (
	[UserID] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[UserName] nvarchar(200) COLLATE [ci_x_icu] NOT NULL,
	[UserPassword] nvarchar(200) COLLATE [ci_x_icu] NULL,
	[UserEmail] nvarchar(50) COLLATE [ci_x_icu] NULL,
	[CreateTime] datetime NOT NULL,
	[LastUpdateTime] datetime NULL,
	[Locked] int NOT NULL,
	[LoginName] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[ModifyTime] datetime NULL,
	CONSTRAINT [con_dbo_Users_constraint_1] PRIMARY KEY (UserID)
);
COMMENT ON TABLE [dbo].[Users] IS '用户表';

-- Column comments

COMMENT ON COLUMN [dbo].[Users].[UserID] IS '用户编号';
COMMENT ON COLUMN [dbo].[Users].[UserName] IS '用户名称';
COMMENT ON COLUMN [dbo].[Users].[UserPassword] IS '用户密码';
COMMENT ON COLUMN [dbo].[Users].[UserEmail] IS '用户邮箱';
COMMENT ON COLUMN [dbo].[Users].[CreateTime] IS '创建时间';
COMMENT ON COLUMN [dbo].[Users].[LastUpdateTime] IS '最新更新时间';
COMMENT ON COLUMN [dbo].[Users].[Locked] IS '是否锁定';
COMMENT ON COLUMN [dbo].[Users].[LoginName] IS '登录名';
COMMENT ON COLUMN [dbo].[Users].[ModifyTime] IS '修改时间';


-- [dbo].[WriteBackTable] definition

-- Drop table

-- DROP TABLE [dbo].[WriteBackTable];

CREATE TABLE [dbo].[WriteBackTable] (
	[ID] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[MSSQLIP] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[KingBaseIP] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[DbName] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[TableSchema] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[TableName] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[PrimaryKey] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[ReverseWriteField] nvarchar(1000) COLLATE [ci_x_icu] NULL,
	[Operation] int NULL,
	[LastUpdateTime] datetime NULL,
	[IsIdentity] int NOT NULL DEFAULT 0,
	[Describe] nvarchar(200) COLLATE [ci_x_icu] NULL,
	[IsSync] int NOT NULL,
	[IsBatchSync] int NOT NULL,
	CONSTRAINT [WriteBackTable_pkey] PRIMARY KEY (ID)
);
COMMENT ON TABLE [dbo].[WriteBackTable] IS '数据反写';

-- Column comments

COMMENT ON COLUMN [dbo].[WriteBackTable].[KingBaseIP] IS '金仓IP';
COMMENT ON COLUMN [dbo].[WriteBackTable].[DbName] IS '数据库名称';
COMMENT ON COLUMN [dbo].[WriteBackTable].[TableSchema] IS '表模式';
COMMENT ON COLUMN [dbo].[WriteBackTable].[TableName] IS '表名';
COMMENT ON COLUMN [dbo].[WriteBackTable].[PrimaryKey] IS '主键';
COMMENT ON COLUMN [dbo].[WriteBackTable].[ReverseWriteField] IS '反写字段';
COMMENT ON COLUMN [dbo].[WriteBackTable].[Operation] IS '同步操作';
COMMENT ON COLUMN [dbo].[WriteBackTable].[LastUpdateTime] IS '最后同步时间';
COMMENT ON COLUMN [dbo].[WriteBackTable].[IsIdentity] IS '是否自增';
COMMENT ON COLUMN [dbo].[WriteBackTable].[Describe] IS '说明';
COMMENT ON COLUMN [dbo].[WriteBackTable].[IsSync] IS '是否同步';
COMMENT ON COLUMN [dbo].[WriteBackTable].[IsBatchSync] IS '是否批量同步';


-- [dbo].[DataMigrationSubTable] definition

-- Drop table

-- DROP TABLE [dbo].[DataMigrationSubTable];

CREATE TABLE [dbo].[DataMigrationSubTable] (
	[ID] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[DataMigrationTableID] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[SourceTableSchema] nvarchar(10) COLLATE [ci_x_icu] NOT NULL,
	[TargetTableSchema] nvarchar(10) COLLATE [ci_x_icu] NOT NULL,
	[SourceTableName] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[TargetTableName] nvarchar(50) COLLATE [ci_x_icu] NOT NULL,
	[SourceForeignKey] nvarchar(50) COLLATE [ci_x_icu] NULL,
	[TargetForeignKey] nvarchar(50) COLLATE [ci_x_icu] NULL,
	[SourceIsIdentity] int NOT NULL,
	[TargetIsIdentity] int NOT NULL,
	[ExcludeField] nvarchar(200) COLLATE [ci_x_icu] NULL,
	[Describe] nvarchar(200) COLLATE [ci_x_icu] NULL,
	[IsSync] int NULL,
	[InsertField] nvarchar(500) COLLATE [ci_x_icu] NULL,
	CONSTRAINT [DataMigrationSubTable_pkey] PRIMARY KEY (ID),
	CONSTRAINT [fkey_dbo_DataMigrationSubTable_fkey_1] FOREIGN KEY (DataMigrationTableID) REFERENCES DataMigrationTable(ID) ON UPDATE CASCADE ON DELETE CASCADE
);
COMMENT ON TABLE [dbo].[DataMigrationSubTable] IS '数据同步配置子表';

-- Column comments

COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[ID] IS '主键';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[DataMigrationTableID] IS '外键';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[SourceTableSchema] IS '源表模式';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[TargetTableSchema] IS '目标表模式';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[SourceTableName] IS '源表名称';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[TargetTableName] IS '目标表名称';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[SourceForeignKey] IS '原表外键';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[TargetForeignKey] IS '目标表外键';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[SourceIsIdentity] IS '源表主键自增';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[TargetIsIdentity] IS '目标表主键自增';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[ExcludeField] IS '排除在字段';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[Describe] IS '说明';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[IsSync] IS '是否同步';
COMMENT ON COLUMN [dbo].[DataMigrationSubTable].[InsertField] IS '插入字段';
```