quartz mysql 建表_【quartz】 各数据库创建脚本

--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` blobNOT 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