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.
190 lines
7.2 KiB
190 lines
7.2 KiB
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : 194
|
|
Source Server Version : 50513
|
|
Source Host : 182.254.245.194:3307
|
|
Source Database : yun_enterprise_cms
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50513
|
|
File Encoding : 65001
|
|
|
|
Date: 2019-12-09 11:25:42
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_blob_triggers
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
|
|
CREATE TABLE `qrtz_blob_triggers` (
|
|
`SCHED_NAME` varchar(120) NOT NULL,
|
|
`TRIGGER_NAME` varchar(200) NOT NULL,
|
|
`TRIGGER_GROUP` varchar(200) NOT NULL,
|
|
`BLOB_DATA` blob,
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
|
|
CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_calendars
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_calendars`;
|
|
CREATE TABLE `qrtz_calendars` (
|
|
`SCHED_NAME` varchar(120) NOT NULL,
|
|
`CALENDAR_NAME` varchar(200) NOT NULL,
|
|
`CALENDAR` blob NOT NULL,
|
|
PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_cron_triggers
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
|
|
CREATE TABLE `qrtz_cron_triggers` (
|
|
`SCHED_NAME` varchar(120) NOT NULL,
|
|
`TRIGGER_NAME` varchar(200) NOT NULL,
|
|
`TRIGGER_GROUP` varchar(200) NOT NULL,
|
|
`CRON_EXPRESSION` varchar(200) NOT NULL,
|
|
`TIME_ZONE_ID` varchar(80) DEFAULT NULL,
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
|
|
CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_fired_triggers
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
|
|
CREATE TABLE `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(13) NOT NULL,
|
|
`SCHED_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_NONCONCURRENT` varchar(1) DEFAULT NULL,
|
|
`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
|
|
PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_job_details
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_job_details`;
|
|
CREATE TABLE `qrtz_job_details` (
|
|
`SCHED_NAME` varchar(120) NOT NULL,
|
|
`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_NONCONCURRENT` varchar(1) NOT NULL,
|
|
`IS_UPDATE_DATA` varchar(1) NOT NULL,
|
|
`REQUESTS_RECOVERY` varchar(1) NOT NULL,
|
|
`JOB_DATA` blob,
|
|
PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_locks
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_locks`;
|
|
CREATE TABLE `qrtz_locks` (
|
|
`SCHED_NAME` varchar(120) NOT NULL,
|
|
`LOCK_NAME` varchar(40) NOT NULL,
|
|
PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_paused_trigger_grps
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
|
|
CREATE TABLE `qrtz_paused_trigger_grps` (
|
|
`SCHED_NAME` varchar(120) NOT NULL,
|
|
`TRIGGER_GROUP` varchar(200) NOT NULL,
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_scheduler_state
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
|
|
CREATE TABLE `qrtz_scheduler_state` (
|
|
`SCHED_NAME` varchar(120) NOT NULL,
|
|
`INSTANCE_NAME` varchar(200) NOT NULL,
|
|
`LAST_CHECKIN_TIME` bigint(13) NOT NULL,
|
|
`CHECKIN_INTERVAL` bigint(13) NOT NULL,
|
|
PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_simple_triggers
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
|
|
CREATE TABLE `qrtz_simple_triggers` (
|
|
`SCHED_NAME` varchar(120) NOT NULL,
|
|
`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 (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
|
|
CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_simprop_triggers
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
|
|
CREATE TABLE `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) DEFAULT NULL,
|
|
`STR_PROP_2` varchar(512) DEFAULT NULL,
|
|
`STR_PROP_3` varchar(512) DEFAULT NULL,
|
|
`INT_PROP_1` int(11) DEFAULT NULL,
|
|
`INT_PROP_2` int(11) DEFAULT NULL,
|
|
`LONG_PROP_1` bigint(20) DEFAULT NULL,
|
|
`LONG_PROP_2` bigint(20) DEFAULT NULL,
|
|
`DEC_PROP_1` decimal(13,4) DEFAULT NULL,
|
|
`DEC_PROP_2` decimal(13,4) DEFAULT NULL,
|
|
`BOOL_PROP_1` varchar(1) DEFAULT NULL,
|
|
`BOOL_PROP_2` varchar(1) DEFAULT NULL,
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
|
|
CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qrtz_triggers
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `qrtz_triggers`;
|
|
CREATE TABLE `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) 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 (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
|
|
KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
|
|
CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|