Index: lams_common/db/sql/create_quartz_table.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -rf9d8fc434a8b7629a1353f532eb15e5c4f5f3cac --- lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision f9d8fc434a8b7629a1353f532eb15e5c4f5f3cac) @@ -1,173 +1,252 @@ -# Quartz 2.2.3 +-- Quartz 2.2.3 +SET FOREIGN_KEY_CHECKS=0; +SET NAMES utf8mb4 ; -DROP TABLE IF EXISTS lams_qtz_FIRED_TRIGGERS; -DROP TABLE IF EXISTS lams_qtz_PAUSED_TRIGGER_GRPS; -DROP TABLE IF EXISTS lams_qtz_SCHEDULER_STATE; -DROP TABLE IF EXISTS lams_qtz_LOCKS; -DROP TABLE IF EXISTS lams_qtz_SIMPLE_TRIGGERS; -DROP TABLE IF EXISTS lams_qtz_SIMPROP_TRIGGERS; -DROP TABLE IF EXISTS lams_qtz_CRON_TRIGGERS; -DROP TABLE IF EXISTS lams_qtz_BLOB_TRIGGERS; -DROP TABLE IF EXISTS lams_qtz_TRIGGERS; -DROP TABLE IF EXISTS lams_qtz_JOB_DETAILS; -DROP TABLE IF EXISTS lams_qtz_CALENDARS; +-- +-- Table structure for table `lams_qtz_BLOB_TRIGGERS` +-- -CREATE TABLE lams_qtz_JOB_DETAILS( -SCHED_NAME VARCHAR(120) NOT NULL, -JOB_NAME VARCHAR(200) NOT NULL, -JOB_GROUP VARCHAR(200) NOT NULL, -DESCRIPTION VARCHAR(250) 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 NULL, -PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)) -ENGINE=InnoDB; +DROP TABLE IF EXISTS `lams_qtz_BLOB_TRIGGERS`; -CREATE TABLE lams_qtz_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) NULL, -NEXT_FIRE_TIME BIGINT(13) NULL, -PREV_FIRE_TIME BIGINT(13) NULL, -PRIORITY INTEGER NULL, -TRIGGER_STATE VARCHAR(16) NOT NULL, -TRIGGER_TYPE VARCHAR(8) NOT NULL, -START_TIME BIGINT(13) NOT NULL, -END_TIME BIGINT(13) NULL, -CALENDAR_NAME VARCHAR(200) NULL, -MISFIRE_INSTR SMALLINT(2) NULL, -JOB_DATA BLOB NULL, -PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), -FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP) -REFERENCES lams_qtz_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)) -ENGINE=InnoDB; +CREATE TABLE `lams_qtz_BLOB_TRIGGERS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `BLOB_DATA` blob, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `lams_qtz_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `lams_qtz_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -CREATE TABLE lams_qtz_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), -FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) -REFERENCES lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; +-- +-- Table structure for table `lams_qtz_CALENDARS` +-- -CREATE TABLE lams_qtz_CRON_TRIGGERS ( -SCHED_NAME VARCHAR(120) NOT NULL, -TRIGGER_NAME VARCHAR(200) NOT NULL, -TRIGGER_GROUP VARCHAR(200) NOT NULL, -CRON_EXPRESSION VARCHAR(120) NOT NULL, -TIME_ZONE_ID VARCHAR(80), -PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), -FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) -REFERENCES lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; +DROP TABLE IF EXISTS `lams_qtz_CALENDARS`; -CREATE TABLE lams_qtz_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) NULL, - STR_PROP_2 VARCHAR(512) NULL, - STR_PROP_3 VARCHAR(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 VARCHAR(1) NULL, - BOOL_PROP_2 VARCHAR(1) NULL, - PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), - FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) - REFERENCES lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; +CREATE TABLE `lams_qtz_CALENDARS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `CALENDAR_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `CALENDAR` blob NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -CREATE TABLE lams_qtz_BLOB_TRIGGERS ( -SCHED_NAME VARCHAR(120) NOT NULL, -TRIGGER_NAME VARCHAR(200) NOT NULL, -TRIGGER_GROUP VARCHAR(200) NOT NULL, -BLOB_DATA BLOB NULL, -PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), -INDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP), -FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) -REFERENCES lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; +-- +-- Table structure for table `lams_qtz_CRON_TRIGGERS` +-- -CREATE TABLE lams_qtz_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; +DROP TABLE IF EXISTS `lams_qtz_CRON_TRIGGERS`; -CREATE TABLE lams_qtz_PAUSED_TRIGGER_GRPS ( -SCHED_NAME VARCHAR(120) NOT NULL, -TRIGGER_GROUP VARCHAR(200) NOT NULL, -PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; +CREATE TABLE `lams_qtz_CRON_TRIGGERS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `CRON_EXPRESSION` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `TIME_ZONE_ID` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `lams_qtz_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `lams_qtz_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -CREATE TABLE lams_qtz_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 INTEGER NOT NULL, -STATE VARCHAR(16) NOT NULL, -JOB_NAME VARCHAR(200) NULL, -JOB_GROUP VARCHAR(200) NULL, -IS_NONCONCURRENT VARCHAR(1) NULL, -REQUESTS_RECOVERY VARCHAR(1) NULL, -PRIMARY KEY (SCHED_NAME,ENTRY_ID)) -ENGINE=InnoDB; +-- +-- Table structure for table `lams_qtz_FIRED_TRIGGERS` +-- -CREATE TABLE lams_qtz_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; +DROP TABLE IF EXISTS `lams_qtz_FIRED_TRIGGERS`; -CREATE TABLE lams_qtz_LOCKS ( -SCHED_NAME VARCHAR(120) NOT NULL, -LOCK_NAME VARCHAR(40) NOT NULL, -PRIMARY KEY (SCHED_NAME,LOCK_NAME)) -ENGINE=InnoDB; +CREATE TABLE `lams_qtz_FIRED_TRIGGERS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `ENTRY_ID` varchar(95) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `INSTANCE_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `FIRED_TIME` bigint(13) NOT NULL, + `SCHED_TIME` bigint(13) NOT NULL, + `PRIORITY` int(11) NOT NULL, + `STATE` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, + `JOB_NAME` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `JOB_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `IS_NONCONCURRENT` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `REQUESTS_RECOVERY` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`), + KEY `IDX_lams_qtz_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`), + KEY `IDX_lams_qtz_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`), + KEY `IDX_lams_qtz_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_lams_qtz_FT_JG` (`SCHED_NAME`,`JOB_GROUP`), + KEY `IDX_lams_qtz_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `IDX_lams_qtz_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -CREATE INDEX IDX_lams_qtz_J_REQ_RECOVERY ON lams_qtz_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY); -CREATE INDEX IDX_lams_qtz_J_GRP ON lams_qtz_JOB_DETAILS(SCHED_NAME,JOB_GROUP); +-- +-- Table structure for table `lams_qtz_JOB_DETAILS` +-- -CREATE INDEX IDX_lams_qtz_T_J ON lams_qtz_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP); -CREATE INDEX IDX_lams_qtz_T_JG ON lams_qtz_TRIGGERS(SCHED_NAME,JOB_GROUP); -CREATE INDEX IDX_lams_qtz_T_C ON lams_qtz_TRIGGERS(SCHED_NAME,CALENDAR_NAME); -CREATE INDEX IDX_lams_qtz_T_G ON lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_GROUP); -CREATE INDEX IDX_lams_qtz_T_STATE ON lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_STATE); -CREATE INDEX IDX_lams_qtz_T_N_STATE ON lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE); -CREATE INDEX IDX_lams_qtz_T_N_G_STATE ON lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE); -CREATE INDEX IDX_lams_qtz_T_NEXT_FIRE_TIME ON lams_qtz_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME); -CREATE INDEX IDX_lams_qtz_T_NFT_ST ON lams_qtz_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME); -CREATE INDEX IDX_lams_qtz_T_NFT_MISFIRE ON lams_qtz_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME); -CREATE INDEX IDX_lams_qtz_T_NFT_ST_MISFIRE ON lams_qtz_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE); -CREATE INDEX IDX_lams_qtz_T_NFT_ST_MISFIRE_GRP ON lams_qtz_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE); +DROP TABLE IF EXISTS `lams_qtz_JOB_DETAILS`; -CREATE INDEX IDX_lams_qtz_FT_TRIG_INST_NAME ON lams_qtz_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME); -CREATE INDEX IDX_lams_qtz_FT_INST_JOB_REQ_RCVRY ON lams_qtz_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY); -CREATE INDEX IDX_lams_qtz_FT_J_G ON lams_qtz_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP); -CREATE INDEX IDX_lams_qtz_FT_JG ON lams_qtz_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP); -CREATE INDEX IDX_lams_qtz_FT_T_G ON lams_qtz_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP); -CREATE INDEX IDX_lams_qtz_FT_TG ON lams_qtz_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP); +CREATE TABLE `lams_qtz_JOB_DETAILS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `JOB_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `JOB_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `DESCRIPTION` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `JOB_CLASS_NAME` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, + `IS_DURABLE` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, + `IS_NONCONCURRENT` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, + `IS_UPDATE_DATA` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, + `REQUESTS_RECOVERY` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, + `JOB_DATA` blob, + PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_lams_qtz_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`), + KEY `IDX_lams_qtz_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -commit; \ No newline at end of file +-- +-- Dumping data for table `lams_qtz_JOB_DETAILS` +-- + +LOCK TABLES `lams_qtz_JOB_DETAILS` WRITE; +INSERT INTO `lams_qtz_JOB_DETAILS` VALUES ('LAMS','Resend Messages Job','DEFAULT',NULL,'org.lamsfoundation.lams.events.ResendMessagesJob','1','0','0','0',0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787000737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F40000000000010770800000010000000007800); +UNLOCK TABLES; + +-- +-- Table structure for table `lams_qtz_LOCKS` +-- + +DROP TABLE IF EXISTS `lams_qtz_LOCKS`; + +CREATE TABLE `lams_qtz_LOCKS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `LOCK_NAME` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Dumping data for table `lams_qtz_LOCKS` +-- + +LOCK TABLES `lams_qtz_LOCKS` WRITE; +INSERT INTO `lams_qtz_LOCKS` VALUES ('LAMS','TRIGGER_ACCESS'); +UNLOCK TABLES; + +-- +-- Table structure for table `lams_qtz_PAUSED_TRIGGER_GRPS` +-- + +DROP TABLE IF EXISTS `lams_qtz_PAUSED_TRIGGER_GRPS`; + +CREATE TABLE `lams_qtz_PAUSED_TRIGGER_GRPS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `lams_qtz_SCHEDULER_STATE` +-- + +DROP TABLE IF EXISTS `lams_qtz_SCHEDULER_STATE`; + +CREATE TABLE `lams_qtz_SCHEDULER_STATE` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `INSTANCE_NAME` varchar(200) COLLATE utf8mb4_unicode_ci 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `lams_qtz_SIMPLE_TRIGGERS` +-- + +DROP TABLE IF EXISTS `lams_qtz_SIMPLE_TRIGGERS`; + +CREATE TABLE `lams_qtz_SIMPLE_TRIGGERS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci 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 `lams_qtz_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `lams_qtz_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Dumping data for table `lams_qtz_SIMPLE_TRIGGERS` +-- + +LOCK TABLES `lams_qtz_SIMPLE_TRIGGERS` WRITE; +INSERT INTO `lams_qtz_SIMPLE_TRIGGERS` VALUES ('LAMS','Resend Messages Job Trigger','DEFAULT',-1,3600000,1); +UNLOCK TABLES; + +-- +-- Table structure for table `lams_qtz_SIMPROP_TRIGGERS` +-- + +DROP TABLE IF EXISTS `lams_qtz_SIMPROP_TRIGGERS`; + +CREATE TABLE `lams_qtz_SIMPROP_TRIGGERS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `STR_PROP_1` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `STR_PROP_2` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `STR_PROP_3` varchar(512) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `BOOL_PROP_2` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `lams_qtz_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `lams_qtz_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `lams_qtz_TRIGGERS` +-- + +DROP TABLE IF EXISTS `lams_qtz_TRIGGERS`; + +CREATE TABLE `lams_qtz_TRIGGERS` ( + `SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `JOB_NAME` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `JOB_GROUP` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, + `DESCRIPTION` varchar(250) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL, + `TRIGGER_TYPE` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL, + `START_TIME` bigint(13) NOT NULL, + `END_TIME` bigint(13) DEFAULT NULL, + `CALENDAR_NAME` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `MISFIRE_INSTR` smallint(2) DEFAULT NULL, + `JOB_DATA` blob, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `IDX_lams_qtz_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_lams_qtz_T_JG` (`SCHED_NAME`,`JOB_GROUP`), + KEY `IDX_lams_qtz_T_C` (`SCHED_NAME`,`CALENDAR_NAME`), + KEY `IDX_lams_qtz_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`), + KEY `IDX_lams_qtz_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`), + KEY `IDX_lams_qtz_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + KEY `IDX_lams_qtz_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + KEY `IDX_lams_qtz_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`), + KEY `IDX_lams_qtz_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`), + KEY `IDX_lams_qtz_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`), + KEY `IDX_lams_qtz_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`), + KEY `IDX_lams_qtz_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + CONSTRAINT `lams_qtz_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `lams_qtz_JOB_DETAILS` (`sched_name`, `job_name`, `job_group`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Dumping data for table `lams_qtz_TRIGGERS` +-- + +LOCK TABLES `lams_qtz_TRIGGERS` WRITE; +INSERT INTO `lams_qtz_TRIGGERS` VALUES ('LAMS','Resend Messages Job Trigger','DEFAULT','Resend Messages Job','DEFAULT',NULL,1546640319849,1546636719849,0,'WAITING','SIMPLE',1546636719849,0,NULL,0,''); +UNLOCK TABLES; + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file