【quartz】 各数据库创建脚本
时间：2021-07-01 10:21:17
帮助过：2人阅读
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_JOB_LISTENERS_QRTZ_JOB_DETAILS]‘) AND OBJECTPROPERTY(id, N‘ISFOREIGNKEY‘) = 1)
ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] DROP CONSTRAINT FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS
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
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
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
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N‘[dbo].[FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]‘) AND OBJECTPROPERTY(id, N‘ISFOREIGNKEY‘) = 1)
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]
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]
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]
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]
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]
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]
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]
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]
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N‘[dbo].[QRTZ_JOB_LISTENERS]‘) AND OBJECTPROPERTY(id, N‘ISUSERTABLE‘) = 1)
DROP TABLE
