-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `appprofileapps`
--

DROP TABLE IF EXISTS `appprofileapps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `appprofileapps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appOrder` double DEFAULT NULL,
  `des` varchar(255) DEFAULT NULL,
  `labelEn` varchar(255) DEFAULT NULL,
  `labelFn` varchar(255) DEFAULT NULL,
  `androidPackage` varchar(512) DEFAULT NULL,
  `startIntent` varchar(512) DEFAULT NULL,
  `tileImage` varchar(512) DEFAULT NULL,
  `showMouseWarning` int(11) DEFAULT NULL,
  `reqPinAndroid` int(11) DEFAULT NULL,
  `notes` text,
  `appProfileId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `appprofileapps`
--

LOCK TABLES `appprofileapps` WRITE;
/*!40000 ALTER TABLE `appprofileapps` DISABLE KEYS */;
/*!40000 ALTER TABLE `appprofileapps` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `appprofiles`
--

DROP TABLE IF EXISTS `appprofiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `appprofiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `des` varchar(255) DEFAULT NULL,
  `detail` text,
  `showBuildingInfo` int(11) DEFAULT NULL,
  `showSupport` int(11) DEFAULT NULL,
  `conifgPin` int(11) DEFAULT NULL,
  `reqConfigPin` int(11) DEFAULT NULL,
  `enablePVR` int(11) DEFAULT NULL,
  `preventLeftRightInEpg` int(11) DEFAULT NULL,
  `preventTimeshift` int(11) DEFAULT NULL,
  `searchOpenInfo` int(11) DEFAULT NULL,
  `preventMenuBar` int(11) DEFAULT NULL,
  `sysInfoReqPin` int(11) DEFAULT NULL,
  `simpleColorButtons` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `appprofiles`
--

LOCK TABLES `appprofiles` WRITE;
/*!40000 ALTER TABLE `appprofiles` DISABLE KEYS */;
/*!40000 ALTER TABLE `appprofiles` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `categories`
--

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

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (6362,'Adult'),(6363,'Animals'),(6364,'Animated'),(6365,'Automotive'),(6366,'Awards'),(6367,'Biography'),(6368,'Business'),(6369,'Children'),(6370,'Christmas'),(6371,'Comedy'),(6372,'Computers & Technologies'),(6373,'Cultural Magazine'),(6374,'Current Affairs'),(6375,'Discussion'),(6376,'Docu-Series'),(6377,'Documentary'),(6378,'Drama'),(6379,'Easter'),(6380,'Environmental'),(6381,'Fashion'),(6382,'Financial'),(6383,'Food'),(6384,'Game Shows'),(6385,'Garden'),(6386,'Hallowe\'en'),(6387,'Health'),(6388,'History'),(6389,'Hobbies & Crafts'),(6390,'Home'),(6391,'Instructional'),(6392,'Legal'),(6393,'Lifestyle'),(6394,'Local'),(6395,'Movies'),(6396,'Music'),(6397,'New Age'),(6398,'News'),(6399,'News Magazine'),(6400,'Paid Program'),(6401,'Parade'),(6402,'Paranormal'),(6403,'Performing Arts'),(6404,'Political'),(6405,'Radio'),(6406,'Reality TV'),(6407,'Regular'),(6408,'Religious'),(6409,'Sci-Fi'),(6410,'Science'),(6411,'Shopping'),(6412,'Short Film'),(6413,'Sitcom'),(6414,'Soaps'),(6415,'Specials'),(6416,'Sports'),(6417,'Talk Shows'),(6418,'TBA'),(6419,'Telenovel'),(6420,'Telethon'),(6421,'Thanksgiving'),(6422,'Travel'),(6423,'True Crime');
/*!40000 ALTER TABLE `categories` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `channelscodes`
--

DROP TABLE IF EXISTS `channelscodes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `channelscodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL DEFAULT '',
  `des` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `channelscodes`
--

LOCK TABLES `channelscodes` WRITE;
/*!40000 ALTER TABLE `channelscodes` DISABLE KEYS */;
INSERT INTO `channelscodes` VALUES (1,'TV','TV'),(2,'AUDIO','AUDIO'),(3,'APP','APP');
/*!40000 ALTER TABLE `channelscodes` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `channelstatus`
--

DROP TABLE IF EXISTS `channelstatus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `channelstatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` varchar(50) DEFAULT NULL,
  `statusUrl` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `channelstatus`
--

LOCK TABLES `channelstatus` WRITE;
/*!40000 ALTER TABLE `channelstatus` DISABLE KEYS */;
INSERT INTO `channelstatus` VALUES (1,'ACTIVE','ACTIVE',NULL),(2,'FUTURE','FUTURE','https://www.uptele.com/epgapp/status/soon'),(3,'REMOVED','REMOVED','https://www.uptele.com/epgapp/status/error'),(4,'ERROR','ERROR','https://www.uptele.com/epgapp/status/error');
/*!40000 ALTER TABLE `channelstatus` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `channelstretchcodes`
--

DROP TABLE IF EXISTS `channelstretchcodes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `channelstretchcodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `channelstretchcodes`
--

LOCK TABLES `channelstretchcodes` WRITE;
/*!40000 ALTER TABLE `channelstretchcodes` DISABLE KEYS */;
INSERT INTO `channelstretchcodes` VALUES (1,'NONE','No Stretching'),(2,'VCROP100','Crop 100px top and bottom, Stretch');
/*!40000 ALTER TABLE `channelstretchcodes` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `channeltypes`
--

DROP TABLE IF EXISTS `channeltypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `channeltypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `channeltypes`
--

LOCK TABLES `channeltypes` WRITE;
/*!40000 ALTER TABLE `channeltypes` DISABLE KEYS */;
INSERT INTO `channeltypes` VALUES (1,'livetv','Live TV'),(2,'web','Web App'),(3,'radio','Radio'),(4,'liveurl','Live TV Direct URL No DVR');
/*!40000 ALTER TABLE `channeltypes` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `costmarkets`
--

DROP TABLE IF EXISTS `costmarkets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `costmarkets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `costmarkets`
--

LOCK TABLES `costmarkets` WRITE;
/*!40000 ALTER TABLE `costmarkets` DISABLE KEYS */;
INSERT INTO `costmarkets` VALUES (1,'FRANCO','FRANCO'),(2,'ANGLO','ANGLO');
/*!40000 ALTER TABLE `costmarkets` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `langs`
--

DROP TABLE IF EXISTS `langs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `langs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `langs`
--

LOCK TABLES `langs` WRITE;
/*!40000 ALTER TABLE `langs` DISABLE KEYS */;
INSERT INTO `langs` VALUES (1,'fr','fr'),(2,'en','en');
/*!40000 ALTER TABLE `langs` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `marketlangs`
--

DROP TABLE IF EXISTS `marketlangs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marketlangs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `marketlangs`
--

LOCK TABLES `marketlangs` WRITE;
/*!40000 ALTER TABLE `marketlangs` DISABLE KEYS */;
INSERT INTO `marketlangs` VALUES (1,'EN','English'),(2,'FR','French');
/*!40000 ALTER TABLE `marketlangs` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `packagetypes`
--

DROP TABLE IF EXISTS `packagetypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `packagetypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `packagetypes`
--

LOCK TABLES `packagetypes` WRITE;
/*!40000 ALTER TABLE `packagetypes` DISABLE KEYS */;
INSERT INTO `packagetypes` VALUES (1,'BULK','Bulk'),(2,'SKINNY','Skinny (CRTC Mandated Small Digital)'),(3,'BASIC','Digital Basic'),(4,'TIER','Tier (Popular Group added to Digital Basic)'),(5,'PICKPACK','Pick Pack (Pick X)'),(6,'THEME','Theme Pack (Multiple Services on Common Theme)'),(7,'STANDALONE','Standalone Service (bought individually)'),(8,'TEST','Test Package (no bill)');
/*!40000 ALTER TABLE `packagetypes` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `progbdulangs`
--

DROP TABLE IF EXISTS `progbdulangs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `progbdulangs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `des` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `progbdulangs`
--

LOCK TABLES `progbdulangs` WRITE;
/*!40000 ALTER TABLE `progbdulangs` DISABLE KEYS */;
/*!40000 ALTER TABLE `progbdulangs` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `pvrprofiles`
--

DROP TABLE IF EXISTS `pvrprofiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pvrprofiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `maxHours` int(11) DEFAULT NULL,
  `maxTimeshiftHours` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pvrprofiles`
--

LOCK TABLES `pvrprofiles` WRITE;
/*!40000 ALTER TABLE `pvrprofiles` DISABLE KEYS */;
INSERT INTO `pvrprofiles` VALUES (1,10,24);
/*!40000 ALTER TABLE `pvrprofiles` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `pvrservers`
--

DROP TABLE IF EXISTS `pvrservers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pvrservers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `des` varchar(512) DEFAULT NULL,
  `storageBasePath` varchar(512) DEFAULT NULL,
  `timeshiftServerUrl` varchar(512) DEFAULT NULL,
  `publicUrl` varchar(512) DEFAULT NULL,
  `publicDrmUrl` varchar(512) DEFAULT NULL,
  `publicUrlRel` varchar(512) NOT NULL DEFAULT '',
  `publicUrl2` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pvrservers`
--

LOCK TABLES `pvrservers` WRITE;
/*!40000 ALTER TABLE `pvrservers` DISABLE KEYS */;
INSERT INTO `pvrservers` VALUES (1,'UPTV_MAIN','/STORAGE/pvr','http://pls1.uptele.net/epgm3u8server/timeshift.php/','http://streamer2.uptele.com:8088/epgm3u8server/pvr.php/','http://172.30.1.4:8080/epgm3u8server/pvrdrm.php/','/epgm3u8server/pvr.php/','http://streamer.uptele.com/pvr/play?id=$id');
/*!40000 ALTER TABLE `pvrservers` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `status`
--

DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status`
--

LOCK TABLES `status` WRITE;
/*!40000 ALTER TABLE `status` DISABLE KEYS */;
INSERT INTO `status` VALUES (1,'','UNKNOWN'),(2,'ACTIVE','ACTIVE'),(3,'DISABLED','DISABLED'),(4,'NOT_ASSIGNED','NOT ASSIGNED');
/*!40000 ALTER TABLE `status` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `substatus`
--

DROP TABLE IF EXISTS `substatus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `substatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `des` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `substatus`
--

LOCK TABLES `substatus` WRITE;
/*!40000 ALTER TABLE `substatus` DISABLE KEYS */;
INSERT INTO `substatus` VALUES (1,'ACTIVE','Active'),(2,'NON_PAY','Non-Pay'),(3,'CANCEL','Cancelled'),(4,'HOLD','On Hold'),(5,'TEST','Test Account');
/*!40000 ALTER TABLE `substatus` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `taxrates`
--

DROP TABLE IF EXISTS `taxrates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taxrates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fromEpoch` int(11) DEFAULT NULL,
  `gstRate` double DEFAULT NULL,
  `pstRate` double DEFAULT NULL,
  `hstRate` double DEFAULT NULL,
  `whRate` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `taxrates`
--

LOCK TABLES `taxrates` WRITE;
/*!40000 ALTER TABLE `taxrates` DISABLE KEYS */;
INSERT INTO `taxrates` VALUES (1,0,0.05,0.09975,0.13,0.1);
/*!40000 ALTER TABLE `taxrates` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `timeshiftprofiles`
--

DROP TABLE IF EXISTS `timeshiftprofiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `timeshiftprofiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ingestServerId` int(11) DEFAULT NULL,
  `des` varchar(255) DEFAULT NULL,
  `keepHours` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `timeshiftprofiles`
--

LOCK TABLES `timeshiftprofiles` WRITE;
/*!40000 ALTER TABLE `timeshiftprofiles` DISABLE KEYS */;
INSERT INTO `timeshiftprofiles` VALUES (1,1,'default 24h',24),(2,1,'4hrs only',4),(3,1,'disabled',0);
/*!40000 ALTER TABLE `timeshiftprofiles` 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 2019-09-08 22:36:10
-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: xmltv
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.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 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 `timezones`
--

DROP TABLE IF EXISTS `timezones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `timezones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(100) DEFAULT NULL,
  `des` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `timezones`
--

LOCK TABLES `timezones` WRITE;
/*!40000 ALTER TABLE `timezones` DISABLE KEYS */;
INSERT INTO `timezones` VALUES (1,'Australia/Adelaide','Australia/Adelaide'),(2,'Australia/Broken_Hill','Australia/Broken_Hill'),(3,'Australia/Darwin','Australia/Darwin'),(4,'Australia/North','Australia/North'),(5,'Australia/South','Australia/South'),(6,'Australia/Yancowinna','Australia/Yancowinna'),(7,'America/Porto_Acre','America/Porto_Acre'),(8,'America/Eirunepe','America/Eirunepe'),(9,'America/Rio_Branco','America/Rio_Branco'),(10,'Brazil/Acre','Brazil/Acre'),(11,'Asia/Jayapura','Asia/Jayapura'),(12,'Australia/Eucla','Australia/Eucla'),(13,'America/Goose_Bay','America/Goose_Bay'),(14,'America/Pangnirtung','America/Pangnirtung'),(15,'America/Halifax','America/Halifax'),(16,'America/Barbados','America/Barbados'),(17,'America/Blanc-Sablon','America/Blanc-Sablon'),(18,'America/Glace_Bay','America/Glace_Bay'),(19,'America/Martinique','America/Martinique'),(20,'America/Moncton','America/Moncton'),(21,'America/Thule','America/Thule'),(22,'Atlantic/Bermuda','Atlantic/Bermuda'),(23,'Canada/Atlantic','Canada/Atlantic'),(24,'Asia/Baghdad','Asia/Baghdad'),(25,'Australia/Melbourne','Australia/Melbourne'),(26,'Antarctica/Macquarie','Antarctica/Macquarie'),(27,'Australia/ACT','Australia/ACT'),(28,'Australia/Brisbane','Australia/Brisbane'),(29,'Australia/Canberra','Australia/Canberra'),(30,'Australia/Currie','Australia/Currie'),(31,'Australia/Hobart','Australia/Hobart'),(32,'Australia/Lindeman','Australia/Lindeman'),(33,'Australia/NSW','Australia/NSW'),(34,'Australia/Queensland','Australia/Queensland'),(35,'Australia/Sydney','Australia/Sydney'),(36,'Australia/Tasmania','Australia/Tasmania'),(37,'Australia/Victoria','Australia/Victoria'),(38,'Australia/LHI','Australia/LHI'),(39,'Australia/Lord_Howe','Australia/Lord_Howe'),(40,'Asia/Kabul','Asia/Kabul'),(41,'America/Anchorage','America/Anchorage'),(42,'America/Adak','America/Adak'),(43,'America/Atka','America/Atka'),(44,'America/Juneau','America/Juneau'),(45,'America/Nome','America/Nome'),(46,'America/Sitka','America/Sitka'),(47,'America/Yakutat','America/Yakutat'),(48,'Asia/Aqtobe','Asia/Aqtobe'),(49,'Asia/Almaty','Asia/Almaty'),(50,'Asia/Yerevan','Asia/Yerevan'),(51,'America/Boa_Vista','America/Boa_Vista'),(52,'America/Campo_Grande','America/Campo_Grande'),(53,'America/Cuiaba','America/Cuiaba'),(54,'America/Manaus','America/Manaus'),(55,'America/Porto_Velho','America/Porto_Velho'),(56,'America/Santarem','America/Santarem'),(57,'Brazil/West','Brazil/West'),(58,'America/Asuncion','America/Asuncion'),(59,'Europe/Amsterdam','Europe/Amsterdam'),(60,'Europe/Athens','Europe/Athens'),(61,'Asia/Anadyr','Asia/Anadyr'),(62,'America/Curacao','America/Curacao'),(63,'America/Aruba','America/Aruba'),(64,'America/Kralendijk','America/Kralendijk'),(65,'America/Lower_Princes','America/Lower_Princes'),(66,'America/Puerto_Rico','America/Puerto_Rico'),(67,'Asia/Aqtau','Asia/Aqtau'),(68,'America/Buenos_Aires','America/Buenos_Aires'),(69,'America/Argentina/Buenos_Aires','America/Argentina/Buenos_Aires'),(70,'America/Argentina/Catamarca','America/Argentina/Catamarca'),(71,'America/Argentina/ComodRivadavia','America/Argentina/ComodRivadavia'),(72,'America/Argentina/Cordoba','America/Argentina/Cordoba'),(73,'America/Argentina/Jujuy','America/Argentina/Jujuy'),(74,'America/Argentina/La_Rioja','America/Argentina/La_Rioja'),(75,'America/Argentina/Mendoza','America/Argentina/Mendoza'),(76,'America/Argentina/Rio_Gallegos','America/Argentina/Rio_Gallegos'),(77,'America/Argentina/Salta','America/Argentina/Salta'),(78,'America/Argentina/San_Juan','America/Argentina/San_Juan'),(79,'America/Argentina/San_Luis','America/Argentina/San_Luis'),(80,'America/Argentina/Tucuman','America/Argentina/Tucuman'),(81,'America/Argentina/Ushuaia','America/Argentina/Ushuaia'),(82,'America/Catamarca','America/Catamarca'),(83,'America/Cordoba','America/Cordoba'),(84,'America/Jujuy','America/Jujuy'),(85,'America/Mendoza','America/Mendoza'),(86,'America/Rosario','America/Rosario'),(87,'Antarctica/Palmer','Antarctica/Palmer'),(88,'Asia/Ashkhabad','Asia/Ashkhabad'),(89,'Asia/Ashgabat','Asia/Ashgabat'),(90,'Asia/Riyadh','Asia/Riyadh'),(91,'America/Anguilla','America/Anguilla'),(92,'America/Antigua','America/Antigua'),(93,'America/Dominica','America/Dominica'),(94,'America/Grand_Turk','America/Grand_Turk'),(95,'America/Grenada','America/Grenada'),(96,'America/Guadeloupe','America/Guadeloupe'),(97,'America/Marigot','America/Marigot'),(98,'America/Miquelon','America/Miquelon'),(99,'America/Montserrat','America/Montserrat'),(100,'America/Port_of_Spain','America/Port_of_Spain'),(101,'America/Santo_Domingo','America/Santo_Domingo'),(102,'America/St_Barthelemy','America/St_Barthelemy'),(103,'America/St_Kitts','America/St_Kitts'),(104,'America/St_Lucia','America/St_Lucia'),(105,'America/St_Thomas','America/St_Thomas'),(106,'America/St_Vincent','America/St_Vincent'),(107,'America/Tortola','America/Tortola'),(108,'America/Virgin','America/Virgin'),(109,'Asia/Aden','Asia/Aden'),(110,'Asia/Bahrain','Asia/Bahrain'),(111,'Asia/Kuwait','Asia/Kuwait'),(112,'Asia/Qatar','Asia/Qatar'),(113,'Australia/Perth','Australia/Perth'),(114,'Australia/West','Australia/West'),(115,'Antarctica/Casey','Antarctica/Casey'),(116,'Atlantic/Azores','Atlantic/Azores'),(117,'Asia/Baku','Asia/Baku'),(118,'Europe/London','Europe/London'),(119,'Asia/Dacca','Asia/Dacca'),(120,'Asia/Dhaka','Asia/Dhaka'),(121,'Europe/Belfast','Europe/Belfast'),(122,'Europe/Gibraltar','Europe/Gibraltar'),(123,'Europe/Guernsey','Europe/Guernsey'),(124,'Europe/Isle_of_Man','Europe/Isle_of_Man'),(125,'Europe/Jersey','Europe/Jersey'),(126,'Africa/Mogadishu','Africa/Mogadishu'),(127,'Africa/Addis_Ababa','Africa/Addis_Ababa'),(128,'Africa/Asmara','Africa/Asmara'),(129,'Africa/Asmera','Africa/Asmera'),(130,'Africa/Dar_es_Salaam','Africa/Dar_es_Salaam'),(131,'Africa/Djibouti','Africa/Djibouti'),(132,'Africa/Kampala','Africa/Kampala'),(133,'Africa/Nairobi','Africa/Nairobi'),(134,'Indian/Antananarivo','Indian/Antananarivo'),(135,'Indian/Comoro','Indian/Comoro'),(136,'Indian/Mayotte','Indian/Mayotte'),(137,'Europe/Tiraspol','Europe/Tiraspol'),(138,'America/Bogota','America/Bogota'),(139,'Asia/Bangkok','Asia/Bangkok'),(140,'Asia/Phnom_Penh','Asia/Phnom_Penh'),(141,'Asia/Vientiane','Asia/Vientiane'),(142,'Asia/Jakarta','Asia/Jakarta'),(143,'Europe/Bucharest','Europe/Bucharest'),(144,'Europe/Chisinau','Europe/Chisinau'),(145,'Asia/Brunei','Asia/Brunei'),(146,'Asia/Kuching','Asia/Kuching'),(147,'America/La_Paz','America/La_Paz'),(148,'America/Sao_Paulo','America/Sao_Paulo'),(149,'America/Araguaina','America/Araguaina'),(150,'America/Bahia','America/Bahia'),(151,'America/Belem','America/Belem'),(152,'America/Fortaleza','America/Fortaleza'),(153,'America/Maceio','America/Maceio'),(154,'America/Recife','America/Recife'),(155,'Brazil/East','Brazil/East'),(156,'Pacific/Midway','Pacific/Midway'),(157,'Pacific/Pago_Pago','Pacific/Pago_Pago'),(158,'Pacific/Samoa','Pacific/Samoa'),(159,'Europe/Dublin','Europe/Dublin'),(160,'Pacific/Bougainville','Pacific/Bougainville'),(161,'Asia/Thimbu','Asia/Thimbu'),(162,'Asia/Thimphu','Asia/Thimphu'),(163,'Asia/Kolkata','Asia/Kolkata'),(164,'Asia/Calcutta','Asia/Calcutta'),(165,'Asia/Rangoon','Asia/Rangoon'),(166,'Atlantic/Canary','Atlantic/Canary'),(167,'Africa/Juba','Africa/Juba'),(168,'Africa/Khartoum','Africa/Khartoum'),(169,'Africa/Blantyre','Africa/Blantyre'),(170,'Africa/Bujumbura','Africa/Bujumbura'),(171,'Africa/Gaborone','Africa/Gaborone'),(172,'Africa/Harare','Africa/Harare'),(173,'Africa/Kigali','Africa/Kigali'),(174,'Africa/Lubumbashi','Africa/Lubumbashi'),(175,'Africa/Lusaka','Africa/Lusaka'),(176,'Africa/Maputo','Africa/Maputo'),(177,'Africa/Windhoek','Africa/Windhoek'),(178,'Indian/Cocos','Indian/Cocos'),(179,'America/Rankin_Inlet','America/Rankin_Inlet'),(180,'America/Resolute','America/Resolute'),(181,'America/Chicago','America/Chicago'),(182,'Asia/Shanghai','Asia/Shanghai'),(183,'America/Havana','America/Havana'),(184,'America/Atikokan','America/Atikokan'),(185,'America/Bahia_Banderas','America/Bahia_Banderas'),(186,'America/Belize','America/Belize'),(187,'America/Cambridge_Bay','America/Cambridge_Bay'),(188,'America/Cancun','America/Cancun'),(189,'America/Chihuahua','America/Chihuahua'),(190,'America/Coral_Harbour','America/Coral_Harbour'),(191,'America/Costa_Rica','America/Costa_Rica'),(192,'America/El_Salvador','America/El_Salvador'),(193,'America/Fort_Wayne','America/Fort_Wayne'),(194,'America/Guatemala','America/Guatemala'),(195,'America/Indiana/Indianapolis','America/Indiana/Indianapolis'),(196,'America/Indiana/Knox','America/Indiana/Knox'),(197,'America/Indiana/Marengo','America/Indiana/Marengo'),(198,'America/Indiana/Petersburg','America/Indiana/Petersburg'),(199,'America/Indiana/Tell_City','America/Indiana/Tell_City'),(200,'America/Indiana/Vevay','America/Indiana/Vevay'),(201,'America/Indiana/Vincennes','America/Indiana/Vincennes'),(202,'America/Indiana/Winamac','America/Indiana/Winamac'),(203,'America/Indianapolis','America/Indianapolis'),(204,'America/Iqaluit','America/Iqaluit'),(205,'America/Kentucky/Louisville','America/Kentucky/Louisville'),(206,'America/Kentucky/Monticello','America/Kentucky/Monticello'),(207,'America/Knox_IN','America/Knox_IN'),(208,'America/Louisville','America/Louisville'),(209,'America/Managua','America/Managua'),(210,'America/Matamoros','America/Matamoros'),(211,'America/Menominee','America/Menominee'),(212,'America/Merida','America/Merida'),(213,'America/Mexico_City','America/Mexico_City'),(214,'America/Monterrey','America/Monterrey'),(215,'America/North_Dakota/Beulah','America/North_Dakota/Beulah'),(216,'America/North_Dakota/Center','America/North_Dakota/Center'),(217,'America/North_Dakota/New_Salem','America/North_Dakota/New_Salem'),(218,'America/Ojinaga','America/Ojinaga'),(219,'America/Rainy_River','America/Rainy_River'),(220,'America/Tegucigalpa','America/Tegucigalpa'),(221,'America/Winnipeg','America/Winnipeg'),(222,'Canada/Central','Canada/Central'),(223,'Mexico/General','Mexico/General'),(224,'Asia/Chongqing','Asia/Chongqing'),(225,'Asia/Chungking','Asia/Chungking'),(226,'Asia/Harbin','Asia/Harbin'),(227,'Asia/Taipei','Asia/Taipei'),(228,'PRC','PRC'),(229,'ROC','ROC'),(230,'Europe/Berlin','Europe/Berlin'),(231,'Europe/Kaliningrad','Europe/Kaliningrad'),(232,'Africa/Algiers','Africa/Algiers'),(233,'Africa/Ceuta','Africa/Ceuta'),(234,'Africa/Tripoli','Africa/Tripoli'),(235,'Africa/Tunis','Africa/Tunis'),(236,'Antarctica/Troll','Antarctica/Troll'),(237,'Arctic/Longyearbyen','Arctic/Longyearbyen'),(238,'Atlantic/Jan_Mayen','Atlantic/Jan_Mayen'),(239,'Europe/Andorra','Europe/Andorra'),(240,'Europe/Belgrade','Europe/Belgrade'),(241,'Europe/Bratislava','Europe/Bratislava'),(242,'Europe/Brussels','Europe/Brussels'),(243,'Europe/Budapest','Europe/Budapest'),(244,'Europe/Busingen','Europe/Busingen'),(245,'Europe/Copenhagen','Europe/Copenhagen'),(246,'Europe/Kiev','Europe/Kiev'),(247,'Europe/Lisbon','Europe/Lisbon'),(248,'Europe/Ljubljana','Europe/Ljubljana'),(249,'Europe/Luxembourg','Europe/Luxembourg'),(250,'Europe/Madrid','Europe/Madrid'),(251,'Europe/Malta','Europe/Malta'),(252,'Europe/Minsk','Europe/Minsk'),(253,'Europe/Monaco','Europe/Monaco'),(254,'Europe/Oslo','Europe/Oslo'),(255,'Europe/Paris','Europe/Paris'),(256,'Europe/Podgorica','Europe/Podgorica'),(257,'Europe/Prague','Europe/Prague'),(258,'Europe/Riga','Europe/Riga'),(259,'Europe/Rome','Europe/Rome'),(260,'Europe/San_Marino','Europe/San_Marino'),(261,'Europe/Sarajevo','Europe/Sarajevo'),(262,'Europe/Simferopol','Europe/Simferopol'),(263,'Europe/Skopje','Europe/Skopje'),(264,'Europe/Sofia','Europe/Sofia'),(265,'Europe/Stockholm','Europe/Stockholm'),(266,'Europe/Tallinn','Europe/Tallinn'),(267,'Europe/Tirane','Europe/Tirane'),(268,'Europe/Uzhgorod','Europe/Uzhgorod'),(269,'Europe/Vaduz','Europe/Vaduz'),(270,'Europe/Vatican','Europe/Vatican'),(271,'Europe/Vienna','Europe/Vienna'),(272,'Europe/Vilnius','Europe/Vilnius'),(273,'Europe/Warsaw','Europe/Warsaw'),(274,'Europe/Zagreb','Europe/Zagreb'),(275,'Europe/Zaporozhye','Europe/Zaporozhye'),(276,'Europe/Zurich','Europe/Zurich'),(277,'Africa/Casablanca','Africa/Casablanca'),(278,'America/Scoresbysund','America/Scoresbysund'),(279,'Pacific/Chatham','Pacific/Chatham'),(280,'Asia/Choibalsan','Asia/Choibalsan'),(281,'Pacific/Chuuk','Pacific/Chuuk'),(282,'Pacific/Truk','Pacific/Truk'),(283,'Pacific/Yap','Pacific/Yap'),(284,'Pacific/Rarotonga','Pacific/Rarotonga'),(285,'America/Santiago','America/Santiago'),(286,'Chile/Continental','Chile/Continental'),(287,'America/Caracas','America/Caracas'),(288,'America/Cayman','America/Cayman'),(289,'America/Panama','America/Panama'),(290,'America/Detroit','America/Detroit'),(291,'America/Hermosillo','America/Hermosillo'),(292,'America/Mazatlan','America/Mazatlan'),(293,'America/Regina','America/Regina'),(294,'America/Swift_Current','America/Swift_Current'),(295,'America/Thunder_Bay','America/Thunder_Bay'),(296,'Canada/East-Saskatchewan','Canada/East-Saskatchewan'),(297,'Canada/Saskatchewan','Canada/Saskatchewan'),(298,'Mexico/BajaSur','Mexico/BajaSur'),(299,'Asia/Macao','Asia/Macao'),(300,'Asia/Macau','Asia/Macau'),(301,'Atlantic/Cape_Verde','Atlantic/Cape_Verde'),(302,'Indian/Christmas','Indian/Christmas'),(303,'Pacific/Guam','Pacific/Guam'),(304,'Pacific/Saipan','Pacific/Saipan'),(305,'Antarctica/Davis','Antarctica/Davis'),(306,'Antarctica/DumontDUrville','Antarctica/DumontDUrville'),(307,'Asia/Dushanbe','Asia/Dushanbe'),(308,'Chile/EasterIsland','Chile/EasterIsland'),(309,'Pacific/Easter','Pacific/Easter'),(310,'America/Guayaquil','America/Guayaquil'),(311,'Pacific/Galapagos','Pacific/Galapagos'),(312,'America/New_York','America/New_York'),(313,'America/Jamaica','America/Jamaica'),(314,'America/Montreal','America/Montreal'),(315,'America/Nassau','America/Nassau'),(316,'America/Nipigon','America/Nipigon'),(317,'America/Port-au-Prince','America/Port-au-Prince'),(318,'America/Toronto','America/Toronto'),(319,'Canada/Eastern','Canada/Eastern'),(320,'Europe/Helsinki','Europe/Helsinki'),(321,'Africa/Cairo','Africa/Cairo'),(322,'Asia/Amman','Asia/Amman'),(323,'Asia/Beirut','Asia/Beirut'),(324,'Asia/Damascus','Asia/Damascus'),(325,'Asia/Gaza','Asia/Gaza'),(326,'Asia/Hebron','Asia/Hebron'),(327,'Asia/Istanbul','Asia/Istanbul'),(328,'Asia/Nicosia','Asia/Nicosia'),(329,'Europe/Istanbul','Europe/Istanbul'),(330,'Europe/Mariehamn','Europe/Mariehamn'),(331,'Europe/Moscow','Europe/Moscow'),(332,'Europe/Nicosia','Europe/Nicosia'),(333,'Europe/Samara','Europe/Samara'),(334,'Pacific/Fiji','Pacific/Fiji'),(335,'Atlantic/Stanley','Atlantic/Stanley'),(336,'Atlantic/Madeira','Atlantic/Madeira'),(337,'America/Noronha','America/Noronha'),(338,'Brazil/DeNoronha','Brazil/DeNoronha'),(339,'Asia/Bishkek','Asia/Bishkek'),(340,'Pacific/Gambier','Pacific/Gambier'),(341,'America/Guyana','America/Guyana'),(342,'Asia/Tbilisi','Asia/Tbilisi'),(343,'America/Cayenne','America/Cayenne'),(344,'Africa/Accra','Africa/Accra'),(345,'Pacific/Tarawa','Pacific/Tarawa'),(346,'Africa/Abidjan','Africa/Abidjan'),(347,'Africa/Bamako','Africa/Bamako'),(348,'Africa/Banjul','Africa/Banjul'),(349,'Africa/Bissau','Africa/Bissau'),(350,'Africa/Conakry','Africa/Conakry'),(351,'Africa/Dakar','Africa/Dakar'),(352,'Africa/Freetown','Africa/Freetown'),(353,'Africa/Lome','Africa/Lome'),(354,'Africa/Monrovia','Africa/Monrovia'),(355,'Africa/Nouakchott','Africa/Nouakchott'),(356,'Africa/Ouagadougou','Africa/Ouagadougou'),(357,'Africa/Sao_Tome','Africa/Sao_Tome'),(358,'Africa/Timbuktu','Africa/Timbuktu'),(359,'America/Danmarkshavn','America/Danmarkshavn'),(360,'Atlantic/Reykjavik','Atlantic/Reykjavik'),(361,'Atlantic/St_Helena','Atlantic/St_Helena'),(362,'Etc/GMT','Etc/GMT'),(363,'Etc/Greenwich','Etc/Greenwich'),(364,'Asia/Dubai','Asia/Dubai'),(365,'Atlantic/South_Georgia','Atlantic/South_Georgia'),(366,'Asia/Muscat','Asia/Muscat'),(367,'Pacific/Honolulu','Pacific/Honolulu'),(368,'Pacific/Johnston','Pacific/Johnston'),(369,'Asia/Hong_Kong','Asia/Hong_Kong'),(370,'Asia/Hovd','Asia/Hovd'),(371,'Asia/Ho_Chi_Minh','Asia/Ho_Chi_Minh'),(372,'Asia/Saigon','Asia/Saigon'),(373,'Asia/Jerusalem','Asia/Jerusalem'),(374,'Asia/Tel_Aviv','Asia/Tel_Aviv'),(375,'Asia/Colombo','Asia/Colombo'),(376,'Asia/Irkutsk','Asia/Irkutsk'),(377,'Indian/Chagos','Indian/Chagos'),(378,'Asia/Tehran','Asia/Tehran'),(379,'Asia/Chita','Asia/Chita'),(380,'Asia/Karachi','Asia/Karachi'),(381,'Asia/Kathmandu','Asia/Kathmandu'),(382,'Asia/Katmandu','Asia/Katmandu'),(383,'Asia/Pyongyang','Asia/Pyongyang'),(384,'Asia/Sakhalin','Asia/Sakhalin'),(385,'Asia/Seoul','Asia/Seoul'),(386,'Asia/Tokyo','Asia/Tokyo'),(387,'ROK','ROK'),(388,'Asia/Dili','Asia/Dili'),(389,'Asia/Kuala_Lumpur','Asia/Kuala_Lumpur'),(390,'Asia/Makassar','Asia/Makassar'),(391,'Asia/Manila','Asia/Manila'),(392,'Asia/Pontianak','Asia/Pontianak'),(393,'Asia/Singapore','Asia/Singapore'),(394,'Asia/Ujung_Pandang','Asia/Ujung_Pandang'),(395,'Pacific/Nauru','Pacific/Nauru'),(396,'Asia/Qyzylorda','Asia/Qyzylorda'),(397,'Pacific/Kosrae','Pacific/Kosrae'),(398,'Asia/Krasnoyarsk','Asia/Krasnoyarsk'),(399,'Asia/Novokuznetsk','Asia/Novokuznetsk'),(400,'Pacific/Kwajalein','Pacific/Kwajalein'),(401,'Pacific/Kiritimati','Pacific/Kiritimati'),(402,'Asia/Magadan','Asia/Magadan'),(403,'Asia/Srednekolymsk','Asia/Srednekolymsk'),(404,'Asia/Ust-Nera','Asia/Ust-Nera'),(405,'Pacific/Marquesas','Pacific/Marquesas'),(406,'Antarctica/Mawson','Antarctica/Mawson'),(407,'America/Yellowknife','America/Yellowknife'),(408,'America/Denver','America/Denver'),(409,'America/Boise','America/Boise'),(410,'America/Edmonton','America/Edmonton'),(411,'America/Inuvik','America/Inuvik'),(412,'America/Phoenix','America/Phoenix'),(413,'America/Shiprock','America/Shiprock'),(414,'Canada/Mountain','Canada/Mountain'),(415,'Pacific/Majuro','Pacific/Majuro'),(416,'America/Montevideo','America/Montevideo'),(417,'Indian/Maldives','Indian/Maldives'),(418,'Europe/Volgograd','Europe/Volgograd'),(419,'America/Creston','America/Creston'),(420,'America/Dawson_Creek','America/Dawson_Creek'),(421,'America/Ensenada','America/Ensenada'),(422,'America/Santa_Isabel','America/Santa_Isabel'),(423,'America/Tijuana','America/Tijuana'),(424,'Mexico/BajaNorte','Mexico/BajaNorte'),(425,'Indian/Mauritius','Indian/Mauritius'),(426,'Pacific/Noumea','Pacific/Noumea'),(427,'America/St_Johns','America/St_Johns'),(428,'Canada/Newfoundland','Canada/Newfoundland'),(429,'America/Paramaribo','America/Paramaribo'),(430,'Pacific/Norfolk','Pacific/Norfolk'),(431,'Asia/Novosibirsk','Asia/Novosibirsk'),(432,'Pacific/Niue','Pacific/Niue'),(433,'Pacific/Auckland','Pacific/Auckland'),(434,'Antarctica/McMurdo','Antarctica/McMurdo'),(435,'Antarctica/South_Pole','Antarctica/South_Pole'),(436,'Asia/Omsk','Asia/Omsk'),(437,'Asia/Oral','Asia/Oral'),(438,'America/Los_Angeles','America/Los_Angeles'),(439,'America/Dawson','America/Dawson'),(440,'America/Metlakatla','America/Metlakatla'),(441,'America/Vancouver','America/Vancouver'),(442,'America/Whitehorse','America/Whitehorse'),(443,'Canada/Pacific','Canada/Pacific'),(444,'Canada/Yukon','Canada/Yukon'),(445,'America/Lima','America/Lima'),(446,'Asia/Kamchatka','Asia/Kamchatka'),(447,'Pacific/Port_Moresby','Pacific/Port_Moresby'),(448,'Pacific/Enderbury','Pacific/Enderbury'),(449,'Asia/Yekaterinburg','Asia/Yekaterinburg'),(450,'Pacific/Pitcairn','Pacific/Pitcairn'),(451,'Pacific/Pohnpei','Pacific/Pohnpei'),(452,'Pacific/Ponape','Pacific/Ponape'),(453,'Pacific/Palau','Pacific/Palau'),(454,'Indian/Reunion','Indian/Reunion'),(455,'Antarctica/Rothera','Antarctica/Rothera'),(456,'Asia/Samarkand','Asia/Samarkand'),(457,'Africa/Johannesburg','Africa/Johannesburg'),(458,'Africa/Maseru','Africa/Maseru'),(459,'Africa/Mbabane','Africa/Mbabane'),(460,'Pacific/Guadalcanal','Pacific/Guadalcanal'),(461,'Indian/Mahe','Indian/Mahe'),(462,'Pacific/Apia','Pacific/Apia'),(463,'Antarctica/Syowa','Antarctica/Syowa'),(464,'Pacific/Tahiti','Pacific/Tahiti'),(465,'Asia/Tashkent','Asia/Tashkent'),(466,'Indian/Kerguelen','Indian/Kerguelen'),(467,'Pacific/Fakaofo','Pacific/Fakaofo'),(468,'Pacific/Tongatapu','Pacific/Tongatapu'),(469,'Pacific/Funafuti','Pacific/Funafuti'),(470,'Etc/UCT','Etc/UCT'),(471,'Asia/Ulaanbaatar','Asia/Ulaanbaatar'),(472,'Asia/Ulan_Bator','Asia/Ulan_Bator'),(473,'Etc/Universal','Etc/Universal'),(474,'Etc/UTC','Etc/UTC'),(475,'Etc/Zulu','Etc/Zulu'),(476,'UTC','UTC'),(477,'Asia/Vladivostok','Asia/Vladivostok'),(478,'Asia/Khandyga','Asia/Khandyga'),(479,'Antarctica/Vostok','Antarctica/Vostok'),(480,'Pacific/Efate','Pacific/Efate'),(481,'Pacific/Wake','Pacific/Wake'),(482,'Africa/Ndjamena','Africa/Ndjamena'),(483,'Africa/Brazzaville','Africa/Brazzaville'),(484,'Africa/El_Aaiun','Africa/El_Aaiun'),(485,'Africa/Bangui','Africa/Bangui'),(486,'Africa/Douala','Africa/Douala'),(487,'Africa/Kinshasa','Africa/Kinshasa'),(488,'Africa/Lagos','Africa/Lagos'),(489,'Africa/Libreville','Africa/Libreville'),(490,'Africa/Luanda','Africa/Luanda'),(491,'Africa/Malabo','Africa/Malabo'),(492,'Africa/Niamey','Africa/Niamey'),(493,'Africa/Porto-Novo','Africa/Porto-Novo'),(494,'Atlantic/Faeroe','Atlantic/Faeroe'),(495,'Atlantic/Faroe','Atlantic/Faroe'),(496,'Pacific/Wallis','Pacific/Wallis'),(497,'America/Godthab','America/Godthab'),(498,'Asia/Kashgar','Asia/Kashgar'),(499,'Asia/Urumqi','Asia/Urumqi'),(500,'Asia/Yakutsk','Asia/Yakutsk');
/*!40000 ALTER TABLE `timezones` 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 2019-09-08 22:36:10
