xKFX3ji2

1-- MySQL dump 10.13  Distrib 5.5.50, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost    Database: stv_hasan
4-- ------------------------------------------------------
5-- Server version	5.5.50-0ubuntu0.14.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `branding_welcomepage`
20--
21
22DROP TABLE IF EXISTS `branding_welcomepage`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `branding_welcomepage` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `name` varchar(255) NOT NULL,
28  `status` varchar(10) NOT NULL,
29  `redirect_url` varchar(255) NOT NULL,
30  `brand_id` int(11),
31  PRIMARY KEY (`id`),
32  KEY `branding_welcomepage_521b20f5` (`brand_id`),
33  CONSTRAINT `branding_welcomep_brand_id_79f64296d5c30e31_fk_branding_brand_id` FOREIGN KEY (`brand_id`) REFERENCES `branding_brand` (`id`)
34) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `branding_welcomepage`
39--
40
41LOCK TABLES `branding_welcomepage` WRITE;
42/*!40000 ALTER TABLE `branding_welcomepage` DISABLE KEYS */;
43INSERT INTO `branding_welcomepage` VALUES (1,'Default welcome page','default','/',NULL);
44/*!40000 ALTER TABLE `branding_welcomepage` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `branding_welcomepageitem`
49--
50
51DROP TABLE IF EXISTS `branding_welcomepageitem`;
52/*!40101 SET @saved_cs_client     = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `branding_welcomepageitem` (
55  `id` int(11) NOT NULL AUTO_INCREMENT,
56  `title` varchar(255) NOT NULL,
57  `content` longtext NOT NULL,
58  `position` smallint(6) NOT NULL,
59  `welcome_page_id` int(11) NOT NULL,
60  `video` varchar(100),
61  `video_title` varchar(255),
62  `video_url` varchar(200),
63  PRIMARY KEY (`id`),
64  KEY `brand_welcome_page_id_41863222bccdd44_fk_branding_welcomepage_id` (`welcome_page_id`),
65  CONSTRAINT `brand_welcome_page_id_41863222bccdd44_fk_branding_welcomepage_id` FOREIGN KEY (`welcome_page_id`) REFERENCES `branding_welcomepage` (`id`)
66) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `branding_welcomepageitem`
71--
72
73LOCK TABLES `branding_welcomepageitem` WRITE;
74/*!40000 ALTER TABLE `branding_welcomepageitem` DISABLE KEYS */;
75INSERT INTO `branding_welcomepageitem` VALUES (1,'Let\'s show you around','<p>Before you start watching, let\\\'s take a quick tour of the site.</p>\r\n<br />\r\n<p class=\"note\">\r\n  <span>Note</span>: If you prefer a language other than English, you can select it in the “Select Language” dropdown below. Otherwise, click “NEXT” to continue.\r\n</p>\r\n<div id=\"google_translate_element_tour\" class=\"text-left mv-20\"></div>\r\n',1,1,NULL,NULL,NULL),(2,'This is the Navigation Menu','Here you can navigate to different sections of the site by clicking on the menu items and their subcategories. Also, you can change the content being displayed from <b>Free Only</b> content to <b>All</b> content, which includes Premium content.',2,1,NULL,NULL,NULL),(5,'Search Bar','You can also use the <b>Search Bar</b> to search for specific shows, movies & more.',3,1,NULL,NULL,NULL),(6,'My Account, Support, & Extras','View or edit your Account Details, Settings, get help in our Support Center. Also check out all the extra member benefits you get as a {{request.branding.site_name }} member.',4,1,NULL,NULL,NULL),(7,'Your Personalized Home Page','Personalize your Home Page with TV Shows, Movie Categories and Music Genres you most enjoy. Select the <b>Personalize</b> button above the My TV Shows carousel to update your Personalized Home Page.',5,1,NULL,NULL,NULL),(8,'That\'s it!','<p>Now that you have all the basics, you are ready to begin your {{request.branding.site_name}} experience.</p> \r\n<p>If you think you missed something, <a class=\"restart-tour\" href=\"#\">restart the tour</a>.</p>',6,1,NULL,NULL,NULL);
76/*!40000 ALTER TABLE `branding_welcomepageitem` ENABLE KEYS */;
77UNLOCK TABLES;
78/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
79
80/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
81/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
82/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
84/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
85/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
86/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
87
88-- Dump completed on 2018-06-11 14:02:42