-- Adminer 4.7.5 MySQL dump

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';



CREATE TABLE `cities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `city` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `country` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `es` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `countries` (`id`, `es`, `en`, `pt`, `fr`, `code`, `lat`, `long`) VALUES
(1,	'Aruba',	'Aruba',	'Aruba',	'Aruba',	'AW',	'12.5',	'-69.96666666'),
(2,	'Afganistán',	'Afghanistan',	'Afeganistão',	'Afghanistan',	'AF',	'33',	'65'),
(3,	'Angola',	'Angola',	'Angola',	'Angola',	'AO',	'-12.5',	'18.5'),
(4,	'Anguilla',	'Anguilla',	'Anguilla',	'Anguilla',	'AI',	'18.25',	'-63.16666666'),
(5,	'Alandia',	'Åland Islands',	'Alândia',	'Ahvenanmaa',	'AX',	'60.116667',	'19.9'),
(6,	'Albania',	'Albania',	'Albânia',	'Albanie',	'AL',	'41',	'20'),
(7,	'Andorra',	'Andorra',	'Andorra',	'Andorre',	'AD',	'42.5',	'1.5'),
(8,	'Emiratos Árabes Unidos',	'United Arab Emirates',	'Emirados Árabes Unidos',	'Émirats arabes unis',	'AE',	'24',	'54'),
(9,	'Argentina',	'Argentina',	'Argentina',	'Argentine',	'AR',	'-34',	'-64'),
(10,	'Armenia',	'Armenia',	'Arménia',	'Arménie',	'AM',	'40',	'45'),
(11,	'Samoa Americana',	'American Samoa',	'Samoa Americana',	'Samoa américaines',	'AS',	'-14.33333333',	'-170'),
(12,	'Antártida',	'Antarctica',	'Antártida',	'Antarctique',	'AQ',	'-90',	'0'),
(13,	'Tierras Australes y Antárticas Francesas',	'French Southern and Antarctic Lands',	'Terras Austrais e Antárticas Francesas',	'Terres australes et antarctiques françaises',	'TF',	'-49.25',	'69.167'),
(14,	'Antigua y Barbuda',	'Antigua and Barbuda',	'Antígua e Barbuda',	'Antigua-et-Barbuda',	'AG',	'17.05',	'-61.8'),
(15,	'Australia',	'Australia',	'Austrália',	'Australie',	'AU',	'-27',	'133'),
(16,	'Austria',	'Austria',	'Áustria',	'Autriche',	'AT',	'47.33333333',	'13.33333333'),
(17,	'Azerbaiyán',	'Azerbaijan',	'Azerbeijão',	'Azerbaïdjan',	'AZ',	'40.5',	'47.5'),
(18,	'Burundi',	'Burundi',	'Burundi',	'Burundi',	'BI',	'-3.5',	'30'),
(19,	'Bélgica',	'Belgium',	'Bélgica',	'Belgique',	'BE',	'50.83333333',	'4'),
(20,	'Benín',	'Benin',	'Benin',	'Bénin',	'BJ',	'9.5',	'2.25'),
(21,	'Burkina Faso',	'Burkina Faso',	'Burkina Faso',	'Burkina Faso',	'BF',	'13',	'-2'),
(22,	'Bangladesh',	'Bangladesh',	'Bangladesh',	'Bangladesh',	'BD',	'24',	'90'),
(23,	'Bulgaria',	'Bulgaria',	'Bulgária',	'Bulgarie',	'BG',	'43',	'25'),
(24,	'Bahrein',	'Bahrain',	'Bahrein',	'Bahreïn',	'BH',	'26',	'50.55'),
(25,	'Bahamas',	'Bahamas',	'Bahamas',	'Bahamas',	'BS',	'24.25',	'-76'),
(26,	'Bosnia y Herzegovina',	'Bosnia and Herzegovina',	'Bósnia e Herzegovina',	'Bosnie-Herzégovine',	'BA',	'44',	'18'),
(27,	'San Bartolomé',	'Saint Barthélemy',	'São Bartolomeu',	'Saint-Barthélemy',	'BL',	'18.5',	'-63.41666666'),
(28,	'Santa Elena, Ascensión y Tristán de Acuña',	'Saint Helena, Ascension and Tristan da Cunha',	'Santa Helena, Ascensão e Tristão da Cunha',	'Sainte-Hélène, Ascension et Tristan da Cunha',	'SH',	'-15.95',	'-5.72'),
(29,	'Bielorrusia',	'Belarus',	'Bielorússia',	'Biélorussie',	'BY',	'53',	'28'),
(30,	'Belice',	'Belize',	'Belize',	'Belize',	'BZ',	'17.25',	'-88.75'),
(31,	'Bermudas',	'Bermuda',	'Bermudas',	'Bermudes',	'BM',	'32.33333333',	'-64.75'),
(32,	'Bolivia',	'Bolivia',	'Bolívia',	'Bolivie',	'BO',	'-17',	'-65'),
(33,	'Caribe Neerlandés',	'Caribbean Netherlands',	'Países Baixos Caribenhos',	'Pays-Bas caribéens',	'BQ',	'12.18',	'-68.25'),
(34,	'Brasil',	'Brazil',	'Brasil',	'Brésil',	'BR',	'-10',	'-55'),
(35,	'Barbados',	'Barbados',	'Barbados',	'Barbade',	'BB',	'13.16666666',	'-59.53333333'),
(36,	'Brunei',	'Brunei',	'Brunei',	'Brunei',	'BN',	'4.5',	'114.66666666'),
(37,	'Bután',	'Bhutan',	'Butão',	'Bhoutan',	'BT',	'27.5',	'90.5'),
(38,	'Isla Bouvet',	'Bouvet Island',	'Ilha Bouvet',	'Île Bouvet',	'BV',	'-54.43333333',	'3.4'),
(39,	'Botswana',	'Botswana',	'Botswana',	'Botswana',	'BW',	'-22',	'24'),
(40,	'República Centroafricana',	'Central African Republic',	'República Centro-Africana',	'République centrafricaine',	'CF',	'7',	'21'),
(41,	'Canadá',	'Canada',	'Canadá',	'Canada',	'CA',	'60',	'-95'),
(42,	'Islas Cocos o Islas Keeling',	'Cocos (Keeling) Islands',	'Ilhas Cocos (Keeling)',	'Îles Cocos',	'CC',	'-12.5',	'96.83333333'),
(43,	'Suiza',	'Switzerland',	'Suíça',	'Suisse',	'CH',	'47',	'8'),
(44,	'Chile',	'Chile',	'Chile',	'Chili',	'CL',	'-30',	'-71'),
(45,	'China',	'China',	'China',	'Chine',	'CN',	'35',	'105'),
(46,	'Costa de Marfil',	'Ivory Coast',	'Costa do Marfim',	'Côte d\'Ivoire',	'CI',	'8',	'-5'),
(47,	'Camerún',	'Cameroon',	'Camarões',	'Cameroun',	'CM',	'6',	'12'),
(48,	'Congo (Rep. Dem.)',	'DR Congo',	'República Democrática do Congo',	'Congo (Rép. dém.)',	'CD',	'0',	'25'),
(49,	'Congo',	'Republic of the Congo',	'Congo',	'Congo',	'CG',	'-1',	'15'),
(50,	'Islas Cook',	'Cook Islands',	'Ilhas Cook',	'Îles Cook',	'CK',	'-21.23333333',	'-159.76666666'),
(51,	'Colombia',	'Colombia',	'Colômbia',	'Colombie',	'CO',	'4',	'-72'),
(52,	'Comoras',	'Comoros',	'Comores',	'Comores',	'KM',	'-12.16666666',	'44.25'),
(53,	'Cabo Verde',	'Cape Verde',	'Cabo Verde',	'Îles du Cap-Vert',	'CV',	'16',	'-24'),
(54,	'Costa Rica',	'Costa Rica',	'Costa Rica',	'Costa Rica',	'CR',	'10',	'-84'),
(55,	'Cuba',	'Cuba',	'Cuba',	'Cuba',	'CU',	'21.5',	'-80'),
(56,	'Curazao',	'Curaçao',	'ilha da Curação',	'Curaçao',	'CW',	'12.116667',	'-68.933333'),
(57,	'Isla de Navidad',	'Christmas Island',	'Ilha do Natal',	'Île Christmas',	'CX',	'-10.5',	'105.66666666'),
(58,	'Islas Caimán',	'Cayman Islands',	'Ilhas Caimão',	'Îles Caïmans',	'KY',	'19.5',	'-80.5'),
(59,	'Chipre',	'Cyprus',	'Chipre',	'Chypre',	'CY',	'35',	'33'),
(60,	'Chequia',	'Czechia',	'Chéquia',	'Tchéquie',	'CZ',	'49.75',	'15.5'),
(61,	'Alemania',	'Germany',	'Alemanha',	'Allemagne',	'DE',	'51',	'9'),
(62,	'Djibouti',	'Djibouti',	'Djibouti',	'Djibouti',	'DJ',	'11.5',	'43'),
(63,	'Dominica',	'Dominica',	'Dominica',	'Dominique',	'DM',	'15.41666666',	'-61.33333333'),
(64,	'Dinamarca',	'Denmark',	'Dinamarca',	'Danemark',	'DK',	'56',	'10'),
(65,	'República Dominicana',	'Dominican Republic',	'República Dominicana',	'République dominicaine',	'DO',	'19',	'-70.66666666'),
(66,	'Argelia',	'Algeria',	'Argélia',	'Algérie',	'DZ',	'28',	'3'),
(67,	'Ecuador',	'Ecuador',	'Equador',	'Équateur',	'EC',	'-2',	'-77.5'),
(68,	'Egipto',	'Egypt',	'Egito',	'Égypte',	'EG',	'27',	'30'),
(69,	'Eritrea',	'Eritrea',	'Eritreia',	'Érythrée',	'ER',	'15',	'39'),
(70,	'Sahara Occidental',	'Western Sahara',	'Saara Ocidental',	'Sahara Occidental',	'EH',	'24.5',	'-13'),
(71,	'España',	'Spain',	'Espanha',	'Espagne',	'ES',	'40',	'-4'),
(72,	'Estonia',	'Estonia',	'Estónia',	'Estonie',	'EE',	'59',	'26'),
(73,	'Etiopía',	'Ethiopia',	'Etiópia',	'Éthiopie',	'ET',	'8',	'38'),
(74,	'Finlandia',	'Finland',	'Finlândia',	'Finlande',	'FI',	'64',	'26'),
(75,	'Fiyi',	'Fiji',	'Fiji',	'Fidji',	'FJ',	'-18',	'175'),
(76,	'Islas Malvinas',	'Falkland Islands',	'Ilhas Malvinas',	'Îles Malouines',	'FK',	'-51.75',	'-59'),
(77,	'Francia',	'France',	'França',	'France',	'FR',	'46',	'2'),
(78,	'Islas Faroe',	'Faroe Islands',	'Ilhas Faroé',	'Îles Féroé',	'FO',	'62',	'-7'),
(79,	'Micronesia',	'Micronesia',	'Micronésia',	'Micronésie',	'FM',	'6.91666666',	'158.25'),
(80,	'Gabón',	'Gabon',	'Gabão',	'Gabon',	'GA',	'-1',	'11.75'),
(81,	'Reino Unido',	'United Kingdom',	'Reino Unido',	'Royaume-Uni',	'GB',	'54',	'-2'),
(82,	'Georgia',	'Georgia',	'Geórgia',	'Géorgie',	'GE',	'42',	'43.5'),
(83,	'Guernsey',	'Guernsey',	'Guernsey',	'Guernesey',	'GG',	'49.46666666',	'-2.58333333'),
(84,	'Ghana',	'Ghana',	'Gana',	'Ghana',	'GH',	'8',	'-2'),
(85,	'Gibraltar',	'Gibraltar',	'Gibraltar',	'Gibraltar',	'GI',	'36.13333333',	'-5.35'),
(86,	'Guinea',	'Guinea',	'Guiné',	'Guinée',	'GN',	'11',	'-10'),
(87,	'Guadalupe',	'Guadeloupe',	'Guadalupe',	'Guadeloupe',	'GP',	'16.25',	'-61.583333'),
(88,	'Gambia',	'Gambia',	'Gâmbia',	'Gambie',	'GM',	'13.46666666',	'-16.56666666'),
(89,	'Guinea-Bisáu',	'Guinea-Bissau',	'Guiné-Bissau',	'Guinée-Bissau',	'GW',	'12',	'-15'),
(90,	'Guinea Ecuatorial',	'Equatorial Guinea',	'Guiné Equatorial',	'Guinée équatoriale',	'GQ',	'2',	'10'),
(91,	'Grecia',	'Greece',	'Grécia',	'Grèce',	'GR',	'39',	'22'),
(92,	'Grenada',	'Grenada',	'Granada',	'Grenade',	'GD',	'12.11666666',	'-61.66666666'),
(93,	'Groenlandia',	'Greenland',	'Gronelândia',	'Groenland',	'GL',	'72',	'-40'),
(94,	'Guatemala',	'Guatemala',	'Guatemala',	'Guatemala',	'GT',	'15.5',	'-90.25'),
(95,	'Guayana Francesa',	'French Guiana',	'Guiana Francesa',	'Guyane',	'GF',	'4',	'-53'),
(96,	'Guam',	'Guam',	'Guam',	'Guam',	'GU',	'13.46666666',	'144.78333333'),
(97,	'Guyana',	'Guyana',	'Guiana',	'Guyana',	'GY',	'5',	'-59'),
(98,	'Hong Kong',	'Hong Kong',	'Hong Kong',	'Hong Kong',	'HK',	'22.267',	'114.188'),
(99,	'Islas Heard y McDonald',	'Heard Island and McDonald Islands',	'Ilha Heard e Ilhas McDonald',	'Îles Heard-et-MacDonald',	'HM',	'-53.1',	'72.51666666'),
(100,	'Honduras',	'Honduras',	'Honduras',	'Honduras',	'HN',	'15',	'-86.5'),
(101,	'Croacia',	'Croatia',	'Croácia',	'Croatie',	'HR',	'45.16666666',	'15.5'),
(102,	'Haiti',	'Haiti',	'Haiti',	'Haïti',	'HT',	'19',	'-72.41666666'),
(103,	'Hungría',	'Hungary',	'Hungria',	'Hongrie',	'HU',	'47',	'20'),
(104,	'Indonesia',	'Indonesia',	'Indonésia',	'Indonésie',	'ID',	'-5',	'120'),
(105,	'Isla de Man',	'Isle of Man',	'Ilha de Man',	'Île de Man',	'IM',	'54.25',	'-4.5'),
(106,	'India',	'India',	'Índia',	'Inde',	'IN',	'20',	'77'),
(107,	'Territorio Británico del Océano Índico',	'British Indian Ocean Territory',	'Território Britânico do Oceano Índico',	'Territoire britannique de l\'océan Indien',	'IO',	'-6',	'71.5'),
(108,	'Irlanda',	'Ireland',	'Irlanda',	'Irlande',	'IE',	'53',	'-8'),
(109,	'Iran',	'Iran',	'Irão',	'Iran',	'IR',	'32',	'53'),
(110,	'Irak',	'Iraq',	'Iraque',	'Irak',	'IQ',	'33',	'44'),
(111,	'Islandia',	'Iceland',	'Islândia',	'Islande',	'IS',	'65',	'-18'),
(112,	'Israel',	'Israel',	'Israel',	'Israël',	'IL',	'31.47',	'35.13'),
(113,	'Italia',	'Italy',	'Itália',	'Italie',	'IT',	'42.83333333',	'12.83333333'),
(114,	'Jamaica',	'Jamaica',	'Jamaica',	'Jamaïque',	'JM',	'18.25',	'-77.5'),
(115,	'Jersey',	'Jersey',	'Jersey',	'Jersey',	'JE',	'49.25',	'-2.16666666'),
(116,	'Jordania',	'Jordan',	'Jordânia',	'Jordanie',	'JO',	'31',	'36'),
(117,	'Japón',	'Japan',	'Japão',	'Japon',	'JP',	'36',	'138'),
(118,	'Kazajistán',	'Kazakhstan',	'Cazaquistão',	'Kazakhstan',	'KZ',	'48',	'68'),
(119,	'Kenia',	'Kenya',	'Quénia',	'Kenya',	'KE',	'1',	'38'),
(120,	'Kirguizistán',	'Kyrgyzstan',	'Quirguistão',	'Kirghizistan',	'KG',	'41',	'75'),
(121,	'Camboya',	'Cambodia',	'Camboja',	'Cambodge',	'KH',	'13',	'105'),
(122,	'Kiribati',	'Kiribati',	'Kiribati',	'Kiribati',	'KI',	'1.41666666',	'173'),
(123,	'San Cristóbal y Nieves',	'Saint Kitts and Nevis',	'São Cristóvão e Nevis',	'Saint-Christophe-et-Niévès',	'KN',	'17.33333333',	'-62.75'),
(124,	'Corea del Sur',	'South Korea',	'Coreia do Sul',	'Corée du Sud',	'KR',	'37',	'127.5'),
(125,	'Kosovo',	'Kosovo',	'Kosovo',	'Kosovo',	'XK',	'42.666667',	'21.166667'),
(126,	'Kuwait',	'Kuwait',	'Kuwait',	'Koweït',	'KW',	'29.5',	'45.75'),
(127,	'Laos',	'Laos',	'Laos',	'Laos',	'LA',	'18',	'105'),
(128,	'Líbano',	'Lebanon',	'Líbano',	'Liban',	'LB',	'33.83333333',	'35.83333333'),
(129,	'Liberia',	'Liberia',	'Libéria',	'Liberia',	'LR',	'6.5',	'-9.5'),
(130,	'Libia',	'Libya',	'Líbia',	'Libye',	'LY',	'25',	'17'),
(131,	'Santa Lucía',	'Saint Lucia',	'Santa Lúcia',	'Sainte-Lucie',	'LC',	'13.88333333',	'-60.96666666'),
(132,	'Liechtenstein',	'Liechtenstein',	'Liechtenstein',	'Liechtenstein',	'LI',	'47.26666666',	'9.53333333'),
(133,	'Sri Lanka',	'Sri Lanka',	'Sri Lanka',	'Sri Lanka',	'LK',	'7',	'81'),
(134,	'Lesotho',	'Lesotho',	'Lesoto',	'Lesotho',	'LS',	'-29.5',	'28.5'),
(135,	'Lituania',	'Lithuania',	'Lituânia',	'Lituanie',	'LT',	'56',	'24'),
(136,	'Luxemburgo',	'Luxembourg',	'Luxemburgo',	'Luxembourg',	'LU',	'49.75',	'6.16666666'),
(137,	'Letonia',	'Latvia',	'Letónia',	'Lettonie',	'LV',	'57',	'25'),
(138,	'Macao',	'Macau',	'Macau',	'Macao',	'MO',	'22.16666666',	'113.55'),
(139,	'Saint Martin',	'Saint Martin',	'São Martinho',	'Saint-Martin',	'MF',	'18.08333333',	'-63.95'),
(140,	'Marruecos',	'Morocco',	'Marrocos',	'Maroc',	'MA',	'32',	'-5'),
(141,	'Mónaco',	'Monaco',	'Mónaco',	'Monaco',	'MC',	'43.73333333',	'7.4'),
(142,	'Moldavia',	'Moldova',	'Moldávia',	'Moldavie',	'MD',	'47',	'29'),
(143,	'Madagascar',	'Madagascar',	'Madagáscar',	'Madagascar',	'MG',	'-20',	'47'),
(144,	'Maldivas',	'Maldives',	'Maldivas',	'Maldives',	'MV',	'3.25',	'73'),
(145,	'México',	'Mexico',	'México',	'Mexique',	'MX',	'23',	'-102'),
(146,	'Islas Marshall',	'Marshall Islands',	'Ilhas Marshall',	'Îles Marshall',	'MH',	'9',	'168'),
(147,	'Macedonia',	'Macedonia',	'Macedónia',	'Macédoine',	'MK',	'41.83333333',	'22'),
(148,	'Mali',	'Mali',	'Mali',	'Mali',	'ML',	'17',	'-4'),
(149,	'Malta',	'Malta',	'Malta',	'Malte',	'MT',	'35.83333333',	'14.58333333'),
(150,	'Myanmar',	'Myanmar',	'Myanmar',	'Birmanie',	'MM',	'22',	'98'),
(151,	'Montenegro',	'Montenegro',	'Montenegro',	'Monténégro',	'ME',	'42.5',	'19.3'),
(152,	'Mongolia',	'Mongolia',	'Mongólia',	'Mongolie',	'MN',	'46',	'105'),
(153,	'Islas Marianas del Norte',	'Northern Mariana Islands',	'Marianas Setentrionais',	'Îles Mariannes du Nord',	'MP',	'15.2',	'145.75'),
(154,	'Mozambique',	'Mozambique',	'Moçambique',	'Mozambique',	'MZ',	'-18.25',	'35'),
(155,	'Mauritania',	'Mauritania',	'Mauritânia',	'Mauritanie',	'MR',	'20',	'-12'),
(156,	'Montserrat',	'Montserrat',	'Montserrat',	'Montserrat',	'MS',	'16.75',	'-62.2'),
(157,	'Martinica',	'Martinique',	'Martinica',	'Martinique',	'MQ',	'14.666667',	'-61'),
(158,	'Mauricio',	'Mauritius',	'Maurício',	'Île Maurice',	'MU',	'-20.28333333',	'57.55'),
(159,	'Malawi',	'Malawi',	'Malawi',	'Malawi',	'MW',	'-13.5',	'34'),
(160,	'Malasia',	'Malaysia',	'Malásia',	'Malaisie',	'MY',	'2.5',	'112.5'),
(161,	'Mayotte',	'Mayotte',	'Mayotte',	'Mayotte',	'YT',	'-12.83333333',	'45.16666666'),
(162,	'Namibia',	'Namibia',	'Namíbia',	'Namibie',	'NA',	'-22',	'17'),
(163,	'Nueva Caledonia',	'New Caledonia',	'Nova Caledónia',	'Nouvelle-Calédonie',	'NC',	'-21.5',	'165.5'),
(164,	'Níger',	'Niger',	'Níger',	'Niger',	'NE',	'16',	'8'),
(165,	'Isla de Norfolk',	'Norfolk Island',	'Ilha Norfolk',	'Île Norfolk',	'NF',	'-29.03333333',	'167.95'),
(166,	'Nigeria',	'Nigeria',	'Nigéria',	'Nigéria',	'NG',	'10',	'8'),
(167,	'Nicaragua',	'Nicaragua',	'Nicarágua',	'Nicaragua',	'NI',	'13',	'-85'),
(168,	'Niue',	'Niue',	'Niue',	'Niue',	'NU',	'-19.03333333',	'-169.86666666'),
(169,	'Países Bajos',	'Netherlands',	'Holanda',	'Pays-Bas',	'NL',	'52.5',	'5.75'),
(170,	'Noruega',	'Norway',	'Noruega',	'Norvège',	'NO',	'62',	'10'),
(171,	'Nepal',	'Nepal',	'Nepal',	'Népal',	'NP',	'28',	'84'),
(172,	'Nauru',	'Nauru',	'Nauru',	'Nauru',	'NR',	'-0.53333333',	'166.91666666'),
(173,	'Nueva Zelanda',	'New Zealand',	'Nova Zelândia',	'Nouvelle-Zélande',	'NZ',	'-41',	'174'),
(174,	'Omán',	'Oman',	'Omã',	'Oman',	'OM',	'21',	'57'),
(175,	'Pakistán',	'Pakistan',	'Paquistão',	'Pakistan',	'PK',	'30',	'70'),
(176,	'Panamá',	'Panama',	'Panamá',	'Panama',	'PA',	'9',	'-80'),
(177,	'Islas Pitcairn',	'Pitcairn Islands',	'Ilhas Pitcairn',	'Îles Pitcairn',	'PN',	'-25.06666666',	'-130.1'),
(178,	'Perú',	'Peru',	'Perú',	'Pérou',	'PE',	'-10',	'-76'),
(179,	'Filipinas',	'Philippines',	'Filipinas',	'Philippines',	'PH',	'13',	'122'),
(180,	'Palau',	'Palau',	'Palau',	'Palaos (Palau)',	'PW',	'7.5',	'134.5'),
(181,	'Papúa Nueva Guinea',	'Papua New Guinea',	'Papua Nova Guiné',	'Papouasie-Nouvelle-Guinée',	'PG',	'-6',	'147'),
(182,	'Polonia',	'Poland',	'Polónia',	'Pologne',	'PL',	'52',	'20'),
(183,	'Puerto Rico',	'Puerto Rico',	'Porto Rico',	'Porto Rico',	'PR',	'18.25',	'-66.5'),
(184,	'Corea del Norte',	'North Korea',	'Coreia do Norte',	'Corée du Nord',	'KP',	'40',	'127'),
(185,	'Portugal',	'Portugal',	'Portugal',	'Portugal',	'PT',	'39.5',	'-8'),
(186,	'Paraguay',	'Paraguay',	'Paraguai',	'Paraguay',	'PY',	'-23',	'-58'),
(187,	'Palestina',	'Palestine',	'Palestina',	'Palestine',	'PS',	'31.9',	'35.2'),
(188,	'Polinesia Francesa',	'French Polynesia',	'Polinésia Francesa',	'Polynésie française',	'PF',	'-15',	'-140'),
(189,	'Catar',	'Qatar',	'Catar',	'Qatar',	'QA',	'25.5',	'51.25'),
(190,	'Reunión',	'Réunion',	'Reunião',	'Réunion',	'RE',	'-21.15',	'55.5'),
(191,	'Rumania',	'Romania',	'Roménia',	'Roumanie',	'RO',	'46',	'25'),
(192,	'Rusia',	'Russia',	'Rússia',	'Russie',	'RU',	'60',	'100'),
(193,	'Ruanda',	'Rwanda',	'Ruanda',	'Rwanda',	'RW',	'-2',	'30'),
(194,	'Arabia Saudí',	'Saudi Arabia',	'Arábia Saudita',	'Arabie Saoudite',	'SA',	'25',	'45'),
(195,	'Sudán',	'Sudan',	'Sudão',	'Soudan',	'SD',	'15',	'30'),
(196,	'Senegal',	'Senegal',	'Senegal',	'Sénégal',	'SN',	'14',	'-14'),
(197,	'Singapur',	'Singapore',	'Singapura',	'Singapour',	'SG',	'1.36666666',	'103.8'),
(198,	'Islas Georgias del Sur y Sandwich del Sur',	'South Georgia',	'Ilhas Geórgia do Sul e Sandwich do Sul',	'Géorgie du Sud-et-les Îles Sandwich du Sud',	'GS',	'-54.5',	'-37'),
(199,	'Islas Svalbard y Jan Mayen',	'Svalbard and Jan Mayen',	'Ilhas Svalbard e Jan Mayen',	'Svalbard et Jan Mayen',	'SJ',	'78',	'20'),
(200,	'Islas Salomón',	'Solomon Islands',	'Ilhas Salomão',	'Îles Salomon',	'SB',	'-8',	'159'),
(201,	'Sierra Leone',	'Sierra Leone',	'Serra Leoa',	'Sierra Leone',	'SL',	'8.5',	'-11.5'),
(202,	'El Salvador',	'El Salvador',	'El Salvador',	'Salvador',	'SV',	'13.83333333',	'-88.91666666'),
(203,	'San Marino',	'San Marino',	'San Marino',	'Saint-Marin',	'SM',	'43.76666666',	'12.41666666'),
(204,	'Somalia',	'Somalia',	'Somália',	'Somalie',	'SO',	'10',	'49'),
(205,	'San Pedro y Miquelón',	'Saint Pierre and Miquelon',	'Saint-Pierre e Miquelon',	'Saint-Pierre-et-Miquelon',	'PM',	'46.83333333',	'-56.33333333'),
(206,	'Serbia',	'Serbia',	'Sérvia',	'Serbie',	'RS',	'44',	'21'),
(207,	'Sudán del Sur',	'South Sudan',	'Sudão do Sul',	'Soudan du Sud',	'SS',	'7',	'30'),
(208,	'Santo Tomé y Príncipe',	'São Tomé and Príncipe',	'São Tomé e Príncipe',	'São Tomé et Príncipe',	'ST',	'1',	'7'),
(209,	'Surinam',	'Suriname',	'Suriname',	'Surinam',	'SR',	'4',	'-56'),
(210,	'República Eslovaca',	'Slovakia',	'Eslováquia',	'Slovaquie',	'SK',	'48.66666666',	'19.5'),
(211,	'Eslovenia',	'Slovenia',	'Eslovénia',	'Slovénie',	'SI',	'46.11666666',	'14.81666666'),
(212,	'Suecia',	'Sweden',	'Suécia',	'Suède',	'SE',	'62',	'15'),
(213,	'Suazilandia',	'Swaziland',	'Suazilândia',	'Swaziland',	'SZ',	'-26.5',	'31.5'),
(214,	'Sint Maarten',	'Sint Maarten',	'São Martinho',	'Saint-Martin',	'SX',	'18.033333',	'-63.05'),
(215,	'Seychelles',	'Seychelles',	'Seicheles',	'Seychelles',	'SC',	'-4.58333333',	'55.66666666'),
(216,	'Siria',	'Syria',	'Síria',	'Syrie',	'SY',	'35',	'38'),
(217,	'Islas Turks y Caicos',	'Turks and Caicos Islands',	'Ilhas Turks e Caicos',	'Îles Turques-et-Caïques',	'TC',	'21.75',	'-71.58333333'),
(218,	'Chad',	'Chad',	'Chade',	'Tchad',	'TD',	'15',	'19'),
(219,	'Togo',	'Togo',	'Togo',	'Togo',	'TG',	'8',	'1.16666666'),
(220,	'Tailandia',	'Thailand',	'Tailândia',	'Thaïlande',	'TH',	'15',	'100'),
(221,	'Tayikistán',	'Tajikistan',	'Tajiquistão',	'Tadjikistan',	'TJ',	'39',	'71'),
(222,	'Islas Tokelau',	'Tokelau',	'Tokelau',	'Tokelau',	'TK',	'-9',	'-172'),
(223,	'Turkmenistán',	'Turkmenistan',	'Turquemenistão',	'Turkménistan',	'TM',	'40',	'60'),
(224,	'Timor Oriental',	'Timor-Leste',	'Timor-Leste',	'Timor oriental',	'TL',	'-8.83333333',	'125.91666666'),
(225,	'Tonga',	'Tonga',	'Tonga',	'Tonga',	'TO',	'-20',	'-175'),
(226,	'Trinidad y Tobago',	'Trinidad and Tobago',	'Trinidade e Tobago',	'Trinité-et-Tobago',	'TT',	'11',	'-61'),
(227,	'Túnez',	'Tunisia',	'Tunísia',	'Tunisie',	'TN',	'34',	'9'),
(228,	'Turquía',	'Turkey',	'Turquia',	'Turquie',	'TR',	'39',	'35'),
(229,	'Tuvalu',	'Tuvalu',	'Tuvalu',	'Tuvalu',	'TV',	'-8',	'178'),
(230,	'Taiwán',	'Taiwan',	'Ilha Formosa',	'Taïwan',	'TW',	'23.5',	'121'),
(231,	'Tanzania',	'Tanzania',	'Tanzânia',	'Tanzanie',	'TZ',	'-6',	'35'),
(232,	'Uganda',	'Uganda',	'Uganda',	'Ouganda',	'UG',	'1',	'32'),
(233,	'Ucrania',	'Ukraine',	'Ucrânia',	'Ukraine',	'UA',	'49',	'32'),
(234,	'Islas Ultramarinas Menores de Estados Unidos',	'United States Minor Outlying Islands',	'Ilhas Menores Distantes dos Estados Unidos',	'Îles mineures éloignées des États-Unis',	'UM',	'19.3',	'166.633333'),
(235,	'Uruguay',	'Uruguay',	'Uruguai',	'Uruguay',	'UY',	'-33',	'-56'),
(236,	'Estados Unidos',	'United States',	'Estados Unidos',	'États-Unis',	'US',	'38',	'-97'),
(237,	'Uzbekistán',	'Uzbekistan',	'Uzbequistão',	'Ouzbékistan',	'UZ',	'41',	'64'),
(238,	'Ciudad del Vaticano',	'Vatican City',	'Cidade do Vaticano',	'Cité du Vatican',	'VA',	'41.9',	'12.45'),
(239,	'San Vicente y Granadinas',	'Saint Vincent and the Grenadines',	'São Vincente e Granadinas',	'Saint-Vincent-et-les-Grenadines',	'VC',	'13.25',	'-61.2'),
(240,	'Venezuela',	'Venezuela',	'Venezuela',	'Venezuela',	'VE',	'8',	'-66'),
(241,	'Islas Vírgenes del Reino Unido',	'British Virgin Islands',	'Ilhas Virgens',	'Îles Vierges britanniques',	'VG',	'18.431383',	'-64.62305'),
(242,	'Islas Vírgenes de los Estados Unidos',	'United States Virgin Islands',	'Ilhas Virgens dos Estados Unidos',	'Îles Vierges des États-Unis',	'VI',	'18.35',	'-64.933333'),
(243,	'Vietnam',	'Vietnam',	'Vietname',	'Viêt Nam',	'VN',	'16.16666666',	'107.83333333'),
(244,	'Vanuatu',	'Vanuatu',	'Vanuatu',	'Vanuatu',	'VU',	'-16',	'167'),
(245,	'Wallis y Futuna',	'Wallis and Futuna',	'Wallis e Futuna',	'Wallis-et-Futuna',	'WF',	'-13.3',	'-176.2'),
(246,	'Samoa',	'Samoa',	'Samoa',	'Samoa',	'WS',	'-13.58333333',	'-172.33333333'),
(247,	'Yemen',	'Yemen',	'Iémen',	'Yémen',	'YE',	'15',	'48'),
(248,	'República de Sudáfrica',	'South Africa',	'África do Sul',	'Afrique du Sud',	'ZA',	'-29',	'24'),
(249,	'Zambia',	'Zambia',	'Zâmbia',	'Zambie',	'ZM',	'-15',	'30'),
(250,	'Zimbabue',	'Zimbabwe',	'Zimbabwe',	'Zimbabwe',	'ZW',	'-20',	'30');

CREATE TABLE `group_revisor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned DEFAULT NULL,
  `revisor_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_revisor_group_id_foreign` (`group_id`),
  KEY `group_revisor_revisor_id_foreign` (`revisor_id`),
  CONSTRAINT `group_revisor_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `group_revisor_revisor_id_foreign` FOREIGN KEY (`revisor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1,	'0000_00_00_000000_create_taggable_table',	1),
