255 lines
6.5 KiB
Transact-SQL
Executable File
255 lines
6.5 KiB
Transact-SQL
Executable File
CREATE TABLE [dbo].[QRTZ_CALENDARS] (
|
|
[CALENDAR_NAME] [nvarchar] (80) NOT NULL ,
|
|
[CALENDAR] [IMAGE] NOT NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (
|
|
[TRIGGER_NAME] [nvarchar] (80) NOT NULL ,
|
|
[TRIGGER_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[CRON_EXPRESSION] [nvarchar] (80) NOT NULL ,
|
|
[TIME_ZONE_ID] [nvarchar] (80)
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (
|
|
[ENTRY_ID] [nvarchar] (95) NOT NULL ,
|
|
[TRIGGER_NAME] [nvarchar] (80) NOT NULL ,
|
|
[TRIGGER_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[IS_VOLATILE] [nvarchar] (1) NOT NULL ,
|
|
[INSTANCE_NAME] [nvarchar] (80) NOT NULL ,
|
|
[FIRED_TIME] [BIGINT] NOT NULL ,
|
|
[STATE] [nvarchar] (16) NOT NULL,
|
|
[JOB_NAME] [nvarchar] (80) NULL ,
|
|
[JOB_GROUP] [nvarchar] (80) NULL ,
|
|
[IS_STATEFUL] [nvarchar] (1) NULL ,
|
|
[REQUESTS_RECOVERY] [nvarchar] (1) NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (
|
|
[TRIGGER_GROUP] [nvarchar] (80) NOT NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (
|
|
[INSTANCE_NAME] [nvarchar] (80) NOT NULL ,
|
|
[LAST_CHECKIN_TIME] [BIGINT] NOT NULL ,
|
|
[CHECKIN_INTERVAL] [BIGINT] NOT NULL ,
|
|
[RECOVERER] [nvarchar] (80) NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_LOCKS] (
|
|
[LOCK_NAME] [nvarchar] (40) NOT NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
|
|
[JOB_NAME] [nvarchar] (80) NOT NULL ,
|
|
[JOB_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[DESCRIPTION] [nvarchar] (120) NULL ,
|
|
[JOB_CLASS_NAME] [nvarchar] (128) NOT NULL ,
|
|
[IS_DURABLE] [nvarchar] (1) NOT NULL ,
|
|
[IS_VOLATILE] [nvarchar] (1) NOT NULL ,
|
|
[IS_STATEFUL] [nvarchar] (1) NOT NULL ,
|
|
[REQUESTS_RECOVERY] [nvarchar] (1) NOT NULL ,
|
|
[JOB_DATA] [IMAGE] NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_JOB_LISTENERS] (
|
|
[JOB_NAME] [nvarchar] (80) NOT NULL ,
|
|
[JOB_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[JOB_LISTENER] [nvarchar] (80) NOT NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (
|
|
[TRIGGER_NAME] [nvarchar] (80) NOT NULL ,
|
|
[TRIGGER_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[REPEAT_COUNT] [BIGINT] NOT NULL ,
|
|
[REPEAT_INTERVAL] [BIGINT] NOT NULL ,
|
|
[TIMES_TRIGGERED] [BIGINT] NOT NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (
|
|
[TRIGGER_NAME] [nvarchar] (80) NOT NULL ,
|
|
[TRIGGER_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[BLOB_DATA] [IMAGE] NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] (
|
|
[TRIGGER_NAME] [nvarchar] (80) NOT NULL ,
|
|
[TRIGGER_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[TRIGGER_LISTENER] [nvarchar] (80) NOT NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
|
|
[TRIGGER_NAME] [nvarchar] (80) NOT NULL ,
|
|
[TRIGGER_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[JOB_NAME] [nvarchar] (80) NOT NULL ,
|
|
[JOB_GROUP] [nvarchar] (80) NOT NULL ,
|
|
[IS_VOLATILE] [nvarchar] (1) NOT NULL ,
|
|
[DESCRIPTION] [nvarchar] (120) NULL ,
|
|
[NEXT_FIRE_TIME] [BIGINT] NULL ,
|
|
[PREV_FIRE_TIME] [BIGINT] NULL ,
|
|
[TRIGGER_STATE] [nvarchar] (16) NOT NULL ,
|
|
[TRIGGER_TYPE] [nvarchar] (8) NOT NULL ,
|
|
[START_TIME] [BIGINT] NOT NULL ,
|
|
[END_TIME] [BIGINT] NULL ,
|
|
[CALENDAR_NAME] [nvarchar] (80) NULL ,
|
|
[MISFIRE_INSTR] [SMALLINT] NULL ,
|
|
[JOB_DATA] [IMAGE] NULL
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_CALENDARS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_CALENDARS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[CALENDAR_NAME]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_CRON_TRIGGERS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_FIRED_TRIGGERS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_FIRED_TRIGGERS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[ENTRY_ID]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_PAUSED_TRIGGER_GRPS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TRIGGER_GROUP]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_SCHEDULER_STATE] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_SCHEDULER_STATE] PRIMARY KEY CLUSTERED
|
|
(
|
|
[INSTANCE_NAME]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_LOCKS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_LOCKS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[LOCK_NAME]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_JOB_DETAILS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_JOB_DETAILS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[JOB_NAME],
|
|
[JOB_GROUP]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_JOB_LISTENERS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[JOB_NAME],
|
|
[JOB_GROUP],
|
|
[JOB_LISTENER]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_SIMPLE_TRIGGERS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_TRIGGER_LISTENERS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP],
|
|
[TRIGGER_LISTENER]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_TRIGGERS] WITH NOCHECK ADD
|
|
CONSTRAINT [PK_QRTZ_TRIGGERS] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] ADD
|
|
CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
|
|
(
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) REFERENCES [dbo].[QRTZ_TRIGGERS] (
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) ON DELETE CASCADE
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] ADD
|
|
CONSTRAINT [FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS] FOREIGN KEY
|
|
(
|
|
[JOB_NAME],
|
|
[JOB_GROUP]
|
|
) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
|
|
[JOB_NAME],
|
|
[JOB_GROUP]
|
|
) ON DELETE CASCADE
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] ADD
|
|
CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
|
|
(
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) REFERENCES [dbo].[QRTZ_TRIGGERS] (
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) ON DELETE CASCADE
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] ADD
|
|
CONSTRAINT [FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS] FOREIGN KEY
|
|
(
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) REFERENCES [dbo].[QRTZ_TRIGGERS] (
|
|
[TRIGGER_NAME],
|
|
[TRIGGER_GROUP]
|
|
) ON DELETE CASCADE
|
|
|
|
|
|
ALTER TABLE [dbo].[QRTZ_TRIGGERS] ADD
|
|
CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS] FOREIGN KEY
|
|
(
|
|
[JOB_NAME],
|
|
[JOB_GROUP]
|
|
) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
|
|
[JOB_NAME],
|
|
[JOB_GROUP]
|
|
)
|
|
|
|
|
|
INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('TRIGGER_ACCESS');
|
|
INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('JOB_ACCESS');
|
|
INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('CALENDAR_ACCESS');
|
|
INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('STATE_ACCESS');
|
|
INSERT INTO [dbo].[QRTZ_LOCKS] VALUES('MISFIRE_ACCESS');
|