Index: lams_common/db/sql/create_quartz_table.sql =================================================================== diff -u -rf9d8fc434a8b7629a1353f532eb15e5c4f5f3cac -r876d50bd746a64ca649314f52ec4de3396727090 --- lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision f9d8fc434a8b7629a1353f532eb15e5c4f5f3cac) +++ lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision 876d50bd746a64ca649314f52ec4de3396727090) @@ -99,14 +99,6 @@ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- --- 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` -- @@ -170,14 +162,6 @@ ) 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` -- @@ -241,12 +225,4 @@ 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