(2,	'2014_10_12_000000_create_users_table',	1),
(3,	'2014_10_12_100000_create_password_resets_table',	1),
(4,	'2014_11_25_231620_create_countries_table',	1),
(5,	'2015_02_24_190249_create_types_table',	1),
(6,	'2015_11_26_100000_create_cities_table',	1),
(7,	'2017_02_24_185517_create_userdata_table',	1),
(8,	'2017_02_24_185615_create_teams_table',	1),
(9,	'2018_02_24_190018_create_projects_table',	1),
(10,	'2018_02_24_190040_create_attachments_table',	1),
(11,	'2018_02_24_201623_create_team_user_pivot_table',	1),
(12,	'2018_02_24_201649_create_project_team_pivot_table',	1),
(13,	'2018_02_28_034054_alter_taggable_tags_table',	1),
(14,	'2018_04_06_145557_create_permission_tables',	1),
(15,	'2018_04_09_163403_create_groups_table',	1),
(16,	'2018_04_09_163503_create_group_revisor_table',	1),
(17,	'2018_04_09_163603_create_stage_table',	1),
(18,	'2018_04_09_175933_create_project_revisor_table',	1),
(19,	'2018_04_12_154816_create_reviews_table',	1),
(20,	'2018_08_24_185508_create_inscriptions_table',	1),
(21,	'2018_09_24_211144_create_invites_table',	1);

