CREATE TABLE `geekPrefix_geekp_age_descriptors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL,
  `translate` varchar(255) NOT NULL,
  `standard_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;



INSERT INTO `geekPrefix_geekp_age_descriptors` (`id`, `description`, `translate`, `standard_id`) VALUES
(1, 'Alcohol Reference', '', 1),
(2, 'Animated Blood', '', 1),
(3, 'Blood', '', 1),
(4, 'Blood and Gore', '', 1),
(5, 'Cartoon Violence', '', 1),
(6, 'Comic Mischief', '', 1),
(7, 'Crude Humor', '', 1),
(8, 'Drug Reference', '', 1),
(9, 'Fantasy Violence', '', 1),
(10, 'Intense Violence', '', 1),
(11, 'Language', '', 1),
(12, 'Lyrics', '', 1),
(13, 'Mature Humor', '', 1),
(14, 'Nudity', '', 1),
(15, 'Partial Nudity', '', 1),
(16, 'Real Gambling', '', 1),
(17, 'Sexual Content', '', 1),
(18, 'Sexual Themes', '', 1),
(19, 'Sexual Violence', '', 1),
(20, 'Simulated Gambling', '', 1),
(21, 'Strong Language', '', 1),
(22, 'Strong Lyrics', '', 1),
(23, 'Strong Sexual Content', '', 1),
(24, 'Suggestive Themes', '', 1),
(25, 'Tobacco Reference', '', 1),
(26, 'Use of Alcohol', '', 1),
(27, 'Use of Drugs', '', 1),
(28, 'Use of Tobacco', '', 1),
(29, 'Violence', '', 1),
(30, 'Violent References', '', 1),
(31, 'Animated Violence', '', 1),
(32, 'Mild Language', '', 1),
(33, 'Mild Violence', '', 1),
(34, 'Use of Drugs and Alcohol', '', 1),
(35, 'Drug and Alcohol Reference', '', 1),
(36, 'Mild Suggestive Themes', '', 1),
(37, 'Mild Cartoon Violence', '', 1),
(38, 'Mild Blood', '', 1),
(39, 'Realistic Blood and Gore', '', 1),
(40, 'Realistic Violence', '', 1),
(41, 'Alcohol and Tobacco Reference', '', 1),
(42, 'Mature Sexual Themes', '', 1),
(43, 'Mild Animated Violence', '', 1),
(44, 'Mild Sexual Themes', '', 1),
(45, 'Use of Alcohol and Tobacco', '', 1),
(46, 'Animated Blood and Gore', '', 1),
(47, 'Mild Fantasy Violence', '', 1),
(48, 'Mild Lyrics', '', 1),
(49, 'Realistic Blood', '', 1),
(50, 'Violence', '', 2),
(51, 'Sex', '', 2),
(52, 'Drugs', '', 2),
(53, 'Fear/Horror', '', 2),
(54, 'Discrimination', '', 2),
(55, 'Bad Language', '', 2),
(56, 'Love', '', 3),
(57, 'Gambling', '', 2),
(58, 'Online Gameplay', '', 2),
(59, 'In-Game Purchases', '', 2),
(60, 'Sexual Content', '', 3),
(61, 'Violence', '', 3),
(62, 'Horror', '', 3),
(63, 'Drinking/Smoking', '', 3),
(64, 'Gambling', '', 3),
(65, 'Crime', '', 3),
(66, 'Controlled substances', '', 3),
(67, 'Languages and others', '', 3),
(68, 'Sexuality', '', 5),
(69, 'Violence', '', 5),
(70, 'Fear, Horror, Threatening', '', 5),
(71, 'Language', '', 5),
(72, 'Alcohol, Tobacco, Drug', '', 5),
(73, 'Crime, Anti-Social', '', 5),
(74, 'Gambling', '', 5),
(75, 'Violência (Violence)', '', 6),
(76, 'Violência Extrema (Extreme Violence)', '', 6),
(77, 'Conteúdo Sexual (Sexual Content)', '', 6),
(78, 'Nudez (Nudity)', '', 6),
(79, 'Sexo (Sex)', '', 6),
(80, 'Sexo Explícito (Explicit Sex)', '', 6),
(81, 'Drogas (Drugs)', '', 6),
(82, 'Drogas Lícitas (Legal Drugs)', '', 6),
(83, 'Drogas Ilícitas (Illegal Drugs)', '', 6),
(84, 'Linguagem Imprópria (Inappropriate Language)', '', 6),
(85, 'Atos Criminosos (Criminal Acts)', '', 6);


CREATE TABLE `geekPrefix_geekp_age_ratings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rating` varchar(32) NOT NULL,
  `standard_id` int NOT NULL,
  `icon` varchar(255) NOT NULL,
   PRIMARY KEY (`id`)	
) geek_charset_collate;


INSERT INTO `geekPrefix_geekp_age_ratings` (`id`, `rating`, `standard_id`, `icon`) VALUES
(1, '3', 2, ''),
(2, '7', 2, ''),
(3, '12', 2, ''),
(4, '16', 2, ''),
(5, '18', 2, ''),
(6, 'RP', 1, ''),
(7, 'EC', 1, ''),
(8, 'E', 1, ''),
(9, 'E10+', 1, ''),
(10, 'T', 1, ''),
(11, 'M', 1, ''),
(12, 'AO', 1, ''),
(13, 'CERO A', 3, ''),
(14, 'CERO B', 3, ''),
(15, 'CERO C', 3, ''),
(16, 'CERO D', 3, ''),
(17, 'CERO Z', 3, ''),
(18, 'USK 0', 4, ''),
(19, 'USK 6', 4, ''),
(20, 'USK 12', 4, ''),
(21, 'USK 16', 4, ''),
(22, 'USK 18', 4, ''),
(23, 'ALL', 5, ''),
(24, '12+', 5, ''),
(25, '15+', 5, ''),
(26, '18+', 5, ''),
(27, 'TESTING', 5, ''),
(28, 'L', 6, ''),
(29, '10', 6, ''),
(30, '12', 6, ''),
(31, '14', 6, ''),
(32, '16', 6, ''),
(33, '18', 6, ''),
(34, 'G', 7, ''),
(35, 'PG', 7, ''),
(36, 'M', 7, ''),
(37, 'MA 15+', 7, ''),
(38, 'R 18+', 7, ''),
(39, 'RC', 7, '');



CREATE TABLE `geekPrefix_geekp_age_standards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` varchar(255) NOT NULL,
  `translate` varchar(255) NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;



INSERT INTO `geekPrefix_geekp_age_standards` (`id`, `name`, `description`, `translate`) VALUES
(1, 'ESRB', 'American Standard', ''),
(2, 'PEGI', 'European Standard', ''),
(3, 'CERO', 'Japan Standard', ''),
(4, 'USK', 'German Standard', ''),
(5, 'GRAC', 'South Korea Standard', ''),
(6, 'CLASS_IND', 'Brazilian Standard', ''),
(7, 'ACB', 'Australian Standard', '');



