AbhPNHUv

1-- phpMyAdmin SQL Dump
2-- version 5.1.0
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Oct 23, 2023 at 02:14 PM
7-- Server version: 10.4.18-MariaDB
8-- PHP Version: 8.0.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11START TRANSACTION;
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8mb4 */;
19
20--
21-- Database: `ovoo_340`
22--
23
24-- --------------------------------------------------------
25
26--
27-- Table structure for table `ads`
28--
29
30CREATE TABLE `ads` (
31  `ads_id` int(11) NOT NULL,
32  `ads_name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
33  `unique_name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
34  `ads_size` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
35  `ads_type` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
36  `ads_url` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
37  `ads_image_url` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
38  `ads_code` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
39  `enable` int(1) DEFAULT 0
40) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
41
42--
43-- Dumping data for table `ads`
44--
45
46INSERT INTO `ads` (`ads_id`, `ads_name`, `unique_name`, `ads_size`, `ads_type`, `ads_url`, `ads_image_url`, `ads_code`, `enable`) VALUES
47(1, 'Home Page Header', 'home_header', '728x90', 'code', '#', '', '', 0),
48(2, 'Movie Page Header', 'movie_header', '728x90', 'code', '#', '', '', 0),
49(3, 'Genre Page Header', 'genre_header', '728x90', 'code', '#', '', '', 0),
50(4, 'Country Page Header', 'country_header', '728x90', 'code', '#', '', '', 0),
51(5, 'Release Page Header', 'release_header', '728x90', 'code', '#', '', '', 0),
52(6, 'TV-series Page Header', 'tv_header', '728x90', 'code', '#', '', '', 0),
53(7, 'Type Page Header', 'type_header', '728x90', 'code', '#', '', '', 0),
54(8, 'Blog Page Header', 'blog_header', '728x90', 'code', '#', '', '', 0),
55(9, 'Sidebar', 'sidebar', '300x600', 'code', '#', '', '', 0),
56(12, 'Player Bottom', 'player_bottom', '728x90', 'code', '#', '', '', 0),
57(10, 'Player Top', 'player_top', '728x90', 'code', '#', '', '', 0),
58(11, 'Billboard(For movie,Landing page & watch page)', 'billboard', '970x250', 'code', '#', '', '', 0);
59
60-- --------------------------------------------------------
61
62--
63-- Table structure for table `calendar`
64--
65
66CREATE TABLE `calendar` (
67  `country_code` char(2) COLLATE utf8mb4_unicode_520_ci NOT NULL,
68  `coordinates` char(15) COLLATE utf8mb4_unicode_520_ci NOT NULL,
69  `timezone` char(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
70  `comments` varchar(85) COLLATE utf8mb4_unicode_520_ci NOT NULL,
71  `utc_offset` char(8) COLLATE utf8mb4_unicode_520_ci NOT NULL,
72  `utc_dst_offset` char(8) COLLATE utf8mb4_unicode_520_ci NOT NULL,
73  `notes` varchar(79) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
74) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
75
76--
77-- Dumping data for table `calendar`
78--
79
80INSERT INTO `calendar` (`country_code`, `coordinates`, `timezone`, `comments`, `utc_offset`, `utc_dst_offset`, `notes`) VALUES
81('CI', '+0519-00402', 'Africa/Abidjan', '', '+00:00', '+00:00', ''),
82('GH', '+0533-00013', 'Africa/Accra', '', '+00:00', '+00:00', ''),
83('ET', '+0902+03842', 'Africa/Addis_Ababa', '', '+03:00', '+03:00', ''),
84('DZ', '+3647+00303', 'Africa/Algiers', '', '+01:00', '+01:00', ''),
85('ER', '+1520+03853', 'Africa/Asmara', '', '+03:00', '+03:00', ''),
86('', '', 'Africa/Asmera', '', '+03:00', '+03:00', 'Link to Africa/Asmara'),
87('ML', '+1239-00800', 'Africa/Bamako', '', '+00:00', '+00:00', ''),
88('CF', '+0422+01835', 'Africa/Bangui', '', '+01:00', '+01:00', ''),
89('GM', '+1328-01639', 'Africa/Banjul', '', '+00:00', '+00:00', ''),
90('GW', '+1151-01535', 'Africa/Bissau', '', '+00:00', '+00:00', ''),
91('MW', '-1547+03500', 'Africa/Blantyre', '', '+02:00', '+02:00', ''),
92('CG', '-0416+01517', 'Africa/Brazzaville', '', '+01:00', '+01:00', ''),
93('BI', '-0323+02922', 'Africa/Bujumbura', '', '+02:00', '+02:00', ''),
94('EG', '+3003+03115', 'Africa/Cairo', '', '+02:00', '+02:00', 'DST has been canceled since 2011'),
95('MA', '+3339-00735', 'Africa/Casablanca', '', '+00:00', '+01:00', ''),
96('ES', '+3553-00519', 'Africa/Ceuta', 'Ceuta & Melilla', '+01:00', '+02:00', ''),
97('GN', '+0931-01343', 'Africa/Conakry', '', '+00:00', '+00:00', ''),
98('SN', '+1440-01726', 'Africa/Dakar', '', '+00:00', '+00:00', ''),
99('TZ', '-0648+03917', 'Africa/Dar_es_Salaam', '', '+03:00', '+03:00', ''),
100('DJ', '+1136+04309', 'Africa/Djibouti', '', '+03:00', '+03:00', ''),
101('CM', '+0403+00942', 'Africa/Douala', '', '+01:00', '+01:00', ''),
102('EH', '+2709-01312', 'Africa/El_Aaiun', '', '+00:00', '+00:00', ''),
103('SL', '+0830-01315', 'Africa/Freetown', '', '+00:00', '+00:00', ''),
104('BW', '-2439+02555', 'Africa/Gaborone', '', '+02:00', '+02:00', ''),
105('ZW', '-1750+03103', 'Africa/Harare', '', '+02:00', '+02:00', ''),
106('ZA', '-2615+02800', 'Africa/Johannesburg', '', '+02:00', '+02:00', ''),
107('SS', '+0451+03136', 'Africa/Juba', '', '+03:00', '+03:00', ''),
108('UG', '+0019+03225', 'Africa/Kampala', '', '+03:00', '+03:00', ''),
109('SD', '+1536+03232', 'Africa/Khartoum', '', '+03:00', '+03:00', ''),
110('RW', '-0157+03004', 'Africa/Kigali', '', '+02:00', '+02:00', ''),
111('CD', '-0418+01518', 'Africa/Kinshasa', 'west Dem. Rep. of Congo', '+01:00', '+01:00', ''),
112('NG', '+0627+00324', 'Africa/Lagos', '', '+01:00', '+01:00', ''),
113('GA', '+0023+00927', 'Africa/Libreville', '', '+01:00', '+01:00', ''),
114('TG', '+0608+00113', 'Africa/Lome', '', '+00:00', '+00:00', ''),
115('AO', '-0848+01314', 'Africa/Luanda', '', '+01:00', '+01:00', ''),
116('CD', '-1140+02728', 'Africa/Lubumbashi', 'east Dem. Rep. of Congo', '+02:00', '+02:00', ''),
117('ZM', '-1525+02817', 'Africa/Lusaka', '', '+02:00', '+02:00', ''),
118('GQ', '+0345+00847', 'Africa/Malabo', '', '+01:00', '+01:00', ''),
119('MZ', '-2558+03235', 'Africa/Maputo', '', '+02:00', '+02:00', ''),
120('LS', '-2928+02730', 'Africa/Maseru', '', '+02:00', '+02:00', ''),
121('SZ', '-2618+03106', 'Africa/Mbabane', '', '+02:00', '+02:00', ''),
122('SO', '+0204+04522', 'Africa/Mogadishu', '', '+03:00', '+03:00', ''),
123('LR', '+0618-01047', 'Africa/Monrovia', '', '+00:00', '+00:00', ''),
124('KE', '-0117+03649', 'Africa/Nairobi', '', '+03:00', '+03:00', ''),
125('TD', '+1207+01503', 'Africa/Ndjamena', '', '+01:00', '+01:00', ''),
126('NE', '+1331+00207', 'Africa/Niamey', '', '+01:00', '+01:00', ''),
127('MR', '+1806-01557', 'Africa/Nouakchott', '', '+00:00', '+00:00', ''),
128('BF', '+1222-00131', 'Africa/Ouagadougou', '', '+00:00', '+00:00', ''),
129('BJ', '+0629+00237', 'Africa/Porto-Novo', '', '+01:00', '+01:00', ''),
130('ST', '+0020+00644', 'Africa/Sao_Tome', '', '+00:00', '+00:00', ''),
131('', '', 'Africa/Timbuktu', '', '+00:00', '+00:00', 'Link to Africa/Bamako'),
132('LY', '+3254+01311', 'Africa/Tripoli', '', '+01:00', '+02:00', ''),
133('TN', '+3648+01011', 'Africa/Tunis', '', '+01:00', '+01:00', ''),
134('NA', '-2234+01706', 'Africa/Windhoek', '', '+01:00', '+02:00', ''),
135('', '', 'AKST9AKDT', '', '−09:00', '−08:00', 'Link to America/Anchorage'),
136('US', '+515248-1763929', 'America/Adak', 'Aleutian Islands', '−10:00', '−09:00', ''),
137('US', '+611305-1495401', 'America/Anchorage', 'Alaska Time', '−09:00', '−08:00', ''),
138('AI', '+1812-06304', 'America/Anguilla', '', '−04:00', '−04:00', ''),
139('AG', '+1703-06148', 'America/Antigua', '', '−04:00', '−04:00', ''),
140('BR', '-0712-04812', 'America/Araguaina', 'Tocantins', '−03:00', '−03:00', ''),
141('AR', '-3436-05827', 'America/Argentina/Buenos_Aires', 'Buenos Aires (BA, CF)', '−03:00', '−03:00', ''),
142('AR', '-2828-06547', 'America/Argentina/Catamarca', 'Catamarca (CT), Chubut (CH)', '−03:00', '−03:00', ''),
143('', '', 'America/Argentina/ComodRivadavia', '', '−03:00', '−03:00', 'Link to America/Argentina/Catamarca'),
144('AR', '-3124-06411', 'America/Argentina/Cordoba', 'most locations (CB, CC, CN, ER, FM, MN, SE, SF)', '−03:00', '−03:00', ''),
145('AR', '-2411-06518', 'America/Argentina/Jujuy', 'Jujuy (JY)', '−03:00', '−03:00', ''),
146('AR', '-2926-06651', 'America/Argentina/La_Rioja', 'La Rioja (LR)', '−03:00', '−03:00', ''),
147('AR', '-3253-06849', 'America/Argentina/Mendoza', 'Mendoza (MZ)', '−03:00', '−03:00', ''),
148('AR', '-5138-06913', 'America/Argentina/Rio_Gallegos', 'Santa Cruz (SC)', '−03:00', '−03:00', ''),
149('AR', '-2447-06525', 'America/Argentina/Salta', '(SA, LP, NQ, RN)', '−03:00', '−03:00', ''),
150('AR', '-3132-06831', 'America/Argentina/San_Juan', 'San Juan (SJ)', '−03:00', '−03:00', ''),
151('AR', '-3319-06621', 'America/Argentina/San_Luis', 'San Luis (SL)', '−03:00', '−03:00', ''),
152('AR', '-2649-06513', 'America/Argentina/Tucuman', 'Tucuman (TM)', '−03:00', '−03:00', ''),
153('AR', '-5448-06818', 'America/Argentina/Ushuaia', 'Tierra del Fuego (TF)', '−03:00', '−03:00', ''),
154('AW', '+1230-06958', 'America/Aruba', '', '−04:00', '−04:00', ''),
155('PY', '-2516-05740', 'America/Asuncion', '', '−04:00', '−03:00', ''),
156('CA', '+484531-0913718', 'America/Atikokan', 'Eastern Standard Time - Atikokan, Ontario and Southampton I, Nunavut', '−05:00', '−05:00', ''),
157('', '', 'America/Atka', '', '−10:00', '−09:00', 'Link to America/Adak'),
158('BR', '-1259-03831', 'America/Bahia', 'Bahia', '−03:00', '−03:00', ''),
159('MX', '+2048-10515', 'America/Bahia_Banderas', 'Mexican Central Time - Bahia de Banderas', '−06:00', '−05:00', ''),
160('BB', '+1306-05937', 'America/Barbados', '', '−04:00', '−04:00', ''),
161('BR', '-0127-04829', 'America/Belem', 'Amapa, E Para', '−03:00', '−03:00', ''),
162('BZ', '+1730-08812', 'America/Belize', '', '−06:00', '−06:00', ''),
163('CA', '+5125-05707', 'America/Blanc-Sablon', 'Atlantic Standard Time - Quebec - Lower North Shore', '−04:00', '−04:00', ''),
164('BR', '+0249-06040', 'America/Boa_Vista', 'Roraima', '−04:00', '−04:00', ''),
165('CO', '+0436-07405', 'America/Bogota', '', '−05:00', '−05:00', ''),
166('US', '+433649-1161209', 'America/Boise', 'Mountain Time - south Idaho & east Oregon', '−07:00', '−06:00', ''),
167('', '', 'America/Buenos_Aires', '', '−03:00', '−03:00', 'Link to America/Argentina/Buenos_Aires'),
168('CA', '+690650-1050310', 'America/Cambridge_Bay', 'Mountain Time - west Nunavut', '−07:00', '−06:00', ''),
169('BR', '-2027-05437', 'America/Campo_Grande', 'Mato Grosso do Sul', '−04:00', '−03:00', ''),
170('MX', '+2105-08646', 'America/Cancun', 'Central Time - Quintana Roo', '−06:00', '−05:00', ''),
171('VE', '+1030-06656', 'America/Caracas', '', '−04:30', '−04:30', ''),
172('', '', 'America/Catamarca', '', '−03:00', '−03:00', 'Link to America/Argentina/Catamarca'),
173('GF', '+0456-05220', 'America/Cayenne', '', '−03:00', '−03:00', ''),
174('KY', '+1918-08123', 'America/Cayman', '', '−05:00', '−05:00', ''),
175('US', '+415100-0873900', 'America/Chicago', 'Central Time', '−06:00', '−05:00', ''),
176('MX', '+2838-10605', 'America/Chihuahua', 'Mexican Mountain Time - Chihuahua away from US border', '−07:00', '−06:00', ''),
177('', '', 'America/Coral_Harbour', '', '−05:00', '−05:00', 'Link to America/Atikokan'),
178('', '', 'America/Cordoba', '', '−03:00', '−03:00', 'Link to America/Argentina/Cordoba'),
179('CR', '+0956-08405', 'America/Costa_Rica', '', '−06:00', '−06:00', ''),
180('CA', '+4906-11631', 'America/Creston', 'Mountain Standard Time - Creston, British Columbia', '−07:00', '−07:00', ''),
181('BR', '-1535-05605', 'America/Cuiaba', 'Mato Grosso', '−04:00', '−03:00', ''),
182('CW', '+1211-06900', 'America/Curacao', '', '−04:00', '−04:00', ''),
183('GL', '+7646-01840', 'America/Danmarkshavn', 'east coast, north of Scoresbysund', '+00:00', '+00:00', ''),
184('CA', '+6404-13925', 'America/Dawson', 'Pacific Time - north Yukon', '−08:00', '−07:00', ''),
185('CA', '+5946-12014', 'America/Dawson_Creek', 'Mountain Standard Time - Dawson Creek & Fort Saint John, British Columbia', '−07:00', '−07:00', ''),
186('US', '+394421-1045903', 'America/Denver', 'Mountain Time', '−07:00', '−06:00', ''),
187('US', '+421953-0830245', 'America/Detroit', 'Eastern Time - Michigan - most locations', '−05:00', '−04:00', ''),
188('DM', '+1518-06124', 'America/Dominica', '', '−04:00', '−04:00', ''),
189('CA', '+5333-11328', 'America/Edmonton', 'Mountain Time - Alberta, east British Columbia & west Saskatchewan', '−07:00', '−06:00', ''),
190('BR', '-0640-06952', 'America/Eirunepe', 'W Amazonas', '−04:00', '−04:00', ''),
191('SV', '+1342-08912', 'America/El_Salvador', '', '−06:00', '−06:00', ''),
192('', '', 'America/Ensenada', '', '−08:00', '−07:00', 'Link to America/Tijuana'),
193('', '', 'America/Fort_Wayne', '', '−05:00', '−04:00', 'Link to America/Indiana/Indianapolis'),
194('BR', '-0343-03830', 'America/Fortaleza', 'NE Brazil (MA, PI, CE, RN, PB)', '−03:00', '−03:00', ''),
195('CA', '+4612-05957', 'America/Glace_Bay', 'Atlantic Time - Nova Scotia - places that did not observe DST 1966-1971', '−04:00', '−03:00', ''),
196('GL', '+6411-05144', 'America/Godthab', 'most locations', '−03:00', '−02:00', ''),
197('CA', '+5320-06025', 'America/Goose_Bay', 'Atlantic Time - Labrador - most locations', '−04:00', '−03:00', ''),
198('TC', '+2128-07108', 'America/Grand_Turk', '', '−05:00', '−04:00', ''),
199('GD', '+1203-06145', 'America/Grenada', '', '−04:00', '−04:00', ''),
200('GP', '+1614-06132', 'America/Guadeloupe', '', '−04:00', '−04:00', ''),
201('GT', '+1438-09031', 'America/Guatemala', '', '−06:00', '−06:00', ''),
202('EC', '-0210-07950', 'America/Guayaquil', 'mainland', '−05:00', '−05:00', ''),
203('GY', '+0648-05810', 'America/Guyana', '', '−04:00', '−04:00', ''),
204('CA', '+4439-06336', 'America/Halifax', 'Atlantic Time - Nova Scotia (most places), PEI', '−04:00', '−03:00', ''),
205('CU', '+2308-08222', 'America/Havana', '', '−05:00', '−04:00', ''),
206('MX', '+2904-11058', 'America/Hermosillo', 'Mountain Standard Time - Sonora', '−07:00', '−07:00', ''),
207('US', '+394606-0860929', 'America/Indiana/Indianapolis', 'Eastern Time - Indiana - most locations', '−05:00', '−04:00', ''),
208('US', '+411745-0863730', 'America/Indiana/Knox', 'Central Time - Indiana - Starke County', '−06:00', '−05:00', ''),
209('US', '+382232-0862041', 'America/Indiana/Marengo', 'Eastern Time - Indiana - Crawford County', '−05:00', '−04:00', ''),
210('US', '+382931-0871643', 'America/Indiana/Petersburg', 'Eastern Time - Indiana - Pike County', '−05:00', '−04:00', ''),
211('US', '+375711-0864541', 'America/Indiana/Tell_City', 'Central Time - Indiana - Perry County', '−06:00', '−05:00', ''),
212('US', '+384452-0850402', 'America/Indiana/Vevay', 'Eastern Time - Indiana - Switzerland County', '−05:00', '−04:00', ''),
213('US', '+384038-0873143', 'America/Indiana/Vincennes', 'Eastern Time - Indiana - Daviess, Dubois, Knox & Martin Counties', '−05:00', '−04:00', ''),
214('US', '+410305-0863611', 'America/Indiana/Winamac', 'Eastern Time - Indiana - Pulaski County', '−05:00', '−04:00', ''),
215('', '', 'America/Indianapolis', '', '−05:00', '−04:00', 'Link to America/Indiana/Indianapolis'),
216('CA', '+682059-1334300', 'America/Inuvik', 'Mountain Time - west Northwest Territories', '−07:00', '−06:00', ''),
217('CA', '+6344-06828', 'America/Iqaluit', 'Eastern Time - east Nunavut - most locations', '−05:00', '−04:00', ''),
218('JM', '+1800-07648', 'America/Jamaica', '', '−05:00', '−05:00', ''),
219('', '', 'America/Jujuy', '', '−03:00', '−03:00', 'Link to America/Argentina/Jujuy'),
220('US', '+581807-1342511', 'America/Juneau', 'Alaska Time - Alaska panhandle', '−09:00', '−08:00', ''),
221('US', '+381515-0854534', 'America/Kentucky/Louisville', 'Eastern Time - Kentucky - Louisville area', '−05:00', '−04:00', ''),
222('US', '+364947-0845057', 'America/Kentucky/Monticello', 'Eastern Time - Kentucky - Wayne County', '−05:00', '−04:00', ''),
223('', '', 'America/Knox_IN', '', '−06:00', '−05:00', 'Link to America/Indiana/Knox'),
224('BQ', '+120903-0681636', 'America/Kralendijk', '', '−04:00', '−04:00', 'Link to America/Curacao'),
225('BO', '-1630-06809', 'America/La_Paz', '', '−04:00', '−04:00', ''),
226('PE', '-1203-07703', 'America/Lima', '', '−05:00', '−05:00', ''),
227('US', '+340308-1181434', 'America/Los_Angeles', 'Pacific Time', '−08:00', '−07:00', ''),
228('', '', 'America/Louisville', '', '−05:00', '−04:00', 'Link to America/Kentucky/Louisville'),
229('SX', '+180305-0630250', 'America/Lower_Princes', '', '−04:00', '−04:00', 'Link to America/Curacao'),
230('BR', '-0940-03543', 'America/Maceio', 'Alagoas, Sergipe', '−03:00', '−03:00', ''),
231('NI', '+1209-08617', 'America/Managua', '', '−06:00', '−06:00', ''),
232('BR', '-0308-06001', 'America/Manaus', 'E Amazonas', '−04:00', '−04:00', ''),
233('MF', '+1804-06305', 'America/Marigot', '', '−04:00', '−04:00', 'Link to America/Guadeloupe'),
234('MQ', '+1436-06105', 'America/Martinique', '', '−04:00', '−04:00', ''),
235('MX', '+2550-09730', 'America/Matamoros', 'US Central Time - Coahuila, Durango, Nuevo León, Tamaulipas near US border', '−06:00', '−05:00', ''),
236('MX', '+2313-10625', 'America/Mazatlan', 'Mountain Time - S Baja, Nayarit, Sinaloa', '−07:00', '−06:00', ''),
237('', '', 'America/Mendoza', '', '−03:00', '−03:00', 'Link to America/Argentina/Mendoza'),
238('US', '+450628-0873651', 'America/Menominee', 'Central Time - Michigan - Dickinson, Gogebic, Iron & Menominee Counties', '−06:00', '−05:00', ''),
239('MX', '+2058-08937', 'America/Merida', 'Central Time - Campeche, Yucatán', '−06:00', '−05:00', ''),
240('US', '+550737-1313435', 'America/Metlakatla', 'Metlakatla Time - Annette Island', '−08:00', '−08:00', ''),
241('MX', '+1924-09909', 'America/Mexico_City', 'Central Time - most locations', '−06:00', '−05:00', ''),
242('PM', '+4703-05620', 'America/Miquelon', '', '−03:00', '−02:00', ''),
243('CA', '+4606-06447', 'America/Moncton', 'Atlantic Time - New Brunswick', '−04:00', '−03:00', ''),
244('MX', '+2540-10019', 'America/Monterrey', 'Mexican Central Time - Coahuila, Durango, Nuevo León, Tamaulipas away from US border', '−06:00', '−05:00', ''),
245('UY', '-3453-05611', 'America/Montevideo', '', '−03:00', '−02:00', ''),
246('CA', '+4531-07334', 'America/Montreal', 'Eastern Time - Quebec - most locations', '−05:00', '−04:00', ''),
247('MS', '+1643-06213', 'America/Montserrat', '', '−04:00', '−04:00', ''),
248('BS', '+2505-07721', 'America/Nassau', '', '−05:00', '−04:00', ''),
249('US', '+404251-0740023', 'America/New_York', 'Eastern Time', '−05:00', '−04:00', ''),
250('CA', '+4901-08816', 'America/Nipigon', 'Eastern Time - Ontario & Quebec - places that did not observe DST 1967-1973', '−05:00', '−04:00', ''),
251('US', '+643004-1652423', 'America/Nome', 'Alaska Time - west Alaska', '−09:00', '−08:00', ''),
252('BR', '-0351-03225', 'America/Noronha', 'Atlantic islands', '−02:00', '−02:00', ''),
253('US', '+471551-1014640', 'America/North_Dakota/Beulah', 'Central Time - North Dakota - Mercer County', '−06:00', '−05:00', ''),
254('US', '+470659-1011757', 'America/North_Dakota/Center', 'Central Time - North Dakota - Oliver County', '−06:00', '−05:00', ''),
255('US', '+465042-1012439', 'America/North_Dakota/New_Salem', 'Central Time - North Dakota - Morton County (except Mandan area)', '−06:00', '−05:00', ''),
256('MX', '+2934-10425', 'America/Ojinaga', 'US Mountain Time - Chihuahua near US border', '−07:00', '−06:00', ''),
257('PA', '+0858-07932', 'America/Panama', '', '−05:00', '−05:00', ''),
258('CA', '+6608-06544', 'America/Pangnirtung', 'Eastern Time - Pangnirtung, Nunavut', '−05:00', '−04:00', ''),
259('SR', '+0550-05510', 'America/Paramaribo', '', '−03:00', '−03:00', ''),
260('US', '+332654-1120424', 'America/Phoenix', 'Mountain Standard Time - Arizona', '−07:00', '−07:00', ''),
261('TT', '+1039-06131', 'America/Port_of_Spain', '', '−04:00', '−04:00', ''),
262('HT', '+1832-07220', 'America/Port-au-Prince', '', '−05:00', '−04:00', ''),
263('', '', 'America/Porto_Acre', '', '−04:00', '−04:00', 'Link to America/Rio_Branco'),
264('BR', '-0846-06354', 'America/Porto_Velho', 'Rondonia', '−04:00', '−04:00', ''),
265('PR', '+182806-0660622', 'America/Puerto_Rico', '', '−04:00', '−04:00', ''),
266('CA', '+4843-09434', 'America/Rainy_River', 'Central Time - Rainy River & Fort Frances, Ontario', '−06:00', '−05:00', ''),
267('CA', '+624900-0920459', 'America/Rankin_Inlet', 'Central Time - central Nunavut', '−06:00', '−05:00', ''),
268('BR', '-0803-03454', 'America/Recife', 'Pernambuco', '−03:00', '−03:00', ''),
269('CA', '+5024-10439', 'America/Regina', 'Central Standard Time - Saskatchewan - most locations', '−06:00', '−06:00', ''),
270('CA', '+744144-0944945', 'America/Resolute', 'Central Standard Time - Resolute, Nunavut', '−06:00', '−05:00', ''),
271('BR', '-0958-06748', 'America/Rio_Branco', 'Acre', '−04:00', '−04:00', ''),
272('', '', 'America/Rosario', '', '−03:00', '−03:00', 'Link to America/Argentina/Cordoba'),
273('MX', '+3018-11452', 'America/Santa_Isabel', 'Mexican Pacific Time - Baja California away from US border', '−08:00', '−07:00', ''),
274('BR', '-0226-05452', 'America/Santarem', 'W Para', '−03:00', '−03:00', ''),
275('CL', '-3327-07040', 'America/Santiago', 'most locations', '−04:00', '−03:00', ''),
276('DO', '+1828-06954', 'America/Santo_Domingo', '', '−04:00', '−04:00', ''),
277('BR', '-2332-04637', 'America/Sao_Paulo', 'S & SE Brazil (GO, DF, MG, ES, RJ, SP, PR, SC, RS)', '−03:00', '−02:00', ''),
278('GL', '+7029-02158', 'America/Scoresbysund', 'Scoresbysund / Ittoqqortoormiit', '−01:00', '+00:00', ''),
279('US', '+364708-1084111', 'America/Shiprock', 'Mountain Time - Navajo', '−07:00', '−06:00', 'Link to America/Denver'),
280('US', '+571035-1351807', 'America/Sitka', 'Alaska Time - southeast Alaska panhandle', '−09:00', '−08:00', ''),
281('BL', '+1753-06251', 'America/St_Barthelemy', '', '−04:00', '−04:00', 'Link to America/Guadeloupe'),
282('CA', '+4734-05243', 'America/St_Johns', 'Newfoundland Time, including SE Labrador', '−03:30', '−02:30', ''),
283('KN', '+1718-06243', 'America/St_Kitts', '', '−04:00', '−04:00', ''),
284('LC', '+1401-06100', 'America/St_Lucia', '', '−04:00', '−04:00', ''),
285('VI', '+1821-06456', 'America/St_Thomas', '', '−04:00', '−04:00', ''),
286('VC', '+1309-06114', 'America/St_Vincent', '', '−04:00', '−04:00', ''),
287('CA', '+5017-10750', 'America/Swift_Current', 'Central Standard Time - Saskatchewan - midwest', '−06:00', '−06:00', ''),
288('HN', '+1406-08713', 'America/Tegucigalpa', '', '−06:00', '−06:00', ''),
289('GL', '+7634-06847', 'America/Thule', 'Thule / Pituffik', '−04:00', '−03:00', ''),
290('CA', '+4823-08915', 'America/Thunder_Bay', 'Eastern Time - Thunder Bay, Ontario', '−05:00', '−04:00', ''),
291('MX', '+3232-11701', 'America/Tijuana', 'US Pacific Time - Baja California near US border', '−08:00', '−07:00', ''),
292('CA', '+4339-07923', 'America/Toronto', 'Eastern Time - Ontario - most locations', '−05:00', '−04:00', ''),
293('VG', '+1827-06437', 'America/Tortola', '', '−04:00', '−04:00', ''),
294('CA', '+4916-12307', 'America/Vancouver', 'Pacific Time - west British Columbia', '−08:00', '−07:00', ''),
295('', '', 'America/Virgin', '', '−04:00', '−04:00', 'Link to America/St_Thomas'),
296('CA', '+6043-13503', 'America/Whitehorse', 'Pacific Time - south Yukon', '−08:00', '−07:00', ''),
297('CA', '+4953-09709', 'America/Winnipeg', 'Central Time - Manitoba & west Ontario', '−06:00', '−05:00', ''),
298('US', '+593249-1394338', 'America/Yakutat', 'Alaska Time - Alaska panhandle neck', '−09:00', '−08:00', ''),
299('CA', '+6227-11421', 'America/Yellowknife', 'Mountain Time - central Northwest Territories', '−07:00', '−06:00', ''),
300('AQ', '-6617+11031', 'Antarctica/Casey', 'Casey Station, Bailey Peninsula', '+11:00', '+08:00', ''),
301('AQ', '-6835+07758', 'Antarctica/Davis', 'Davis Station, Vestfold Hills', '+05:00', '+07:00', ''),
302('AQ', '-6640+14001', 'Antarctica/DumontDUrville', 'Dumont-d\'Urville Station, Terre Adelie', '+10:00', '+10:00', ''),
303('AQ', '-5430+15857', 'Antarctica/Macquarie', 'Macquarie Island Station, Macquarie Island', '+11:00', '+11:00', ''),
304('AQ', '-6736+06253', 'Antarctica/Mawson', 'Mawson Station, Holme Bay', '+05:00', '+05:00', ''),
305('AQ', '-7750+16636', 'Antarctica/McMurdo', 'McMurdo Station, Ross Island', '+12:00', '+13:00', ''),
306('AQ', '-6448-06406', 'Antarctica/Palmer', 'Palmer Station, Anvers Island', '−04:00', '−03:00', ''),
307('AQ', '-6734-06808', 'Antarctica/Rothera', 'Rothera Station, Adelaide Island', '−03:00', '−03:00', ''),
308('AQ', '-9000+00000', 'Antarctica/South_Pole', 'Amundsen-Scott Station, South Pole', '+12:00', '+13:00', 'Link to Antarctica/McMurdo'),
309('AQ', '-690022+0393524', 'Antarctica/Syowa', 'Syowa Station, E Ongul I', '+03:00', '+03:00', ''),
310('AQ', '-7824+10654', 'Antarctica/Vostok', 'Vostok Station, Lake Vostok', '+06:00', '+06:00', ''),
311('SJ', '+7800+01600', 'Arctic/Longyearbyen', '', '+01:00', '+02:00', 'Link to Europe/Oslo'),
312('YE', '+1245+04512', 'Asia/Aden', '', '+03:00', '+03:00', ''),
313('KZ', '+4315+07657', 'Asia/Almaty', 'most locations', '+06:00', '+06:00', ''),
314('JO', '+3157+03556', 'Asia/Amman', '', '+03:00', '+03:00', ''),
315('RU', '+6445+17729', 'Asia/Anadyr', 'Moscow+08 - Bering Sea', '+12:00', '+12:00', ''),
316('KZ', '+4431+05016', 'Asia/Aqtau', 'Atyrau (Atirau, Gur\'yev), Mangghystau (Mankistau)', '+05:00', '+05:00', ''),
317('KZ', '+5017+05710', 'Asia/Aqtobe', 'Aqtobe (Aktobe)', '+05:00', '+05:00', ''),
318('TM', '+3757+05823', 'Asia/Ashgabat', '', '+05:00', '+05:00', ''),
319('', '', 'Asia/Ashkhabad', '', '+05:00', '+05:00', 'Link to Asia/Ashgabat'),
320('IQ', '+3321+04425', 'Asia/Baghdad', '', '+03:00', '+03:00', ''),
321('BH', '+2623+05035', 'Asia/Bahrain', '', '+03:00', '+03:00', ''),
322('AZ', '+4023+04951', 'Asia/Baku', '', '+04:00', '+05:00', ''),
323('TH', '+1345+10031', 'Asia/Bangkok', '', '+07:00', '+07:00', ''),
324('LB', '+3353+03530', 'Asia/Beirut', '', '+02:00', '+03:00', ''),
325('KG', '+4254+07436', 'Asia/Bishkek', '', '+06:00', '+06:00', ''),
326('BN', '+0456+11455', 'Asia/Brunei', '', '+08:00', '+08:00', ''),
327('', '', 'Asia/Calcutta', '', '+05:30', '+05:30', 'Link to Asia/Kolkata'),
328('MN', '+4804+11430', 'Asia/Choibalsan', 'Dornod, Sukhbaatar', '+08:00', '+08:00', ''),
329('CN', '+2934+10635', 'Asia/Chongqing', 'central China - Sichuan, Yunnan, Guangxi, Shaanxi, Guizhou, etc.', '+08:00', '+08:00', 'Covering historic Kansu-Szechuan time zone.'),
330('', '', 'Asia/Chungking', '', '+08:00', '+08:00', 'Link to Asia/Chongqing'),
331('LK', '+0656+07951', 'Asia/Colombo', '', '+05:30', '+05:30', ''),
332('', '', 'Asia/Dacca', '', '+06:00', '+06:00', 'Link to Asia/Dhaka'),
333('SY', '+3330+03618', 'Asia/Damascus', '', '+02:00', '+03:00', ''),
334('BD', '+2343+09025', 'Asia/Dhaka', '', '+06:00', '+06:00', ''),
335('TL', '-0833+12535', 'Asia/Dili', '', '+09:00', '+09:00', ''),
336('AE', '+2518+05518', 'Asia/Dubai', '', '+04:00', '+04:00', ''),
337('TJ', '+3835+06848', 'Asia/Dushanbe', '', '+05:00', '+05:00', ''),
338('PS', '+3130+03428', 'Asia/Gaza', 'Gaza Strip', '+02:00', '+03:00', ''),
339('CN', '+4545+12641', 'Asia/Harbin', 'Heilongjiang (except Mohe), Jilin', '+08:00', '+08:00', 'Covering historic Changpai time zone.'),
340('PS', '+313200+0350542', 'Asia/Hebron', 'West Bank', '+02:00', '+03:00', ''),
341('VN', '+1045+10640', 'Asia/Ho_Chi_Minh', '', '+07:00', '+07:00', ''),
342('HK', '+2217+11409', 'Asia/Hong_Kong', '', '+08:00', '+08:00', ''),
343('MN', '+4801+09139', 'Asia/Hovd', 'Bayan-Olgiy, Govi-Altai, Hovd, Uvs, Zavkhan', '+07:00', '+07:00', ''),
344('RU', '+5216+10420', 'Asia/Irkutsk', 'Moscow+05 - Lake Baikal', '+09:00', '+09:00', ''),
345('', '', 'Asia/Istanbul', '', '+02:00', '+03:00', 'Link to Europe/Istanbul'),
346('ID', '-0610+10648', 'Asia/Jakarta', 'Java & Sumatra', '+07:00', '+07:00', ''),
347('ID', '-0232+14042', 'Asia/Jayapura', 'west New Guinea (Irian Jaya) & Malukus (Moluccas)', '+09:00', '+09:00', ''),
348('IL', '+3146+03514', 'Asia/Jerusalem', '', '+02:00', '+03:00', ''),
349('AF', '+3431+06912', 'Asia/Kabul', '', '+04:30', '+04:30', ''),
350('RU', '+5301+15839', 'Asia/Kamchatka', 'Moscow+08 - Kamchatka', '+12:00', '+12:00', ''),
351('PK', '+2452+06703', 'Asia/Karachi', '', '+05:00', '+05:00', ''),
352('CN', '+3929+07559', 'Asia/Kashgar', 'west Tibet & Xinjiang', '+08:00', '+08:00', 'Covering historic Kunlun time zone.'),
353('NP', '+2743+08519', 'Asia/Kathmandu', '', '+05:45', '+05:45', ''),
354('', '', 'Asia/Katmandu', '', '+05:45', '+05:45', 'Link to Asia/Kathmandu'),
355('IN', '+2232+08822', 'Asia/Kolkata', '', '+05:30', '+05:30', 'Note: Different zones in history, see Time in India.'),
356('RU', '+5601+09250', 'Asia/Krasnoyarsk', 'Moscow+04 - Yenisei River', '+08:00', '+08:00', ''),
357('MY', '+0310+10142', 'Asia/Kuala_Lumpur', 'peninsular Malaysia', '+08:00', '+08:00', ''),
358('MY', '+0133+11020', 'Asia/Kuching', 'Sabah & Sarawak', '+08:00', '+08:00', ''),
359('KW', '+2920+04759', 'Asia/Kuwait', '', '+03:00', '+03:00', ''),
360('', '', 'Asia/Macao', '', '+08:00', '+08:00', 'Link to Asia/Macau'),
361('MO', '+2214+11335', 'Asia/Macau', '', '+08:00', '+08:00', ''),
362('RU', '+5934+15048', 'Asia/Magadan', 'Moscow+08 - Magadan', '+12:00', '+12:00', ''),
363('ID', '-0507+11924', 'Asia/Makassar', 'east & south Borneo, Sulawesi (Celebes), Bali, Nusa Tenggara, west Timor', '+08:00', '+08:00', ''),
364('PH', '+1435+12100', 'Asia/Manila', '', '+08:00', '+08:00', ''),
365('OM', '+2336+05835', 'Asia/Muscat', '', '+04:00', '+04:00', ''),
366('CY', '+3510+03322', 'Asia/Nicosia', '', '+02:00', '+03:00', ''),
367('RU', '+5345+08707', 'Asia/Novokuznetsk', 'Moscow+03 - Novokuznetsk', '+07:00', '+07:00', ''),
368('RU', '+5502+08255', 'Asia/Novosibirsk', 'Moscow+03 - Novosibirsk', '+07:00', '+07:00', ''),
369('RU', '+5500+07324', 'Asia/Omsk', 'Moscow+03 - west Siberia', '+07:00', '+07:00', ''),
370('KZ', '+5113+05121', 'Asia/Oral', 'West Kazakhstan', '+05:00', '+05:00', ''),
371('KH', '+1133+10455', 'Asia/Phnom_Penh', '', '+07:00', '+07:00', ''),
372('ID', '-0002+10920', 'Asia/Pontianak', 'west & central Borneo', '+07:00', '+07:00', ''),
373('KP', '+3901+12545', 'Asia/Pyongyang', '', '+09:00', '+09:00', ''),
374('QA', '+2517+05132', 'Asia/Qatar', '', '+03:00', '+03:00', ''),
375('KZ', '+4448+06528', 'Asia/Qyzylorda', 'Qyzylorda (Kyzylorda, Kzyl-Orda)', '+06:00', '+06:00', ''),
376('MM', '+1647+09610', 'Asia/Rangoon', '', '+06:30', '+06:30', ''),
377('SA', '+2438+04643', 'Asia/Riyadh', '', '+03:00', '+03:00', ''),
378('', '', 'Asia/Saigon', '', '+07:00', '+07:00', 'Link to Asia/Ho_Chi_Minh'),
379('RU', '+4658+14242', 'Asia/Sakhalin', 'Moscow+07 - Sakhalin Island', '+11:00', '+11:00', ''),
380('UZ', '+3940+06648', 'Asia/Samarkand', 'west Uzbekistan', '+05:00', '+05:00', ''),
381('KR', '+3733+12658', 'Asia/Seoul', '', '+09:00', '+09:00', ''),
382('CN', '+3114+12128', 'Asia/Shanghai', 'east China - Beijing, Guangdong, Shanghai, etc.', '+08:00', '+08:00', 'Covering historic Chungyuan time zone.'),
383('SG', '+0117+10351', 'Asia/Singapore', '', '+08:00', '+08:00', ''),
384('TW', '+2503+12130', 'Asia/Taipei', '', '+08:00', '+08:00', ''),
385('UZ', '+4120+06918', 'Asia/Tashkent', 'east Uzbekistan', '+05:00', '+05:00', ''),
386('GE', '+4143+04449', 'Asia/Tbilisi', '', '+04:00', '+04:00', ''),
387('IR', '+3540+05126', 'Asia/Tehran', '', '+03:30', '+04:30', ''),
388('', '', 'Asia/Tel_Aviv', '', '+02:00', '+03:00', 'Link to Asia/Jerusalem'),
389('', '', 'Asia/Thimbu', '', '+06:00', '+06:00', 'Link to Asia/Thimphu'),
390('BT', '+2728+08939', 'Asia/Thimphu', '', '+06:00', '+06:00', ''),
391('JP', '+353916+1394441', 'Asia/Tokyo', '', '+09:00', '+09:00', ''),
392('', '', 'Asia/Ujung_Pandang', '', '+08:00', '+08:00', 'Link to Asia/Makassar'),
393('MN', '+4755+10653', 'Asia/Ulaanbaatar', 'most locations', '+08:00', '+08:00', ''),
394('', '', 'Asia/Ulan_Bator', '', '+08:00', '+08:00', 'Link to Asia/Ulaanbaatar'),
395('CN', '+4348+08735', 'Asia/Urumqi', 'most of Tibet & Xinjiang', '+08:00', '+08:00', 'Covering historic Sinkiang-Tibet time zone.'),
396('LA', '+1758+10236', 'Asia/Vientiane', '', '+07:00', '+07:00', ''),
397('RU', '+4310+13156', 'Asia/Vladivostok', 'Moscow+07 - Amur River', '+11:00', '+11:00', ''),
398('RU', '+6200+12940', 'Asia/Yakutsk', 'Moscow+06 - Lena River', '+10:00', '+10:00', ''),
399('RU', '+5651+06036', 'Asia/Yekaterinburg', 'Moscow+02 - Urals', '+06:00', '+06:00', ''),
400('AM', '+4011+04430', 'Asia/Yerevan', '', '+04:00', '+04:00', ''),
401('PT', '+3744-02540', 'Atlantic/Azores', 'Azores', '−01:00', '+00:00', ''),
402('BM', '+3217-06446', 'Atlantic/Bermuda', '', '−04:00', '−03:00', ''),
403('ES', '+2806-01524', 'Atlantic/Canary', 'Canary Islands', '+00:00', '+01:00', ''),
404('CV', '+1455-02331', 'Atlantic/Cape_Verde', '', '−01:00', '−01:00', ''),
405('', '', 'Atlantic/Faeroe', '', '+00:00', '+01:00', 'Link to Atlantic/Faroe'),
406('FO', '+6201-00646', 'Atlantic/Faroe', '', '+00:00', '+01:00', ''),
407('', '', 'Atlantic/Jan_Mayen', '', '+01:00', '+02:00', 'Link to Europe/Oslo'),
408('PT', '+3238-01654', 'Atlantic/Madeira', 'Madeira Islands', '+00:00', '+01:00', ''),
409('IS', '+6409-02151', 'Atlantic/Reykjavik', '', '+00:00', '+00:00', ''),
410('GS', '-5416-03632', 'Atlantic/South_Georgia', '', '−02:00', '−02:00', ''),
411('SH', '-1555-00542', 'Atlantic/St_Helena', '', '+00:00', '+00:00', ''),
412('FK', '-5142-05751', 'Atlantic/Stanley', '', '−03:00', '−03:00', ''),
413('', '', 'Australia/ACT', '', '+10:00', '+11:00', 'Link to Australia/Sydney'),
414('AU', '-3455+13835', 'Australia/Adelaide', 'South Australia', '+09:30', '+10:30', ''),
415('AU', '-2728+15302', 'Australia/Brisbane', 'Queensland - most locations', '+10:00', '+10:00', ''),
416('AU', '-3157+14127', 'Australia/Broken_Hill', 'New South Wales - Yancowinna', '+09:30', '+10:30', ''),
417('', '', 'Australia/Canberra', '', '+10:00', '+11:00', 'Link to Australia/Sydney'),
418('AU', '-3956+14352', 'Australia/Currie', 'Tasmania - King Island', '+10:00', '+11:00', ''),
419('AU', '-1228+13050', 'Australia/Darwin', 'Northern Territory', '+09:30', '+09:30', ''),
420('AU', '-3143+12852', 'Australia/Eucla', 'Western Australia - Eucla area', '+08:45', '+08:45', ''),
421('AU', '-4253+14719', 'Australia/Hobart', 'Tasmania - most locations', '+10:00', '+11:00', ''),
422('', '', 'Australia/LHI', '', '+10:30', '+11:00', 'Link to Australia/Lord_Howe'),
423('AU', '-2016+14900', 'Australia/Lindeman', 'Queensland - Holiday Islands', '+10:00', '+10:00', ''),
424('AU', '-3133+15905', 'Australia/Lord_Howe', 'Lord Howe Island', '+10:30', '+11:00', ''),
425('AU', '-3749+14458', 'Australia/Melbourne', 'Victoria', '+10:00', '+11:00', ''),
426('', '', 'Australia/North', '', '+09:30', '+09:30', 'Link to Australia/Darwin'),
427('', '', 'Australia/NSW', '', '+10:00', '+11:00', 'Link to Australia/Sydney'),
428('AU', '-3157+11551', 'Australia/Perth', 'Western Australia - most locations', '+08:00', '+08:00', ''),
429('', '', 'Australia/Queensland', '', '+10:00', '+10:00', 'Link to Australia/Brisbane'),
430('', '', 'Australia/South', '', '+09:30', '+10:30', 'Link to Australia/Adelaide'),
431('AU', '-3352+15113', 'Australia/Sydney', 'New South Wales - most locations', '+10:00', '+11:00', ''),
432('', '', 'Australia/Tasmania', '', '+10:00', '+11:00', 'Link to Australia/Hobart'),
433('', '', 'Australia/Victoria', '', '+10:00', '+11:00', 'Link to Australia/Melbourne'),
434('', '', 'Australia/West', '', '+08:00', '+08:00', 'Link to Australia/Perth'),
435('', '', 'Australia/Yancowinna', '', '+09:30', '+10:30', 'Link to Australia/Broken_Hill'),
436('', '', 'Brazil/Acre', '', '−04:00', '−04:00', 'Link to America/Rio_Branco'),
437('', '', 'Brazil/DeNoronha', '', '−02:00', '−02:00', 'Link to America/Noronha'),
438('', '', 'Brazil/East', '', '−03:00', '−02:00', 'Link to America/Sao_Paulo'),
439('', '', 'Brazil/West', '', '−04:00', '−04:00', 'Link to America/Manaus'),
440('', '', 'Canada/Atlantic', '', '−04:00', '−03:00', 'Link to America/Halifax'),
441('', '', 'Canada/Central', '', '−06:00', '−05:00', 'Link to America/Winnipeg'),
442('', '', 'Canada/East-Saskatchewan', '', '−06:00', '−06:00', 'Link to America/Regina'),
443('', '', 'Canada/Eastern', '', '−05:00', '−04:00', 'Link to America/Toronto'),
444('', '', 'Canada/Mountain', '', '−07:00', '−06:00', 'Link to America/Edmonton'),
445('', '', 'Canada/Newfoundland', '', '−03:30', '−02:30', 'Link to America/St_Johns'),
446('', '', 'Canada/Pacific', '', '−08:00', '−07:00', 'Link to America/Vancouver'),
447('', '', 'Canada/Saskatchewan', '', '−06:00', '−06:00', 'Link to America/Regina'),
448('', '', 'Canada/Yukon', '', '−08:00', '−07:00', 'Link to America/Whitehorse'),
449('', '', 'CET', '', '+01:00', '+02:00', ''),
450('', '', 'Chile/Continental', '', '−04:00', '−03:00', 'Link to America/Santiago'),
451('', '', 'Chile/EasterIsland', '', '−06:00', '−05:00', 'Link to Pacific/Easter'),
452('', '', 'CST6CDT', '', '−06:00', '−05:00', ''),
453('', '', 'Cuba', '', '−05:00', '−04:00', 'Link to America/Havana'),
454('', '', 'EET', '', '+02:00', '+03:00', ''),
455('', '', 'Egypt', '', '+02:00', '+02:00', 'Link to Africa/Cairo'),
456('', '', 'Eire', '', '+00:00', '+01:00', 'Link to Europe/Dublin'),
457('', '', 'EST', '', '−05:00', '−05:00', ''),
458('', '', 'EST5EDT', '', '−05:00', '−04:00', ''),
459('', '', 'Etc./GMT', '', '+00:00', '+00:00', 'Link to UTC'),
460('', '', 'Etc./GMT+0', '', '+00:00', '+00:00', 'Link to UTC'),
461('', '', 'Etc./UCT', '', '+00:00', '+00:00', 'Link to UTC'),
462('', '', 'Etc./Universal', '', '+00:00', '+00:00', 'Link to UTC'),
463('', '', 'Etc./UTC', '', '+00:00', '+00:00', 'Link to UTC'),
464('', '', 'Etc./Zulu', '', '+00:00', '+00:00', 'Link to UTC'),
465('NL', '+5222+00454', 'Europe/Amsterdam', '', '+01:00', '+02:00', ''),
466('AD', '+4230+00131', 'Europe/Andorra', '', '+01:00', '+02:00', ''),
467('GR', '+3758+02343', 'Europe/Athens', '', '+02:00', '+03:00', ''),
468('', '', 'Europe/Belfast', '', '+00:00', '+01:00', 'Link to Europe/London'),
469('RS', '+4450+02030', 'Europe/Belgrade', '', '+01:00', '+02:00', ''),
470('DE', '+5230+01322', 'Europe/Berlin', '', '+01:00', '+02:00', 'In 1945, the Trizone did not follow Berlin\'s switch to DST, see Time in Germany'),
471('SK', '+4809+01707', 'Europe/Bratislava', '', '+01:00', '+02:00', 'Link to Europe/Prague'),
472('BE', '+5050+00420', 'Europe/Brussels', '', '+01:00', '+02:00', ''),
473('RO', '+4426+02606', 'Europe/Bucharest', '', '+02:00', '+03:00', ''),
474('HU', '+4730+01905', 'Europe/Budapest', '', '+01:00', '+02:00', ''),
475('MD', '+4700+02850', 'Europe/Chisinau', '', '+02:00', '+03:00', ''),
476('DK', '+5540+01235', 'Europe/Copenhagen', '', '+01:00', '+02:00', ''),
477('IE', '+5320-00615', 'Europe/Dublin', '', '+00:00', '+01:00', ''),
478('GI', '+3608-00521', 'Europe/Gibraltar', '', '+01:00', '+02:00', ''),
479('GG', '+4927-00232', 'Europe/Guernsey', '', '+00:00', '+01:00', 'Link to Europe/London'),
480('FI', '+6010+02458', 'Europe/Helsinki', '', '+02:00', '+03:00', ''),
481('IM', '+5409-00428', 'Europe/Isle_of_Man', '', '+00:00', '+01:00', 'Link to Europe/London'),
482('TR', '+4101+02858', 'Europe/Istanbul', '', '+02:00', '+03:00', ''),
483('JE', '+4912-00207', 'Europe/Jersey', '', '+00:00', '+01:00', 'Link to Europe/London'),
484('RU', '+5443+02030', 'Europe/Kaliningrad', 'Moscow-01 - Kaliningrad', '+03:00', '+03:00', ''),
485('UA', '+5026+03031', 'Europe/Kiev', 'most locations', '+02:00', '+03:00', ''),
486('PT', '+3843-00908', 'Europe/Lisbon', 'mainland', '+00:00', '+01:00', ''),
487('SI', '+4603+01431', 'Europe/Ljubljana', '', '+01:00', '+02:00', 'Link to Europe/Belgrade'),
488('GB', '+513030-0000731', 'Europe/London', '', '+00:00', '+01:00', ''),
489('LU', '+4936+00609', 'Europe/Luxembourg', '', '+01:00', '+02:00', ''),
490('ES', '+4024-00341', 'Europe/Madrid', 'mainland', '+01:00', '+02:00', ''),
491('MT', '+3554+01431', 'Europe/Malta', '', '+01:00', '+02:00', ''),
492('AX', '+6006+01957', 'Europe/Mariehamn', '', '+02:00', '+03:00', 'Link to Europe/Helsinki'),
493('BY', '+5354+02734', 'Europe/Minsk', '', '+03:00', '+03:00', ''),
494('MC', '+4342+00723', 'Europe/Monaco', '', '+01:00', '+02:00', ''),
495('RU', '+5545+03735', 'Europe/Moscow', 'Moscow+00 - west Russia', '+04:00', '+04:00', ''),
496('', '', 'Europe/Nicosia', '', '+02:00', '+03:00', 'Link to Asia/Nicosia'),
497('NO', '+5955+01045', 'Europe/Oslo', '', '+01:00', '+02:00', ''),
498('FR', '+4852+00220', 'Europe/Paris', '', '+01:00', '+02:00', ''),
499('ME', '+4226+01916', 'Europe/Podgorica', '', '+01:00', '+02:00', 'Link to Europe/Belgrade'),
500('CZ', '+5005+01426', 'Europe/Prague', '', '+01:00', '+02:00', ''),
501('LV', '+5657+02406', 'Europe/Riga', '', '+02:00', '+03:00', ''),
502('IT', '+4154+01229', 'Europe/Rome', '', '+01:00', '+02:00', ''),
503('RU', '+5312+05009', 'Europe/Samara', 'Moscow+00 - Samara, Udmurtia', '+04:00', '+04:00', ''),
504('SM', '+4355+01228', 'Europe/San_Marino', '', '+01:00', '+02:00', 'Link to Europe/Rome'),
505('BA', '+4352+01825', 'Europe/Sarajevo', '', '+01:00', '+02:00', 'Link to Europe/Belgrade'),
506('UA', '+4457+03406', 'Europe/Simferopol', 'central Crimea', '+02:00', '+03:00', ''),
507('MK', '+4159+02126', 'Europe/Skopje', '', '+01:00', '+02:00', 'Link to Europe/Belgrade'),
508('BG', '+4241+02319', 'Europe/Sofia', '', '+02:00', '+03:00', ''),
509('SE', '+5920+01803', 'Europe/Stockholm', '', '+01:00', '+02:00', ''),
510('EE', '+5925+02445', 'Europe/Tallinn', '', '+02:00', '+03:00', ''),
511('AL', '+4120+01950', 'Europe/Tirane', '', '+01:00', '+02:00', ''),
512('', '', 'Europe/Tiraspol', '', '+02:00', '+03:00', 'Link to Europe/Chisinau'),
513('UA', '+4837+02218', 'Europe/Uzhgorod', 'Ruthenia', '+02:00', '+03:00', ''),
514('LI', '+4709+00931', 'Europe/Vaduz', '', '+01:00', '+02:00', ''),
515('VA', '+415408+0122711', 'Europe/Vatican', '', '+01:00', '+02:00', 'Link to Europe/Rome'),
516('AT', '+4813+01620', 'Europe/Vienna', '', '+01:00', '+02:00', ''),
517('LT', '+5441+02519', 'Europe/Vilnius', '', '+02:00', '+03:00', ''),
518('RU', '+4844+04425', 'Europe/Volgograd', 'Moscow+00 - Caspian Sea', '+04:00', '+04:00', ''),
519('PL', '+5215+02100', 'Europe/Warsaw', '', '+01:00', '+02:00', ''),
520('HR', '+4548+01558', 'Europe/Zagreb', '', '+01:00', '+02:00', 'Link to Europe/Belgrade'),
521('UA', '+4750+03510', 'Europe/Zaporozhye', 'Zaporozh\'ye, E Lugansk / Zaporizhia, E Luhansk', '+02:00', '+03:00', ''),
522('CH', '+4723+00832', 'Europe/Zurich', '', '+01:00', '+02:00', ''),
523('', '', 'GB', '', '+00:00', '+01:00', 'Link to Europe/London'),
524('', '', 'GB-Eire', '', '+00:00', '+01:00', 'Link to Europe/London'),
525('', '', 'GMT', '', '+00:00', '+00:00', 'Link to UTC'),
526('', '', 'GMT-0', '', '+00:00', '+00:00', 'Link to UTC'),
527('', '', 'GMT+0', '', '+00:00', '+00:00', 'Link to UTC'),
528('', '', 'GMT0', '', '+00:00', '+00:00', 'Link to UTC'),
529('', '', 'Greenwich', '', '+00:00', '+00:00', 'Link to UTC'),
530('', '', 'Hong Kong', '', '+08:00', '+08:00', 'Link to Asia/Hong_Kong'),
531('', '', 'HST', '', '−10:00', '−10:00', ''),
532('', '', 'Iceland', '', '+00:00', '+00:00', 'Link to Atlantic/Reykjavik'),
533('MG', '-1855+04731', 'Indian/Antananarivo', '', '+03:00', '+03:00', ''),
534('IO', '-0720+07225', 'Indian/Chagos', '', '+06:00', '+06:00', ''),
535('CX', '-1025+10543', 'Indian/Christmas', '', '+07:00', '+07:00', ''),
536('CC', '-1210+09655', 'Indian/Cocos', '', '+06:30', '+06:30', ''),
537('KM', '-1141+04316', 'Indian/Comoro', '', '+03:00', '+03:00', ''),
538('TF', '-492110+0701303', 'Indian/Kerguelen', '', '+05:00', '+05:00', ''),
539('SC', '-0440+05528', 'Indian/Mahe', '', '+04:00', '+04:00', ''),
540('MV', '+0410+07330', 'Indian/Maldives', '', '+05:00', '+05:00', ''),
541('MU', '-2010+05730', 'Indian/Mauritius', '', '+04:00', '+04:00', ''),
542('YT', '-1247+04514', 'Indian/Mayotte', '', '+03:00', '+03:00', ''),
543('RE', '-2052+05528', 'Indian/Reunion', '', '+04:00', '+04:00', ''),
544('', '', 'Iran', '', '+03:30', '+04:30', 'Link to Asia/Tehran'),
545('', '', 'Israel', '', '+02:00', '+03:00', 'Link to Asia/Jerusalem'),
546('', '', 'Jamaica', '', '−05:00', '−05:00', 'Link to America/Jamaica'),
547('', '', 'Japan', '', '+09:00', '+09:00', 'Link to Asia/Tokyo'),
548('', '', 'JST-9', '', '+09:00', '+09:00', 'Link to Asia/Tokyo'),
549('', '', 'Kwajalein', '', '+12:00', '+12:00', 'Link to Pacific/Kwajalein'),
550('', '', 'Libya', '', '+02:00', '+02:00', 'Link to Africa/Tripoli'),
551('', '', 'MET', '', '+01:00', '+02:00', ''),
552('', '', 'Mexico/BajaNorte', '', '−08:00', '−07:00', 'Link to America/Tijuana'),
553('', '', 'Mexico/BajaSur', '', '−07:00', '−06:00', 'Link to America/Mazatlan'),
554('', '', 'Mexico/General', '', '−06:00', '−05:00', 'Link to America/Mexico_City'),
555('', '', 'MST', '', '−07:00', '−07:00', ''),
556('', '', 'MST7MDT', '', '−07:00', '−06:00', ''),
557('', '', 'Navajo', '', '−07:00', '−06:00', 'Link to America/Denver'),
558('', '', 'NZ', '', '+12:00', '+13:00', 'Link to Pacific/Auckland'),
559('', '', 'NZ-CHAT', '', '+12:45', '+13:45', 'Link to Pacific/Chatham'),
560('WS', '-1350-17144', 'Pacific/Apia', '', '+13:00', '+14:00', ''),
561('NZ', '-3652+17446', 'Pacific/Auckland', 'most locations', '+12:00', '+13:00', ''),
562('NZ', '-4357-17633', 'Pacific/Chatham', 'Chatham Islands', '+12:45', '+13:45', ''),
563('FM', '+0725+15147', 'Pacific/Chuuk', 'Chuuk (Truk) and Yap', '+10:00', '+10:00', ''),
564('CL', '-2709-10926', 'Pacific/Easter', 'Easter Island & Sala y Gomez', '−06:00', '−05:00', ''),
565('VU', '-1740+16825', 'Pacific/Efate', '', '+11:00', '+11:00', ''),
566('KI', '-0308-17105', 'Pacific/Enderbury', 'Phoenix Islands', '+13:00', '+13:00', ''),
567('TK', '-0922-17114', 'Pacific/Fakaofo', '', '+13:00', '+13:00', ''),
568('FJ', '-1808+17825', 'Pacific/Fiji', '', '+12:00', '+13:00', ''),
569('TV', '-0831+17913', 'Pacific/Funafuti', '', '+12:00', '+12:00', ''),
570('EC', '-0054-08936', 'Pacific/Galapagos', 'Galapagos Islands', '−06:00', '−06:00', ''),
571('PF', '-2308-13457', 'Pacific/Gambier', 'Gambier Islands', '−09:00', '−09:00', ''),
572('SB', '-0932+16012', 'Pacific/Guadalcanal', '', '+11:00', '+11:00', ''),
573('GU', '+1328+14445', 'Pacific/Guam', '', '+10:00', '+10:00', ''),
574('US', '+211825-1575130', 'Pacific/Honolulu', 'Hawaii', '−10:00', '−10:00', ''),
575('UM', '+1645-16931', 'Pacific/Johnston', 'Johnston Atoll', '−10:00', '−10:00', ''),
576('KI', '+0152-15720', 'Pacific/Kiritimati', 'Line Islands', '+14:00', '+14:00', ''),
577('FM', '+0519+16259', 'Pacific/Kosrae', 'Kosrae', '+11:00', '+11:00', ''),
578('MH', '+0905+16720', 'Pacific/Kwajalein', 'Kwajalein', '+12:00', '+12:00', ''),
579('MH', '+0709+17112', 'Pacific/Majuro', 'most locations', '+12:00', '+12:00', ''),
580('PF', '-0900-13930', 'Pacific/Marquesas', 'Marquesas Islands', '−09:30', '−09:30', ''),
581('UM', '+2813-17722', 'Pacific/Midway', 'Midway Islands', '−11:00', '−11:00', ''),
582('NR', '-0031+16655', 'Pacific/Nauru', '', '+12:00', '+12:00', ''),
583('NU', '-1901-16955', 'Pacific/Niue', '', '−11:00', '−11:00', ''),
584('NF', '-2903+16758', 'Pacific/Norfolk', '', '+11:30', '+11:30', ''),
585('NC', '-2216+16627', 'Pacific/Noumea', '', '+11:00', '+11:00', ''),
586('AS', '-1416-17042', 'Pacific/Pago_Pago', '', '−11:00', '−11:00', ''),
587('PW', '+0720+13429', 'Pacific/Palau', '', '+09:00', '+09:00', ''),
588('PN', '-2504-13005', 'Pacific/Pitcairn', '', '−08:00', '−08:00', ''),
589('FM', '+0658+15813', 'Pacific/Pohnpei', 'Pohnpei (Ponape)', '+11:00', '+11:00', ''),
590('', '', 'Pacific/Ponape', '', '+11:00', '+11:00', 'Link to Pacific/Pohnpei'),
591('PG', '-0930+14710', 'Pacific/Port_Moresby', '', '+10:00', '+10:00', ''),
592('CK', '-2114-15946', 'Pacific/Rarotonga', '', '−10:00', '−10:00', ''),
593('MP', '+1512+14545', 'Pacific/Saipan', '', '+10:00', '+10:00', ''),
594('', '', 'Pacific/Samoa', '', '−11:00', '−11:00', 'Link to Pacific/Pago_Pago'),
595('PF', '-1732-14934', 'Pacific/Tahiti', 'Society Islands', '−10:00', '−10:00', ''),
596('KI', '+0125+17300', 'Pacific/Tarawa', 'Gilbert Islands', '+12:00', '+12:00', ''),
597('TO', '-2110-17510', 'Pacific/Tongatapu', '', '+13:00', '+13:00', ''),
598('', '', 'Pacific/Truk', '', '+10:00', '+10:00', 'Link to Pacific/Chuuk'),
599('UM', '+1917+16637', 'Pacific/Wake', 'Wake Island', '+12:00', '+12:00', ''),
600('WF', '-1318-17610', 'Pacific/Wallis', '', '+12:00', '+12:00', ''),
601('', '', 'Pacific/Yap', '', '+10:00', '+10:00', 'Link to Pacific/Chuuk'),
602('', '', 'Poland', '', '+01:00', '+02:00', 'Link to Europe/Warsaw'),
603('', '', 'Portugal', '', '+00:00', '+01:00', 'Link to Europe/Lisbon'),
604('', '', 'PRC', '', '+08:00', '+08:00', 'Link to Asia/Shanghai'),
605('', '', 'PST8PDT', '', '−08:00', '−07:00', ''),
606('', '', 'ROC', '', '+08:00', '+08:00', 'Link to Asia/Taipei'),
607('', '', 'ROK', '', '+09:00', '+09:00', 'Link to Asia/Seoul'),
608('', '', 'Singapore', '', '+08:00', '+08:00', 'Link to Asia/Singapore'),
609('', '', 'Turkey', '', '+02:00', '+03:00', 'Link to Europe/Istanbul'),
610('', '', 'UCT', '', '+00:00', '+00:00', 'Link to UTC'),
611('', '', 'Universal', '', '+00:00', '+00:00', 'Link to UTC'),
612('', '', 'US/Alaska', '', '−09:00', '−08:00', 'Link to America/Anchorage'),
613('', '', 'US/Aleutian', '', '−10:00', '−09:00', 'Link to America/Adak'),
614('', '', 'US/Arizona', '', '−07:00', '−07:00', 'Link to America/Phoenix'),
615('', '', 'US/Central', '', '−06:00', '−05:00', 'Link to America/Chicago'),
616('', '', 'US/East-Indiana', '', '−05:00', '−04:00', 'Link to America/Indiana/Indianapolis'),
617('', '', 'US/Eastern', '', '−05:00', '−04:00', 'Link to America/New_York'),
618('', '', 'US/Hawaii', '', '−10:00', '−10:00', 'Link to Pacific/Honolulu'),
619('', '', 'US/Indiana-Starke', '', '−06:00', '−05:00', 'Link to America/Indiana/Knox'),
620('', '', 'US/Michigan', '', '−05:00', '−04:00', 'Link to America/Detroit'),
621('', '', 'US/Mountain', '', '−07:00', '−06:00', 'Link to America/Denver'),
622('', '', 'US/Pacific', '', '−08:00', '−07:00', 'Link to America/Los_Angeles'),
623('', '', 'US/Pacific-New', '', '−08:00', '−07:00', 'Link to America/Los_Angeles'),
624('', '', 'US/Samoa', '', '−11:00', '−11:00', 'Link to Pacific/Pago_Pago'),
625('', '', 'UTC', '', '+00:00', '+00:00', ''),
626('', '', 'W-SU', '', '+04:00', '+04:00', 'Link to Europe/Moscow'),
627('', '', 'WET', '', '+00:00', '+01:00', ''),
628('', '', 'Zulu', '', '+00:00', '+00:00', 'Link to UTC');
629
630-- --------------------------------------------------------
631
632--
633-- Table structure for table `ci_sessions`
634--
635
636CREATE TABLE `ci_sessions` (
637  `id` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
638  `ip_address` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL,
639  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
640  `data` longblob DEFAULT NULL
641) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
642
643--
644-- Dumping data for table `ci_sessions`
645--
646
647INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
648('ahbao7ufqdv9j5cdadpislf7qg9hk7sr', '::1', 1698063105, 0x5f5f63695f6c6173745f726567656e65726174657c693a313639383036333130343b);
649
650-- --------------------------------------------------------
651
652--
653-- Table structure for table `comments`
654--
655
656CREATE TABLE `comments` (
657  `comments_id` int(20) NOT NULL,
658  `user_id` int(10) NOT NULL,
659  `video_id` int(20) NOT NULL,
660  `comment_type` int(5) NOT NULL DEFAULT 1,
661  `replay_for` int(10) DEFAULT 0,
662  `comment` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
663  `comment_at` datetime DEFAULT NULL,
664  `publication` int(5) DEFAULT 0
665) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
666
667-- --------------------------------------------------------
668
669--
670-- Table structure for table `config`
671--
672
673CREATE TABLE `config` (
674  `config_id` int(11) NOT NULL,
675  `title` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
676  `value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL
677) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
678
679--
680-- Dumping data for table `config`
681--
682
683INSERT INTO `config` (`config_id`, `title`, `value`) VALUES
684(1, 'system_name', 'OVOO - Live TV & Movie Portal CMS with Unlimited TV-Series'),
685(2, 'site_name', 'My Movie Site'),
686(3, 'author', 'Jone Doe'),
687(4, 'business_address', 'My Address'),
688(5, 'business_phone', '880170000000'),
689(6, 'contact_email', 'contact@mydomain.com'),
690(7, 'system_email', 'email@mydomain.com'),
691(8, 'system_short_name', 'OVOO'),
692(9, 'social_share_enable', '0'),
693(10, 'default_color', '#00CC6A'),
694(11, 'front_end_theme', 'red'),
695(12, 'seo_title', ''),
696(13, 'focus_keyword', ''),
697(14, 'meta_description', ''),
698(15, 'blog_enable', '0'),
699(16, 'blog_title', ''),
700(17, 'blog_keyword', ''),
701(18, 'blog_meta_description', ''),
702(19, 'home_page_seo_title', ''),
703(20, 'language', 'english'),
704(21, 'site_url', 'https://mydomain.com'),
705(22, 'total_movie_in_slider', '5'),
706(23, 'footer1_title', 'About'),
707(24, 'footer1_content', '<p><br></p>'),
708(25, 'footer2_title', 'Useful Link'),
709(26, 'footer2_content', '<p><br></p>'),
710(27, 'footer3_title', 'Useful Link'),
711(28, 'footer3_content', '<p><br></p>'),
712(29, 'copyright_text', 'Copyright 2023&nbsp;<a href=\"#\">Business Name</a>'),
713(30, 'slider_type', 'disable'),
714(31, 'slide_per_page', '8'),
715(32, 'protocol', 'sendmail'),
716(33, 'mailpath', '/usr/bin/sendmail'),
717(34, 'smtp_host', 'smtp.gmail.com'),
718(35, 'smtp_user', 'example@gmail.com'),
719(36, 'smtp_pass', 'xxxxxxxxxxxx'),
720(37, 'smtp_port', '465'),
721(38, 'smtp_crypto', 'ssl'),
722(39, 'facebook_url', '#'),
723(40, 'twitter_url', '#'),
724(41, 'vimeo_url', '#'),
725(42, 'linkedin_url', '#'),
726(43, 'youtube_url', '#'),
727(44, 'google_analytics_id', ''),
728(45, 'about_us_enable', '1'),
729(46, 'about_us_title', 'about'),
730(47, 'about_us_text', 'about us'),
731(48, 'about_us_to_primary_menu', '1'),
732(49, 'about_us_to_footer_menu', '0'),
733(50, 'facebook_comment_appid', '0000'),
734(51, 'comments_method', '0'),
735(52, 'comments_approval', '0'),
736(53, 'ad_160x600_code', ''),
737(54, 'ad_160x600_type', '1'),
738(55, 'ad_160x600_image_url', ''),
739(56, 'ad_250x300_type', '1'),
740(57, 'ad_250x300_image_url', ''),
741(58, 'ad_250x300_code', ''),
742(59, 'ad_160x600_url', ''),
743(60, 'ad_250x300_url', '#'),
744(61, 'map_api', 'xxxxxxxxxxxxxxxxxxxxxxx'),
745(62, 'map_lat', 'xxxxxxxxxxxxxxxx'),
746(63, 'map_lng', 'xxxxxxxxxxxxxxxxxxxx'),
747(64, 'movie_per_page', '18'),
748(65, 'google_application_name', 'Connect With TRC4'),
749(66, 'google_client_id', 'xxxxxxxxxxxxxxxxxxxx'),
750(67, 'google_client_secret', 'xxxxxxxxxxxxxxxxxxxxxxx'),
751(68, 'google_redirect_uri', 'https://google.com/'),
752(69, 'google_api_key', ''),
753(70, 'google_login_enable', '0'),
754(71, 'facebook_app_id', 'xxxxxxxxxxxxxxxxxxxx'),
755(72, 'facebook_app_secret', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx'),
756(73, 'facebook_graph_version', 'v2.10'),
757(74, 'google_login_enable', '0'),
758(75, 'facebook_login_enable', '0'),
759(76, 'tv_series_publish', '1'),
760(77, 'tv_series_title', 'Tv-Series Page SEO Title'),
761(78, 'tv_series_keyword', ''),
762(79, 'tv_series_meta_description', ''),
763(80, 'tv_series_pin_primary_menu', '1'),
764(81, 'tv_series_pin_footer_menu', '1'),
765(82, 'purchase_code', '123456'),
766(83, 'header_templete', 'header1'),
767(84, 'footer_templete', 'footer1'),
768(85, 'dark_theme', '1'),
769(86, 'player_color_skin', 'green'),
770(87, 'player_watermark', '1'),
771(88, 'player_watermark_logo', 'uploads/watermark_logo.png'),
772(89, 'player_watermark_url', '#'),
773(90, 'player_share', ''),
774(91, 'player_share_fb_id', '35345'),
775(92, 'player_seek_button', '0'),
776(95, 'player_volume_remember', '1'),
777(93, 'player_seek_forward', '10'),
778(94, 'player_seek_back', '5'),
779(98, 'live_tv_publish', '1'),
780(99, 'live_tv_title', 'Latest TV Page SEO Title'),
781(100, 'live_tv_keyword', ''),
782(101, 'live_tv_meta_description', ''),
783(102, 'live_tv_pin_primary_menu', '1'),
784(103, 'live_tv_pin_footer_menu', '1'),
785(104, 'registration_enable', '1'),
786(105, 'frontend_login_enable', '1'),
787(106, 'push_notification_enable', ''),
788(107, 'onesignal_appid', 'xxxxxxxxxxxxxxx'),
789(108, 'onesignal_actionmessage', 'We\\\'d like to show you notifications for the latest news.'),
790(109, 'onesignal_acceptbuttontext', 'ALLOW'),
791(110, 'onesignal_cancelbuttontext', 'NO THANKS'),
792(111, 'onesignal_api_keys', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'),
793(112, 'landing_page_enable', '0'),
794(113, 'landing_page_image_url', 'landing_page/bg.jpg'),
795(142, 'mobile_apps_api_secret_key', 'b8385215ee161ff'),
796(115, 'country_to_primary_menu', '0'),
797(116, 'genre_to_primary_menu', '1'),
798(117, 'release_to_primary_menu', '1'),
799(118, 'show_star_image', '0'),
800(119, 'movie_page_seo_title', 'Movie Page SEO Title'),
801(120, 'movie_page_focus_keyword', ''),
802(121, 'movie_page_meta_description', ''),
803(128, 'dmca_policy_content', 'privacy_policy_content'),
804(122, 'privacy_policy_content', ''),
805(123, 'privacy_policy_to_primary_menu', '0'),
806(124, 'privacy_policy_to_footer_menu', '0'),
807(125, 'disclaimer_text', '<b>Disclaimer:</b> This site does not store any files on its server. All contents are provided by non-affiliated third parties.'),
808(126, 'disclaimer_text_enable', '0'),
809(127, 'movie_report_enable', '1'),
810(129, 'dmca_to_primary_menu', '0'),
811(130, 'dmca_to_footer_menu', '0'),
812(131, 'dmca_content', ''),
813(132, 'contact_to_primary_menu', '0'),
814(133, 'contact_to_footer_menu', '1'),
815(134, 'movie_report_note', 'Please help us to describe the issue so we can fix it asap. \r\nNote: This feature used to report the issue for the current movie, not used for requesting new subtitle/audio in another language'),
816(135, 'movie_report_email', 'contact@mydomain.com'),
817(136, 'movie_request_enable', '1'),
818(137, 'movie_request_email', 'contact@mydomain.com'),
819(138, 'envato_support_untill', '2019-01-01'),
820(139, 'cron_key', '51664c535ae94b3'),
821(140, 'db_backup', '0'),
822(141, 'backup_schedule', '1'),
823(143, 'version', '3.4'),
824(144, 'preroll_ads_enable', '0'),
825(145, 'preroll_ads_video', 'https://sample-videos.com/video123/mp4/720/big_buck_bunny_720p_20mb.mp4'),
826(146, 'admob_ads_enable', '0'),
827(147, 'admob_app_id', 'ca-app-pub-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxe'),
828(148, 'admob_banner_ads_id', 'ca-app-pub-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'),
829(149, 'admob_interstitial_ads_id', 'ca-app-pub-xxxxxxxxxxxxxxxxxxx/xxxxxxxxxxxxxx'),
830(150, 'admob_publisher_id', 'pub-xxxxxxxxxxxxxxxxxxe'),
831(151, 'recaptcha_site_key', 'xxxxxxxxxxxxxxxxxxx'),
832(152, 'recaptcha_secret_key', 'xxxxxxxxxxxxxxxxxxxx'),
833(153, 'az_to_primary_menu', '1'),
834(154, 'az_to_footer_menu', '1'),
835(155, 'recaptcha_enable', '0'),
836(156, 'active_theme', 'default'),
837(157, 'active_language_id', '1'),
838(158, 'disqus_short_name', 'ovoo'),
839(159, 'trial_enable', '0'),
840(160, 'trial_period', '0'),
841(171, 'tmdb_language', 'en'),
842(172, 'default_quality', 'HD'),
843(173, 'app_menu', 'grid'),
844(174, 'app_program_guide_enable', 'false'),
845(175, 'app_mandatory_login', 'false'),
846(176, 'genre_visible', 'true'),
847(177, 'country_visible', 'true'),
848(178, 'timezone', 'Europe/Tirane'),
849(179, 'season_order', 'DESC'),
850(180, 'episode_order', 'DESC'),
851(181, 'video_source', 'mp4'),
852(182, 'video_file_order', 'DESC'),
853(183, 'tmbd_api_key', ''),
854(193, 'slider_border_radius', '10'),
855(192, 'slider_height', '420'),
856(190, 'slider_arrow', '0'),
857(191, 'slider_bullet', '1'),
858(189, 'slider_fullwide', '0'),
859(194, 'logo', 'logo.png'),
860(196, 'favicon', 'favicon.ico'),
861(197, 'landing_bg', 'landing_page/bg.jpg'),
862(199, 'trial_enable', '0'),
863(200, 'trial_period', '0'),
864(201, 'paypal_email', 'paypal@domain.com'),
865(202, 'currency_symbol', '$'),
866(203, 'stripe_publishable_key', 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'),
867(204, 'stripe_secret_key', 'xxxxxxxxxxxxxxxxxxxxxxxxxxx'),
868(205, 'currency', 'USD'),
869(206, 'paypal_client_id', 'xxxxxxxxxxxxxxxxxxxx'),
870(207, 'exchange_rate_update_by_cron', '0'),
871(208, 'enable_ribbon', '1'),
872(209, 'mobile_ads_enable', '0'),
873(210, 'mobile_ads_network', 'admob'),
874(211, 'fan_native_ads_placement_id', 'xxxxxxxxxxxxxxxxxxxx'),
875(212, 'fan_banner_ads_placement_id', 'xxxxxxxxxxxxxxxxxxxxxxx'),
876(213, 'fan_Interstitial_ads_placement_id', 'xxxxxxxxxxxxxxxxxxxxxx'),
877(214, 'startapp_app_id', 'xxxxxxxxxxx'),
878(218, 'apk_version_code', '15'),
879(219, 'apk_version_name', 'v1.2.8'),
880(220, 'apk_whats_new', 'New UI\r\nDownload option\r\nAdvanced Search\r\nSubscription'),
881(221, 'latest_apk_url', 'http://oxoo.spagreen.net/demo/oxoo-v121.apk'),
882(222, 'apk_update_is_skipable', '1'),
883(223, 'razorpay_key_id', 'xxxxxxxxxxx'),
884(224, 'razorpay_key_secret', 'xxxxxxxxxxxx'),
885(225, 'paypal_enable', 'true'),
886(226, 'stripe_enable', 'true'),
887(227, 'razorpay_enable', 'true'),
888(228, 'razorpay_inr_exchange_rate', '1'),
889(229, 'admob_native_ads_id', 'xxxxxxxxxxx'),
890(230, 'offline_payment_enable', 'false'),
891(231, 'offline_payment_title', 'Offline Payment'),
892(232, 'offline_payment_instruction', 'Offline payment instruction goes here.<div>Your Name, IBAN, ETC....</div>'),
893(233, 'movie_page_slider', '1'),
894(234, 'tv_series_page_slider', '1'),
895(235, 'bg_img_disable', '0'),
896(236, 'bg_image', 'bg.jpg'),
897(237, 'preloader_disable', '0'),
898(238, 'reward_ad', 'disable'),
899(239, 'reward_ad_id', 'reward_ad_ide'),
900(240, 'banner_ad', 'disable'),
901(241, 'banner_ad_id', 'banner_ad_ide'),
902(242, 'interstitial_ad', 'disable'),
903(243, 'interstitial_ad_id', 'interstitial_ad_ide'),
904(244, 'native_ad', 'disable'),
905(245, 'native_ad_id', 'native_ad_ide'),
906(246, 'unity_test_mode', '0'),
907(247, 'unity_android_game_id', 'unity_android_game_ide'),
908(248, 'unity_ios_game_id', 'unity_ios_game_ide'),
909(249, 'native_ad_interval', 'native_ad_interval'),
910(250, 'tmdb_image_import_by_cron', '0');
911
912-- --------------------------------------------------------
913
914--
915-- Table structure for table `country`
916--
917
918CREATE TABLE `country` (
919  `country_id` int(11) NOT NULL,
920  `name` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
921  `description` varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL,
922  `slug` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL,
923  `publication` int(2) NOT NULL
924) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
925
926--
927-- Dumping data for table `country`
928--
929
930INSERT INTO `country` (`country_id`, `name`, `description`, `slug`, `publication`) VALUES
931(1, 'International', '', 'international', 1),
932(2, 'Asia', '', 'asia', 1),
933(3, 'USA', '', 'usa', 1),
934(4, 'China', '', 'china', 1),
935(5, 'Japan', '', 'japan', 1),
936(6, 'Korean', '', 'korean', 1),
937(7, 'Nepal', '', 'nepal', 1),
938(8, 'Thailand', '', 'thailand', 1),
939(9, 'Tamil', '', 'tamil', 1),
940(10, 'India', '', 'india', 1),
941(11, 'France', '', 'france', 1),
942(12, 'Italy', '', 'italy', 1),
943(13, 'German', '', 'german', 1),
944(14, 'London', '', 'london', 1),
945(15, 'Canada', '', 'canada', 1),
946(16, 'Denmark', '', 'denmark', 1),
947(17, 'UK', '', 'uk', 1),
948(18, 'Hong kong', '', 'hong-kong', 1),
949(19, 'UAE', '', 'uae', 1),
950(20, 'Australia', '', 'australia', 1),
951(21, 'South Korea', '', 'south-korea', 1),
952(22, 'Russia', '', 'russia', 1),
953(23, ' Sweden', '', 'sweden', 1),
954(24, 'Spain', '', 'spain', 1),
955(25, 'Brazil', '', 'brazil', 1),
956(26, 'Iran', '', 'iran', 1),
957(27, 'Israel', '', 'israel', 1),
958(28, 'Indonesia', '', 'indonesia', 1),
959(29, 'Philippines', '', 'philippines', 1),
960(30, ' Peru', ' Peru', 'peru', 1),
961(31, ' Canada', ' Canada', 'canada', 1),
962(32, ' Japan', ' Japan', 'japan', 1),
963(33, ' USA', ' USA', 'usa', 1),
964(34, ' Hong Kong', ' Hong Kong', 'hong-kong', 1),
965(35, ' Mexico', ' Mexico', 'mexico', 1),
966(36, ' New Zealand', ' New Zealand', 'new-zealand', 1),
967(37, ' UK', ' UK', 'uk', 1),
968(38, ' Denmark', ' Denmark', 'denmark', 1),
969(39, ' Australia', ' Australia', 'australia', 1),
970(40, ' Germany', ' Germany', 'germany', 1),
971(41, ' Hungary', ' Hungary', 'hungary', 1),
972(42, ' India', ' India', 'india', 1),
973(43, 'Hungary', 'Hungary', 'hungary', 1),
974(44, ' France', ' France', 'france', 1),
975(45, ' China', ' China', 'china', 1),
976(46, 'Chile', 'Chile', 'chile', 1),
977(47, ' Argentina', ' Argentina', 'argentina', 1),
978(48, 'Egypt', 'Egypt', 'egypt', 1),
979(49, 'New Zealand', 'New Zealand', 'new-zealand', 1),
980(50, 'Croatia', 'Croatia', 'croatia', 1),
981(51, ' Switzerland', ' Switzerland', 'switzerland', 1),
982(52, ' Tunisia', ' Tunisia', 'tunisia', 1),
983(53, 'Belgium', 'Belgium', 'belgium', 1),
984(68, 'United States of America', 'United States of America', 'united-states-of-america', 1),
985(69, 'Bangladesh', 'Bangladesh', 'bangladesh', 1),
986(70, 'United Kingdom', 'United Kingdom', 'united-kingdom', 1),
987(71, 'Malaysia', 'Malaysia', 'malaysia', 1),
988(72, 'South Africa', 'South Africa', 'south-africa', 1),
989(73, 'Switzerland', 'Switzerland', 'switzerland', 1),
990(74, 'Germany', 'Germany', 'germany', 1),
991(75, 'Sweden', 'Sweden', 'sweden', 1),
992(76, 'Bulgaria', 'Bulgaria', 'bulgaria', 1),
993(77, 'Soviet Union', 'Soviet Union', 'soviet-union', 1),
994(78, 'Netherlands', 'Netherlands', 'netherlands', 1),
995(80, 'Malta', 'Malta', 'malta', 1),
996(81, 'Taiwan', 'Taiwan', 'taiwan', 1),
997(82, 'Argentina', 'Argentina', 'argentina', 1),
998(83, 'Iceland', 'Iceland', 'iceland', 1),
999(84, 'CA', 'CA', 'ca', 1),
1000(85, 'JP', 'JP', 'jp', 1),
1001(86, 'US', 'US', 'us', 1),
1002(87, 'GB', 'GB', 'gb', 1),
1003(88, '', '', '', 1);
1004
1005-- --------------------------------------------------------
1006
1007--
1008-- Table structure for table `cron`
1009--
1010
1011CREATE TABLE `cron` (
1012  `cron_id` int(11) NOT NULL,
1013  `type` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1014  `action` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1015  `image_url` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1016  `save_to` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1017  `videos_id` int(250) DEFAULT NULL,
1018  `admin_email_from` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1019  `admin_email` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1020  `email_to` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1021  `email_sub` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1022  `message` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
1023) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1024
1025-- --------------------------------------------------------
1026
1027--
1028-- Table structure for table `currency`
1029--
1030
1031CREATE TABLE `currency` (
1032  `currency_id` int(11) NOT NULL,
1033  `country` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1034  `currency` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1035  `iso_code` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1036  `symbol` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1037  `exchange_rate` double NOT NULL DEFAULT 1,
1038  `default` int(11) NOT NULL DEFAULT 0,
1039  `status` int(11) NOT NULL DEFAULT 1
1040) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1041
1042--
1043-- Dumping data for table `currency`
1044--
1045
1046INSERT INTO `currency` (`currency_id`, `country`, `currency`, `iso_code`, `symbol`, `exchange_rate`, `default`, `status`) VALUES
1047(1, 'Albania', 'Leke', 'ALL', 'Lek', 1, 0, 1),
1048(2, 'America', 'Dollars', 'USD', '$', 1, 0, 1),
1049(3, 'Afghanistan', 'Afghanis', 'AFN', '؋', 1, 0, 1),
1050(4, 'Argentina', 'Pesos', 'ARS', '$', 61.399228, 0, 1),
1051(5, 'Aruba', 'Guilders', 'AWG', 'ƒ', 1, 0, 1),
1052(6, 'Australia', 'Dollars', 'AUD', '$', 1.4882, 0, 1),
1053(7, 'Azerbaijan', 'New Manats', 'AZN', 'ман', 1, 0, 1),
1054(8, 'Bahamas', 'Dollars', 'BSD', '$', 1, 0, 1),
1055(9, 'Barbados', 'Dollars', 'BBD', '$', 1, 0, 1),
1056(10, 'Belarus', 'Rubles', 'BYR', 'p.', 1, 0, 1),
1057(11, 'Belgium', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1058(12, 'Beliz', 'Dollars', 'BZD', 'BZ$', 1, 0, 1),
1059(13, 'Bermuda', 'Dollars', 'BMD', '$', 1, 0, 1),
1060(14, 'Bolivia', 'Bolivianos', 'BOB', '$b', 1, 0, 1),
1061(15, 'Bosnia and Herzegovina', 'Convertible Marka', 'BAM', 'KM', 1, 0, 1),
1062(16, 'Botswana', 'Pula', 'BWP', 'P', 1, 0, 1),
1063(17, 'Bulgaria', 'Leva', 'BGN', 'лв', 1.803753, 0, 1),
1064(18, 'Brazil', 'Reais', 'BRL', 'R$', 4.330496, 0, 1),
1065(19, 'Britain (United Kingdom)', 'Pounds', 'GBP', '£', 83, 0, 1),
1066(20, 'Brunei Darussalam', 'Dollars', 'BND', '$', 1, 0, 1),
1067(21, 'Cambodia', 'Riels', 'KHR', '៛', 1, 0, 1),
1068(22, 'Canada', 'Dollars', 'CAD', '$', 1.325097, 0, 1),
1069(23, 'Cayman Islands', 'Dollars', 'KYD', '$', 1, 0, 1),
1070(24, 'Chile', 'Pesos', 'CLP', '$', 794.622928, 0, 1),
1071(25, 'China', 'Yuan Renminbi', 'CNY', '¥', 6.984162, 0, 1),
1072(26, 'Colombia', 'Pesos', 'COP', '$', 3313, 0, 1),
1073(27, 'Costa Rica', 'Colón', 'CRC', '₡', 1, 0, 1),
1074(28, 'Croatia', 'Kuna', 'HRK', 'kn', 6.869981, 0, 1),
1075(29, 'Cuba', 'Pesos', 'CUP', '₱', 1, 0, 1),
1076(30, 'Cyprus', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1077(31, 'Czech Republic', 'Koruny', 'CZK', 'Kč', 22.911451, 0, 1),
1078(32, 'Denmark', 'Kroner', 'DKK', 'kr', 6.890187, 0, 1),
1079(33, 'Dominican Republic', 'Pesos', 'DOP ', 'RD$', 53.507402, 0, 1),
1080(34, 'East Caribbean', 'Dollars', 'XCD', '$', 1, 0, 1),
1081(35, 'Egypt', 'Pounds', 'EGP', '£', 15.61815, 0, 1),
1082(36, 'El Salvador', 'Colones', 'SVC', '$', 1, 0, 1),
1083(37, 'England (United Kingdom)', 'Pounds', 'GBP', '£', 83, 0, 1),
1084(38, 'Euro', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1085(39, 'Falkland Islands', 'Pounds', 'FKP', '£', 1, 0, 1),
1086(40, 'Fiji', 'Dollars', 'FJD', '$', 2.195918, 0, 1),
1087(41, 'France', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1088(42, 'Ghana', 'Cedis', 'GHC', '¢', 1, 0, 1),
1089(43, 'Gibraltar', 'Pounds', 'GIP', '£', 1, 0, 1),
1090(44, 'Greece', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1091(45, 'Guatemala', 'Quetzales', 'GTQ', 'Q', 7.63804, 0, 1),
1092(46, 'Guernsey', 'Pounds', 'GGP', '£', 1, 0, 1),
1093(47, 'Guyana', 'Dollars', 'GYD', '$', 1, 0, 1),
1094(48, 'Holland (Netherlands)', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1095(49, 'Honduras', 'Lempiras', 'HNL', 'L', 1, 0, 1),
1096(50, 'Hong Kong', 'Dollars', 'HKD', '$', 7.767071, 0, 1),
1097(51, 'Hungary', 'Forint', 'HUF', 'Ft', 310.231043, 0, 1),
1098(52, 'Iceland', 'Kronur', 'ISK', 'kr', 126.858376, 0, 1),
1099(53, 'India', 'Rupees', 'INR', 'Rp', 71.40112, 0, 1),
1100(54, 'Indonesia', 'Rupiahs', 'IDR', 'Rp', 13612.651679, 0, 1),
1101(55, 'Iran', 'Rials', 'IRR', '﷼', 1, 0, 1),
1102(56, 'Ireland', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1103(57, 'Isle of Man', 'Pounds', 'IMP', '£', 1, 0, 1),
1104(58, 'Israel', 'New Shekels', 'ILS', '₪', 3.427408, 0, 1),
1105(59, 'Italy', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1106(60, 'Jamaica', 'Dollars', 'JMD', 'J$', 1, 0, 1),
1107(61, 'Japan', 'Yen', 'JPY', '¥', 109.814254, 0, 1),
1108(62, 'Jersey', 'Pounds', 'JEP', '£', 1, 0, 1),
1109(63, 'Kazakhstan', 'Tenge', 'KZT', 'лв', 376.834123, 0, 1),
1110(64, 'Korea (North)', 'Won', 'KPW', '₩', 1, 0, 1),
1111(65, 'Korea (South)', 'Won', 'KRW', '₩', 1183.94149, 0, 1),
1112(66, 'Kyrgyzstan', 'Soms', 'KGS', 'лв', 1, 0, 1),
1113(67, 'Laos', 'Kips', 'LAK', '₭', 1, 0, 1),
1114(68, 'Latvia', 'Lati', 'LVL', 'Ls', 1, 0, 1),
1115(69, 'Lebanon', 'Pounds', 'LBP', '£', 1, 0, 1),
1116(70, 'Liberia', 'Dollars', 'LRD', '$', 1, 0, 1),
1117(71, 'Liechtenstein', 'Switzerland Francs', 'CHF', 'CHF', 0.980752, 0, 1),
1118(72, 'Lithuania', 'Litai', 'LTL', 'Lt', 1, 0, 1),
1119(73, 'Luxembourg', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1120(74, 'Macedonia', 'Denars', 'MKD', 'ден', 1, 0, 1),
1121(75, 'Malaysia', 'Ringgits', 'MYR', 'RM', 4.139749, 0, 1),
1122(76, 'Malta', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1123(77, 'Mauritius', 'Rupees', 'MUR', '₨', 1, 0, 1),
1124(78, 'Mexico', 'Pesos', 'MXN', '$', 18.585695, 0, 1),
1125(79, 'Mongolia', 'Tugriks', 'MNT', '₮', 1, 0, 1),
1126(80, 'Mozambique', 'Meticais', 'MZN', 'MT', 1, 0, 1),
1127(81, 'Namibia', 'Dollars', 'NAD', '$', 1, 0, 1),
1128(82, 'Nepal', 'Rupees', 'NPR', '₨', 1, 0, 1),
1129(83, 'Netherlands Antilles', 'Guilders', 'ANG', 'ƒ', 1, 0, 1),
1130(84, 'Netherlands', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1131(85, 'New Zealand', 'Dollars', 'NZD', '$', 1.553574, 0, 1),
1132(86, 'Nicaragua', 'Cordobas', 'NIO', 'C$', 1, 0, 1),
1133(87, 'Nigeria', 'Nairas', 'NGN', '₦', 1, 0, 1),
1134(88, 'North Korea', 'Won', 'KPW', '₩', 1, 0, 1),
1135(89, 'Norway', 'Krone', 'NOK', 'kr', 9.253793, 0, 1),
1136(90, 'Oman', 'Rials', 'OMR', '﷼', 1, 0, 1),
1137(91, 'Pakistan', 'Rupees', 'PKR', '₨', 154.392233, 0, 1),
1138(92, 'Panama', 'Balboa', 'PAB', 'B/.', 1, 0, 1),
1139(93, 'Paraguay', 'Guarani', 'PYG', 'Gs', 6626, 0, 1),
1140(94, 'Peru', 'Nuevos Soles', 'PEN', 'S/.', 3.383275, 0, 1),
1141(95, 'Philippines', 'Pesos', 'PHP', 'Php', 50.525693, 0, 1),
1142(96, 'Poland', 'Zlotych', 'PLN', 'zł', 3.917289, 0, 1),
1143(97, 'Qatar', 'Rials', 'QAR', '﷼', 1, 0, 1),
1144(98, 'Romania', 'New Lei', 'RON', 'lei', 4.396745, 0, 1),
1145(99, 'Russia', 'Rubles', 'RUB', 'руб', 63.537178, 0, 1),
1146(100, 'Saint Helena', 'Pounds', 'SHP', '£', 1, 0, 1),
1147(101, 'Saudi Arabia', 'Riyals', 'SAR', '﷼', 3.75061, 0, 1),
1148(102, 'Serbia', 'Dinars', 'RSD', 'Дин.', 1, 0, 1),
1149(103, 'Seychelles', 'Rupees', 'SCR', '₨', 1, 0, 1),
1150(104, 'Singapore', 'Dollars', 'SGD', '$', 1.390516, 0, 1),
1151(105, 'Slovenia', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1152(106, 'Solomon Islands', 'Dollars', 'SBD', '$', 1, 0, 1),
1153(107, 'Somalia', 'Shillings', 'SOS', 'S', 1, 0, 1),
1154(108, 'South Africa', 'Rand', 'ZAR', 'R', 14.88117, 0, 1),
1155(109, 'South Korea', 'Won', 'KRW', '₩', 1183.94149, 0, 1),
1156(110, 'Spain', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1157(111, 'Sri Lanka', 'Rupees', 'LKR', '₨', 1, 0, 1),
1158(112, 'Sweden', 'Kronor', 'SEK', 'kr', 9.694847, 0, 1),
1159(113, 'Switzerland', 'Francs', 'CHF', 'CHF', 0.980752, 0, 1),
1160(114, 'Suriname', 'Dollars', 'SRD', '$', 1, 0, 1),
1161(115, 'Syria', 'Pounds', 'SYP', '£', 1, 0, 1),
1162(116, 'Taiwan', 'New Dollars', 'TWD', 'NT$', 30.0056, 0, 1),
1163(117, 'Thailand', 'Baht', 'THB', '฿', 31.163295, 0, 1),
1164(118, 'Trinidad and Tobago', 'Dollars', 'TTD', 'TT$', 1, 0, 1),
1165(119, 'Turkey', 'Lira', 'TRY', 'TL', 6.053817, 0, 1),
1166(120, 'Turkey', 'Liras', 'TRL', '£', 1, 0, 1),
1167(121, 'Tuvalu', 'Dollars', 'TVD', '$', 1, 0, 1),
1168(122, 'Ukraine', 'Hryvnia', 'UAH', '₴', 24.336642, 0, 1),
1169(123, 'United Kingdom', 'Pounds', 'GBP', '£', 83, 0, 1),
1170(124, 'United States of America', 'Dollars', 'USD', '$', 1, 0, 1),
1171(125, 'Uruguay', 'Pesos', 'UYU', '$U', 37.880896, 0, 1),
1172(126, 'Uzbekistan', 'Sums', 'UZS', 'лв', 1, 0, 1),
1173(127, 'Vatican City', 'Euro', 'EUR', '€', 0.922379, 0, 1),
1174(128, 'Venezuela', 'Bolivares Fuertes', 'VEF', 'Bs', 1, 0, 1),
1175(129, 'Vietnam', 'Dong', 'VND', '₫', 1, 0, 1),
1176(130, 'Yemen', 'Rials', 'YER', '﷼', 1, 0, 1),
1177(131, 'Zimbabwe', 'Zimbabwe Dollars', 'ZWD', 'Z$', 1, 0, 1),
1178(132, 'Bangladesh', 'Taka', 'BDT', '৳', 83, 0, 1);
1179
1180-- --------------------------------------------------------
1181
1182--
1183-- Table structure for table `download_link`
1184--
1185
1186CREATE TABLE `download_link` (
1187  `download_link_id` int(11) NOT NULL,
1188  `videos_id` int(11) DEFAULT NULL,
1189  `link_title` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1190  `resolution` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '720p',
1191  `file_size` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '00MB',
1192  `download_url` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1193  `in_app_download` tinyint(1) NOT NULL DEFAULT 0
1194) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1195
1196-- --------------------------------------------------------
1197
1198--
1199-- Table structure for table `episodes`
1200--
1201
1202CREATE TABLE `episodes` (
1203  `episodes_id` int(11) NOT NULL,
1204  `stream_key` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1205  `videos_id` int(11) DEFAULT NULL,
1206  `seasons_id` int(11) DEFAULT NULL,
1207  `episodes_name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1208  `file_source` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1209  `source_type` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1210  `file_url` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1211  `order` int(50) NOT NULL DEFAULT 0,
1212  `date_added` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
1213  `last_ep_added` datetime NOT NULL DEFAULT '2019-01-01 00:00:00'
1214) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1215
1216-- --------------------------------------------------------
1217
1218--
1219-- Table structure for table `episode_download_link`
1220--
1221
1222CREATE TABLE `episode_download_link` (
1223  `episode_download_link_id` int(11) NOT NULL,
1224  `videos_id` int(11) DEFAULT NULL,
1225  `season_id` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1226  `link_title` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1227  `resolution` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '720p',
1228  `file_size` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '00MB',
1229  `download_url` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1230  `in_app_download` tinyint(1) NOT NULL DEFAULT 0
1231) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1232
1233-- --------------------------------------------------------
1234
1235--
1236-- Table structure for table `genre`
1237--
1238
1239CREATE TABLE `genre` (
1240  `genre_id` int(11) NOT NULL,
1241  `name` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1242  `description` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1243  `slug` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1244  `publication` int(1) NOT NULL,
1245  `featured` int(2) DEFAULT 0
1246) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1247
1248--
1249-- Dumping data for table `genre`
1250--
1251
1252INSERT INTO `genre` (`genre_id`, `name`, `description`, `slug`, `publication`, `featured`) VALUES
1253(62, 'Action', 'Action Movie', 'action', 1, 1),
1254(63, 'Comedy', 'Comedy Movies', 'comedy', 1, 1),
1255(64, 'Crime', 'Crime Movies', 'crime', 1, 0),
1256(65, 'Documentary', 'Documentary Movies', 'documentary', 1, 0),
1257(66, 'Drama', '', 'drama', 1, 0),
1258(67, 'Family', 'Family', 'family', 1, 0),
1259(68, 'Fantasy', 'Fantasy Movies', 'fantasy', 1, 0),
1260(69, 'History', '', 'history', 1, 0),
1261(70, 'Horror', 'Horror Movies', 'horror', 1, 1),
1262(71, 'Thriller', '', 'thriller', 1, 1),
1263(72, ' Romance', ' Romance', 'romance', 1, 0),
1264(73, ' Adventure', ' Adventure', 'adventure', 1, 0),
1265(74, '', '', '', 1, 0);
1266
1267-- --------------------------------------------------------
1268
1269--
1270-- Table structure for table `homepage_sections`
1271--
1272
1273CREATE TABLE `homepage_sections` (
1274  `id` int(11) NOT NULL,
1275  `title` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1276  `content_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1277  `layout` tinyint(4) DEFAULT NULL,
1278  `order` tinyint(4) DEFAULT 0,
1279  `genre_id` int(11) DEFAULT NULL
1280) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1281
1282--
1283-- Dumping data for table `homepage_sections`
1284--
1285
1286INSERT INTO `homepage_sections` (`id`, `title`, `content_type`, `layout`, `order`, `genre_id`) VALUES
1287(1, 'Latest Episodes', 'latest_episodes', NULL, 10, NULL),
1288(2, 'Latest Movies', 'latest_movies', NULL, 4, NULL),
1289(3, 'Latest Series', 'latest_tvseries', NULL, 5, NULL),
1290(4, 'Popular Movies', 'popular_movies', NULL, 7, NULL),
1291(5, 'Popular Tv Series', 'popular_tv_series', NULL, 8, NULL),
1292(6, 'Live TV', 'live_tv_list', NULL, 1, NULL),
1293(7, 'Popular Actor', 'popular_actors', NULL, 2, NULL),
1294(8, 'Animation', 'genre', NULL, 3, 5);
1295
1296-- --------------------------------------------------------
1297
1298--
1299-- Table structure for table `keys`
1300--
1301
1302CREATE TABLE `keys` (
1303  `id` int(11) NOT NULL,
1304  `label` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT 'System',
1305  `key` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1306  `level` int(2) NOT NULL,
1307  `ignore_limits` tinyint(1) NOT NULL DEFAULT 0,
1308  `is_private_key` tinyint(1) NOT NULL DEFAULT 0,
1309  `ip_addresses` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1310  `date_created` int(11) NOT NULL
1311) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1312
1313--
1314-- Dumping data for table `keys`
1315--
1316
1317INSERT INTO `keys` (`id`, `label`, `key`, `level`, `ignore_limits`, `is_private_key`, `ip_addresses`, `date_created`) VALUES
1318(1, 'Default', '0334c0755f4d448', 1, 0, 0, NULL, 1582700749);
1319
1320-- --------------------------------------------------------
1321
1322--
1323-- Table structure for table `language`
1324--
1325
1326CREATE TABLE `language` (
1327  `language_id` int(11) NOT NULL,
1328  `name` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1329  `description` varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1330  `slug` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1331  `publication` int(11) NOT NULL DEFAULT 1
1332) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1333
1334--
1335-- Dumping data for table `language`
1336--
1337
1338INSERT INTO `language` (`language_id`, `name`, `description`, `slug`, `publication`) VALUES
1339(1, 'English', 'English', 'english', 1);
1340
1341-- --------------------------------------------------------
1342
1343--
1344-- Table structure for table `languages_iso`
1345--
1346
1347CREATE TABLE `languages_iso` (
1348  `id` int(10) UNSIGNED NOT NULL,
1349  `name` char(49) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1350  `iso` char(2) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
1351) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1352
1353--
1354-- Dumping data for table `languages_iso`
1355--
1356
1357INSERT INTO `languages_iso` (`id`, `name`, `iso`) VALUES
1358(1, 'English', 'en'),
1359(2, 'Afar', 'aa'),
1360(3, 'Abkhazian', 'ab'),
1361(4, 'Afrikaans', 'af'),
1362(5, 'Amharic', 'am'),
1363(6, 'Arabic', 'ar'),
1364(7, 'Assamese', 'as'),
1365(8, 'Aymara', 'ay'),
1366(9, 'Azerbaijani', 'az'),
1367(10, 'Bashkir', 'ba'),
1368(11, 'Belarusian', 'be'),
1369(12, 'Bulgarian', 'bg'),
1370(13, 'Bihari', 'bh'),
1371(14, 'Bislama', 'bi'),
1372(15, 'Bangla', 'bn'),
1373(16, 'Tibetan', 'bo'),
1374(17, 'Breton', 'br'),
1375(18, 'Catalan', 'ca'),
1376(19, 'Corsican', 'co'),
1377(20, 'Czech', 'cs'),
1378(21, 'Welsh', 'cy'),
1379(22, 'Danish', 'da'),
1380(23, 'German', 'de'),
1381(24, 'Bhutani', 'dz'),
1382(25, 'Greek', 'el'),
1383(26, 'Esperanto', 'eo'),
1384(27, 'Spanish', 'es'),
1385(28, 'Estonian', 'et'),
1386(29, 'Basque', 'eu'),
1387(30, 'Persian', 'fa'),
1388(31, 'Finnish', 'fi'),
1389(32, 'Fiji', 'fj'),
1390(33, 'Faeroese', 'fo'),
1391(34, 'French', 'fr'),
1392(35, 'Frisian', 'fy'),
1393(36, 'Irish', 'ga'),
1394(37, 'Scots/Gaelic', 'gd'),
1395(38, 'Galician', 'gl'),
1396(39, 'Guarani', 'gn'),
1397(40, 'Gujarati', 'gu'),
1398(41, 'Hausa', 'ha'),
1399(42, 'Hindi', 'hi'),
1400(43, 'Croatian', 'hr'),
1401(44, 'Hungarian', 'hu'),
1402(45, 'Armenian', 'hy'),
1403(46, 'Interlingua', 'ia'),
1404(47, 'Interlingue', 'ie'),
1405(48, 'Inupiak', 'ik'),
1406(49, 'Indonesian', 'in'),
1407(50, 'Icelandic', 'is'),
1408(51, 'Italian', 'it'),
1409(52, 'Hebrew', 'iw'),
1410(53, 'Japanese', 'ja'),
1411(54, 'Yiddish', 'ji'),
1412(55, 'Javanese', 'jw'),
1413(56, 'Georgian', 'ka'),
1414(57, 'Kazakh', 'kk'),
1415(58, 'Greenlandic', 'kl'),
1416(59, 'Cambodian', 'km'),
1417(60, 'Kannada', 'kn'),
1418(61, 'Korean', 'ko'),
1419(62, 'Kashmiri', 'ks'),
1420(63, 'Kurdish', 'ku'),
1421(64, 'Kirghiz', 'ky'),
1422(65, 'Latin', 'la'),
1423(66, 'Lingala', 'ln'),
1424(67, 'Laothian', 'lo'),
1425(68, 'Lithuanian', 'lt'),
1426(69, 'Latvian/Lettish', 'lv'),
1427(70, 'Malagasy', 'mg'),
1428(71, 'Maori', 'mi'),
1429(72, 'Macedonian', 'mk'),
1430(73, 'Malayalam', 'ml'),
1431(74, 'Mongolian', 'mn'),
1432(75, 'Moldavian', 'mo'),
1433(76, 'Marathi', 'mr'),
1434(77, 'Malay', 'ms'),
1435(78, 'Maltese', 'mt'),
1436(79, 'Burmese', 'my'),
1437(80, 'Nauru', 'na'),
1438(81, 'Nepali', 'ne'),
1439(82, 'Dutch', 'nl'),
1440(83, 'Norwegian', 'no'),
1441(84, 'Occitan', 'oc'),
1442(85, '(Afan)/Oromoor/Oriya', 'om'),
1443(86, 'Punjabi', 'pa'),
1444(87, 'Polish', 'pl'),
1445(88, 'Pashto/Pushto', 'ps'),
1446(89, 'Portuguese', 'pt'),
1447(90, 'Quechua', 'qu'),
1448(91, 'Rhaeto-Romance', 'rm'),
1449(92, 'Kirundi', 'rn'),
1450(93, 'Romanian', 'ro'),
1451(94, 'Russian', 'ru'),
1452(95, 'Kinyarwanda', 'rw'),
1453(96, 'Sanskrit', 'sa'),
1454(97, 'Sindhi', 'sd'),
1455(98, 'Sangro', 'sg'),
1456(99, 'Serbo-Croatian', 'sh'),
1457(100, 'Singhalese', 'si'),
1458(101, 'Slovak', 'sk'),
1459(102, 'Slovenian', 'sl'),
1460(103, 'Samoan', 'sm'),
1461(104, 'Shona', 'sn'),
1462(105, 'Somali', 'so'),
1463(106, 'Albanian', 'sq'),
1464(107, 'Serbian', 'sr'),
1465(108, 'Siswati', 'ss'),
1466(109, 'Sesotho', 'st'),
1467(110, 'Sundanese', 'su'),
1468(111, 'Swedish', 'sv'),
1469(112, 'Swahili', 'sw'),
1470(113, 'Tamil', 'ta'),
1471(114, 'Telugu', 'te'),
1472(115, 'Tajik', 'tg'),
1473(116, 'Thai', 'th'),
1474(117, 'Tigrinya', 'ti'),
1475(118, 'Turkmen', 'tk'),
1476(119, 'Tagalog', 'tl'),
1477(120, 'Setswana', 'tn'),
1478(121, 'Tonga', 'to'),
1479(122, 'Turkish', 'tr'),
1480(123, 'Tsonga', 'ts'),
1481(124, 'Tatar', 'tt'),
1482(125, 'Twi', 'tw'),
1483(126, 'Ukrainian', 'uk'),
1484(127, 'Urdu', 'ur'),
1485(128, 'Uzbek', 'uz'),
1486(129, 'Vietnamese', 'vi'),
1487(130, 'Volapuk', 'vo'),
1488(131, 'Wolof', 'wo'),
1489(132, 'Xhosa', 'xh'),
1490(133, 'Yoruba', 'yo'),
1491(134, 'Chinese', 'zh'),
1492(135, 'Zulu', 'zu');
1493
1494-- --------------------------------------------------------
1495
1496--
1497-- Table structure for table `language_list`
1498--
1499
1500CREATE TABLE `language_list` (
1501  `id` int(11) NOT NULL,
1502  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1503  `short_form` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1504  `language_code` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1505  `folder_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1506  `text_direction` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1507  `status` int(11) NOT NULL DEFAULT 1,
1508  `language_order` int(11) NOT NULL DEFAULT 1
1509) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1510
1511--
1512-- Dumping data for table `language_list`
1513--
1514
1515INSERT INTO `language_list` (`id`, `name`, `short_form`, `language_code`, `folder_name`, `text_direction`, `status`, `language_order`) VALUES
1516(1, 'English', 'en', 'en_us', 'english', 'ltr', 1, 1);
1517
1518-- --------------------------------------------------------
1519
1520--
1521-- Table structure for table `live_tv`
1522--
1523
1524CREATE TABLE `live_tv` (
1525  `live_tv_id` int(11) NOT NULL,
1526  `tv_name` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1527  `seo_title` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1528  `live_tv_category_id` int(50) DEFAULT NULL,
1529  `slug` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1530  `language` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT 'en',
1531  `stream_from` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1532  `stream_label` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1533  `stream_url` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1534  `poster` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1535  `thumbnail` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1536  `focus_keyword` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1537  `meta_description` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1538  `featured` int(2) DEFAULT 1,
1539  `is_paid` int(5) NOT NULL DEFAULT 1,
1540  `tags` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1541  `description` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1542  `publish` int(10) UNSIGNED DEFAULT 0
1543) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1544
1545-- --------------------------------------------------------
1546
1547--
1548-- Table structure for table `live_tv_category`
1549--
1550
1551CREATE TABLE `live_tv_category` (
1552  `live_tv_category_id` int(11) NOT NULL,
1553  `live_tv_category` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1554  `slug` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1555  `live_tv_category_desc` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1556  `status` int(11) DEFAULT 1
1557) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1558
1559--
1560-- Dumping data for table `live_tv_category`
1561--
1562
1563INSERT INTO `live_tv_category` (`live_tv_category_id`, `live_tv_category`, `slug`, `live_tv_category_desc`, `status`) VALUES
1564(1, 'TEST', 'test', 'TEST', 1);
1565
1566-- --------------------------------------------------------
1567
1568--
1569-- Table structure for table `live_tv_url`
1570--
1571
1572CREATE TABLE `live_tv_url` (
1573  `live_tv_url_id` int(11) NOT NULL,
1574  `stream_key` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1575  `live_tv_id` int(11) DEFAULT NULL,
1576  `url_for` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1577  `source` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1578  `label` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1579  `quality` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1580  `url` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
1581) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1582
1583--
1584-- Dumping data for table `live_tv_url`
1585--
1586
1587-- --------------------------------------------------------
1588
1589--
1590-- Table structure for table `logs`
1591--
1592
1593CREATE TABLE `logs` (
1594  `id` int(11) NOT NULL,
1595  `uri` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1596  `method` varchar(6) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1597  `params` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1598  `api_key` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1599  `ip_address` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1600  `time` int(11) NOT NULL,
1601  `rtime` float DEFAULT NULL,
1602  `authorized` varchar(1) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1603  `response_code` smallint(3) DEFAULT 0
1604) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1605
1606-- --------------------------------------------------------
1607
1608--
1609-- Table structure for table `page`
1610--
1611
1612CREATE TABLE `page` (
1613  `page_id` int(11) NOT NULL,
1614  `page_title` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1615  `seo_title` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1616  `slug` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1617  `content` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1618  `primary_menu` int(10) DEFAULT 0,
1619  `footer_menu` int(10) DEFAULT 0,
1620  `focus_keyword` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1621  `meta_description` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1622  `publication` int(11) DEFAULT 1,
1623  `publish_at` datetime DEFAULT NULL,
1624  `deletable` int(1) NOT NULL DEFAULT 1
1625) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1626
1627-- --------------------------------------------------------
1628
1629--
1630-- Table structure for table `plan`
1631--
1632
1633CREATE TABLE `plan` (
1634  `plan_id` int(11) NOT NULL,
1635  `name` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1636  `day` int(50) DEFAULT 0,
1637  `screens` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1638  `price` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1639  `status` int(11) NOT NULL
1640) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1641
1642--
1643-- Dumping data for table `plan`
1644--
1645
1646INSERT INTO `plan` (`plan_id`, `name`, `day`, `screens`, `price`, `status`) VALUES
1647(1, 'Basic', 7, NULL, '5', 1),
1648(2, 'Professional ', 30, NULL, '10', 1),
1649(3, 'Ultra', 90, NULL, '20', 1);
1650
1651-- --------------------------------------------------------
1652
1653--
1654-- Table structure for table `posts`
1655--
1656
1657CREATE TABLE `posts` (
1658  `posts_id` int(11) NOT NULL,
1659  `post_title` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1660  `seo_title` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1661  `slug` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1662  `focus_keyword` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1663  `meta_description` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1664  `category_id` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1665  `content` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1666  `image_link` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1667  `user_id` int(20) DEFAULT 1,
1668  `post_at` datetime DEFAULT NULL,
1669  `publication` int(11) DEFAULT 1
1670) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1671
1672-- --------------------------------------------------------
1673
1674--
1675-- Table structure for table `post_category`
1676--
1677
1678CREATE TABLE `post_category` (
1679  `post_category_id` int(11) NOT NULL,
1680  `category` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1681  `slug` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1682  `category_desc` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
1683) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1684
1685-- --------------------------------------------------------
1686
1687--
1688-- Table structure for table `post_comments`
1689--
1690
1691CREATE TABLE `post_comments` (
1692  `post_comments_id` int(20) NOT NULL,
1693  `user_id` int(10) NOT NULL,
1694  `post_id` int(20) NOT NULL,
1695  `comment_type` int(5) NOT NULL DEFAULT 1,
1696  `replay_for` int(10) DEFAULT 0,
1697  `comment` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1698  `comment_at` datetime DEFAULT NULL,
1699  `publication` int(5) DEFAULT 1
1700) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1701
1702-- --------------------------------------------------------
1703
1704--
1705-- Table structure for table `quality`
1706--
1707
1708CREATE TABLE `quality` (
1709  `quality_id` int(10) NOT NULL,
1710  `quality` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1711  `description` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1712  `status` int(5) DEFAULT 1
1713) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1714
1715--
1716-- Dumping data for table `quality`
1717--
1718
1719INSERT INTO `quality` (`quality_id`, `quality`, `description`, `status`) VALUES
1720(1, '4K', 'High Defination', 1),
1721(2, 'HD', 'Sandard Defination', 1),
1722(3, 'SD', 'Ultra High Defination', 1),
1723(4, 'CAM', 'Web Camera Video', 1),
1724(7, 'LQ', 'Low Quality', 1),
1725(8, 'DVD', 'Digital Video Device', 1);
1726
1727-- --------------------------------------------------------
1728
1729--
1730-- Table structure for table `rating`
1731--
1732
1733CREATE TABLE `rating` (
1734  `rating_id` int(50) NOT NULL,
1735  `video_id` int(11) NOT NULL,
1736  `ip` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1737  `rating` int(5) DEFAULT NULL,
1738  `datetime` datetime DEFAULT NULL
1739) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1740
1741-- --------------------------------------------------------
1742
1743--
1744-- Table structure for table `report`
1745--
1746
1747CREATE TABLE `report` (
1748  `report_id` int(11) NOT NULL,
1749  `type` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1750  `id` int(50) DEFAULT NULL,
1751  `issue` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1752  `report_datetime` datetime DEFAULT current_timestamp(),
1753  `message` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1754  `status` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending'
1755) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1756
1757-- --------------------------------------------------------
1758
1759--
1760-- Table structure for table `request`
1761--
1762
1763CREATE TABLE `request` (
1764  `request_id` int(11) NOT NULL,
1765  `name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1766  `email` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1767  `movie_name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1768  `message` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1769  `request_datetime` datetime DEFAULT current_timestamp(),
1770  `status` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending'
1771) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1772
1773-- --------------------------------------------------------
1774
1775--
1776-- Table structure for table `rest_logins`
1777--
1778
1779CREATE TABLE `rest_logins` (
1780  `id` int(11) NOT NULL,
1781  `username` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1782  `password` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1783  `status` int(11) NOT NULL DEFAULT 1
1784) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1785
1786--
1787-- Dumping data for table `rest_logins`
1788--
1789
1790INSERT INTO `rest_logins` (`id`, `username`, `password`, `status`) VALUES
1791(1, 'admin', 'e9b40ee66261f01', 1);
1792
1793-- --------------------------------------------------------
1794
1795--
1796-- Table structure for table `seasons`
1797--
1798
1799CREATE TABLE `seasons` (
1800  `seasons_id` int(11) NOT NULL,
1801  `videos_id` int(11) DEFAULT NULL,
1802  `seasons_name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1803  `order` int(50) NOT NULL DEFAULT 0,
1804  `publish` int(11) DEFAULT 1
1805) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1806
1807-- --------------------------------------------------------
1808
1809--
1810-- Table structure for table `slider`
1811--
1812
1813CREATE TABLE `slider` (
1814  `slider_id` int(11) NOT NULL,
1815  `title` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1816  `description` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1817  `video_link` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1818  `image_link` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1819  `slug` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1820  `action_type` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1821  `action_btn_text` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1822  `action_id` int(50) DEFAULT NULL,
1823  `action_url` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1824  `order` int(50) NOT NULL DEFAULT 0,
1825  `publication` int(1) NOT NULL
1826) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1827
1828-- --------------------------------------------------------
1829
1830--
1831-- Table structure for table `star`
1832--
1833
1834CREATE TABLE `star` (
1835  `star_id` int(10) NOT NULL,
1836  `star_type` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1837  `star_name` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
1838  `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1839  `star_desc` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1840  `view` int(11) NOT NULL DEFAULT 1,
1841  `status` int(11) NOT NULL DEFAULT 1
1842) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1843
1844-- --------------------------------------------------------
1845
1846--
1847-- Table structure for table `subscription`
1848--
1849
1850CREATE TABLE `subscription` (
1851  `subscription_id` int(50) NOT NULL,
1852  `plan_id` int(50) NOT NULL,
1853  `user_id` int(50) NOT NULL,
1854  `price_amount` double NOT NULL,
1855  `paid_amount` float NOT NULL,
1856  `currency` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'USD',
1857  `timestamp_from` int(50) NOT NULL,
1858  `timestamp_to` int(50) NOT NULL,
1859  `payment_method` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1860  `transaction_id` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1861  `payment_info` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1862  `payment_timestamp` int(50) NOT NULL,
1863  `recurring` int(10) NOT NULL DEFAULT 1,
1864  `status` int(5) NOT NULL DEFAULT 1
1865) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1866
1867-- --------------------------------------------------------
1868
1869--
1870-- Table structure for table `subtitle`
1871--
1872
1873CREATE TABLE `subtitle` (
1874  `subtitle_id` int(11) NOT NULL,
1875  `videos_id` int(50) NOT NULL,
1876  `video_file_id` int(50) DEFAULT NULL,
1877  `language` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1878  `kind` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1879  `src` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1880  `srclang` varchar(5) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1881  `common` int(2) DEFAULT 0,
1882  `status` int(2) DEFAULT 1
1883) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1884
1885-- --------------------------------------------------------
1886
1887--
1888-- Table structure for table `tvseries_subtitle`
1889--
1890
1891CREATE TABLE `tvseries_subtitle` (
1892  `tvseries_subtitle_id` int(11) NOT NULL,
1893  `videos_id` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1894  `episodes_id` int(250) DEFAULT NULL,
1895  `language` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1896  `kind` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1897  `src` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1898  `srclang` varchar(5) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1899  `common` int(2) DEFAULT 0,
1900  `status` int(2) DEFAULT 1
1901) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1902
1903-- --------------------------------------------------------
1904
1905--
1906-- Table structure for table `user`
1907--
1908
1909CREATE TABLE `user` (
1910  `user_id` int(11) NOT NULL,
1911  `name` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1912  `slug` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1913  `username` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1914  `email` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1915  `is_password_set` int(5) NOT NULL DEFAULT 0 COMMENT '0 = unknown, 1=set, 2 =unset',
1916  `password` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1917  `gender` int(2) DEFAULT 1,
1918  `role` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1919  `token` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1920  `theme` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'default',
1921  `theme_color` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT '#16163F',
1922  `join_date` datetime DEFAULT NULL,
1923  `last_login` datetime DEFAULT NULL,
1924  `deactivate_reason` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1925  `phone` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1926  `dob` date DEFAULT '0000-00-00',
1927  `firebase_auth_uid` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1928  `status` int(10) NOT NULL DEFAULT 1
1929) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1930
1931--
1932-- Dumping data for table `user`
1933--
1934
1935INSERT INTO `user` (`user_id`, `name`, `slug`, `username`, `email`, `is_password_set`, `password`, `gender`, `role`, `token`, `theme`, `theme_color`, `join_date`, `last_login`, `deactivate_reason`, `phone`, `dob`, `firebase_auth_uid`, `status`) VALUES
1936(1, 'TRC4 SXT', '', 'trc4@usa.com', 'trc4@usa.com', 0, 'e10adc3949ba59abbe56e057f20f883e', 1, 'admin', NULL, 'default', '#16163F', '2023-10-23 12:57:18', '2023-10-23 14:07:03', NULL, NULL, '0000-00-00', NULL, 1);
1937
1938-- --------------------------------------------------------
1939
1940--
1941-- Table structure for table `videos`
1942--
1943
1944CREATE TABLE `videos` (
1945  `videos_id` int(11) NOT NULL,
1946  `imdbid` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1947  `tmdbid` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1948  `title` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1949  `seo_title` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1950  `slug` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1951  `description` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1952  `stars` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
1953  `director` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1954  `writer` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1955  `rating` varchar(5) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',
1956  `release` varchar(25) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1957  `country` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1958  `genre` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1959  `language` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1960  `video_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1961  `runtime` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1962  `video_quality` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT 'HD',
1963  `is_paid` int(5) NOT NULL DEFAULT 1,
1964  `publication` int(5) DEFAULT NULL,
1965  `trailer` int(5) DEFAULT 0,
1966  `trailler_youtube_source` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1967  `enable_download` int(5) DEFAULT 1,
1968  `focus_keyword` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1969  `meta_description` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1970  `tags` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1971  `imdb_rating` varchar(5) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1972  `is_tvseries` int(11) NOT NULL DEFAULT 0,
1973  `total_rating` int(50) DEFAULT 1,
1974  `today_view` int(250) DEFAULT 0,
1975  `weekly_view` int(250) DEFAULT 0,
1976  `monthly_view` int(250) DEFAULT 0,
1977  `total_view` int(250) DEFAULT 1,
1978  `last_ep_added` datetime DEFAULT '2019-04-04 00:00:00'
1979) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1980
1981
1982-- --------------------------------------------------------
1983
1984--
1985-- Table structure for table `video_file`
1986--
1987
1988CREATE TABLE `video_file` (
1989  `video_file_id` int(11) NOT NULL,
1990  `stream_key` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1991  `videos_id` int(11) DEFAULT NULL,
1992  `file_source` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1993  `source_type` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1994  `file_url` varchar(500) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1995  `label` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Server#1',
1996  `order` int(50) NOT NULL DEFAULT 0
1997) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
1998
1999-- --------------------------------------------------------
2000
2001--
2002-- Table structure for table `video_type`
2003--
2004
2005CREATE TABLE `video_type` (
2006  `video_type_id` int(11) NOT NULL,
2007  `video_type` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
2008  `video_type_desc` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
2009  `primary_menu` int(11) DEFAULT NULL,
2010  `footer_menu` int(11) DEFAULT NULL,
2011  `slug` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
2012) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
2013
2014--
2015-- Dumping data for table `video_type`
2016--
2017
2018INSERT INTO `video_type` (`video_type_id`, `video_type`, `video_type_desc`, `primary_menu`, `footer_menu`, `slug`) VALUES
2019(1, 'Trending', '', NULL, NULL, 'trending'),
2020(2, 'Trending2', '', NULL, NULL, 'trending2');
2021
2022-- --------------------------------------------------------
2023
2024--
2025-- Table structure for table `wish_list`
2026--
2027
2028CREATE TABLE `wish_list` (
2029  `wish_list_id` int(11) NOT NULL,
2030  `wish_list_type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
2031  `user_id` int(11) DEFAULT NULL,
2032  `videos_id` int(11) DEFAULT NULL,
2033  `create_at` datetime DEFAULT NULL,
2034  `status` int(11) DEFAULT 1
2035) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
2036
2037--
2038-- Indexes for dumped tables
2039--
2040
2041--
2042-- Indexes for table `ads`
2043--
2044ALTER TABLE `ads`
2045  ADD PRIMARY KEY (`ads_id`);
2046
2047--
2048-- Indexes for table `calendar`
2049--
2050ALTER TABLE `calendar`
2051  ADD PRIMARY KEY (`timezone`);
2052
2053--
2054-- Indexes for table `ci_sessions`
2055--
2056ALTER TABLE `ci_sessions`
2057  ADD KEY `ci_sessions_timestamp` (`timestamp`);
2058
2059--
2060-- Indexes for table `comments`
2061--
2062ALTER TABLE `comments`
2063  ADD PRIMARY KEY (`comments_id`);
2064
2065--
2066-- Indexes for table `config`
2067--
2068ALTER TABLE `config`
2069  ADD PRIMARY KEY (`config_id`);
2070
2071--
2072-- Indexes for table `country`
2073--
2074ALTER TABLE `country`
2075  ADD PRIMARY KEY (`country_id`);
2076
2077--
2078-- Indexes for table `cron`
2079--
2080ALTER TABLE `cron`
2081  ADD PRIMARY KEY (`cron_id`);
2082
2083--
2084-- Indexes for table `currency`
2085--
2086ALTER TABLE `currency`
2087  ADD PRIMARY KEY (`currency_id`);
2088
2089--
2090-- Indexes for table `download_link`
2091--
2092ALTER TABLE `download_link`
2093  ADD PRIMARY KEY (`download_link_id`);
2094
2095--
2096-- Indexes for table `episodes`
2097--
2098ALTER TABLE `episodes`
2099  ADD PRIMARY KEY (`episodes_id`);
2100
2101--
2102-- Indexes for table `episode_download_link`
2103--
2104ALTER TABLE `episode_download_link`
2105  ADD PRIMARY KEY (`episode_download_link_id`);
2106
2107--
2108-- Indexes for table `genre`
2109--
2110ALTER TABLE `genre`
2111  ADD PRIMARY KEY (`genre_id`);
2112
2113--
2114-- Indexes for table `homepage_sections`
2115--
2116ALTER TABLE `homepage_sections`
2117  ADD PRIMARY KEY (`id`);
2118
2119--
2120-- Indexes for table `keys`
2121--
2122ALTER TABLE `keys`
2123  ADD PRIMARY KEY (`id`);
2124
2125--
2126-- Indexes for table `languages_iso`
2127--
2128ALTER TABLE `languages_iso`
2129  ADD PRIMARY KEY (`id`);
2130
2131--
2132-- Indexes for table `language_list`
2133--
2134ALTER TABLE `language_list`
2135  ADD PRIMARY KEY (`id`);
2136
2137--
2138-- Indexes for table `live_tv`
2139--
2140ALTER TABLE `live_tv`
2141  ADD PRIMARY KEY (`live_tv_id`);
2142
2143--
2144-- Indexes for table `live_tv_category`
2145--
2146ALTER TABLE `live_tv_category`
2147  ADD PRIMARY KEY (`live_tv_category_id`);
2148
2149--
2150-- Indexes for table `live_tv_url`
2151--
2152ALTER TABLE `live_tv_url`
2153  ADD PRIMARY KEY (`live_tv_url_id`);
2154
2155--
2156-- Indexes for table `page`
2157--
2158ALTER TABLE `page`
2159  ADD PRIMARY KEY (`page_id`);
2160
2161--
2162-- Indexes for table `plan`
2163--
2164ALTER TABLE `plan`
2165  ADD PRIMARY KEY (`plan_id`);
2166
2167--
2168-- Indexes for table `posts`
2169--
2170ALTER TABLE `posts`
2171  ADD PRIMARY KEY (`posts_id`);
2172
2173--
2174-- Indexes for table `post_category`
2175--
2176ALTER TABLE `post_category`
2177  ADD PRIMARY KEY (`post_category_id`);
2178
2179--
2180-- Indexes for table `post_comments`
2181--
2182ALTER TABLE `post_comments`
2183  ADD PRIMARY KEY (`post_comments_id`);
2184
2185--
2186-- Indexes for table `quality`
2187--
2188ALTER TABLE `quality`
2189  ADD PRIMARY KEY (`quality_id`);
2190
2191--
2192-- Indexes for table `rating`
2193--
2194ALTER TABLE `rating`
2195  ADD PRIMARY KEY (`rating_id`);
2196
2197--
2198-- Indexes for table `report`
2199--
2200ALTER TABLE `report`
2201  ADD PRIMARY KEY (`report_id`);
2202
2203--
2204-- Indexes for table `request`
2205--
2206ALTER TABLE `request`
2207  ADD PRIMARY KEY (`request_id`);
2208
2209--
2210-- Indexes for table `rest_logins`
2211--
2212ALTER TABLE `rest_logins`
2213  ADD PRIMARY KEY (`id`);
2214
2215--
2216-- Indexes for table `seasons`
2217--
2218ALTER TABLE `seasons`
2219  ADD PRIMARY KEY (`seasons_id`);
2220
2221--
2222-- Indexes for table `slider`
2223--
2224ALTER TABLE `slider`
2225  ADD PRIMARY KEY (`slider_id`);
2226
2227--
2228-- Indexes for table `star`
2229--
2230ALTER TABLE `star`
2231  ADD PRIMARY KEY (`star_id`);
2232
2233--
2234-- Indexes for table `subscription`
2235--
2236ALTER TABLE `subscription`
2237  ADD PRIMARY KEY (`subscription_id`);
2238
2239--
2240-- Indexes for table `subtitle`
2241--
2242ALTER TABLE `subtitle`
2243  ADD PRIMARY KEY (`subtitle_id`);
2244
2245--
2246-- Indexes for table `tvseries_subtitle`
2247--
2248ALTER TABLE `tvseries_subtitle`
2249  ADD PRIMARY KEY (`tvseries_subtitle_id`);
2250
2251--
2252-- Indexes for table `user`
2253--
2254ALTER TABLE `user`
2255  ADD PRIMARY KEY (`user_id`);
2256
2257--
2258-- Indexes for table `videos`
2259--
2260ALTER TABLE `videos`
2261  ADD PRIMARY KEY (`videos_id`);
2262
2263--
2264-- Indexes for table `video_file`
2265--
2266ALTER TABLE `video_file`
2267  ADD PRIMARY KEY (`video_file_id`);
2268
2269--
2270-- Indexes for table `video_type`
2271--
2272ALTER TABLE `video_type`
2273  ADD PRIMARY KEY (`video_type_id`);
2274
2275--
2276-- Indexes for table `wish_list`
2277--
2278ALTER TABLE `wish_list`
2279  ADD PRIMARY KEY (`wish_list_id`);
2280
2281--
2282-- AUTO_INCREMENT for dumped tables
2283--
2284
2285--
2286-- AUTO_INCREMENT for table `ads`
2287--
2288ALTER TABLE `ads`
2289  MODIFY `ads_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
2290
2291--
2292-- AUTO_INCREMENT for table `comments`
2293--
2294ALTER TABLE `comments`
2295  MODIFY `comments_id` int(20) NOT NULL AUTO_INCREMENT;
2296
2297--
2298-- AUTO_INCREMENT for table `config`
2299--
2300ALTER TABLE `config`
2301  MODIFY `config_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;
2302
2303--
2304-- AUTO_INCREMENT for table `country`
2305--
2306ALTER TABLE `country`
2307  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;
2308
2309--
2310-- AUTO_INCREMENT for table `cron`
2311--
2312ALTER TABLE `cron`
2313  MODIFY `cron_id` int(11) NOT NULL AUTO_INCREMENT;
2314
2315--
2316-- AUTO_INCREMENT for table `currency`
2317--
2318ALTER TABLE `currency`
2319  MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133;
2320
2321--
2322-- AUTO_INCREMENT for table `download_link`
2323--
2324ALTER TABLE `download_link`
2325  MODIFY `download_link_id` int(11) NOT NULL AUTO_INCREMENT;
2326
2327--
2328-- AUTO_INCREMENT for table `episodes`
2329--
2330ALTER TABLE `episodes`
2331  MODIFY `episodes_id` int(11) NOT NULL AUTO_INCREMENT;
2332
2333--
2334-- AUTO_INCREMENT for table `episode_download_link`
2335--
2336ALTER TABLE `episode_download_link`
2337  MODIFY `episode_download_link_id` int(11) NOT NULL AUTO_INCREMENT;
2338
2339--
2340-- AUTO_INCREMENT for table `genre`
2341--
2342ALTER TABLE `genre`
2343  MODIFY `genre_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;
2344
2345--
2346-- AUTO_INCREMENT for table `homepage_sections`
2347--
2348ALTER TABLE `homepage_sections`
2349  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
2350
2351--
2352-- AUTO_INCREMENT for table `keys`
2353--
2354ALTER TABLE `keys`
2355  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
2356
2357--
2358-- AUTO_INCREMENT for table `languages_iso`
2359--
2360ALTER TABLE `languages_iso`
2361  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;
2362
2363--
2364-- AUTO_INCREMENT for table `language_list`
2365--
2366ALTER TABLE `language_list`
2367  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
2368
2369--
2370-- AUTO_INCREMENT for table `live_tv`
2371--
2372ALTER TABLE `live_tv`
2373  MODIFY `live_tv_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
2374
2375--
2376-- AUTO_INCREMENT for table `live_tv_category`
2377--
2378ALTER TABLE `live_tv_category`
2379  MODIFY `live_tv_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
2380
2381--
2382-- AUTO_INCREMENT for table `live_tv_url`
2383--
2384ALTER TABLE `live_tv_url`
2385  MODIFY `live_tv_url_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
2386
2387--
2388-- AUTO_INCREMENT for table `page`
2389--
2390ALTER TABLE `page`
2391  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT;
2392
2393--
2394-- AUTO_INCREMENT for table `plan`
2395--
2396ALTER TABLE `plan`
2397  MODIFY `plan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
2398
2399--
2400-- AUTO_INCREMENT for table `posts`
2401--
2402ALTER TABLE `posts`
2403  MODIFY `posts_id` int(11) NOT NULL AUTO_INCREMENT;
2404
2405--
2406-- AUTO_INCREMENT for table `post_category`
2407--
2408ALTER TABLE `post_category`
2409  MODIFY `post_category_id` int(11) NOT NULL AUTO_INCREMENT;
2410
2411--
2412-- AUTO_INCREMENT for table `post_comments`
2413--
2414ALTER TABLE `post_comments`
2415  MODIFY `post_comments_id` int(20) NOT NULL AUTO_INCREMENT;
2416
2417--
2418-- AUTO_INCREMENT for table `quality`
2419--
2420ALTER TABLE `quality`
2421  MODIFY `quality_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
2422
2423--
2424-- AUTO_INCREMENT for table `rating`
2425--
2426ALTER TABLE `rating`
2427  MODIFY `rating_id` int(50) NOT NULL AUTO_INCREMENT;
2428
2429--
2430-- AUTO_INCREMENT for table `report`
2431--
2432ALTER TABLE `report`
2433  MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT;
2434
2435--
2436-- AUTO_INCREMENT for table `request`
2437--
2438ALTER TABLE `request`
2439  MODIFY `request_id` int(11) NOT NULL AUTO_INCREMENT;
2440
2441--
2442-- AUTO_INCREMENT for table `rest_logins`
2443--
2444ALTER TABLE `rest_logins`
2445  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
2446
2447--
2448-- AUTO_INCREMENT for table `seasons`
2449--
2450ALTER TABLE `seasons`
2451  MODIFY `seasons_id` int(11) NOT NULL AUTO_INCREMENT;
2452
2453--
2454-- AUTO_INCREMENT for table `slider`
2455--
2456ALTER TABLE `slider`
2457  MODIFY `slider_id` int(11) NOT NULL AUTO_INCREMENT;
2458
2459--
2460-- AUTO_INCREMENT for table `star`
2461--
2462ALTER TABLE `star`
2463  MODIFY `star_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
2464
2465--
2466-- AUTO_INCREMENT for table `subscription`
2467--
2468ALTER TABLE `subscription`
2469  MODIFY `subscription_id` int(50) NOT NULL AUTO_INCREMENT;
2470
2471--
2472-- AUTO_INCREMENT for table `subtitle`
2473--
2474ALTER TABLE `subtitle`
2475  MODIFY `subtitle_id` int(11) NOT NULL AUTO_INCREMENT;
2476
2477--
2478-- AUTO_INCREMENT for table `tvseries_subtitle`
2479--
2480ALTER TABLE `tvseries_subtitle`
2481  MODIFY `tvseries_subtitle_id` int(11) NOT NULL AUTO_INCREMENT;
2482
2483--
2484-- AUTO_INCREMENT for table `user`
2485--
2486ALTER TABLE `user`
2487  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
2488
2489--
2490-- AUTO_INCREMENT for table `videos`
2491--
2492ALTER TABLE `videos`
2493  MODIFY `videos_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
2494
2495--
2496-- AUTO_INCREMENT for table `video_file`
2497--
2498ALTER TABLE `video_file`
2499  MODIFY `video_file_id` int(11) NOT NULL AUTO_INCREMENT;
2500
2501--
2502-- AUTO_INCREMENT for table `video_type`
2503--
2504ALTER TABLE `video_type`
2505  MODIFY `video_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
2506
2507--
2508-- AUTO_INCREMENT for table `wish_list`
2509--
2510ALTER TABLE `wish_list`
2511  MODIFY `wish_list_id` int(11) NOT NULL AUTO_INCREMENT;
2512COMMIT;
2513
2514/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2515/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2516/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2517