-- MariaDB dump 10.19  Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: ol521
-- ------------------------------------------------------
-- Server version	10.6.18-MariaDB-0ubuntu0.22.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `banners`
--

DROP TABLE IF EXISTS `banners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banners` (
  `bannerid` int(11) NOT NULL AUTO_INCREMENT,
  `bannername` tinytext DEFAULT NULL,
  `bannercolor` tinytext DEFAULT NULL,
  `textcolor` tinytext DEFAULT NULL,
  PRIMARY KEY (`bannerid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banners`
--

LOCK TABLES `banners` WRITE;
/*!40000 ALTER TABLE `banners` DISABLE KEYS */;
INSERT INTO `banners` VALUES 
(1,'no banner','#000000','#000000'),
(2,'UNCLASSIFIED','#009900','#FFFFFF'),
(3,'CONFIDENTIAL','#000099','#FFFFFF'),
(4,'SECRET','#990000','#FFFFFF'),
(5,'TOP SECRET','#FF6600','#FFFFFF');
/*!40000 ALTER TABLE `banners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `configs`
--

DROP TABLE IF EXISTS `configs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `configs` (
  `confid` int(11) NOT NULL AUTO_INCREMENT,
  `confname` text DEFAULT NULL,
  `confvalue` text DEFAULT NULL,
  PRIMARY KEY (`confid`),
  UNIQUE (`confname`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `configs`
--

LOCK TABLES `configs` WRITE;
/*!40000 ALTER TABLE `configs` DISABLE KEYS */;
INSERT INTO `configs` VALUES 
(1,'ol_version','5.2.5'),
(2,'log_name','OpenLog'),
(3,'banner','1'),
(4,'background_color','#003333'),
(5,'p_background_color','#FFFFFF'),
(6,'sidebar_color','#336666'),
(7,'p_sidebar_color','#FFFFFF'),
(8,'menubg_color','#000000'),
(9,'p_menubg_color','#FFFFFF'),
(10,'text_color','#FFFFFF'),
(11,'p_text_color','#000000'),
(12,'link_color','#00FF00'),
(13,'p_link_color','#000000'),
(14,'vlink_color','#00FF00'),
(15,'p_vlink_color','#000000'),
(16,'heading_color','#00FFFF'),
(17,'p_heading_color','#000000'),
(18,'footer_message','Please report bugs to software@thermionic.net.'),
(19,'show_ts','1'),
(20,'url_chunk_size','70'),
(21,'tech_alpha','1'),
(22,'subj_alpha','1'),
(23,'unix_server_session_dir','/tmp/openlog/openlog/sessions'),
(24,'win_server_session_dir','c:\\Windows\\Temp\\openlog\\\\openlog\\sessions'),
(25,'session_ttl_days','30'),
(26,'log_style','1'),
(27,'uid_text','Part ID Number'),
(28,'parts_functions','1'),
(29,'schedmaint_functions','1'),
(30,'log_errors','0');
/*!40000 ALTER TABLE `configs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customs`
--

DROP TABLE IF EXISTS `customs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customs` (
  `customid` int(11) NOT NULL AUTO_INCREMENT,
  `customtech` int(11) DEFAULT NULL,
  `customconfnum` int(11) DEFAULT NULL,
  `customconfvalue` text DEFAULT NULL,
  PRIMARY KEY (`customid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customs`
--

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

--
-- Table structure for table `devicegroups`
--

DROP TABLE IF EXISTS `devicegroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `devicegroups` (
  `groupid` int(11) NOT NULL AUTO_INCREMENT,
  `groupdevice` int(11) DEFAULT NULL,
  `memberdevice` int(11) DEFAULT NULL,
  PRIMARY KEY (`groupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `devicegroups`
--

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

--
-- Table structure for table `devices`
--

DROP TABLE IF EXISTS `devices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `devices` (
  `deviceid` int(11) NOT NULL AUTO_INCREMENT,
  `devicename` tinytext DEFAULT NULL,
  `devicedesc` text DEFAULT NULL,
  `group_flag` int(11) DEFAULT NULL,
  `active_flag` int(11) DEFAULT NULL,
  PRIMARY KEY (`deviceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `devices`
--

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

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
  `eventid` int(11) NOT NULL AUTO_INCREMENT,
  `task` int(11) DEFAULT NULL,
  `device` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `last_date` date DEFAULT NULL,
  `deferred_flag` int(11) DEFAULT NULL,
  `deferred_date` date DEFAULT NULL,
  `active_flag` int(11) DEFAULT NULL,
  PRIMARY KEY (`eventid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events`
--

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

--
-- Table structure for table `flags`
--

DROP TABLE IF EXISTS `flags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `flags` (
  `flagid` int(11) NOT NULL AUTO_INCREMENT,
  `flagname` tinytext DEFAULT NULL,
  `flagsym` tinytext DEFAULT NULL,
  `flagcolor` tinytext DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`flagid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `flags`
--

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

--
-- Table structure for table `links`
--

DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
  `linkid` int(11) NOT NULL AUTO_INCREMENT,
  `linkpriority` int(11) NOT NULL,
  `displaytxt` text DEFAULT NULL,
  `urltxt` text DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`linkid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `links`
--

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

--
-- Table structure for table `lognotes`
--

DROP TABLE IF EXISTS `lognotes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lognotes` (
  `lognoteid` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `shift` int(11) NOT NULL,
  `tech` int(11) NOT NULL,
  `subject` int(11) NOT NULL,
  `lognote` text DEFAULT NULL,
  `refs` tinytext DEFAULT NULL,
  PRIMARY KEY (`lognoteid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lognotes`
--

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

--
-- Table structure for table `logpartactions`
--

DROP TABLE IF EXISTS `logpartactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logpartactions` (
  `lpactionid` int(11) NOT NULL AUTO_INCREMENT,
  `lpactionname` tinytext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`lpactionid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logpartactions`
--

LOCK TABLES `logpartactions` WRITE;
/*!40000 ALTER TABLE `logpartactions` DISABLE KEYS */;
INSERT INTO `logpartactions` VALUES 
(1,'removed',1),
(2,'installed',1),
(3,'repaired',1),
(4,'replaced',1),
(5,'incoming',1),
(6,'outgoing',1);
/*!40000 ALTER TABLE `logpartactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logparts`
--

DROP TABLE IF EXISTS `logparts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logparts` (
  `logpartid` int(11) NOT NULL AUTO_INCREMENT,
  `lognoteid` int(11) DEFAULT NULL,
  `partid` int(11) DEFAULT NULL,
  `action` int(11) DEFAULT NULL,
  PRIMARY KEY (`logpartid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logparts`
--

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

--
-- Table structure for table `maintactions`
--

DROP TABLE IF EXISTS `maintactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maintactions` (
  `maintactionid` int(11) NOT NULL AUTO_INCREMENT,
  `actiondate` date DEFAULT NULL,
  `actiontime` time DEFAULT NULL,
  `maintformnum` int(11) NOT NULL,
  `actiontech` int(11) NOT NULL,
  `action` text DEFAULT NULL,
  PRIMARY KEY (`maintactionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maintactions`
--

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

--
-- Table structure for table `maintforms`
--

DROP TABLE IF EXISTS `maintforms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maintforms` (
  `maintformid` int(11) NOT NULL AUTO_INCREMENT,
  `mfdate` date DEFAULT NULL,
  `mftime` time DEFAULT NULL,
  `mftech` int(11) DEFAULT NULL,
  `mfpart` int(11) NOT NULL,
  `mfpartloc` text DEFAULT NULL,
  `mfmalfunction` text DEFAULT NULL,
  `nha` tinytext DEFAULT NULL,
  `repord` tinytext DEFAULT NULL,
  `lognoteid` int(11) DEFAULT NULL,
  `pending` int(11) DEFAULT NULL,
  PRIMARY KEY (`maintformid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maintforms`
--

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

--
-- Table structure for table `notetemplates`
--

DROP TABLE IF EXISTS `notetemplates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notetemplates` (
  `templateid` int(11) NOT NULL AUTO_INCREMENT,
  `templatename` tinytext DEFAULT NULL,
  `shift` int(11) NOT NULL,
  `tech` int(11) NOT NULL,
  `subject` int(11) NOT NULL,
  `lognote` text DEFAULT NULL,
  `refs` tinytext DEFAULT NULL,
  PRIMARY KEY (`templateid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notetemplates`
--

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

--
-- Table structure for table `parts`
--

DROP TABLE IF EXISTS `parts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `parts` (
  `partid` int(11) NOT NULL AUTO_INCREMENT,
  `uid` tinytext DEFAULT NULL,
  `partnum` tinytext DEFAULT NULL,
  `sernum` tinytext DEFAULT NULL,
  `partname` tinytext DEFAULT NULL,
  PRIMARY KEY (`partid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parts`
--

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

--
-- Table structure for table `shifts`
--

DROP TABLE IF EXISTS `shifts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shifts` (
  `shiftid` int(11) NOT NULL AUTO_INCREMENT,
  `shiftname` tinytext DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`shiftid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shifts`
--

LOCK TABLES `shifts` WRITE;
/*!40000 ALTER TABLE `shifts` DISABLE KEYS */;
INSERT INTO `shifts` VALUES 
(1,'First Shift',1);
/*!40000 ALTER TABLE `shifts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `styles`
--

DROP TABLE IF EXISTS `styles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `styles` (
  `styleid` int(11) NOT NULL AUTO_INCREMENT,
  `styletype` tinytext DEFAULT NULL,
  `stylename` tinytext DEFAULT NULL,
  PRIMARY KEY (`styleid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `styles`
--

LOCK TABLES `styles` WRITE;
/*!40000 ALTER TABLE `styles` DISABLE KEYS */;
INSERT INTO `styles` VALUES 
(1,'logdisplay','classic'),
(2,'logdisplay','clean');
/*!40000 ALTER TABLE `styles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subjects`
--

DROP TABLE IF EXISTS `subjects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subjects` (
  `subjectid` int(11) NOT NULL AUTO_INCREMENT,
  `subjectname` tinytext DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`subjectid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subjects`
--

LOCK TABLES `subjects` WRITE;
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
INSERT INTO `subjects` VALUES 
(1,'Miscellaneous',1);
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tasks`
--

DROP TABLE IF EXISTS `tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tasks` (
  `taskid` int(11) NOT NULL AUTO_INCREMENT,
  `taskname` tinytext DEFAULT NULL,
  `taskdesc` text DEFAULT NULL,
  `frequency` int(11) DEFAULT NULL,
  `period` tinytext DEFAULT NULL,
  `weekdays_only` int(11) DEFAULT NULL,
  `nextdue_relative` int(11) DEFAULT NULL,
  `refdoc_name` tinytext DEFAULT NULL,
  `refdoc_url` tinytext DEFAULT NULL,
  `active_flag` int(11) DEFAULT NULL,
  PRIMARY KEY (`taskid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tasks`
--

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

--
-- Table structure for table `techs`
--

DROP TABLE IF EXISTS `techs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `techs` (
  `techid` int(11) NOT NULL AUTO_INCREMENT,
  `techname` tinytext DEFAULT NULL,
  `admin` int(11) DEFAULT NULL,
  `shift` int(11) DEFAULT NULL,
  `techpass` text DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`techid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `techs`
--

LOCK TABLES `techs` WRITE;
/*!40000 ALTER TABLE `techs` DISABLE KEYS */;
INSERT INTO `techs` VALUES 
(1,'OpenLogAdmin',1,1,'$2y$10$6eCxUFNzoAkycMJpZ.zvaOfoByYhqi0YicQbut3XGc/TRxyxiUwcm',1);
/*!40000 ALTER TABLE `techs` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-07-09 14:36:00