CREATE TABLE `geekPrefix_geekp_akas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `aka` varchar(255) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `content_type` varchar(32) NOT NULL,
  `content_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`)
) geek_charset_collate;

CREATE TABLE `geekPrefix_geekp_badges` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `type` varchar(32) NOT NULL,
  `action` varchar(32) NOT NULL,
  `status` varchar(32) NOT NULL,
  `goal` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;

CREATE TABLE `geekPrefix_geekp_cache` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content_id` int NOT NULL,
  `content_type` varchar(100) NOT NULL,
  `op_id` int NOT NULL,
  `op_name` varchar(255) NOT NULL,
  `type` varchar(100) NOT NULL,
  `cache` longtext NOT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `op` (`op_id`,`type`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `type` varchar(32) NOT NULL,
  `category` tinyint NOT NULL,
  `icon` varchar(255) NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;



INSERT INTO `geekPrefix_geekp_categories` (`id`, `name`, `type`, `category`, `icon`) VALUES
(1, 'official', 'website', 1, ''),
(2, 'wikia', 'website', 2, ''),
(3, 'wikipedia', 'website', 3, ''),
(4, 'facebook', 'website', 4, ''),
(5, 'twitter', 'website', 5, ''),
(6, 'twitch', 'website', 6, ''),
(7, 'instagram', 'website', 8, ''),
(8, 'youtube', 'website', 9, ''),
(9, 'iphone', 'website', 10, ''),
(10, 'ipad', 'website', 11, ''),
(11, 'android', 'website', 12, ''),
(12, 'steam', 'website', 13, ''),
(13, 'reddit', 'website', 14, ''),
(14, 'itch', 'website', 15, ''),
(15, 'epicgames', 'website', 16, ''),
(16, 'gog', 'website', 17, ''),
(17, 'discord', 'website', 18, ''),
(18, 'YYYYMMMMDD', 'date', 0, ''),
(19, 'YYYYMMMM', 'date', 1, ''),
(20, 'YYYY', 'date', 2, ''),
(21, 'YYYYQ1', 'date', 3, ''),
(22, 'YYYYQ2', 'date', 4, ''),
(23, 'YYYYQ3', 'date', 5, ''),
(24, 'YYYYQ4', 'date', 6, ''),
(25, 'TBD', 'date', 7, '');


CREATE TABLE `geekPrefix_geekp_chars` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `imdb_id` varchar(32) NOT NULL,
  `summary` text NOT NULL,
  `uni` int NOT NULL,
  `creator` int NOT NULL,
  `race` int NOT NULL,
  `class` int NOT NULL,
  `cover` varchar(255) NOT NULL,
  `cover_exp` varchar(100) NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `imdb_id` (`imdb_id`),
   KEY `name` (`name`)
) geek_charset_collate;


CREATE TABLE `geekPrefix_geekp_companies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `logo` varchar(100) NOT NULL,
  `status` varchar(30) NOT NULL,
  `country_id` tinyint NOT NULL,
  `website` varchar(150) NOT NULL,
  `founded` varchar(30) NOT NULL,
  `start_date` date DEFAULT NULL,
  `start_date_category` tinyint DEFAULT NULL,
  `change_date` date DEFAULT NULL,
  `change_date_category` tinyint DEFAULT NULL,
  `changed` varchar(30) NOT NULL,
  `changed_id` int NOT NULL,
  `changed_comp` varchar(255) NOT NULL,
  `parent_id` int NOT NULL,
  `parent_comp` varchar(255) NOT NULL,
  `igdb_id` int DEFAULT NULL,
  `igdb_slug` varchar(255) NOT NULL,
  `checked` tinyint NOT NULL DEFAULT '0',
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `name` (`name`),
   KEY `igdb_id` (`igdb_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_content_ages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title_id` int NOT NULL,
  `standard_id` int NOT NULL,
  `rating_id` int NOT NULL,
  `descriptor` text NOT NULL,
  `synopsis` text NOT NULL,
   PRIMARY KEY (`id`),
   KEY `title_id` (`title_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_content_comps` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `content_id` int NOT NULL,
  `content_type` varchar(32) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_content_img` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_id` int NOT NULL,
  `content_type` varchar(100) NOT NULL,
  `img_id` int NOT NULL,
  `url` varchar(255) NOT NULL,
  `type` varchar(32) NOT NULL,
  `fetch_type` varchar(32) NOT NULL,
  `fetch_id` varchar(32) NOT NULL,
  `attachment_id` int NOT NULL,
  `is_main` int NOT NULL DEFAULT '0',
  `que` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `img_id` (`img_id`),
   KEY `is_main` (`is_main`),
   KEY `attachment_id` (`attachment_id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `fetch` (`fetch_id`,`fetch_type`)
) geek_charset_collate;


