--
-- Table structure for table `lams_qtz_blob_triggers`
--

DROP TABLE IF EXISTS `lams_qtz_blob_triggers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_blob_triggers` (
  `TRIGGER_NAME` varchar(80) NOT NULL,
  `TRIGGER_GROUP` varchar(80) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_blob_triggers`
--

LOCK TABLES `lams_qtz_blob_triggers` WRITE;
/*!40000 ALTER TABLE `lams_qtz_blob_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `lams_qtz_blob_triggers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_calendars`
--

DROP TABLE IF EXISTS `lams_qtz_calendars`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_calendars` (
  `CALENDAR_NAME` varchar(80) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`CALENDAR_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_calendars`
--

LOCK TABLES `lams_qtz_calendars` WRITE;
/*!40000 ALTER TABLE `lams_qtz_calendars` DISABLE KEYS */;
/*!40000 ALTER TABLE `lams_qtz_calendars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_cron_triggers`
--

DROP TABLE IF EXISTS `lams_qtz_cron_triggers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_cron_triggers` (
  `TRIGGER_NAME` varchar(80) NOT NULL,
  `TRIGGER_GROUP` varchar(80) NOT NULL,
  `CRON_EXPRESSION` varchar(80) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_cron_triggers`
--

LOCK TABLES `lams_qtz_cron_triggers` WRITE;
/*!40000 ALTER TABLE `lams_qtz_cron_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `lams_qtz_cron_triggers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_fired_triggers`
--

DROP TABLE IF EXISTS `lams_qtz_fired_triggers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_fired_triggers` (
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(80) NOT NULL,
  `TRIGGER_GROUP` varchar(80) NOT NULL,
  `IS_VOLATILE` varchar(1) NOT NULL,
  `INSTANCE_NAME` varchar(80) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(80) DEFAULT NULL,
  `JOB_GROUP` varchar(80) DEFAULT NULL,
  `IS_STATEFUL` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`ENTRY_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_fired_triggers`
--

LOCK TABLES `lams_qtz_fired_triggers` WRITE;
/*!40000 ALTER TABLE `lams_qtz_fired_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `lams_qtz_fired_triggers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_job_details`
--

DROP TABLE IF EXISTS `lams_qtz_job_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_job_details` (
  `JOB_NAME` varchar(80) NOT NULL,
  `JOB_GROUP` varchar(80) NOT NULL,
  `DESCRIPTION` varchar(120) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(128) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_VOLATILE` varchar(1) NOT NULL,
  `IS_STATEFUL` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_job_details`
--

LOCK TABLES `lams_qtz_job_details` WRITE;
/*!40000 ALTER TABLE `lams_qtz_job_details` DISABLE KEYS */;
INSERT INTO `lams_qtz_job_details` VALUES ('Resend Messages Job','DEFAULT','','org.lamsfoundation.lams.events.ResendMessagesJob','0','0','0','0','\0sr\0org.quartz.JobDataMap迩\0
Z\0allowsTransientDataxr\0org.quartz.utils.DirtyFlagMap.(v\n\0Z\0dirtyL\0mapt\0Ljava/util/Map;xp\0sr\0java.util.HashMap`\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0\r\nw\0\0\0\0\0\0\0x\0');
/*!40000 ALTER TABLE `lams_qtz_job_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_job_listeners`
--

DROP TABLE IF EXISTS `lams_qtz_job_listeners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_job_listeners` (
  `JOB_NAME` varchar(80) NOT NULL,
  `JOB_GROUP` varchar(80) NOT NULL,
  `JOB_LISTENER` varchar(80) NOT NULL,
  PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`,`JOB_LISTENER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_job_listeners`
--

LOCK TABLES `lams_qtz_job_listeners` WRITE;
/*!40000 ALTER TABLE `lams_qtz_job_listeners` DISABLE KEYS */;
/*!40000 ALTER TABLE `lams_qtz_job_listeners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_locks`
--

DROP TABLE IF EXISTS `lams_qtz_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_locks` (
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`LOCK_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_locks`
--

LOCK TABLES `lams_qtz_locks` WRITE;
/*!40000 ALTER TABLE `lams_qtz_locks` DISABLE KEYS */;
INSERT INTO `lams_qtz_locks` VALUES ('CALENDAR_ACCESS'),('JOB_ACCESS'),('MISFIRE_ACCESS'),('STATE_ACCESS'),('TRIGGER_ACCESS');
/*!40000 ALTER TABLE `lams_qtz_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_paused_trigger_grps`
--

DROP TABLE IF EXISTS `lams_qtz_paused_trigger_grps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_paused_trigger_grps` (
  `TRIGGER_GROUP` varchar(80) NOT NULL,
  PRIMARY KEY (`TRIGGER_GROUP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_paused_trigger_grps`
--

LOCK TABLES `lams_qtz_paused_trigger_grps` WRITE;
/*!40000 ALTER TABLE `lams_qtz_paused_trigger_grps` DISABLE KEYS */;
/*!40000 ALTER TABLE `lams_qtz_paused_trigger_grps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_scheduler_state`
--

DROP TABLE IF EXISTS `lams_qtz_scheduler_state`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_scheduler_state` (
  `INSTANCE_NAME` varchar(80) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  `RECOVERER` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`INSTANCE_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_scheduler_state`
--

LOCK TABLES `lams_qtz_scheduler_state` WRITE;
/*!40000 ALTER TABLE `lams_qtz_scheduler_state` DISABLE KEYS */;
/*!40000 ALTER TABLE `lams_qtz_scheduler_state` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_simple_triggers`
--

DROP TABLE IF EXISTS `lams_qtz_simple_triggers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_simple_triggers` (
  `TRIGGER_NAME` varchar(80) NOT NULL,
  `TRIGGER_GROUP` varchar(80) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(7) NOT NULL,
  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_simple_triggers`
--

LOCK TABLES `lams_qtz_simple_triggers` WRITE;
/*!40000 ALTER TABLE `lams_qtz_simple_triggers` DISABLE KEYS */;
INSERT INTO `lams_qtz_simple_triggers` VALUES ('Resend Messages Job trigger','DEFAULT',-1,3600000,2269);
/*!40000 ALTER TABLE `lams_qtz_simple_triggers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_trigger_listeners`
--

DROP TABLE IF EXISTS `lams_qtz_trigger_listeners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_trigger_listeners` (
  `TRIGGER_NAME` varchar(80) NOT NULL,
  `TRIGGER_GROUP` varchar(80) NOT NULL,
  `TRIGGER_LISTENER` varchar(80) NOT NULL,
  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_LISTENER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_trigger_listeners`
--

LOCK TABLES `lams_qtz_trigger_listeners` WRITE;
/*!40000 ALTER TABLE `lams_qtz_trigger_listeners` DISABLE KEYS */;
/*!40000 ALTER TABLE `lams_qtz_trigger_listeners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lams_qtz_triggers`
--

DROP TABLE IF EXISTS `lams_qtz_triggers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lams_qtz_triggers` (
  `TRIGGER_NAME` varchar(80) NOT NULL,
  `TRIGGER_GROUP` varchar(80) NOT NULL,
  `JOB_NAME` varchar(80) NOT NULL,
  `JOB_GROUP` varchar(80) NOT NULL,
  `IS_VOLATILE` varchar(1) NOT NULL,
  `DESCRIPTION` varchar(120) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) 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(80) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lams_qtz_triggers`
--

LOCK TABLES `lams_qtz_triggers` WRITE;
/*!40000 ALTER TABLE `lams_qtz_triggers` DISABLE KEYS */;
INSERT INTO `lams_qtz_triggers` VALUES ('Resend Messages Job trigger','DEFAULT','Resend Messages Job','DEFAULT','0',NULL,1242292462116,1242288862116,'MISFIRED','SIMPLE',1234124062116,0,NULL,0,NULL);
/*!40000 ALTER TABLE `lams_qtz_triggers` ENABLE KEYS */;
UNLOCK TABLES;