-- MariaDB dump 10.17  Distrib 10.4.7-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: dce_website
-- ------------------------------------------------------
-- Server version	10.4.7-MariaDB-1:10.4.7+maria~stretch-log

/*!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 utf8 */;
/*!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 `tbl_announcements`
--

DROP TABLE IF EXISTS `tbl_announcements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_announcements` (
  `announcement_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `content` text DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `publish` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`announcement_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_announcements`
--

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

--
-- Table structure for table `tbl_conferences`
--

DROP TABLE IF EXISTS `tbl_conferences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_conferences` (
  `conference_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `theme` varchar(255) DEFAULT NULL,
  `topic` varchar(255) DEFAULT NULL,
  `venue` varchar(255) NOT NULL,
  `start_date` datetime DEFAULT current_timestamp(),
  `end_date` datetime DEFAULT NULL,
  PRIMARY KEY (`conference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_conferences`
--

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

--
-- Table structure for table `tbl_events`
--

DROP TABLE IF EXISTS `tbl_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_events` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `host` varchar(255) DEFAULT NULL,
  `type` enum('ACADEMIC','ADMINISTRATIVE','GENERAL','SOCIAL','RELIGIOUS','OTHER') DEFAULT NULL,
  `description` text DEFAULT NULL,
  `venue` varchar(255) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `publish` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_events`
--

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

--
-- Table structure for table `tbl_faq`
--

DROP TABLE IF EXISTS `tbl_faq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_faq` (
  `faq_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`faq_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_faq`
--

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

--
-- Table structure for table `tbl_faq_questions_and_responses`
--

DROP TABLE IF EXISTS `tbl_faq_questions_and_responses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_faq_questions_and_responses` (
  `faq_questions_and_response_id` int(11) NOT NULL AUTO_INCREMENT,
  `faq_id` int(11) NOT NULL,
  `question` text NOT NULL,
  `response` text NOT NULL,
  PRIMARY KEY (`faq_questions_and_response_id`),
  KEY `faq_id` (`faq_id`),
  CONSTRAINT `tbl_faq_questions_and_responses_ibfk_1` FOREIGN KEY (`faq_id`) REFERENCES `tbl_faq` (`faq_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_faq_questions_and_responses`
--

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

--
-- Table structure for table `tbl_gallery_and_downloads`
--

DROP TABLE IF EXISTS `tbl_gallery_and_downloads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_gallery_and_downloads` (
  `gallery_and_download_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('GALLERY','DOWNLOADS','HOMESLIDER') NOT NULL,
  `content` longblob NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_mime` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `publish` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`gallery_and_download_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_gallery_and_downloads`
--

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

--
-- Table structure for table `tbl_home`
--

DROP TABLE IF EXISTS `tbl_home`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_home` (
  `home_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `establishment` text DEFAULT NULL,
  `vision_mission_statement` text DEFAULT NULL,
  `about_department` text NOT NULL,
  `publish` int(1) NOT NULL,
  PRIMARY KEY (`home_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_home`
--

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

--
-- Table structure for table `tbl_logs`
--

DROP TABLE IF EXISTS `tbl_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_logs` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) DEFAULT NULL,
  `action` varchar(250) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `ip_address` varchar(50) NOT NULL,
  PRIMARY KEY (`log_id`),
  KEY `username` (`username`),
  CONSTRAINT `tbl_logs_ibfk_1` FOREIGN KEY (`username`) REFERENCES `tbl_users` (`username`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_logs`
--

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

--
-- Table structure for table `tbl_news`
--

DROP TABLE IF EXISTS `tbl_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_news` (
  `news_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `author` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `content` text NOT NULL,
  `image` longblob DEFAULT NULL,
  `image_preview` longblob DEFAULT NULL,
  `image_mime` varchar(255) DEFAULT NULL,
  `publish` enum('0','1') DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`news_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_news`
--

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

--
-- Table structure for table `tbl_partnerships_and_collaborations`
--

DROP TABLE IF EXISTS `tbl_partnerships_and_collaborations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_partnerships_and_collaborations` (
  `partnership_and_collaboration_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`partnership_and_collaboration_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_partnerships_and_collaborations`
--

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

--
-- Table structure for table `tbl_programmes`
--

DROP TABLE IF EXISTS `tbl_programmes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_programmes` (
  `programmes_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` enum('UNDERGRADUATE-PROGRAMME','POSTGRADUATE-PROGRAMME','SHORT-COURSE') NOT NULL,
  PRIMARY KEY (`programmes_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_programmes`
--

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

--
-- Table structure for table `tbl_publications`
--

DROP TABLE IF EXISTS `tbl_publications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_publications` (
  `publication_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` enum('PEER-REVIEWED-PAPER','PEER-REVIEWED-BOOK','PATENT') NOT NULL,
  `abstract` text DEFAULT NULL,
  `other_details` text DEFAULT NULL,
  `year` year(4) DEFAULT NULL,
  `research_id` int(11) unsigned NOT NULL,
  `publish` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`publication_id`),
  KEY `research_id` (`research_id`),
  CONSTRAINT `tbl_publications_ibfk_1` FOREIGN KEY (`research_id`) REFERENCES `tbl_research` (`research_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_publications`
--

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

--
-- Table structure for table `tbl_research`
--

DROP TABLE IF EXISTS `tbl_research`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_research` (
  `research_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `research_type` enum('RESEARCH','DEVELOPMENTAL-RESEARCH') DEFAULT NULL,
  `area` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `research_document` longblob DEFAULT NULL,
  `research_document_mime` varchar(100) DEFAULT NULL,
  `research_document_file` varchar(255) DEFAULT NULL,
  `publish` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`research_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_research`
--

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

--
-- Table structure for table `tbl_staff`
--

DROP TABLE IF EXISTS `tbl_staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_staff` (
  `staff_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` enum('Mr.','Mrs.','Miss.','Ms.','Dr.','Prof.','Rev.','Pastor','Father','Sister','Prophet') NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `middle_names` varchar(255) DEFAULT NULL,
  `surname` varchar(255) NOT NULL,
  `position` enum('HEAD OF DEPARTMENT','DEPUTY HEAD OF DEPARTMENT','SECRETARY','OFFICE ASSISTANT','PROFESSOR','ASSOCIATE PROFESSOR','SENIOR LECTURER','LECTURER','OTHER') DEFAULT 'OTHER',
  `sex` enum('F','M') NOT NULL,
  `category` enum('ACADEMIC','CTS','ADMINISTRATION') DEFAULT NULL,
  `brief_profile` text DEFAULT NULL,
  `profile_image` longblob DEFAULT NULL,
  PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_staff`
--

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

--
-- Table structure for table `tbl_staff_publications`
--

DROP TABLE IF EXISTS `tbl_staff_publications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_staff_publications` (
  `publication_id` int(11) unsigned NOT NULL,
  `staff_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`publication_id`,`staff_id`),
  KEY `staff_id` (`staff_id`),
  CONSTRAINT `tbl_staff_publications_ibfk_1` FOREIGN KEY (`publication_id`) REFERENCES `tbl_publications` (`publication_id`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_staff_publications_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `tbl_staff` (`staff_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_staff_publications`
--

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

--
-- Table structure for table `tbl_staff_research`
--

DROP TABLE IF EXISTS `tbl_staff_research`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_staff_research` (
  `research_id` int(11) unsigned NOT NULL,
  `staff_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`research_id`,`staff_id`),
  KEY `staff_id` (`staff_id`),
  CONSTRAINT `tbl_staff_research_ibfk_1` FOREIGN KEY (`research_id`) REFERENCES `tbl_research` (`research_id`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_staff_research_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `tbl_staff` (`staff_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_staff_research`
--

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

--
-- Table structure for table `tbl_students_and_alumni`
--

DROP TABLE IF EXISTS `tbl_students_and_alumni`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_students_and_alumni` (
  `students_and_alumni_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` enum('Mr.','Mrs.','Miss.','Ms.','Dr.','Prof.','Rev.','Pastor','Father','Sister','Prophet') NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `middle_names` varchar(255) DEFAULT NULL,
  `surname` varchar(255) NOT NULL,
  `sex` enum('F','M') NOT NULL,
  `type` enum('Student','Alumni') DEFAULT NULL,
  PRIMARY KEY (`students_and_alumni_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_students_and_alumni`
--

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

--
-- Table structure for table `tbl_users`
--

DROP TABLE IF EXISTS `tbl_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_users` (
  `username` varchar(100) NOT NULL,
  `staff_id` int(11) unsigned DEFAULT NULL,
  `account_status` enum('BLOCKED','ACTIVE','DELETED') NOT NULL DEFAULT 'ACTIVE',
  `time_blocked` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `password_digest` varchar(128) NOT NULL,
  PRIMARY KEY (`username`),
  KEY `staff_id` (`staff_id`),
  CONSTRAINT `tbl_users_ibfk_1` FOREIGN KEY (`staff_id`) REFERENCES `tbl_staff` (`staff_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_users`
--

LOCK TABLES `tbl_users` WRITE;
/*!40000 ALTER TABLE `tbl_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_users` 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 2020-03-11 13:36:51