CREATE TABLE `geekPrefix_geekp_content_lists` (
  `id` int NOT NULL AUTO_INCREMENT,
  `list_id` int NOT NULL,
  `content_id` int NOT NULL,
  `content_type` varchar(32) NOT NULL,
  `summary` text NOT NULL,
  `que` tinyint NOT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `list_id` (`list_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_content_videos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `video_id` int NOT NULL,
  `content_id` int NOT NULL,
  `content_type` varchar(32) NOT NULL,
  `source_id` varchar(255) NOT NULL,
  `source` varchar(32) NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `video_lang` varchar(32) NOT NULL,
  `video_sub` varchar(32) NOT NULL,
  `video_type` varchar(32) NOT NULL,
  `que` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `video_id` (`video_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_countries` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `iso2` varchar(10) NOT NULL,
  `iso3` varchar(10) NOT NULL,
  `numerics` varchar(32) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;


INSERT INTO `geekPrefix_geekp_countries` (`id`, `name`, `aka`, `iso2`, `iso3`, `numerics`, `icon`, `post_id`) VALUES
(1, 'United States', '', 'US', 'USA', '840', '', 0),
(2, 'Afghanistan', '', 'AF', 'AFG', '004', '', 0),
(3, 'Germany', '', 'DE', 'DEU', '276', '', 0),
(4, 'Andorra', '', 'AD', 'AND', '020', '', 0),
(5, 'Angola', '', 'AO', 'AGO', '024', '', 0),
(6, 'Antarctica', '', 'AQ', 'ATA', '010', '', 0),
(7, 'Antigua and Barbuda', '', 'AG', 'ATG', '028', '', 0),
(8, 'Argentina', '', 'AR', 'ARG', '032', '', 0),
(9, 'Albania', '', 'AL', 'ALB', '008', '', 0),
(10, 'Australia', '', 'AU', 'AUS', '036', '', 0),
(11, 'Austria', '', 'AT', 'AUT', '040', '', 0),
(12, 'Azerbaijan', '', 'AZ', 'AZE', '031', '', 0),
(13, 'Bahamas', '', 'BS', 'BHS', '044', '', 0),
(14, 'Bahrain', '', 'BH', 'BHR', '048', '', 0),
(15, 'Bangladesh', '', 'BD', 'BGD', '050', '', 0),
(16, 'Barbados', '', 'BB', 'BRB', '052', '', 0),
(17, 'American Samoa', '', 'AS', 'ASM', '016', '', 0),
(18, 'Belgium', '', 'BE', 'BEL', '056', '', 0),
(19, 'Belize', '', 'BZ', 'BLZ', '084', '', 0),
(20, 'Benin', '', 'BJ', 'BEN', '204', '', 0),
(21, 'Bermuda', '', 'BM', 'BMU', '060', '', 0),
(22, 'Belarus', '', 'BY', 'BLR', '112', '', 0),
(23, 'Bhutan', '', 'BT', 'BTN', '064', '', 0),
(24, 'United Arab Emirates', '', 'AE', 'ARE', '784', '', 0),
(25, 'Bolivia', '', 'BO', 'BOL', '068', '', 0),
(26, 'Bosnia and Herzegovina', '', 'BA', 'BIH', '070', '', 0),
(27, 'Botswana', '', 'BW', 'BWA', '072', '', 0),
(28, 'Brazil', '', 'BR', 'BRA', '076', '', 0),
(29, 'Brunei', '', 'BN', 'BRN', '096', '', 0),
(30, 'Bulgaria', '', 'BG', 'BGR', '100', '', 0),
(31, 'Burkina Faso', '', 'BF', 'BFA', '854', '', 0),
(32, 'Burundi', '', 'BI', 'BDI', '108', '', 0),
(33, 'Cape Verde', '', 'CV', 'CPV', '132', '', 0),
(34, 'Algeria', '', 'DZ', 'DZA', '012', '', 0),
(35, 'Djibouti', '', 'DJ', 'DJI', '262', '', 0),
(36, 'Chad', '', 'TD', 'TCD', '148', '', 0),
(37, 'Czech Republic', '', 'CZ', 'CZE', '203', '', 0),
(38, 'China', '', 'CN', 'CHN', '156', '', 0),
(39, 'Denmark', '', 'DK', 'DNK', '208', '', 0),
(40, 'Dominican Republic', '', 'DO', 'DOM', '214', '', 0),
(41, 'Dominica', '', 'DM', 'DMA', '212', '', 0),
(42, 'Ecuador', '', 'EC', 'ECU', '218', '', 0),
(43, 'Equatorial Guinea', '', 'GQ', 'GNQ', '226', '', 0),
(44, 'El Salvador', '', 'SV', 'SLV', '222', '', 0),
(45, 'Indonesia', '', 'ID', 'IDN', '360', '', 0),
(46, 'Eritrea', '', 'ER', 'ERI', '232', '', 0),
(47, 'Armenia', '', 'AM', 'ARM', '051', '', 0),
(48, 'Estonia', '', 'EE', 'EST', '233', '', 0),
(49, 'Ethiopia', '', 'ET', 'ETH', '231', '', 0),
(50, 'Falkland Islands', '', 'FK', 'FLK', '238', '', 0),
(51, 'Faroe Islands', '', 'FO', 'FRO', '234', '', 0),
(52, 'Morocco', '', 'MA', 'MAR', '504', '', 0),
(53, 'Fiji', '', 'FJ', 'FJI', '242', '', 0),
(54, 'Côte d\'Ivoire', '', '', '', '', '', 0),
(55, 'Philippines', '', 'PH', 'PHL', '608', '', 0),
(56, 'Finland', '', 'FI', 'FIN', '246', '', 0),
(57, 'France', '', 'FR', 'FRA', '250', '', 0),
(58, 'Gabon', '', 'GA', 'GAB', '266', '', 0),
(59, 'Gambia', '', 'GM', 'GMB', '270', '', 0),
(60, 'Ghana', '', 'GH', 'GHA', '288', '', 0),
(61, 'Guinea', '', 'GN', 'GIN', '324', '', 0),
(62, 'Guinea-Bissau', '', 'GW', 'GNB', '624', '', 0),
(63, 'Grenada', '', 'GD', 'GRD', '308', '', 0),
(64, 'Greenland', '', 'GL', 'GRL', '304', '', 0),
(65, 'Guatemala', '', 'GT', 'GTM', '320', '', 0),
(66, 'Guyana', '', 'GY', 'GUY', '328', '', 0),
(67, 'South Africa', '', 'ZA', 'ZAF', '710', '', 0),
(68, 'South Cyprus', '', '', '', '', '', 0),
(69, 'Georgia', '', 'GE', 'GEO', '268', '', 0),
(70, 'Haiti', '', 'HT', 'HTI', '332', '', 0),
(71, 'Croatia', '', 'HR', 'HRV', '191', '', 0),
(72, 'India', '', 'IN', 'IND', '356', '', 0),
(73, 'Netherlands', '', 'NL', 'NLD', '528', '', 0),
(74, 'Honduras', '', 'HN', 'HND', '340', '', 0),
(75, 'Iraq', '', 'IQ', 'IRQ', '368', '', 0),
(76, 'United Kingdom', '', 'GB', 'GBR', '826', '', 0),
(77, 'Iran', '', 'IR', 'IRN', '364', '', 0),
(78, 'Ireland', '', 'IE', 'IRL', '372', '', 0),
(79, 'Spain', '', 'ES', 'ESP', '724', '', 0),
(80, 'Israel', '', 'IL', 'ISR', '376', '', 0),
(81, 'Sweden', '', 'SE', 'SWE', '752', '', 0),
(82, 'Switzerland', '', 'CH', 'CHE', '756', '', 0),
(83, 'Italy', '', 'IT', 'ITA', '380', '', 0),
(84, 'Iceland', '', 'IS', 'ISL', '352', '', 0),
(85, 'Jamaica', '', 'JM', 'JAM', '388', '', 0),
(86, 'Japan', '', 'JP', 'JPN', '392', '', 0),
(87, 'Cambodia', '', 'KH', 'KHM', '116', '', 0),
(88, 'Cameroon', '', 'CM', 'CMR', '120', '', 0),
(89, 'Canada', '', 'CA', 'CAN', '124', '', 0),
(90, 'Qatar', '', 'QA', 'QAT', '634', '', 0),
(91, 'Kazakhstan', '', 'KZ', 'KAZ', '398', '', 0),
(92, 'Kenya', '', 'KE', 'KEN', '404', '', 0),
(93, 'Kyrgyzstan', '', 'KG', 'KGZ', '417', '', 0),
(94, 'Kiribati', '', 'KI', 'KIR', '296', '', 0),
(95, 'Colombia', '', 'CO', 'COL', '170', '', 0),
(96, 'Comoros', '', 'KM', 'COM', '174', '', 0),
(97, 'Republic of the Congo', '', 'CG', 'COG', '178', '', 0),
(98, 'Democratic Republic of the Congo', '', 'CD', 'COD', '180', '', 0),
(99, 'Korea', '', '', '', '', '', 0),
(100, 'Kosovo', '', 'XK', 'XKX', '0', '', 0),
(101, 'Costa Rica', '', 'CR', 'CRI', '188', '', 0),
(102, 'Kuwait', '', 'KW', 'KWT', '414', '', 0),
(103, 'Cyprus', '', 'CY', 'CYP', '196', '', 0),
(104, 'Cuba', '', 'CU', 'CUB', '192', '', 0),
(105, 'Laos', '', 'LA', 'LAO', '418', '', 0),
(106, 'Lesotho', '', 'LS', 'LSO', '426', '', 0),
(107, 'Latvia', '', 'LV', 'LVA', '428', '', 0),
(108, 'Liberia', '', 'LR', 'LBR', '430', '', 0),
(109, 'Libya', '', 'LY', 'LBY', '434', '', 0),
(110, 'Liechtenstein', '', 'LI', 'LIE', '438', '', 0),
(111, 'Lithuania', '', 'LT', 'LTU', '440', '', 0),
(112, 'Lebanon', '', 'LB', 'LBN', '422', '', 0),
(113, 'Luxembourg', '', 'LU', 'LUX', '442', '', 0),
(114, 'Hungary', '', 'HU', 'HUN', '348', '', 0),
(115, 'Madagascar', '', 'MG', 'MDG', '450', '', 0),
(116, 'Macau', '', 'MO', 'MAC', '446', '', 0),
(117, 'Macedonia', '', 'MK', 'MKD', '807', '', 0),
(118, 'Malawi', '', 'MW', 'MWI', '454', '', 0),
(119, 'Maldives', '', 'MV', 'MDV', '462', '', 0),
(120, 'Malaysia', '', 'MY', 'MYS', '458', '', 0),
(121, 'Mali', '', 'ML', 'MLI', '466', '', 0),
(122, 'Malta', '', 'MT', 'MLT', '470', '', 0),
(123, 'Mauritius', '', 'MU', 'MUS', '480', '', 0),
(124, 'Mexico', '', 'MX', 'MEX', '484', '', 0),
(125, 'Egypt', '', 'EG', 'EGY', '818', '', 0),
(126, 'Mongolia', '', 'MN', 'MNG', '496', '', 0),
(127, 'Moldova', '', 'MD', 'MDA', '498', '', 0),
(128, 'Monaco', '', 'MC', 'MCO', '492', '', 0),
(129, 'Mauritania', '', 'MR', 'MRT', '478', '', 0),
(130, 'Mozambique', '', 'MZ', 'MOZ', '508', '', 0),
(131, 'Myanmar', '', 'MM', 'MMR', '104', '', 0),
(132, 'Namibia', '', 'NA', 'NAM', '516', '', 0),
(133, 'Nauru', '', 'NR', 'NRU', '520', '', 0),
(134, 'Nepal', '', 'NP', 'NPL', '524', '', 0),
(135, 'Niger', '', 'NE', 'NER', '562', '', 0),
(136, 'Nigeria', '', 'NG', 'NGA', '566', '', 0),
(137, 'Nicaragua', '', 'NI', 'NIC', '558', '', 0),
(138, 'Norfolk Island', '', '', '', '', '', 0),
(139, 'Norway', '', 'NO', 'NOR', '578', '', 0),
(140, 'Central African Republic', '', 'CF', 'CAF', '140', '', 0),
(141, 'Uzbekistan', '', 'UZ', 'UZB', '860', '', 0),
(142, 'Pakistan', '', 'PK', 'PAK', '586', '', 0),
(143, 'Palau', '', 'PW', 'PLW', '585', '', 0),
(144, 'Panama', '', 'PA', 'PAN', '591', '', 0),
(145, 'Papua New Guinea', '', 'PG', 'PNG', '598', '', 0),
(146, 'Paraguay', '', 'PY', 'PRY', '600', '', 0),
(147, 'Peru', '', 'PE', 'PER', '604', '', 0),
(148, 'Poland', '', 'PL', 'POL', '616', '', 0),
(149, 'Portugal', '', 'PT', 'PRT', '620', '', 0),
(150, 'Puerto Rico', '', 'PR', 'PRI', '630', '', 0),
(151, 'Romania', '', 'RO', 'ROU', '642', '', 0),
(152, 'Rwanda', '', 'RW', 'RWA', '646', '', 0),
(153, 'Russia', '', 'RU', 'RUS', '643', '', 0),
(154, 'San Marino', '', 'SM', 'SMR', '674', '', 0),
(155, 'Saint Kitts and Nevis', '', 'KN', 'KNA', '659', '', 0),
(156, 'Saint Lucia', '', 'LC', 'LCA', '662', '', 0),
(157, 'Saint Vincent and the Grenadines', '', 'VC', 'VCT', '670', '', 0),
(158, 'Sao Tome and Principe', '', 'ST', 'STP', '678', '', 0),
(159, 'Senegal', '', 'SN', 'SEN', '686', '', 0),
(160, 'Seychelles', '', 'SC', 'SYC', '690', '', 0),
(161, 'Sierra Leone', '', 'SL', 'SLE', '694', '', 0),
(162, 'Singapore', '', 'SG', 'SGP', '702', '', 0),
(163, 'Slovakia', '', 'SK', 'SVK', '703', '', 0),
(164, 'Slovenia', '', 'SI', 'SVN', '705', '', 0),
(165, 'Solomon Islands', '', 'SB', 'SLB', '090', '', 0),
(166, 'Somalia', '', 'SO', 'SOM', '706', '', 0),
(167, 'Sri Lanka', '', 'LK', 'LKA', '144', '', 0),
(168, 'Sudan', '', 'SD', 'SDN', '729', '', 0),
(169, 'Suriname', '', 'SR', 'SUR', '740', '', 0),
(170, 'Syria', '', 'SY', 'SYR', '760', '', 0),
(171, 'Saudi Arabia', '', 'SA', 'SAU', '682', '', 0),
(172, 'Swaziland', '', 'SZ', 'SWZ', '748', '', 0),
(173, 'Chile', '', 'CL', 'CHL', '152', '', 0),
(174, 'Tajikistan', '', 'TJ', 'TJK', '762', '', 0),
(175, 'Tanzania', '', 'TZ', 'TZA', '834', '', 0),
(176, 'Siam', '', '', '', '', '', 0),
(177, 'Taiwan', '', 'TW', 'TWN', '158', '', 0),
(178, 'Togo', '', 'TG', 'TGO', '768', '', 0),
(179, 'Tonga', '', 'TO', 'TON', '776', '', 0),
(180, 'Trinidad and Tobago', '', 'TT', 'TTO', '780', '', 0),
(181, 'Tunisia', '', 'TN', 'TUN', '788', '', 0),
(182, 'Turkey', '', 'TR', 'TUR', '792', '', 0),
(183, 'Turkmenistan', '', 'TM', 'TKM', '795', '', 0),
(184, 'Uganda', '', 'UG', 'UGA', '800', '', 0),
(185, 'Ukraine', '', 'UA', 'UKR', '804', '', 0),
(186, 'Oman', '', 'OM', 'OMN', '512', '', 0),
(187, 'Uruguay', '', 'UY', 'URY', '858', '', 0),
(188, 'Jordan', '', 'JO', 'JOR', '400', '', 0),
(189, 'Vanuatu', '', 'VU', 'VUT', '548', '', 0),
(190, 'Vatican City State', '', '', '', '', '', 0),
(191, 'Venezuela', '', 'VE', 'VEN', '862', '', 0),
(192, 'Vietnam', '', 'VN', 'VNM', '704', '', 0),
(193, 'Yemen', '', 'YE', 'YEM', '887', '', 0),
(194, 'New Caledonia', '', 'NC', 'NCL', '540', '', 0),
(195, 'New Zealand', '', 'NZ', 'NZL', '554', '', 0),
(196, 'Yugoslavia', '', '', '', '', '', 0),
(197, 'Greece', '', 'GR', 'GRC', '300', '', 0),
(198, 'Zambia', '', 'ZM', 'ZMB', '894', '', 0),
(199, 'Zimbabwe', '', 'ZW', 'ZWE', '716', '', 0),
(200, 'Anguilla', '', 'AI', 'AIA', '660', '', 0),
(201, 'Hong Kong', '', 'HK', 'HKG', '344', '', 0),
(202, 'Åland Islands', '', '', '', '', '', 0),
(203, 'Aruba', '', 'AW', 'ABW', '533', '', 0),
(204, 'Bouvet Island', '', '', '', '', '', 0),
(205, 'Czechoslovakia', '', '', '', '', '', 0),
(206, 'Gibraltar', '', 'GI', 'GIB', '292', '', 0),
(208, 'North Korea', '', 'KP', 'PRK', '408', '', 0),
(209, 'Palestinian Territory', '', '', '', '', '', 0),
(210, 'Serbia', '', 'RS', 'SRB', '688', '', 0),
(211, 'South Korea', '', 'KR', 'KOR', '410', '', 0),
(212, 'Soviet Union', '', '', '', '', '', 0),
(213, 'Turks and Caicos Islands', '', 'TC', 'TCA', '796', '', 0),
(214, 'Trinidad', '', '', '', '', '', 0),
(215, 'British Indian Ocean Territory', '', 'IO', 'IOT', '086', '', 0),
(216, 'British Virgin Islands', '', 'VG', 'VGB', '092', '', 0),
(217, 'Brunei Darussalam', '', '', '', '', '', 0),
(218, 'Burma', '', '', '', '', '', 0),
(219, 'Cayman Islands', '', 'KY', 'CYM', '136', '', 0),
(220, 'Christmas Island', '', 'CX', 'CXR', '162', '', 0),
(221, 'Cocos Islands', '', 'CC', 'CCK', '166', '', 0),
(222, 'Cook Islands', '', 'CK', 'COK', '184', '', 0),
(223, 'Micronesia', '', 'FM', 'FSM', '583', '', 0),
(224, 'French Guiana', '', '', '', '', '', 0),
(225, 'French Polynesia', '', 'PF', 'PYF', '258', '', 0),
(226, 'French Southern Territories', '', '', '', '', '', 0),
(228, 'Guadeloupe', '', '', '', '', '', 0),
(229, 'Guam', '', 'GU', 'GUM', '316', '', 0),
(230, 'Guernsey', '', 'GG', 'GGY', '831', '', 0),
(231, 'Heard Island and McDonald Islands', '', '', '', '', '', 0),
(232, 'Isle of Man', '', 'IM', 'IMN', '833', '', 0),
(233, 'Jersey', '', 'JE', 'JEY', '832', '', 0),
(235, 'Marshall Islands', '', 'MH', 'MHL', '584', '', 0),
(236, 'Martinique', '', '', '', '', '', 0),
(237, 'Mayotte', '', 'YT', 'MYT', '175', '', 0),
(238, 'Montenegro', '', 'ME', 'MNE', '499', '', 0),
(239, 'Montserrat', '', 'MS', 'MSR', '500', '', 0),
(240, 'Netherlands Antilles', '', 'AN', 'ANT', '530', '', 0),
(241, 'Niue', '', 'NU', 'NIU', '570', '', 0),
(242, 'Northern Mariana Islands', '', 'MP', 'MNP', '580', '', 0),
(243, 'Pitcairn', '', 'PN', 'PCN', '612', '', 0),
(244, 'Réunion', '', 'RE', 'REU', '638', '', 0),
(245, 'Saint Barthélemy', '', 'BL', 'BLM', '652', '', 0),
(246, 'Saint Helena', '', 'SH', 'SHN', '654', '', 0),
(247, 'Saint Martin', '', 'MF', 'MAF', '663', '', 0),
(248, 'Saint Pierre and Miquelon', '', 'PM', 'SPM', '666', '', 0),
(249, 'Samoa', '', 'WS', 'WSM', '882', '', 0),
(250, 'Serbia and Montenegro', '', '', '', '', '', 0),
(251, 'Sierra Leone', '', 'SL', 'SLE', '694', '', 0),
(252, 'South Georgia and the South Sandwich Islands', '', '', '', '', '', 0),
(253, 'Svalbard and Jan Mayen', '', 'SJ', 'SJM', '744', '', 0),
(254, 'East Timor', '', 'TL', 'TLS', '626', '', 0),
(255, 'Tuvalu', '', 'TV', 'TUV', '798', '', 0),
(256, 'U.S. Virgin Islands', '', 'VI', 'VIR', '850', '', 0),
(257, 'United States Minor Outlying Islands', '', '', '', '', '', 0),
(258, 'Wallis and Futuna', '', 'WF', 'WLF', '876', '', 0),
(259, 'West Germany', '', '', '', '', '', 0),
(260, 'Western Sahara', '', 'EH', 'ESH', '732', '', 0),
(261, 'Zaire', '', '', '', '', '', 0),
(262, 'East Germany', '', '', '', '', '', 0),
(264, 'Curacao', '', 'CW', 'CUW', '531', '', 0),
(265, 'Ivory Coast', '', 'CI', 'CIV', '384', '', 0),
(266, 'Palestine', '', 'PS', 'PSE', '275', '', 0),
(267, 'Sint Maarten', '', 'SX', 'SXM', '534', '', 0),
(268, 'South Sudan', '', 'SS', 'SSD', '728', '', 0),
(269, 'Thailand', '', 'TH', 'THA', '764', '', 0),
(270, 'Tokelau', '', 'TK', 'TKL', '772', '', 0),
(271, 'Vatican', '', 'VA', 'VAT', '336', '', 0);


CREATE TABLE `geekPrefix_geekp_critics` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `content_id` int NOT NULL,
  `content_type` varchar(32) NOT NULL,
  `rating` double DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `introduction` text NOT NULL,
  `content` longtext NOT NULL,
  `positives` text NOT NULL,
  `negatives` text NOT NULL,
  `conclusion` text NOT NULL,
  `post_id` int NOT NULL,
  `published` tinyInt NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `rating` (`rating`),
   KEY `user_id` (`user_id`),
   KEY `post_id` (`post_id`),
   KEY `created` (`created_at`),
   KEY `updated` (`updated_at`)
) geek_charset_collate;

CREATE TABLE `geekPrefix_geekp_engines` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `logo` varchar(255) NOT NULL,
  `released` date DEFAULT NULL,
  `igdb_id` int DEFAULT NULL,
  `igdb_slug` varchar(255) DEFAULT NULL,
  `checked` tinyint NOT NULL DEFAULT '0',
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `name` (`name`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_engine_op` (
  `id` int NOT NULL AUTO_INCREMENT,
  `engine_id` int NOT NULL,
  `op_id` int NOT NULL,
  `op_type` varchar(32) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `engine_id` (`engine_id`),
   KEY `op` (`op_id`,`op_type`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_episodes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_id` int NOT NULL,
  `parent_id` int NOT NULL,
  `plot` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `season` tinyint NOT NULL,
  `episode` tinyint NOT NULL,
  `year` smallint NOT NULL,
  `released` date NOT NULL,
   PRIMARY KEY (`id`),
   KEY `title_id` (`title_id`),
   KEY `parent_id` (`parent_id`)
) geek_charset_collate;


CREATE TABLE `geekPrefix_geekp_families` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `type` varchar(32) NOT NULL,
  `parent_id` int NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;

INSERT INTO `geekPrefix_geekp_families` (`id`, `name`, `description`, `type`, `parent_id`, `post_id`) VALUES
(6, 'PlayStation', '', 'platform', 0, 180332),
(7, 'Sega', '', 'platform', 0, 180333),
(8, 'Nintendo', '', 'platform', 0, 180338),
(9, 'Xbox', '', 'platform', 0, 180339),
(10, 'Linux', '', 'platform', 0, 180340);



CREATE TABLE `geekPrefix_geekp_game_modes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `igdb_id` int NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;



INSERT INTO `geekPrefix_geekp_game_modes` (`id`, `name`, `aka`, `icon`, `igdb_id`, `post_id`) VALUES
(1, 'Co-operative (Co-op)', '', '', 3, 0),
(2, 'Massively Multiplayer Online (MMO)', '', '', 5, 0),
(3, 'Multiplayer', '', '', 2, 0),
(4, 'Single player', '', '', 1, 0),
(5, 'Split screen', '', '', 4, 0),
(6, 'Battle Royale', '', '', 6, 0);



CREATE TABLE `geekPrefix_geekp_game_op` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title_id` int NOT NULL,
  `op_id` int NOT NULL,
  `type` varchar(32) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `op` (`op_id`,`type`),
   KEY `title_id` (`title_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_game_relationships` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title_id` int NOT NULL,
  `content_id` int NOT NULL,
  `content_type` varchar(32) NOT NULL,
  `relation` varchar(32) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `relation` (`relation`),
   KEY `title_id` (`title_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_game_themes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `igdb_id` int NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;


INSERT INTO `geekPrefix_geekp_game_themes` (`id`, `name`, `aka`, `icon`, `igdb_id`, `post_id`) VALUES
(1, 'Adventure', '', '', 31, 0),
(2, 'Arcade', '', '', 33, 0),
(3, 'Fighting', '', '', 4, 0),
(4, 'Hack and Slash - Beat them up', '', '', 25, 0),
(5, 'Music', '', '', 7, 0),
(6, 'Pinball', '', '', 30, 0),
(7, 'Platform', '', '', 8, 0),
(8, 'Point-and-click', '', '', 2, 0),
(9, 'Puzzle', '', '', 9, 0),
(10, 'Quiz/Trivia', '', '', 26, 0),
(11, 'Racing', '', '', 10, 0),
(12, 'Real Time Strategy (RTS)', '', '', 11, 0),
(13, 'Role-playing (RPG)', '', '', 12, 0),
(14, 'Shooter', '', '', 5, 0),
(15, 'Simulator', '', '', 13, 0),
(16, 'Sport', '', '', 14, 0),
(17, 'Strategy', '', '', 15, 0),
(18, 'Tactical', '', '', 24, 0),
(19, 'Turn-based strategy (TBS)', '', '', 16, 0),
(20, 'Visual Novel', '', '', 34, 0),
(21, 'Indie', '', '', 32, 0),
(22, 'Card & Board Game', '', '', 35, 0),
(23, 'MOBA', '', '', 36, 0),
(24, 'Roguelike', '', '', 0, 0);



CREATE TABLE `geekPrefix_geekp_images` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `expansion` varchar(100) NOT NULL,
  `caption` text NOT NULL,
  `ext` varchar(100) NOT NULL,
  `path` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `type` varchar(32) NOT NULL,
  `fetch_type` varchar(32) NOT NULL,
  `fetch_id` varchar(32) NOT NULL,
  `attachment_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `attachment_id` (`attachment_id`),
   KEY `fetch` (`fetch_type`,`fetch_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_jobs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `imdb_key` varchar(100) NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;


INSERT INTO `geekPrefix_geekp_jobs` (`id`, `name`, `aka`, `icon`, `imdb_key`, `post_id`) VALUES
(1, 'Director', '', '', 'director', 0),
(2, 'Book Writer', '', '', 'book_writer', 0),
(3, 'Creator', '', '', 'creator', 0),
(4, 'Writer', '', '', 'writer', 0),
(5, 'Acting', '', '', 'cast', 0),
(6, 'Voice', '', '', 'voice', 0),
(7, 'Producer', '', '', 'producer', 0),
(8, 'Cinematographer ', '', '', 'cinematographer', 0),
(9, 'Art Director', '', '', 'art_director', 0),
(10, 'Music', '', '', 'composer', 0),
(11, 'Second Unit Director', '', '', 'second_unit_director', 0),
(12, 'Second Unit Director or Assistant Director', '', '', 'assistant_director', 0),
(13, 'Makeup Department', '', '', 'make_up_department', 0),
(14, 'Music Department', '', '', 'music_department', 0),
(15, 'Casting', '', '', 'casting_director', 0),
(16, 'Other Language Voice', '', '', '', 0),
(17, 'Production Design', '', '', 'production_designer', 0),
(18, 'Film Editing', '', '', 'editor', 0),
(19, 'Costume Designer', '', '', 'costume_designer', 0),
(20, 'Production Manager', '', '', 'production_manager', 0),
(21, 'Art Department', '', '', 'art_department', 0),
(22, 'Sound Department', '', '', 'sound_department', 0),
(23, 'Special Effects', '', '', 'special_effects', 0),
(24, 'Visual Effects', '', '', 'visual_effects', 0),
(25, 'Stunts', '', '', 'stunts', 0),
(26, 'Camera and Electrical Department ', '', '', 'camera_department', 0),
(27, 'Casting Department', '', '', 'casting_department', 0),
(28, 'Costume and Wardrobe Department', '', '', 'costume_department', 0),
(29, 'Editorial Department', '', '', 'editorial_department', 0),
(30, 'Transportation Department', '', '', 'transportation_department', 0),
(31, 'Set Decoration', '', '', 'set_decorator', 0),
(32, 'Additional Crew', '', '', 'miscellaneous', 0),
(33, 'Thanks', '', '', 'thanks', 0),
(34, 'Comic Book', '', '', 'comic_book', 0),
(35, 'Location Management', '', '', 'location_management', 0),
(36, 'Script and Continuity Department', '', '', 'script_department', 0),
(37, 'Animation Department', '', '', 'animation_department', 0);


CREATE TABLE `geekPrefix_geekp_langs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `native_name` varchar(255) NOT NULL,
  `locale` varchar(32) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `igdb_id` int NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;



INSERT INTO `geekPrefix_geekp_langs` (`id`, `name`, `aka`, `native_name`, `locale`, `icon`, `igdb_id`, `post_id`) VALUES
(1, 'Turkish', '', 'Türkçe', 'tr-TR', '', 24, 0),
(2, 'English', '', 'English (US)', 'en-US', '', 7, 0),
(3, 'German', '', 'Deutsch', 'de-DE', '', 27, 0),
(4, 'French', '', 'Français', 'fr-FR', '', 12, 0),
(5, 'Italian', '', 'Italiano', 'it-IT', '', 15, 0),
(6, 'Russian', '', 'Русский', 'ru-RU', '', 22, 0),
(7, 'Chinese', '', '', '', '', 0, 0),
(8, 'Japanese', '', '日本語', 'ja-JP', '', 16, 0),
(9, 'Spanish', '', 'Español (España)', 'es-ES', '', 9, 0),
(10, 'Korean', '', '한국어', 'ko-KR', '', 17, 0),
(11, 'Arabic', '', 'العربية', 'ar', '', 1, 0),
(12, 'Dutch', '', 'Nederlands', 'nl-NL', '', 6, 0),
(13, 'Hungarian', '', 'Magyar', 'hu-HU', '', 14, 0),
(14, 'Portuguese', '', 'Português (Portugal)', 'pt-PT', '', 20, 0),
(15, 'Bulgarian', '', '', '', '', 0, 0),
(16, 'Greek', '', '', '', '', 0, 0),
(17, 'Icelandic', '', '', '', '', 0, 0),
(18, 'Norwegian', '', 'Norsk', 'nb-NO', '', 18, 0),
(19, 'Punjabi', '', '', '', '', 0, 0),
(20, 'Swedish', '', 'Svenska', 'sv-SE', '', 23, 0),
(21, 'Finnish', '', 'Suomi', 'fi-FI', '', 11, 0),
(22, 'Hebrew', '', 'עברית', 'he-IL', '', 13, 0),
(23, 'Persian', '', '', '', '', 0, 0),
(24, 'Romanian', '', '', '', '', 0, 0),
(25, 'Croatian', '', '', '', '', 0, 0),
(26, 'Hindi', '', '', '', '', 0, 0),
(27, 'Polish', '', 'Polski', '\"pl-PL', '', 19, 0),
(28, 'Japanese Sign Language', '', '', '', '', 0, 0),
(29, 'Sindarin', '', '', '', '', 0, 0),
(30, 'Kurdish', '', '', '', '', 0, 0),
(31, 'Berber languages', '', '', '', '', 0, 0),
(32, 'Old English', '', '', '', '', 0, 0),
(33, 'Quenya', '', '', '', '', 0, 0),
(34, 'Khuzdul', '', '', '', '', 0, 0),
(35, 'Ukrainian', '', 'українська', 'uk-UA', '', 28, 0),
(36, 'Black Speech', '', '', '', '', 0, 0),
(37, 'Indonesian', '', '', '', '', 0, 0),
(38, 'Danish', '', 'Dansk', 'da-DK', '', 5, 0),
(39, 'Mandarin', '', '', '', '', 0, 0),
(40, 'Georgian', '', '', '', '', 0, 0),
(41, 'Chinese (Simplified)', '', '简体中文', 'zh-CN', '', 2, 0),
(42, 'Chinese (Traditional)', '', '繁體中文', 'zh-TW', '', 3, 0),
(43, 'Czech', '', 'čeština', 'cs-CZ', '', 4, 0),
(44, 'English (UK)', '', 'English (UK)', 'en-GB', '', 8, 0),
(45, 'Spanish (Mexico)', '', 'Español (Mexico)', 'es-MX', '', 10, 0),
(46, 'Portuguese (Brazil)', '', 'Português (Brasil)', 'pt-BR', '', 21, 0),
(47, 'Thai', '', 'ไทย', 'th-TH', '', 25, 0),
(48, 'Vietnamese', '', 'Tiếng Việt', 'vi-VN', '', 26, 0);



CREATE TABLE `geekPrefix_geekp_lang_supports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title_id` int NOT NULL,
  `lang_id` int NOT NULL,
  `audio` tinyint NOT NULL DEFAULT '0',
  `subtitles` tinyint NOT NULL DEFAULT '0',
  `interface` tinyint NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `lang_id` (`lang_id`),
   KEY `title_id` (`title_id`,`id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_lists` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `summary` text NOT NULL,
  `user_id` int NOT NULL,
  `type` varchar(32) NOT NULL DEFAULT 'general',
  `cover` varchar(255) NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `name` (`name`),
   KEY `user_id` (`user_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_persons` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `imdb_id` varchar(100) NOT NULL,
  `real_name` varchar(255) NOT NULL,
  `aka` text NOT NULL,
  `birthday` date NOT NULL,
  `death` date NOT NULL,
  `deathcause` varchar(255) NOT NULL,
  `deathplace` varchar(255) NOT NULL,
  `birthplace` varchar(255) NOT NULL,
  `bio` text NOT NULL,
  `website` varchar(255) NOT NULL,
  `eye_color` varchar(32) NOT NULL,
  `hair_color` varchar(32) NOT NULL,
  `height` varchar(32) NOT NULL,
  `weight` varchar(32) NOT NULL,
  `zodiac` varchar(32) NOT NULL,
  `gender` varchar(32) NOT NULL,
  `cover` varchar(255) NOT NULL,
  `cover_exp` varchar(100) NOT NULL,
  `check_imdb` int NOT NULL DEFAULT '0',
  `meter` int NOT NULL DEFAULT '999999999',
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `imdb_id` (`imdb_id`),
   KEY `post_id` (`post_id`),
   KEY `name` (`name`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_perspectives` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `igdb_id` int NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;


INSERT INTO `geekPrefix_geekp_perspectives` (`id`, `name`, `aka`, `icon`, `igdb_id`, `post_id`) VALUES
(1, 'Auditory', '', '', 6, 0),
(2, 'Bird View / Isometric', '', '', 3, 0),
(3, 'First Person', '', '', 1, 0),
(4, 'Third Person', '', '', 2, 0),
(5, 'Virtual Reality', '', '', 7, 0),
(6, 'Side View', '', '', 4, 0),
(7, 'Text', '', '', 5, 0);



CREATE TABLE `geekPrefix_geekp_platforms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `igdb_id` int NOT NULL,
  `aka` varchar(255) NOT NULL,
  `abb` varchar(32) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `type` varchar(32) NOT NULL,
  `description` text NOT NULL,
  `generation` tinyint NULL, 	
  `family_id` int NOT NULL,
  `igdb_slug` varchar(255) NOT NULL,
  `checked` tinyint NOT NULL DEFAULT '0',
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `name` (`name`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_platform_op` (
  `id` int NOT NULL AUTO_INCREMENT,
  `platform_id` int NOT NULL,
  `version_id` int NOT NULL,
  `op_id` int NOT NULL,
  `op_type` varchar(255) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `op` (`op_id`,`op_type`),
   KEY `platform_id` (`platform_id`,`version_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_platform_versions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `connectivity` varchar(255) NOT NULL,
  `cpu` varchar(255) NOT NULL,
  `graphics` varchar(255) NOT NULL,
  `media` varchar(255) NOT NULL,
  `online_service` varchar(255) NOT NULL,
  `memory` varchar(255) NOT NULL,
  `os` varchar(255) NOT NULL,
  `storage` varchar(255) NOT NULL,
  `sound` varchar(255) NOT NULL,
  `resolutions` varchar(255) NOT NULL,
  `output` varchar(255) NOT NULL,
  `summary` text NOT NULL,
  `logo` varchar(255) NOT NULL,
  `platform_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `platform_id` (`platform_id`)
) geek_charset_collate;

CREATE TABLE `geekPrefix_geekp_posts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content_id` int NOT NULL,
  `content_type` varchar(100) NOT NULL,
  `post_id` int NOT NULL,
  `type` varchar(100) NOT NULL,
  `post_date` timestamp NULL DEFAULT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `post_id` (`post_id`),
   KEY `type` (`type`),
   KEY `post_date` (`post_date`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_programs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `history` text NOT NULL,
  `comapny_id` int NOT NULL,
  `logo` varchar(255) NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;




CREATE TABLE `geekPrefix_geekp_regions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `aka` varchar(32) NOT NULL,
  `abb` varchar(32) NOT NULL,
  `icon` varchar(255) NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;



INSERT INTO `geekPrefix_geekp_regions` (`id`, `name`, `abb`, `icon`) VALUES
(1, 'Europe', 'EU', ''),
(2, 'North America', 'NA', ''),
(3, 'Australia', 'AU', ''),
(4, 'New Zeland', 'NZ', ''),
(5, 'Japan', 'JP', ''),
(6, 'China', 'CN', ''),
(7, 'Asia', 'AS', ''),
(8, 'Worldwide', 'WW', ''),
(9, 'Korea', 'KR', ''),
(10, 'Brazil', 'BR', '');



CREATE TABLE `geekPrefix_geekp_releases` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content_id` int NOT NULL,
  `content_type` varchar(32) NOT NULL,
  `date` date NOT NULL,
  `category` tinyint NOT NULL DEFAULT '0',
  `region_id` tinyint NOT NULL,
  `country_id` int NOT NULL,
  `platform_id` int NOT NULL,
  `type` varchar(32) NOT NULL,
  `order` tinyint NOT NULL,
   PRIMARY KEY (`id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `platform_id` (`platform_id`)
) geek_charset_collate;


CREATE TABLE `geekPrefix_geekp_reviews` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NOT NULL,
    `content_id` int NOT NULL,
    `content_type` varchar(32) NOT NULL,
    `rating` tinyInt NOT NULL,
    `title` varchar(255) NOT NULL,
    `introduction` text NOT NULL,
    `content` longtext NOT NULL,
    `positives` text NOT NULL,
    `negatives` text NOT NULL,
    `conclusion` text NOT NULL,
    `post_id` int NOT NULL,
    `published` tinyInt NOT NULL DEFAULT 0,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
     PRIMARY KEY (`id`),
     KEY `content` (`content_id`,`content_type`),
     KEY `rating` (`rating`),
     KEY `user_id` (`user_id`),
     KEY `post_id` (`post_id`),
     KEY `created` (`created_at`),
     KEY `updated` (`updated_at`)
) geek_charset_collate;


CREATE TABLE `geekPrefix_geekp_titles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `year` int NOT NULL,
  `imdb_id` varchar(100) NOT NULL,
  `igdb_id` varchar(100) NOT NULL,
  `igdb_slug` varchar(255) DEFAULT NULL,
  `external` varchar(255) DEFAULT NULL,
  `released` date NOT NULL,
  `sum` longtext NOT NULL,
  `storyline` longtext NOT NULL,
  `runtime` varchar(100) NOT NULL,
  `budget` varchar(255) NOT NULL,
  `gross` varchar(255) NOT NULL,
  `weekend_gross` varchar(255) NOT NULL,
  `ww_gross` varchar(255) NOT NULL,
  `age_limit` varchar(255) NOT NULL,
  `aspect` varchar(100) NOT NULL,
  `category` varchar(100) NOT NULL,
  `poster` varchar(255) NOT NULL,
  `poster_exp` varchar(100) NOT NULL,
  `family_id` int NOT NULL,
  `imdb_rating` double DEFAULT NULL,
  `imdb_count` int DEFAULT NULL,
  `igdb_rating` tinyint DEFAULT NULL,
  `igdb_count` int DEFAULT NULL,
  `rating` double DEFAULT NULL,
  `rating_count` int DEFAULT NULL,
  `critic` double DEFAULT NULL,
  `critic_count` int DEFAULT NULL,
  `metacritic` tinyint DEFAULT NULL,
  `check_imdb` int NOT NULL DEFAULT '0',
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `title` (`title`),
   KEY `aka` (`aka`),
   KEY `imdb_id` (`imdb_id`),
   KEY `igdb_id` (`igdb_id`)
) geek_charset_collate;


CREATE TABLE `geekPrefix_geekp_title_genres` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `aka` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `igdb_id` int NOT NULL,
  `post_id` int NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;


INSERT INTO `geekPrefix_geekp_title_genres` (`id`, `name`, `aka`, `icon`, `igdb_id`, `post_id`) VALUES
(1, 'Family', '', '', 0, 0),
(2, 'Action', '', '', 1, 0),
(3, 'Animation', '', '', 0, 0),
(4, 'Documentary', '', '', 0, 0),
(5, 'Sci-Fi', '', '', 18, 0),
(6, 'Biography', '', '', 0, 0),
(7, 'Bollywood', '', '', 0, 0),
(8, 'Spy', '', '', 0, 0),
(9, 'Cartoon', '', '', 0, 0),
(10, 'TV Series', '', '', 0, 0),
(11, 'Fight', '', '', 0, 0),
(12, 'Drama', '', '', 31, 0),
(13, 'Erotic', '', '', 42, 0),
(14, 'Fantasy', '', '', 17, 0),
(15, 'Thriller', '', '', 20, 0),
(16, 'Mystery', '', '', 43, 0),
(17, 'Talk-Show', '', '', 0, 0),
(18, 'News', '', '', 0, 0),
(19, 'Film Noir', '', '', 0, 0),
(20, 'Black List', '', '', 0, 0),
(21, 'Short', '', '', 0, 0),
(22, 'Classical', '', '', 0, 0),
(23, 'Comedy', '', '', 27, 0),
(24, 'Concert', '', '', 0, 0),
(25, 'Horror', '', '', 19, 0),
(26, 'Adventure', '', '', 0, 0),
(27, 'Music', '', '', 0, 0),
(28, 'Musical', '', '', 0, 0),
(29, 'Video Game', '', '', 0, 0),
(30, 'Police', '', '', 0, 0),
(31, 'Politic', '', '', 0, 0),
(32, 'Romance', '', '', 44, 0),
(33, 'Reality-TV', '', '', 0, 0),
(34, 'War', '', '', 0, 0),
(35, 'Silent Movie', '', '', 0, 0),
(36, 'Sport', '', '', 0, 0),
(37, 'Crime', '', '', 0, 0),
(38, 'Talk Show', '', '', 0, 0),
(39, 'History', '', '', 0, 0),
(40, 'Western', '', '', 0, 0),
(41, 'Adult', '', '', 0, 0),
(42, 'Survival', '', '', 21, 0),
(43, 'Sandbox', '', '', 33, 0),
(44, '4X (explore, expand, exploit, and exterminate)', '', '', 41, 0),
(45, 'Historical', '', '', 22, 0),
(46, 'Stealth', '', '', 23, 0),
(47, 'Business', '', '', 28, 0),
(48, 'Non-fiction', '', '', 32, 0),
(49, 'Educational', '', '', 34, 0),
(50, 'Kids', '', '', 35, 0),
(51, 'Open world', '', '', 38, 0),
(52, 'Warfare', '', '', 39, 0),
(53, 'Party', '', '', 40, 0);
(55, 'Horror', '', '', 19, 0);



CREATE TABLE `geekPrefix_geekp_title_op` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title_id` int NOT NULL,
  `op_id` int NOT NULL,
  `type` varchar(32) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `title_id` (`title_id`),
   KEY `op` (`op_id`,`type`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_title_people` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title_id` int NOT NULL,
  `job_id` int NOT NULL,
  `job_name` varchar(255) NOT NULL,
  `company_id` int NOT NULL,
  `person_id` int NOT NULL,
  `char_id` int NOT NULL,
  `char_name` varchar(255) NOT NULL,
  `que` int NOT NULL DEFAULT '9999',
   PRIMARY KEY (`id`),
   KEY `title` (`title_id`),
   KEY `person` (`person_id`),
   KEY `char` (`char_id`),
   KEY `job` (`job_id`),
   KEY `according_job` (`title_id`,`job_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_universes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` int NOT NULL,
  `description` int NOT NULL,
  `logo` varchar(255) NOT NULL,
  `type` varchar(32) NOT NULL,
  `parent_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY 	`parent_id` (`parent_id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_universe_op` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uni_id` int NOT NULL,
  `op_type` varchar(32) NOT NULL,
  `op_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `uni_id` (`uni_id`),
   KEY `op` (`op_id`,`op_type`)
) geek_charset_collate;

CREATE TABLE `geekPrefix_geekp_user_badges` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `badge_id` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `user_id` (`user_id`),
   KEY `badge_id` (`badge_id`)
) geek_charset_collate;

CREATE TABLE `geekPrefix_geekp_user_contents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `content_id` int NOT NULL,
  `content_type` varchar(32) NOT NULL,
  `action` varchar(32) NOT NULL,
  `status` varchar(32) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `user_id` (`user_id`),
   KEY `content` (`content_id`,`content_type`),
   KEY `action` (`action`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_videos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `source_id` varchar(255) NOT NULL,
  `source` varchar(255) NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `video_lang` int NOT NULL,
  `video_sub` int NOT NULL,
  `video_type` varchar(32) NOT NULL,
   PRIMARY KEY (`id`)
) geek_charset_collate;



CREATE TABLE `geekPrefix_geekp_websites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content_id` int NOT NULL,
  `content_type` varchar(32) NOT NULL,
  `category` tinyint NOT NULL,
  `trusted` tinyint NOT NULL DEFAULT '1',
  `url` varchar(255) NOT NULL,
   PRIMARY KEY (`id`)	
) geek_charset_collate;
