【quartz】各データベース作成スクリプト

QRTZ_CALENDARSはBlobタイプでQuartzのCalendar情報を格納する
QRTZ_CRON_TRIGGERSは、Cron式およびタイムゾーン情報を含むCron Triggerを格納する
QRTZ_FIRED_TRIGGERSは、トリガーされたTriggerに関する状態情報と、ジョブに関連付けられた実行情報QRTZ_を記憶するPAUSED_TRIGGER_GRPSは、一時停止したTriggerグループの情報を格納する
QRTZ_SCHEDULER_STATEは、少数のSchedulerに関する状態情報を記憶し、他のSchedulerインスタンス(クラスタで使用される場合)
QRTZ_LOCKSメモリプログラムの悲観ロックの情報(悲観ロックが使用されている場合)
QRTZ_JOB_DETAILSは、各構成されたジョブの詳細を格納する
QRTZ_JOB_LISTENERSは、構成されたJobListenerに関する情報を格納します.
QRTZ_SIMPLE_TRIGGERSは、繰り返し回数、間隔、および接触回数を含む簡単なTriggerを格納する
QRTZ_BLOG_TRIGGERS TriggerはBlobタイプとして格納されます(QuartzユーザーがJDBCで独自にカスタマイズしたTriggerタイプを作成するために使用され、JobStoreがインスタンスの格納方法を知らない場合)
QRTZ_TRIGGER_LISTENERSは、構成されたTriggerListenerの情報を格納します.
QRTZ_TRIGGERSは、構成されたTriggerの情報を格納する
 
Mysql   github
 

-- MySQL dump 10.13  Distrib 5.1.63, for Win64 (unknown)

--

-- Host: localhost    Database: liukehong

-- ------------------------------------------------------

-- Server version    5.1.63-community



/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;



--

-- Table structure for table `QRTZ_BLOB_TRIGGERS`

--



DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_BLOB_TRIGGERS` (

  `TRIGGER_NAME` varchar(200) NOT NULL,

  `TRIGGER_GROUP` varchar(200) NOT NULL,

  `BLOB_DATA` blob,

  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  KEY `TRIGGER_NAME` (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`TRIGGER_NAME`, `TRIGGER_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_BLOB_TRIGGERS`

--



LOCK TABLES `QRTZ_BLOB_TRIGGERS` WRITE;

/*!40000 ALTER TABLE `QRTZ_BLOB_TRIGGERS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_BLOB_TRIGGERS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_CALENDARS`

--



DROP TABLE IF EXISTS `QRTZ_CALENDARS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_CALENDARS` (

  `CALENDAR_NAME` varchar(200) NOT NULL,

  `CALENDAR` blob NOT NULL,

  PRIMARY KEY (`CALENDAR_NAME`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_CALENDARS`

--



LOCK TABLES `QRTZ_CALENDARS` WRITE;

/*!40000 ALTER TABLE `QRTZ_CALENDARS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_CALENDARS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_CRON_TRIGGERS`

--



DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_CRON_TRIGGERS` (

  `TRIGGER_NAME` varchar(200) NOT NULL,

  `TRIGGER_GROUP` varchar(200) NOT NULL,

  `CRON_EXPRESSION` varchar(120) NOT NULL,

  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,

  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  KEY `TRIGGER_NAME` (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`TRIGGER_NAME`, `TRIGGER_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_CRON_TRIGGERS`

--



LOCK TABLES `QRTZ_CRON_TRIGGERS` WRITE;

/*!40000 ALTER TABLE `QRTZ_CRON_TRIGGERS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_CRON_TRIGGERS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_FIRED_TRIGGERS`

--



DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_FIRED_TRIGGERS` (

  `ENTRY_ID` varchar(95) NOT NULL,

  `TRIGGER_NAME` varchar(200) NOT NULL,

  `TRIGGER_GROUP` varchar(200) NOT NULL,

  `IS_VOLATILE` varchar(1) NOT NULL,

  `INSTANCE_NAME` varchar(200) NOT NULL,

  `FIRED_TIME` bigint(13) NOT NULL,

  `PRIORITY` int(11) NOT NULL,

  `STATE` varchar(16) NOT NULL,

  `JOB_NAME` varchar(200) DEFAULT NULL,

  `JOB_GROUP` varchar(200) DEFAULT NULL,

  `IS_STATEFUL` varchar(1) DEFAULT NULL,

  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,

  PRIMARY KEY (`ENTRY_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_FIRED_TRIGGERS`

--



LOCK TABLES `QRTZ_FIRED_TRIGGERS` WRITE;

/*!40000 ALTER TABLE `QRTZ_FIRED_TRIGGERS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_FIRED_TRIGGERS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_JOB_DETAILS`

--



DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_JOB_DETAILS` (

  `JOB_NAME` varchar(200) NOT NULL,

  `JOB_GROUP` varchar(200) NOT NULL,

  `DESCRIPTION` varchar(250) DEFAULT NULL,

  `JOB_CLASS_NAME` varchar(250) NOT NULL,

  `IS_DURABLE` varchar(1) NOT NULL,

  `IS_VOLATILE` varchar(1) NOT NULL,

  `IS_STATEFUL` varchar(1) NOT NULL,

  `REQUESTS_RECOVERY` varchar(1) NOT NULL,

  `JOB_DATA` blob,

  PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_JOB_DETAILS`

--



LOCK TABLES `QRTZ_JOB_DETAILS` WRITE;

/*!40000 ALTER TABLE `QRTZ_JOB_DETAILS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_JOB_DETAILS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_JOB_LISTENERS`

--



DROP TABLE IF EXISTS `QRTZ_JOB_LISTENERS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_JOB_LISTENERS` (

  `JOB_NAME` varchar(200) NOT NULL,

  `JOB_GROUP` varchar(200) NOT NULL,

  `JOB_LISTENER` varchar(200) NOT NULL,

  PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`,`JOB_LISTENER`),

  KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`),

  CONSTRAINT `QRTZ_JOB_LISTENERS_ibfk_1` FOREIGN KEY (`JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`JOB_NAME`, `JOB_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_JOB_LISTENERS`

--



LOCK TABLES `QRTZ_JOB_LISTENERS` WRITE;

/*!40000 ALTER TABLE `QRTZ_JOB_LISTENERS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_JOB_LISTENERS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_LOCKS`

--



DROP TABLE IF EXISTS `QRTZ_LOCKS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_LOCKS` (

  `LOCK_NAME` varchar(40) NOT NULL,

  PRIMARY KEY (`LOCK_NAME`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_LOCKS`

--



LOCK TABLES `QRTZ_LOCKS` WRITE;

/*!40000 ALTER TABLE `QRTZ_LOCKS` DISABLE KEYS */;