CREATE TABLE `model_has_permissions` (
  `permission_id` int(10) unsigned NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_type_model_id_index` (`model_type`,`model_id`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `model_has_roles` (
  `role_id` int(10) unsigned NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_type_model_id_index` (`model_type`,`model_id`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1,	'App\\User',	1),
(4,	'App\\User',	2);


CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `project_revisor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(10) unsigned DEFAULT NULL,
  `revisor_id` int(10) unsigned DEFAULT NULL,
  `stage_id` int(10) unsigned DEFAULT NULL,
  `group_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_revisor_project_id_foreign` (`project_id`),
  KEY `project_revisor_revisor_id_foreign` (`revisor_id`),
  KEY `project_revisor_stage_id_foreign` (`stage_id`),
  KEY `project_revisor_group_id_foreign` (`group_id`),
  CONSTRAINT `project_revisor_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `project_revisor_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `project_revisor_revisor_id_foreign` FOREIGN KEY (`revisor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `project_revisor_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `project_team` (
  `project_id` int(10) unsigned NOT NULL,
  `team_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`project_id`,`team_id`),
  KEY `project_team_project_id_index` (`project_id`),
  KEY `project_team_team_id_index` (`team_id`),
  CONSTRAINT `project_team_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `project_team_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `reviews` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(10) unsigned DEFAULT NULL,
  `revisor_id` int(10) unsigned DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rating` int(10) unsigned DEFAULT NULL,
  `type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reviews_project_id_foreign` (`project_id`),
  KEY `reviews_revisor_id_foreign` (`revisor_id`),
  CONSTRAINT `reviews_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reviews_revisor_id_foreign` FOREIGN KEY (`revisor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `role_has_permissions` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1,	'superadmin',	'web',	'2018-04-06 16:25:28',	'2018-04-06 16:25:28'),
