260 lines
12 KiB
PL/PgSQL
260 lines
12 KiB
PL/PgSQL
/*
|
||
Navicat MySQL Data Transfer
|
||
|
||
Source Server : localhost
|
||
Source Server Type : MySQL
|
||
Source Server Version : 50736 (5.7.36)
|
||
Source Host : localhost:3306
|
||
Source Schema : ry-vue
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 50736 (5.7.36)
|
||
File Encoding : 65001
|
||
|
||
Date: 16/06/2023 11:02:07
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
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 COMMENT '调度名称',
|
||
`trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
|
||
`trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
|
||
`blob_data` blob COMMENT '存放持久化Trigger对象',
|
||
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 COMMENT='Blob类型的触发器表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_BLOB_TRIGGERS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_CALENDARS
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
|
||
CREATE TABLE `QRTZ_CALENDARS` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`calendar_name` varchar(200) NOT NULL COMMENT '日历名称',
|
||
`calendar` blob NOT NULL COMMENT '存放持久化calendar对象',
|
||
PRIMARY KEY (`sched_name`,`calendar_name`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日历信息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_CALENDARS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_CRON_TRIGGERS
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
|
||
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
|
||
`trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
|
||
`cron_expression` varchar(200) NOT NULL COMMENT 'cron表达式',
|
||
`time_zone_id` varchar(80) DEFAULT NULL COMMENT '时区',
|
||
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 COMMENT='Cron类型的触发器表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_CRON_TRIGGERS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_FIRED_TRIGGERS
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
|
||
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`entry_id` varchar(95) NOT NULL COMMENT '调度器实例id',
|
||
`trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
|
||
`trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
|
||
`instance_name` varchar(200) NOT NULL COMMENT '调度器实例名',
|
||
`fired_time` bigint(13) NOT NULL COMMENT '触发的时间',
|
||
`sched_time` bigint(13) NOT NULL COMMENT '定时器制定的时间',
|
||
`priority` int(11) NOT NULL COMMENT '优先级',
|
||
`state` varchar(16) NOT NULL COMMENT '状态',
|
||
`job_name` varchar(200) DEFAULT NULL COMMENT '任务名称',
|
||
`job_group` varchar(200) DEFAULT NULL COMMENT '任务组名',
|
||
`is_nonconcurrent` varchar(1) DEFAULT NULL COMMENT '是否并发',
|
||
`requests_recovery` varchar(1) DEFAULT NULL COMMENT '是否接受恢复执行',
|
||
PRIMARY KEY (`sched_name`,`entry_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='已触发的触发器表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_FIRED_TRIGGERS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_JOB_DETAILS
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
|
||
CREATE TABLE `QRTZ_JOB_DETAILS` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`job_name` varchar(200) NOT NULL COMMENT '任务名称',
|
||
`job_group` varchar(200) NOT NULL COMMENT '任务组名',
|
||
`description` varchar(250) DEFAULT NULL COMMENT '相关介绍',
|
||
`job_class_name` varchar(250) NOT NULL COMMENT '执行任务类名称',
|
||
`is_durable` varchar(1) NOT NULL COMMENT '是否持久化',
|
||
`is_nonconcurrent` varchar(1) NOT NULL COMMENT '是否并发',
|
||
`is_update_data` varchar(1) NOT NULL COMMENT '是否更新数据',
|
||
`requests_recovery` varchar(1) NOT NULL COMMENT '是否接受恢复执行',
|
||
`job_data` blob COMMENT '存放持久化job对象',
|
||
PRIMARY KEY (`sched_name`,`job_name`,`job_group`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='任务详细信息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_JOB_DETAILS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_LOCKS
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
|
||
CREATE TABLE `QRTZ_LOCKS` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`lock_name` varchar(40) NOT NULL COMMENT '悲观锁名称',
|
||
PRIMARY KEY (`sched_name`,`lock_name`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='存储的悲观锁信息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_LOCKS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- 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 COMMENT '调度名称',
|
||
`trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
|
||
PRIMARY KEY (`sched_name`,`trigger_group`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='暂停的触发器表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_PAUSED_TRIGGER_GRPS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_SCHEDULER_STATE
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
|
||
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`instance_name` varchar(200) NOT NULL COMMENT '实例名称',
|
||
`last_checkin_time` bigint(13) NOT NULL COMMENT '上次检查时间',
|
||
`checkin_interval` bigint(13) NOT NULL COMMENT '检查间隔时间',
|
||
PRIMARY KEY (`sched_name`,`instance_name`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='调度器状态表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_SCHEDULER_STATE
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_SIMPLE_TRIGGERS
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
|
||
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
|
||
`trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
|
||
`repeat_count` bigint(7) NOT NULL COMMENT '重复的次数统计',
|
||
`repeat_interval` bigint(12) NOT NULL COMMENT '重复的间隔时间',
|
||
`times_triggered` bigint(10) NOT NULL COMMENT '已经触发的次数',
|
||
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 COMMENT='简单触发器的信息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_SIMPLE_TRIGGERS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_SIMPROP_TRIGGERS
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
|
||
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
|
||
`trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
|
||
`str_prop_1` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第一个参数',
|
||
`str_prop_2` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第二个参数',
|
||
`str_prop_3` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第三个参数',
|
||
`int_prop_1` int(11) DEFAULT NULL COMMENT 'int类型的trigger的第一个参数',
|
||
`int_prop_2` int(11) DEFAULT NULL COMMENT 'int类型的trigger的第二个参数',
|
||
`long_prop_1` bigint(20) DEFAULT NULL COMMENT 'long类型的trigger的第一个参数',
|
||
`long_prop_2` bigint(20) DEFAULT NULL COMMENT 'long类型的trigger的第二个参数',
|
||
`dec_prop_1` decimal(13,4) DEFAULT NULL COMMENT 'decimal类型的trigger的第一个参数',
|
||
`dec_prop_2` decimal(13,4) DEFAULT NULL COMMENT 'decimal类型的trigger的第二个参数',
|
||
`bool_prop_1` varchar(1) DEFAULT NULL COMMENT 'Boolean类型的trigger的第一个参数',
|
||
`bool_prop_2` varchar(1) DEFAULT NULL COMMENT 'Boolean类型的trigger的第二个参数',
|
||
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 COMMENT='同步机制的行锁表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_SIMPROP_TRIGGERS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for QRTZ_TRIGGERS
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
|
||
CREATE TABLE `QRTZ_TRIGGERS` (
|
||
`sched_name` varchar(120) NOT NULL COMMENT '调度名称',
|
||
`trigger_name` varchar(200) NOT NULL COMMENT '触发器的名字',
|
||
`trigger_group` varchar(200) NOT NULL COMMENT '触发器所属组的名字',
|
||
`job_name` varchar(200) NOT NULL COMMENT 'qrtz_job_details表job_name的外键',
|
||
`job_group` varchar(200) NOT NULL COMMENT 'qrtz_job_details表job_group的外键',
|
||
`description` varchar(250) DEFAULT NULL COMMENT '相关介绍',
|
||
`next_fire_time` bigint(13) DEFAULT NULL COMMENT '上一次触发时间（毫秒）',
|
||
`prev_fire_time` bigint(13) DEFAULT NULL COMMENT '下一次触发时间（默认为-1表示不触发）',
|
||
`priority` int(11) DEFAULT NULL COMMENT '优先级',
|
||
`trigger_state` varchar(16) NOT NULL COMMENT '触发器状态',
|
||
`trigger_type` varchar(8) NOT NULL COMMENT '触发器的类型',
|
||
`start_time` bigint(13) NOT NULL COMMENT '开始时间',
|
||
`end_time` bigint(13) DEFAULT NULL COMMENT '结束时间',
|
||
`calendar_name` varchar(200) DEFAULT NULL COMMENT '日程表名称',
|
||
`misfire_instr` smallint(2) DEFAULT NULL COMMENT '补偿执行的策略',
|
||
`job_data` blob COMMENT '存放持久化job对象',
|
||
PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
|
||
KEY `sched_name` (`sched_name`,`job_name`,`job_group`),
|
||
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 COMMENT='触发器详细信息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of QRTZ_TRIGGERS
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|