API tools faq
paste
Advertisement
s4m33r789

ovoo-v3.4

s4m33r789
Jun 28th, 2025
360
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 114.50 KB | Source Code | 0 0
raw download clone embed print report
  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.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. START TRANSACTION;
  12. SET 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.  
  30. CREATE 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.  
  46. INSERT 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.  
  66. CREATE 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.  
  80. INSERT 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.  
  636. CREATE 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.  
  647. INSERT 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.  
  656. CREATE 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.  
  673. CREATE 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.  
  683. INSERT 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', '[email protected]'),
  690. (7, 'system_email', '[email protected]'),
  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', '[email protected]'),
  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', '[email protected]'),
  817. (136, 'movie_request_enable', '1'),
  818. (137, 'movie_request_email', '[email protected]'),
  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', '[email protected]'),
  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.  
  918. CREATE 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.  
  930. INSERT 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.  
  1011. CREATE 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.  
  1031. CREATE 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.  
  1046. INSERT 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.  
  1186. CREATE 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.  
  1202. CREATE 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.  
  1222. CREATE 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.  
  1239. CREATE 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.  
  1252. INSERT 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.  
  1273. CREATE 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.  
  1286. INSERT 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.  
  1302. CREATE 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.  
  1317. INSERT 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.  
  1326. CREATE 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.  
  1338. INSERT 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.  
  1347. CREATE 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.  
  1357. INSERT 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.  
  1500. CREATE 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.  
  1515. INSERT 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.  
  1524. CREATE 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.  
  1551. CREATE 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.  
  1563. INSERT 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.  
  1572. CREATE 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.  
  1593. CREATE 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.  
  1612. CREATE 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.  
  1633. CREATE 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.  
  1646. INSERT 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.  
  1657. CREATE 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.  
  1678. CREATE 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.  
  1691. CREATE 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.  
  1708. CREATE 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.  
  1719. INSERT 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.  
  1733. CREATE 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.  
  1747. CREATE 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.  
  1763. CREATE 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.  
  1779. CREATE 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.  
  1790. INSERT 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.  
  1799. CREATE 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.  
  1813. CREATE 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.  
  1834. CREATE 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.  
  1850. CREATE 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.  
  1873. CREATE 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.  
  1891. CREATE 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.  
  1909. CREATE 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.  
  1935. INSERT 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', '', '[email protected]', '[email protected]', 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.  
  1944. CREATE 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.  
  1988. CREATE 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.  
  2005. CREATE 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.  
  2018. INSERT 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.  
  2028. CREATE 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. --
  2044. ALTER TABLE `ads`
  2045.   ADD PRIMARY KEY (`ads_id`);
  2046.  
  2047. --
  2048. -- Indexes for table `calendar`
  2049. --
  2050. ALTER TABLE `calendar`
  2051.   ADD PRIMARY KEY (`timezone`);
  2052.  
  2053. --
  2054. -- Indexes for table `ci_sessions`
  2055. --
  2056. ALTER TABLE `ci_sessions`
  2057.   ADD KEY `ci_sessions_timestamp` (`timestamp`);
  2058.  
  2059. --
  2060. -- Indexes for table `comments`
  2061. --
  2062. ALTER TABLE `comments`
  2063.   ADD PRIMARY KEY (`comments_id`);
  2064.  
  2065. --
  2066. -- Indexes for table `config`
  2067. --
  2068. ALTER TABLE `config`
  2069.   ADD PRIMARY KEY (`config_id`);
  2070.  
  2071. --
  2072. -- Indexes for table `country`
  2073. --
  2074. ALTER TABLE `country`
  2075.   ADD PRIMARY KEY (`country_id`);
  2076.  
  2077. --
  2078. -- Indexes for table `cron`
  2079. --
  2080. ALTER TABLE `cron`
  2081.   ADD PRIMARY KEY (`cron_id`);
  2082.  
  2083. --
  2084. -- Indexes for table `currency`
  2085. --
  2086. ALTER TABLE `currency`
  2087.   ADD PRIMARY KEY (`currency_id`);
  2088.  
  2089. --
  2090. -- Indexes for table `download_link`
  2091. --
  2092. ALTER TABLE `download_link`
  2093.   ADD PRIMARY KEY (`download_link_id`);
  2094.  
  2095. --
  2096. -- Indexes for table `episodes`
  2097. --
  2098. ALTER TABLE `episodes`
  2099.   ADD PRIMARY KEY (`episodes_id`);
  2100.  
  2101. --
  2102. -- Indexes for table `episode_download_link`
  2103. --
  2104. ALTER TABLE `episode_download_link`
  2105.   ADD PRIMARY KEY (`episode_download_link_id`);
  2106.  
  2107. --
  2108. -- Indexes for table `genre`
  2109. --
  2110. ALTER TABLE `genre`
  2111.   ADD PRIMARY KEY (`genre_id`);
  2112.  
  2113. --
  2114. -- Indexes for table `homepage_sections`
  2115. --
  2116. ALTER TABLE `homepage_sections`
  2117.   ADD PRIMARY KEY (`id`);
  2118.  
  2119. --
  2120. -- Indexes for table `keys`
  2121. --
  2122. ALTER TABLE `keys`
  2123.   ADD PRIMARY KEY (`id`);
  2124.  
  2125. --
  2126. -- Indexes for table `languages_iso`
  2127. --
  2128. ALTER TABLE `languages_iso`
  2129.   ADD PRIMARY KEY (`id`);
  2130.  
  2131. --
  2132. -- Indexes for table `language_list`
  2133. --
  2134. ALTER TABLE `language_list`
  2135.   ADD PRIMARY KEY (`id`);
  2136.  
  2137. --
  2138. -- Indexes for table `live_tv`
  2139. --
  2140. ALTER TABLE `live_tv`
  2141.   ADD PRIMARY KEY (`live_tv_id`);
  2142.  
  2143. --
  2144. -- Indexes for table `live_tv_category`
  2145. --
  2146. ALTER TABLE `live_tv_category`
  2147.   ADD PRIMARY KEY (`live_tv_category_id`);
  2148.  
  2149. --
  2150. -- Indexes for table `live_tv_url`
  2151. --
  2152. ALTER TABLE `live_tv_url`
  2153.   ADD PRIMARY KEY (`live_tv_url_id`);
  2154.  
  2155. --
  2156. -- Indexes for table `page`
  2157. --
  2158. ALTER TABLE `page`
  2159.   ADD PRIMARY KEY (`page_id`);
  2160.  
  2161. --
  2162. -- Indexes for table `plan`
  2163. --
  2164. ALTER TABLE `plan`
  2165.   ADD PRIMARY KEY (`plan_id`);
  2166.  
  2167. --
  2168. -- Indexes for table `posts`
  2169. --
  2170. ALTER TABLE `posts`
  2171.   ADD PRIMARY KEY (`posts_id`);
  2172.  
  2173. --
  2174. -- Indexes for table `post_category`
  2175. --
  2176. ALTER TABLE `post_category`
  2177.   ADD PRIMARY KEY (`post_category_id`);
  2178.  
  2179. --
  2180. -- Indexes for table `post_comments`
  2181. --
  2182. ALTER TABLE `post_comments`
  2183.   ADD PRIMARY KEY (`post_comments_id`);
  2184.  
  2185. --
  2186. -- Indexes for table `quality`
  2187. --
  2188. ALTER TABLE `quality`
  2189.   ADD PRIMARY KEY (`quality_id`);
  2190.  
  2191. --
  2192. -- Indexes for table `rating`
  2193. --
  2194. ALTER TABLE `rating`
  2195.   ADD PRIMARY KEY (`rating_id`);
  2196.  
  2197. --
  2198. -- Indexes for table `report`
  2199. --
  2200. ALTER TABLE `report`
  2201.   ADD PRIMARY KEY (`report_id`);
  2202.  
  2203. --
  2204. -- Indexes for table `request`
  2205. --
  2206. ALTER TABLE `request`
  2207.   ADD PRIMARY KEY (`request_id`);
  2208.  
  2209. --
  2210. -- Indexes for table `rest_logins`
  2211. --
  2212. ALTER TABLE `rest_logins`
  2213.   ADD PRIMARY KEY (`id`);
  2214.  
  2215. --
  2216. -- Indexes for table `seasons`
  2217. --
  2218. ALTER TABLE `seasons`
  2219.   ADD PRIMARY KEY (`seasons_id`);
  2220.  
  2221. --
  2222. -- Indexes for table `slider`
  2223. --
  2224. ALTER TABLE `slider`
  2225.   ADD PRIMARY KEY (`slider_id`);
  2226.  
  2227. --
  2228. -- Indexes for table `star`
  2229. --
  2230. ALTER TABLE `star`
  2231.   ADD PRIMARY KEY (`star_id`);
  2232.  
  2233. --
  2234. -- Indexes for table `subscription`
  2235. --
  2236. ALTER TABLE `subscription`
  2237.   ADD PRIMARY KEY (`subscription_id`);
  2238.  
  2239. --
  2240. -- Indexes for table `subtitle`
  2241. --
  2242. ALTER TABLE `subtitle`
  2243.   ADD PRIMARY KEY (`subtitle_id`);
  2244.  
  2245. --
  2246. -- Indexes for table `tvseries_subtitle`
  2247. --
  2248. ALTER TABLE `tvseries_subtitle`
  2249.   ADD PRIMARY KEY (`tvseries_subtitle_id`);
  2250.  
  2251. --
  2252. -- Indexes for table `user`
  2253. --
  2254. ALTER TABLE `user`
  2255.   ADD PRIMARY KEY (`user_id`);
  2256.  
  2257. --
  2258. -- Indexes for table `videos`
  2259. --
  2260. ALTER TABLE `videos`
  2261.   ADD PRIMARY KEY (`videos_id`);
  2262.  
  2263. --
  2264. -- Indexes for table `video_file`
  2265. --
  2266. ALTER TABLE `video_file`
  2267.   ADD PRIMARY KEY (`video_file_id`);
  2268.  
  2269. --
  2270. -- Indexes for table `video_type`
  2271. --
  2272. ALTER TABLE `video_type`
  2273.   ADD PRIMARY KEY (`video_type_id`);
  2274.  
  2275. --
  2276. -- Indexes for table `wish_list`
  2277. --
  2278. ALTER 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. --
  2288. ALTER TABLE `ads`
  2289.   MODIFY `ads_id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  2290.  
  2291. --
  2292. -- AUTO_INCREMENT for table `comments`
  2293. --
  2294. ALTER TABLE `comments`
  2295.   MODIFY `comments_id` INT(20) NOT NULL AUTO_INCREMENT;
  2296.  
  2297. --
  2298. -- AUTO_INCREMENT for table `config`
  2299. --
  2300. ALTER TABLE `config`
  2301.   MODIFY `config_id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;
  2302.  
  2303. --
  2304. -- AUTO_INCREMENT for table `country`
  2305. --
  2306. ALTER TABLE `country`
  2307.   MODIFY `country_id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;
  2308.  
  2309. --
  2310. -- AUTO_INCREMENT for table `cron`
  2311. --
  2312. ALTER TABLE `cron`
  2313.   MODIFY `cron_id` INT(11) NOT NULL AUTO_INCREMENT;
  2314.  
  2315. --
  2316. -- AUTO_INCREMENT for table `currency`
  2317. --
  2318. ALTER 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. --
  2324. ALTER TABLE `download_link`
  2325.   MODIFY `download_link_id` INT(11) NOT NULL AUTO_INCREMENT;
  2326.  
  2327. --
  2328. -- AUTO_INCREMENT for table `episodes`
  2329. --
  2330. ALTER TABLE `episodes`
  2331.   MODIFY `episodes_id` INT(11) NOT NULL AUTO_INCREMENT;
  2332.  
  2333. --
  2334. -- AUTO_INCREMENT for table `episode_download_link`
  2335. --
  2336. ALTER 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. --
  2342. ALTER 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. --
  2348. ALTER TABLE `homepage_sections`
  2349.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  2350.  
  2351. --
  2352. -- AUTO_INCREMENT for table `keys`
  2353. --
  2354. ALTER TABLE `keys`
  2355.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  2356.  
  2357. --
  2358. -- AUTO_INCREMENT for table `languages_iso`
  2359. --
  2360. ALTER 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. --
  2366. ALTER 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. --
  2372. ALTER 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. --
  2378. ALTER 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. --
  2384. ALTER 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. --
  2390. ALTER TABLE `page`
  2391.   MODIFY `page_id` INT(11) NOT NULL AUTO_INCREMENT;
  2392.  
  2393. --
  2394. -- AUTO_INCREMENT for table `plan`
  2395. --
  2396. ALTER TABLE `plan`
  2397.   MODIFY `plan_id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  2398.  
  2399. --
  2400. -- AUTO_INCREMENT for table `posts`
  2401. --
  2402. ALTER TABLE `posts`
  2403.   MODIFY `posts_id` INT(11) NOT NULL AUTO_INCREMENT;
  2404.  
  2405. --
  2406. -- AUTO_INCREMENT for table `post_category`
  2407. --
  2408. ALTER TABLE `post_category`
  2409.   MODIFY `post_category_id` INT(11) NOT NULL AUTO_INCREMENT;
  2410.  
  2411. --
  2412. -- AUTO_INCREMENT for table `post_comments`
  2413. --
  2414. ALTER TABLE `post_comments`
  2415.   MODIFY `post_comments_id` INT(20) NOT NULL AUTO_INCREMENT;
  2416.  
  2417. --
  2418. -- AUTO_INCREMENT for table `quality`
  2419. --
  2420. ALTER TABLE `quality`
  2421.   MODIFY `quality_id` INT(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  2422.  
  2423. --
  2424. -- AUTO_INCREMENT for table `rating`
  2425. --
  2426. ALTER TABLE `rating`
  2427.   MODIFY `rating_id` INT(50) NOT NULL AUTO_INCREMENT;
  2428.  
  2429. --
  2430. -- AUTO_INCREMENT for table `report`
  2431. --
  2432. ALTER TABLE `report`
  2433.   MODIFY `report_id` INT(11) NOT NULL AUTO_INCREMENT;
  2434.  
  2435. --
  2436. -- AUTO_INCREMENT for table `request`
  2437. --
  2438. ALTER TABLE `request`
  2439.   MODIFY `request_id` INT(11) NOT NULL AUTO_INCREMENT;
  2440.  
  2441. --
  2442. -- AUTO_INCREMENT for table `rest_logins`
  2443. --
  2444. ALTER TABLE `rest_logins`
  2445.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  2446.  
  2447. --
  2448. -- AUTO_INCREMENT for table `seasons`
  2449. --
  2450. ALTER TABLE `seasons`
  2451.   MODIFY `seasons_id` INT(11) NOT NULL AUTO_INCREMENT;
  2452.  
  2453. --
  2454. -- AUTO_INCREMENT for table `slider`
  2455. --
  2456. ALTER TABLE `slider`
  2457.   MODIFY `slider_id` INT(11) NOT NULL AUTO_INCREMENT;
  2458.  
  2459. --
  2460. -- AUTO_INCREMENT for table `star`
  2461. --
  2462. ALTER TABLE `star`
  2463.   MODIFY `star_id` INT(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  2464.  
  2465. --
  2466. -- AUTO_INCREMENT for table `subscription`
  2467. --
  2468. ALTER TABLE `subscription`
  2469.   MODIFY `subscription_id` INT(50) NOT NULL AUTO_INCREMENT;
  2470.  
  2471. --
  2472. -- AUTO_INCREMENT for table `subtitle`
  2473. --
  2474. ALTER TABLE `subtitle`
  2475.   MODIFY `subtitle_id` INT(11) NOT NULL AUTO_INCREMENT;
  2476.  
  2477. --
  2478. -- AUTO_INCREMENT for table `tvseries_subtitle`
  2479. --
  2480. ALTER TABLE `tvseries_subtitle`
  2481.   MODIFY `tvseries_subtitle_id` INT(11) NOT NULL AUTO_INCREMENT;
  2482.  
  2483. --
  2484. -- AUTO_INCREMENT for table `user`
  2485. --
  2486. ALTER TABLE `user`
  2487.   MODIFY `user_id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  2488.  
  2489. --
  2490. -- AUTO_INCREMENT for table `videos`
  2491. --
  2492. ALTER 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. --
  2498. ALTER TABLE `video_file`
  2499.   MODIFY `video_file_id` INT(11) NOT NULL AUTO_INCREMENT;
  2500.  
  2501. --
  2502. -- AUTO_INCREMENT for table `video_type`
  2503. --
  2504. ALTER 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. --
  2510. ALTER TABLE `wish_list`
  2511.   MODIFY `wish_list_id` INT(11) NOT NULL AUTO_INCREMENT;
  2512. COMMIT;
  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.  
Tags: ovoo-v3.4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!