forked from rongchao/epmet-cloud-rizhao
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
407 lines
20 KiB
407 lines
20 KiB
6 years ago
|
CREATE TABLE schedule_job (
|
||
|
|
id bigint NOT NULL,
|
||
|
|
bean_name varchar(200),
|
||
|
|
params varchar(2000),
|
||
|
|
cron_expression varchar(100),
|
||
|
|
status int,
|
||
|
|
remark varchar(255),
|
||
|
|
creator bigint,
|
||
|
|
create_date datetime,
|
||
|
|
updater bigint,
|
||
|
|
update_date datetime,
|
||
|
|
PRIMARY KEY (id)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE INDEX idx_schedule_job_create_date on schedule_job(create_date);
|
||
|
|
|
||
|
|
|
||
|
|
CREATE TABLE schedule_job_log (
|
||
|
|
id bigint NOT NULL,
|
||
|
|
job_id bigint NOT NULL,
|
||
|
|
bean_name varchar(200),
|
||
|
|
params varchar(2000),
|
||
|
|
status int,
|
||
|
|
error varchar(2000),
|
||
|
|
times int,
|
||
|
|
create_date datetime,
|
||
|
|
PRIMARY KEY (id)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE INDEX idx_job_log_job_id on schedule_job_log(job_id);
|
||
|
|
CREATE INDEX idx_job_log_create_date on schedule_job_log(create_date);
|
||
|
|
|
||
|
|
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000047, 1067246875800000019, 'job/schedule', 0, 'icon-edit-square', '', 3, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000048, 1067246875800000047, '', 1, '', 'sys:schedule:view', 0, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000049, 1067246875800000047, '', 1, '', 'sys:schedule:save', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000050, 1067246875800000047, '', 1, '', 'sys:schedule:update', 2, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000051, 1067246875800000047, '', 1, '', 'sys:schedule:delete', 3, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000052, 1067246875800000047, '', 1, '', 'sys:schedule:pause', 4, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000053, 1067246875800000047, '', 1, '', 'sys:schedule:resume', 5, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000054, 1067246875800000047, '', 1, '', 'sys:schedule:run', 6, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_menu(id, pid, url, type, icon, permissions, sort, del_flag, creator, create_date, updater, update_date) VALUES (1067246875800000055, 1067246875800000047, '', 1, '', 'sys:schedule:log', 7, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', 'Timed Task', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', '定时任务', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', '定時任務', 'zh-TW');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', 'View', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', '查看', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', '查看', 'zh-TW');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', 'Add', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', '新增', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', '新增', 'zh-TW');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', 'Edit', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', '修改', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', '修改', 'zh-TW');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', 'Delete', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', '删除', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', '刪除', 'zh-TW');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', 'Pause', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', '暂停', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', '暫停', 'zh-TW');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', 'Resume', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', '恢复', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', '恢復', 'zh-TW');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', 'Execute', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', '立即执行', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', '立即執行', 'zh-TW');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', 'Log List', 'en-US');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', '日志列表', 'zh-CN');
|
||
|
|
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', '日誌列表', 'zh-TW');
|
||
|
|
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000134, 1067246875800000048, '查看', '/job/schedule/{id}', 'GET', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000135, 1067246875800000048, '查看', '/job/schedule/page', 'GET', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000136, 1067246875800000049, '新增', '/job/schedule', 'POST', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000137, 1067246875800000050, '修改', '/job/schedule', 'PUT', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000138, 1067246875800000051, '删除', '/job/schedule', 'DELETE', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000139, 1067246875800000052, '暂停', '/job/schedule/pause', 'PUT', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000140, 1067246875800000053, '恢复', '/job/schedule/resume', 'PUT', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000141, 1067246875800000054, '立即执行', '/job/schedule/run', 'PUT', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000142, 1067246875800000055, '日志列表', '/job/scheduleLog/{id}', 'GET', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
INSERT INTO sys_resource(id, resource_code, resource_name, resource_url, resource_method, menu_flag, auth_level, creator, create_date, updater, update_date) VALUES (1067246875800000143, 1067246875800000055, '日志列表', '/job/scheduleLog/page', 'GET', 1, 0, 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
|
||
|
|
|
||
|
|
INSERT INTO schedule_job (id, bean_name, params, cron_expression, status, remark, creator, create_date, updater, update_date) VALUES (1067246875800000144, 'testTask', 'renren', '0 0/30 * * * ?', '1', '有参数测试', 1067246875800000001, getdate(), 1067246875800000001, getdate());
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
-- quartz自带表结构
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
|
||
|
|
ALTER TABLE [dbo].[QRTZ_TRIGGERS] DROP CONSTRAINT FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
|
||
|
|
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] DROP CONSTRAINT FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
|
||
|
|
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
|
||
|
|
ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_CALENDARS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_CRON_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_CRON_TRIGGERS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_BLOB_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_BLOB_TRIGGERS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_FIRED_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_FIRED_TRIGGERS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_PAUSED_TRIGGER_GRPS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SCHEDULER_STATE]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_SCHEDULER_STATE]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_LOCKS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_LOCKS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_JOB_DETAILS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SIMPLE_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SIMPROP_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
|
||
|
|
DROP TABLE [dbo].[QRTZ_TRIGGERS]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_CALENDARS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[CALENDAR_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[CALENDAR] [IMAGE] NOT NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[CRON_EXPRESSION] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[TIME_ZONE_ID] [VARCHAR] (80)
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[ENTRY_ID] [VARCHAR] (95) NOT NULL ,
|
||
|
|
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[INSTANCE_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[FIRED_TIME] [BIGINT] NOT NULL ,
|
||
|
|
[SCHED_TIME] [BIGINT] NOT NULL ,
|
||
|
|
[PRIORITY] [INTEGER] NOT NULL ,
|
||
|
|
[STATE] [VARCHAR] (16) NOT NULL,
|
||
|
|
[JOB_NAME] [VARCHAR] (200) NULL ,
|
||
|
|
[JOB_GROUP] [VARCHAR] (200) NULL ,
|
||
|
|
[IS_NONCONCURRENT] [VARCHAR] (1) NULL ,
|
||
|
|
[REQUESTS_RECOVERY] [VARCHAR] (1) NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[INSTANCE_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[LAST_CHECKIN_TIME] [BIGINT] NOT NULL ,
|
||
|
|
[CHECKIN_INTERVAL] [BIGINT] NOT NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_LOCKS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[LOCK_NAME] [VARCHAR] (40) NOT NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[JOB_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[JOB_GROUP] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[DESCRIPTION] [VARCHAR] (250) NULL ,
|
||
|
|
[JOB_CLASS_NAME] [VARCHAR] (250) NOT NULL ,
|
||
|
|
[IS_DURABLE] [VARCHAR] (1) NOT NULL ,
|
||
|
|
[IS_NONCONCURRENT] [VARCHAR] (1) NOT NULL ,
|
||
|
|
[IS_UPDATE_DATA] [VARCHAR] (1) NOT NULL ,
|
||
|
|
[REQUESTS_RECOVERY] [VARCHAR] (1) NOT NULL ,
|
||
|
|
[JOB_DATA] [IMAGE] NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[REPEAT_COUNT] [BIGINT] NOT NULL ,
|
||
|
|
[REPEAT_INTERVAL] [BIGINT] NOT NULL ,
|
||
|
|
[TIMES_TRIGGERED] [BIGINT] NOT NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[STR_PROP_1] [VARCHAR] (512) NULL,
|
||
|
|
[STR_PROP_2] [VARCHAR] (512) NULL,
|
||
|
|
[STR_PROP_3] [VARCHAR] (512) 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) NULL,
|
||
|
|
[BOOL_PROP_2] [VARCHAR] (1) NULL,
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[BLOB_DATA] [IMAGE] NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
|
||
|
|
[SCHED_NAME] [VARCHAR] (120) NOT NULL ,
|
||
|
|
[TRIGGER_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[TRIGGER_GROUP] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[JOB_NAME] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[JOB_GROUP] [VARCHAR] (200) NOT NULL ,
|
||
|
|
[DESCRIPTION] [VARCHAR] (250) NULL ,
|
||
|
|
[NEXT_FIRE_TIME] [BIGINT] NULL ,
|
||
|
|
[PREV_FIRE_TIME] [BIGINT] NULL ,
|
||
|
|
[PRIORITY] [INTEGER] NULL ,
|
||
|
|
[TRIGGER_STATE] [VARCHAR] (16) NOT NULL ,
|
||
|
|
[TRIGGER_TYPE] [VARCHAR] (8) NOT NULL ,
|
||
|
|
[START_TIME] [BIGINT] NOT NULL ,
|
||
|
|
[END_TIME] [BIGINT] NULL ,
|
||
|
|
[CALENDAR_NAME] [VARCHAR] (200) NULL ,
|
||
|
|
[MISFIRE_INSTR] [SMALLINT] NULL ,
|
||
|
|
[JOB_DATA] [IMAGE] NULL
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_CALENDARS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_CALENDARS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[CALENDAR_NAME]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_CRON_TRIGGERS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_FIRED_TRIGGERS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_FIRED_TRIGGERS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[ENTRY_ID]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_PAUSED_TRIGGER_GRPS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_SCHEDULER_STATE] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_SCHEDULER_STATE] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[INSTANCE_NAME]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_LOCKS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_LOCKS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[LOCK_NAME]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_JOB_DETAILS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_JOB_DETAILS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[JOB_NAME],
|
||
|
|
[JOB_GROUP]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_SIMPLE_TRIGGERS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_SIMPROP_TRIGGERS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_TRIGGERS] WITH NOCHECK ADD
|
||
|
|
CONSTRAINT [PK_QRTZ_TRIGGERS] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] ADD
|
||
|
|
CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) REFERENCES [dbo].[QRTZ_TRIGGERS] (
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) ON DELETE CASCADE
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] ADD
|
||
|
|
CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) REFERENCES [dbo].[QRTZ_TRIGGERS] (
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) ON DELETE CASCADE
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] ADD
|
||
|
|
CONSTRAINT [FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) REFERENCES [dbo].[QRTZ_TRIGGERS] (
|
||
|
|
[SCHED_NAME],
|
||
|
|
[TRIGGER_NAME],
|
||
|
|
[TRIGGER_GROUP]
|
||
|
|
) ON DELETE CASCADE
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [dbo].[QRTZ_TRIGGERS] ADD
|
||
|
|
CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS] FOREIGN KEY
|
||
|
|
(
|
||
|
|
[SCHED_NAME],
|
||
|
|
[JOB_NAME],
|
||
|
|
[JOB_GROUP]
|
||
|
|
) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
|
||
|
|
[SCHED_NAME],
|
||
|
|
[JOB_NAME],
|
||
|
|
[JOB_GROUP]
|
||
|
|
)
|
||
|
|
GO
|