INSERT INTO `QRTZ_LOCKS` VALUES ('CALENDAR_ACCESS'),('JOB_ACCESS'),('MISFIRE_ACCESS'),('STATE_ACCESS'),('TRIGGER_ACCESS');

/*!40000 ALTER TABLE `QRTZ_LOCKS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_PAUSED_TRIGGER_GRPS`

--



DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (

  `TRIGGER_GROUP` varchar(200) NOT NULL,

  PRIMARY KEY (`TRIGGER_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_PAUSED_TRIGGER_GRPS`

--



LOCK TABLES `QRTZ_PAUSED_TRIGGER_GRPS` WRITE;

/*!40000 ALTER TABLE `QRTZ_PAUSED_TRIGGER_GRPS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_PAUSED_TRIGGER_GRPS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_SCHEDULER_STATE`

--



DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_SCHEDULER_STATE` (

  `INSTANCE_NAME` varchar(200) NOT NULL,

  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,

  `CHECKIN_INTERVAL` bigint(13) NOT NULL,

  PRIMARY KEY (`INSTANCE_NAME`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_SCHEDULER_STATE`

--



LOCK TABLES `QRTZ_SCHEDULER_STATE` WRITE;

/*!40000 ALTER TABLE `QRTZ_SCHEDULER_STATE` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_SCHEDULER_STATE` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_SIMPLE_TRIGGERS`

--



DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (

  `TRIGGER_NAME` varchar(200) NOT NULL,

  `TRIGGER_GROUP` varchar(200) NOT NULL,

  `REPEAT_COUNT` bigint(7) NOT NULL,

  `REPEAT_INTERVAL` bigint(12) NOT NULL,

  `TIMES_TRIGGERED` bigint(10) NOT NULL,

  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  KEY `TRIGGER_NAME` (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`TRIGGER_NAME`, `TRIGGER_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_SIMPLE_TRIGGERS`

--



LOCK TABLES `QRTZ_SIMPLE_TRIGGERS` WRITE;

/*!40000 ALTER TABLE `QRTZ_SIMPLE_TRIGGERS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_SIMPLE_TRIGGERS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_TRIGGERS`

--



DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_TRIGGERS` (

  `TRIGGER_NAME` varchar(200) NOT NULL,

  `TRIGGER_GROUP` varchar(200) NOT NULL,

  `JOB_NAME` varchar(200) NOT NULL,

  `JOB_GROUP` varchar(200) NOT NULL,

  `IS_VOLATILE` varchar(1) NOT NULL,

  `DESCRIPTION` varchar(250) DEFAULT NULL,

  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,

  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,

  `PRIORITY` int(11) DEFAULT NULL,

  `TRIGGER_STATE` varchar(16) NOT NULL,

  `TRIGGER_TYPE` varchar(8) NOT NULL,

  `START_TIME` bigint(13) NOT NULL,

  `END_TIME` bigint(13) DEFAULT NULL,

  `CALENDAR_NAME` varchar(200) DEFAULT NULL,

  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,

  `JOB_DATA` blob,

  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`),

  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`JOB_NAME`, `JOB_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_TRIGGERS`

--



LOCK TABLES `QRTZ_TRIGGERS` WRITE;

/*!40000 ALTER TABLE `QRTZ_TRIGGERS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_TRIGGERS` ENABLE KEYS */;

UNLOCK TABLES;



--

-- Table structure for table `QRTZ_TRIGGER_LISTENERS`

--