(2,	'administrador',	'web',	'2018-04-06 16:27:02',	'2018-04-06 16:27:02'),
(3,	'revisor',	'web',	'2018-04-06 16:27:24',	'2018-04-06 16:27:24'),
(4,	'postulante',	'web',	'2018-04-06 16:28:59',	'2018-04-06 16:28:59');

CREATE TABLE `stages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `taggable_taggables` (
  `tag_id` int(10) unsigned NOT NULL,
  `taggable_id` int(10) unsigned NOT NULL,
  `taggable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `i_taggable_fwd` (`tag_id`,`taggable_id`),
  KEY `i_taggable_rev` (`taggable_id`,`tag_id`),
  KEY `i_taggable_type` (`taggable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `taggable_tags` (
  `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `normalized` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `es` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT '99',
  PRIMARY KEY (`tag_id`),
  KEY `taggable_tags_normalized_index` (`normalized`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `taggable_tags` (`tag_id`, `name`, `normalized`, `created_at`, `updated_at`, `es`, `en`, `pt`, `fr`, `type`, `slug`, `order`) VALUES
(1,	'Photography',	'Photography',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Fotografía',	'Photography',	NULL,	NULL,	'artists',	'photography',	10),
(2,	'Sculpture',	'Sculpture',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Escultura',	'Sculpture',	NULL,	NULL,	'artists',	'sculpture',	20),
(3,	'Graphic',	'Graphic',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Gráfica',	'Graphic',	NULL,	NULL,	'artists',	'graphic',	30),
(4,	'Action',	'Action',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Acción',	'Action',	NULL,	NULL,	'artists',	'action',	40),
(5,	'Video',	'Video',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Video',	'Video',	NULL,	NULL,	'artists',	'video',	50),
(6,	'Painting',	'Painting',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Pintura',	'Painting',	NULL,	NULL,	'artists',	'painting',	60),
(7,	'Object',	'Object',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Objeto',	'Object',	NULL,	NULL,	'artists',	'object',	70),
(8,	'Instalation',	'Instalation',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Instalación',	'Instalation',	NULL,	NULL,	'artists',	'instalation',	80),
(9,	'Performance',	'Performance',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Performance',	'Performance',	NULL,	NULL,	'artists',	'performance',	90),
(10,	'Videoinstalation',	'Performance',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Videoinstalación',	'Videoinstalation',	NULL,	NULL,	'artists',	'videoinstalation',	100),
(11,	'Others',	'Others',	'2018-02-28 00:00:00',	'2018-02-28 00:00:00',	'Otros',	'Others',	NULL,	NULL,	'artists',	'others',	140),
(12,	'Espacio Público      ',	'Espacio Público      ',	'2020-02-12 03:32:20',	'2020-02-12 03:32:20',	'Espacio Público',	'Espacio Público',	'Espacio Público',	'Espacio Público',	'artists',	'public-space',	110),
(13,	'Acción Social ',	'Acción Social ',	'2020-02-12 03:33:10',	'2020-02-12 03:33:10',	'Acción Social ',	'Acción Social ',	'Acción Social ',	'Espacio Público',	'artists',	'social-action',	120);

CREATE TABLE `team_user` (
  `team_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`team_id`,`user_id`),
  KEY `team_user_team_id_index` (`team_id`),
  KEY `team_user_user_id_index` (`user_id`),
  CONSTRAINT `team_user_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE CASCADE,
  CONSTRAINT `team_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `teams` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `teams_user_id_foreign` (`user_id`),
  CONSTRAINT `teams_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_es` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_pt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_fr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `types` (`id`, `name`, `slug`, `name_es`, `name_pt`, `name_fr`, `name_en`, `created_at`, `updated_at`) VALUES
(1,	'Artists',	'artist',	'Artistas',	'art_port',	'art_fr',	'Artists',	NULL,	NULL),
(2,	'Curators',	'curator',	'Curadores',	'cura_port',	'cura_fr',	'Curators',	NULL,	NULL);

CREATE TABLE `userdata` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fullname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dni_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dni` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city_id` int(10) unsigned DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `nacionality` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthdate` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cellphone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `web` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `userdata_user_id_foreign` (`user_id`),
  KEY `userdata_city_id_foreign` (`city_id`),
  CONSTRAINT `userdata_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `userdata_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `userdata` (`id`, `name`, `surname`, `fullname`, `email`, `dni_type`, `dni`, `address`, `city`, `city_id`, `country_id`, `nacionality`, `birthdate`, `telephone`, `cellphone`, `web`, `user_id`, `created_at`, `updated_at`) VALUES
(1,	'admin',	'admin',	'admin-admin',	'admin@admin.com',	'',	'123',	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	1,	NULL,	'2018-04-10 13:42:44');

-- 2020-02-13 03:39:14
