Index: lams_common/db/sql/create_quartz_table.sql =================================================================== diff -u -r876d50bd746a64ca649314f52ec4de3396727090 -r812d599154aefa64ac8c3db4cdecdc1b679706af --- lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision 876d50bd746a64ca649314f52ec4de3396727090) +++ lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) @@ -1,228 +1,183 @@ -- Quartz 2.2.3 SET FOREIGN_KEY_CHECKS=0; -SET NAMES utf8mb4 ; --- --- Table structure for table `lams_qtz_BLOB_TRIGGERS` --- +DROP TABLE IF EXISTS lams_qtz_blob_triggers; -DROP TABLE IF EXISTS `lams_qtz_BLOB_TRIGGERS`; +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, + 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) +); -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; +DROP TABLE IF EXISTS lams_qtz_calendars; --- --- Table structure for table `lams_qtz_CALENDARS` --- +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) +); -DROP TABLE IF EXISTS `lams_qtz_CALENDARS`; +DROP TABLE IF EXISTS lams_qtz_cron_triggers; -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_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) 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) +); --- --- Table structure for table `lams_qtz_CRON_TRIGGERS` --- +DROP TABLE IF EXISTS lams_qtz_fired_triggers; -DROP TABLE IF EXISTS `lams_qtz_CRON_TRIGGERS`; +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 NOT NULL, + SCHED_TIME bigint NOT NULL, + PRIORITY int 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), + 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) +); -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; +DROP TABLE IF EXISTS lams_qtz_job_details; --- --- Table structure for table `lams_qtz_FIRED_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) 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), + KEY IDX_lams_qtz_J_REQ_RECOVERY (SCHED_NAME,REQUESTS_RECOVERY), + KEY IDX_lams_qtz_J_GRP (SCHED_NAME,JOB_GROUP) +); -DROP TABLE IF EXISTS `lams_qtz_FIRED_TRIGGERS`; +DROP TABLE IF EXISTS lams_qtz_locks; -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 TABLE lams_qtz_locks ( + SCHED_NAME varchar(120) NOT NULL, + LOCK_NAME varchar(40) NOT NULL, + PRIMARY KEY (SCHED_NAME,LOCK_NAME) +); --- --- Table structure for table `lams_qtz_JOB_DETAILS` --- +DROP TABLE IF EXISTS lams_qtz_paused_trigger_grps; -DROP TABLE IF EXISTS `lams_qtz_JOB_DETAILS`; +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) +); -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; +DROP TABLE IF EXISTS lams_qtz_scheduler_state; --- --- Table structure for table `lams_qtz_LOCKS` --- +CREATE TABLE lams_qtz_scheduler_state ( + SCHED_NAME varchar(120) NOT NULL, + INSTANCE_NAME varchar(200) NOT NULL, + LAST_CHECKIN_TIME bigint NOT NULL, + CHECKIN_INTERVAL bigint NOT NULL, + PRIMARY KEY (SCHED_NAME,INSTANCE_NAME) +); -DROP TABLE IF EXISTS `lams_qtz_LOCKS`; +DROP TABLE IF EXISTS lams_qtz_simple_triggers; -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; +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 NOT NULL, + REPEAT_INTERVAL bigint NOT NULL, + TIMES_TRIGGERED bigint 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) +); --- --- Dumping data for table `lams_qtz_LOCKS` --- +DROP TABLE IF EXISTS lams_qtz_simprop_triggers; -LOCK TABLES `lams_qtz_LOCKS` WRITE; -INSERT INTO `lams_qtz_LOCKS` VALUES ('LAMS','TRIGGER_ACCESS'); -UNLOCK TABLES; +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) DEFAULT NULL, + STR_PROP_2 varchar(512) DEFAULT NULL, + STR_PROP_3 varchar(512) DEFAULT NULL, + INT_PROP_1 int DEFAULT NULL, + INT_PROP_2 int DEFAULT NULL, + LONG_PROP_1 bigint DEFAULT NULL, + LONG_PROP_2 bigint 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 lams_qtz_SIMPROP_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) +); --- --- Table structure for table `lams_qtz_PAUSED_TRIGGER_GRPS` --- +DROP TABLE IF EXISTS lams_qtz_triggers; -DROP TABLE IF EXISTS `lams_qtz_PAUSED_TRIGGER_GRPS`; +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) DEFAULT NULL, + NEXT_FIRE_TIME bigint DEFAULT NULL, + PREV_FIRE_TIME bigint DEFAULT NULL, + PRIORITY int DEFAULT NULL, + TRIGGER_STATE varchar(16) NOT NULL, + TRIGGER_TYPE varchar(8) NOT NULL, + START_TIME bigint NOT NULL, + END_TIME bigint DEFAULT NULL, + CALENDAR_NAME varchar(200) DEFAULT NULL, + MISFIRE_INSTR smallint 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) +); -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; +INSERT INTO lams_qtz_job_details VALUES ('LAMS','Resend Messages Job','DEFAULT',NULL,'org.lamsfoundation.lams.events.ResendMessagesJob','1','0','0','0',0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787000737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F40000000000010770800000010000000007800); --- --- Table structure for table `lams_qtz_SCHEDULER_STATE` --- +INSERT INTO lams_qtz_locks VALUES ('LAMS','TRIGGER_ACCESS'); -DROP TABLE IF EXISTS `lams_qtz_SCHEDULER_STATE`; +INSERT INTO lams_qtz_simple_triggers VALUES ('LAMS','Resend Messages Job Trigger','DEFAULT',-1,3600000,0); -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; +INSERT INTO lams_qtz_triggers VALUES ('LAMS','Resend Messages Job Trigger','DEFAULT','Resend Messages Job','DEFAULT',NULL,1663667031020,-1,0,'WAITING','SIMPLE',1663667031020,0,NULL,0,''); --- --- 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; - --- --- 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; - SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file