DROP TABLE IF EXISTS `QRTZ_TRIGGER_LISTENERS`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `QRTZ_TRIGGER_LISTENERS` (

  `TRIGGER_NAME` varchar(200) NOT NULL,

  `TRIGGER_GROUP` varchar(200) NOT NULL,

  `TRIGGER_LISTENER` varchar(200) NOT NULL,

  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_LISTENER`),

  KEY `TRIGGER_NAME` (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  CONSTRAINT `QRTZ_TRIGGER_LISTENERS_ibfk_1` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`TRIGGER_NAME`, `TRIGGER_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;



--

-- Dumping data for table `QRTZ_TRIGGER_LISTENERS`

--



LOCK TABLES `QRTZ_TRIGGER_LISTENERS` WRITE;

/*!40000 ALTER TABLE `QRTZ_TRIGGER_LISTENERS` DISABLE KEYS */;

/*!40000 ALTER TABLE `QRTZ_TRIGGER_LISTENERS` ENABLE KEYS */;

UNLOCK TABLES;







/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;



-- Dump completed on 2012-11-12  0:31:11

 
sqlserver    github
 
 

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 sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS]') AND parent_object_id = OBJECT_ID(N'[dbo].[QRTZ_JOB_LISTENERS]'))

ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] DROP CONSTRAINT [FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS]

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]') AND parent_object_id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGER_LISTENERS]'))

ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] DROP CONSTRAINT [FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]

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 sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QRTZ_JOB_LISTENERS]') AND type in (N'U'))

DROP TABLE [dbo].[QRTZ_JOB_LISTENERS]

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 sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGER_LISTENERS]') AND type in (N'U'))

DROP TABLE [dbo].[QRTZ_TRIGGER_LISTENERS]

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] [NVARCHAR] (100)  NOT NULL ,

  [CALENDAR_NAME] [NVARCHAR] (200)  NOT NULL ,

  [CALENDAR] [IMAGE] NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,

  [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,

  [CRON_EXPRESSION] [NVARCHAR] (120)  NOT NULL ,

  [TIME_ZONE_ID] [NVARCHAR] (80) 

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [ENTRY_ID] [NVARCHAR] (95)  NOT NULL ,

  [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,

  [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,

  [INSTANCE_NAME] [NVARCHAR] (200)  NOT NULL ,

  [FIRED_TIME] [BIGINT] NOT NULL ,

  [PRIORITY] [INTEGER] NOT NULL ,

  [STATE] [NVARCHAR] (16)  NOT NULL,

  [JOB_NAME] [NVARCHAR] (150)  NULL ,

  [JOB_GROUP] [NVARCHAR] (150)  NULL ,

  [IS_NONCONCURRENT] BIT  NULL ,

  [REQUESTS_RECOVERY] BIT  NULL 

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL 

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [INSTANCE_NAME] [NVARCHAR] (200)  NOT NULL ,

  [LAST_CHECKIN_TIME] [BIGINT] NOT NULL ,

  [CHECKIN_INTERVAL] [BIGINT] NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_LOCKS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [LOCK_NAME] [NVARCHAR] (40)  NOT NULL 

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [JOB_NAME] [NVARCHAR] (150)  NOT NULL ,

  [JOB_GROUP] [NVARCHAR] (150)  NOT NULL ,

  [DESCRIPTION] [NVARCHAR] (250) NULL ,

  [JOB_CLASS_NAME] [NVARCHAR] (250)  NOT NULL ,

  [IS_DURABLE] BIT  NOT NULL ,

  [IS_NONCONCURRENT] BIT  NOT NULL ,

  [IS_UPDATE_DATA] BIT  NOT NULL ,

  [REQUESTS_RECOVERY] BIT  NOT NULL ,

  [JOB_DATA] [IMAGE] NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,

  [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,

  [REPEAT_COUNT] [INTEGER] NOT NULL ,

  [REPEAT_INTERVAL] [BIGINT] NOT NULL ,

  [TIMES_TRIGGERED] [INTEGER] NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,

  [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,

  [STR_PROP_1] [NVARCHAR] (512) NULL,

  [STR_PROP_2] [NVARCHAR] (512) NULL,

  [STR_PROP_3] [NVARCHAR] (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] BIT NULL,

  [BOOL_PROP_2] BIT NULL,

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,

  [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,

  [BLOB_DATA] [IMAGE] NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[QRTZ_TRIGGERS] (

  [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,

  [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,

  [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,

  [JOB_NAME] [NVARCHAR] (150)  NOT NULL ,

  [JOB_GROUP] [NVARCHAR] (150)  NOT NULL ,

  [DESCRIPTION] [NVARCHAR] (250) NULL ,

  [NEXT_FIRE_TIME] [BIGINT] NULL ,

  [PREV_FIRE_TIME] [BIGINT] NULL ,

  [PRIORITY] [INTEGER] 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] (200)  NULL ,

  [MISFIRE_INSTR] [INTEGER] 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

CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP)

CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP)

CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME)

CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP)

CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE)

CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE)

CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE)

CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME)

CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME)

CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME)

CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE)

CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE)

CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME)

CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY)

CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP)

CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP)

CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)

CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP)