INSERT INTO `{prefix}permissions` (`name`, `key`, `is_support_guest`, `group_id`, `created_at`, `updated_at`, `type`, `is_support_moderator`, `order`, `description`) VALUES
('Manage Countries', 'admin.country.manage', 0, 1, NOW(), NOW(), 'checkbox', 1, 23, '');

INSERT INTO `{prefix}permission_groups` (`name`, `key`, `created_at`, `updated_at`, `order`) VALUES
('Post', 'post', NOW(), NOW(), 2);

INSERT INTO `{prefix}permissions` (`name`, `key`, `is_support_guest`, `group_id`, `created_at`, `updated_at`, `type`, `is_support_moderator`, `order`, `description`) VALUES
('Manage Packages', 'admin.subscription.manage', 0, 1, NOW(), NOW(), 'checkbox', 1, 24, ''),
('Max characters per post', 'post.character_max', 0, (SELECT `id` FROM `{prefix}permission_groups` WHERE `key` = 'post'), NOW(), NOW(), 'text', 0, 1, ''),
('Max video size (duration - seconds) can upload', 'post.video_max_duration', 0, (SELECT `id` FROM `{prefix}permission_groups` WHERE `key` = 'post'), NOW(), NOW(), 'text', 0, 2, '');

INSERT INTO `{prefix}setting_group_subs` (`name`, `group_id`, `key`, `order`, `package`) VALUES 
('Post', 2, 'post', (SELECT MAX(p.`order`) + 1 FROM `{prefix}setting_group_subs` as p), 'shaun_core');

INSERT INTO `{prefix}settings` (`key`, `name`, `description`, `value`, `params`, `type`, `order`, `group_id`, `group_sub_id`, `hidden`) VALUES
('post.upload_files_enable', 'Allow to attach files to the post', '', '1', '', 'checkbox', 1, 2, (SELECT `id` FROM `{prefix}setting_group_subs` WHERE `key` = 'post'), 0),
('post.support_files', 'Supported file formats', '', 'txt,doc,docx,csv,xls,xlsx,ppt,pptx,pdf,ai,psd', '', 'text', 2, 2, (SELECT `id` FROM `{prefix}setting_group_subs` WHERE `key` = 'post'), 0),
('post.post_file_max', 'Post - maximum files can be attached', 'Maximum files that member can attach into a post.', '10', '', 'number', 3, 2, (SELECT `id` FROM `{prefix}setting_group_subs` WHERE `key` = 'post'), 0);

UPDATE `{prefix}settings` SET `group_sub_id` = (SELECT `id` FROM `{prefix}setting_group_subs` WHERE `key` = 'post') WHERE `key` = 'feature.post_photo_max';
UPDATE `{prefix}settings` SET `group_sub_id` = (SELECT `id` FROM `{prefix}setting_group_subs` WHERE `key` = 'post') WHERE `key` = 'feature.post_character_max';

INSERT INTO `{prefix}countries` (`id`, `name`, `country_iso`, `state_count`, `order`, `is_active`) VALUES
(1,	'United States',	'US',	51,	231,	1),
(2,	'United Arab Emirates',	'AE',	0,	229,	1),
(3,	'Afghanistan',	'AF',	0,	1,	1),
(4,	'Antigua and Barbuda',	'AG',	0,	10,	1),
(5,	'Anguilla',	'AI',	0,	8,	1),
(6,	'Albania',	'AL',	0,	3,	1),
(7,	'Armenia',	'AM',	0,	12,	1),
(8,	'Netherlands Antilles',	'AN',	0,	155,	1),
(9,	'Angola',	'AO',	0,	7,	1),
(10,	'Antarctica',	'AQ',	0,	9,	1),
(11,	'Argentina',	'AR',	0,	11,	1),
(12,	'American Samoa',	'AS',	0,	5,	1),
(13,	'Austria',	'AT',	0,	15,	1),
(14,	'Australia',	'AU',	0,	14,	1),
(15,	'Aruba',	'AW',	0,	13,	1),
(16,	'Aland Islands',	'AX',	0,	2,	1),
(17,	'Azerbaijan',	'AZ',	0,	16,	1),
(18,	'Bosnia and Herzegovina',	'BA',	0,	28,	1),
(19,	'Barbados',	'BB',	0,	20,	1),
(20,	'Bangladesh',	'BD',	0,	19,	1),
(21,	'Belgium',	'BE',	0,	22,	1),
(22,	'Burkina Faso',	'BF',	0,	35,	1),
(23,	'Bulgaria',	'BG',	0,	34,	1),
(24,	'Bahrain',	'BH',	0,	18,	1),
(25,	'Burundi',	'BI',	0,	36,	1),
(26,	'Benin',	'BJ',	0,	24,	1),
(27,	'Saint Barthelemy',	'BL',	0,	183,	1),
(28,	'Bermuda',	'BM',	0,	25,	1),
(29,	'Brunei Darussalam',	'BN',	0,	33,	1),
(30,	'Bolivia',	'BO',	0,	27,	1),
(31,	'Brazil',	'BR',	0,	31,	1),
(32,	'Bahamas',	'BS',	0,	17,	1),
(33,	'Bhutan',	'BT',	0,	26,	1),
(34,	'Bouvet Island',	'BV',	0,	30,	1),
(35,	'Botswana',	'BW',	0,	29,	1),
(36,	'Belarus',	'BY',	0,	21,	1),
(37,	'Belize',	'BZ',	0,	23,	1),
(38,	'Canada',	'CA',	0,	39,	1),
(39,	'Cocos (Keeling) Islands',	'CC',	0,	47,	1),
(40,	'Congo, the Democratic Republic of the',	'CD',	0,	51,	1),
(41,	'Central African Republic',	'CF',	0,	42,	1),
(42,	'Congo',	'CG',	0,	50,	1),
(43,	'Switzerland',	'CH',	0,	211,	1),
(44,	'Cote D\'Ivoire',	'CI',	0,	54,	1),
(45,	'Cook Islands',	'CK',	0,	52,	1),
(46,	'Chile',	'CL',	0,	44,	1),
(47,	'Cameroon',	'CM',	0,	38,	1),
(48,	'China',	'CN',	0,	45,	1),
(49,	'Colombia',	'CO',	0,	48,	1),
(50,	'Costa Rica',	'CR',	0,	53,	1),
(51,	'Cuba',	'CU',	0,	56,	1),
(52,	'Cape Verde',	'CV',	0,	40,	1),
(53,	'Christmas Island',	'CX',	0,	46,	1),
(54,	'Cyprus',	'CY',	0,	57,	1),
(55,	'Czech Republic',	'CZ',	0,	58,	1),
(56,	'Germany',	'DE',	0,	81,	1),
(57,	'Djibouti',	'DJ',	0,	60,	1),
(58,	'Denmark',	'DK',	0,	59,	1),
(59,	'Dominica',	'DM',	0,	61,	1),
(60,	'Dominican Republic',	'DO',	0,	62,	1),
(61,	'Algeria',	'DZ',	0,	4,	1),
(62,	'Ecuador',	'EC',	0,	63,	1),
(63,	'Estonia',	'EE',	0,	68,	1),
(64,	'Egypt',	'EG',	0,	64,	1),
(65,	'Western Sahara',	'EH',	0,	241,	1),
(66,	'Eritrea',	'ER',	0,	67,	1),
(67,	'Spain',	'ES',	0,	204,	1),
(68,	'Ethiopia',	'ET',	0,	69,	1),
(69,	'Finland',	'FI',	0,	73,	1),
(70,	'Fiji',	'FJ',	0,	72,	1),
(71,	'Falkland Islands (Malvinas)',	'FK',	0,	70,	1),
(72,	'Micronesia, Federated States of',	'FM',	0,	142,	1),
(73,	'Faroe Islands',	'FO',	0,	71,	1),
(74,	'France',	'FR',	0,	74,	1),
(75,	'Gabon',	'GA',	0,	78,	1),
(76,	'United Kingdom',	'GB',	0,	230,	1),
(77,	'Grenada',	'GD',	0,	86,	1),
(78,	'Georgia',	'GE',	0,	80,	1),
(79,	'French Guiana',	'GF',	0,	75,	1),
(80,	'Guernsey',	'GG',	0,	90,	1),
(81,	'Ghana',	'GH',	0,	82,	1),
(82,	'Gibraltar',	'GI',	0,	83,	1),
(83,	'Greenland',	'GL',	0,	85,	1),
(84,	'Gambia',	'GM',	0,	79,	1),
(85,	'Guinea',	'GN',	0,	91,	1),
(86,	'Guadeloupe',	'GP',	0,	87,	1),
(87,	'Equatorial Guinea',	'GQ',	0,	66,	1),
(88,	'Greece',	'GR',	0,	84,	1),
(89,	'South Georgia and the South Sandwich Islands',	'GS',	0,	203,	1),
(90,	'Guatemala',	'GT',	0,	89,	1),
(91,	'Guam',	'GU',	0,	88,	1),
(92,	'Guinea-Bissau',	'GW',	0,	92,	1),
(93,	'Guyana',	'GY',	0,	93,	1),
(94,	'Hong Kong',	'HK',	0,	98,	1),
(95,	'Heard Island and Mcdonald Islands',	'HM',	0,	95,	1),
(96,	'Honduras',	'HN',	0,	97,	1),
(97,	'Croatia',	'HR',	0,	55,	1),
(98,	'Haiti',	'HT',	0,	94,	1),
(99,	'Hungary',	'HU',	0,	99,	1),
(100,	'Indonesia',	'ID',	0,	102,	1),
(101,	'Ireland',	'IE',	0,	105,	1),
(102,	'Israel',	'IL',	0,	107,	1),
(103,	'Isle of Man',	'IM',	0,	106,	1),
(104,	'India',	'IN',	0,	101,	1),
(105,	'British Indian Ocean Territory',	'IO',	0,	32,	1),
(106,	'Iraq',	'IQ',	0,	104,	1),
(107,	'Iran, Islamic Republic of',	'IR',	0,	103,	1),
(108,	'Iceland',	'IS',	0,	100,	1),
(109,	'Italy',	'IT',	0,	108,	1),
(110,	'Jamaica',	'JM',	0,	109,	1),
(111,	'Jordan',	'JO',	0,	111,	1),
(112,	'Japan',	'JP',	0,	110,	1),
(113,	'Kenya',	'KE',	0,	113,	1),
(114,	'Kyrgyzstan',	'KG',	0,	118,	1),
(115,	'Cambodia',	'KH',	0,	37,	1),
(116,	'Kiribati',	'KI',	0,	114,	1),
(117,	'Comoros',	'KM',	0,	49,	1),
(118,	'Saint Kitts and Nevis',	'KN',	0,	185,	1),
(119,	'Korea, Democratic People\'s Republic of',	'KP',	0,	115,	1),
(120,	'Korea, Republic of',	'KR',	0,	116,	1),
(121,	'Kuwait',	'KW',	0,	117,	1),
(122,	'Cayman Islands',	'KY',	0,	41,	1),
(123,	'Kazakhstan',	'KZ',	0,	112,	1),
(124,	'Lao People\'s Democratic Republic',	'LA',	0,	119,	1),
(125,	'Lebanon',	'LB',	0,	121,	1),
(126,	'Saint Lucia',	'LC',	0,	186,	1),
(127,	'Liechtenstein',	'LI',	0,	125,	1),
(128,	'Sri Lanka',	'LK',	0,	205,	1),
(129,	'Liberia',	'LR',	0,	123,	1),
(130,	'Lesotho',	'LS',	0,	122,	1),
(131,	'Lithuania',	'LT',	0,	126,	1),
(132,	'Luxembourg',	'LU',	0,	127,	1),
(133,	'Latvia',	'LV',	0,	120,	1),
(134,	'Libyan Arab Jamahiriya',	'LY',	0,	124,	1),
(135,	'Morocco',	'MA',	0,	148,	1),
(136,	'Monaco',	'MC',	0,	144,	1),
(137,	'Moldova, Republic of',	'MD',	0,	143,	1),
(138,	'Montenegro',	'ME',	0,	146,	1),
(139,	'Madagascar',	'MG',	0,	130,	1),
(140,	'Marshall Islands',	'MH',	0,	136,	1),
(141,	'Macedonia, the Former Yugoslav Republic of',	'MK',	0,	129,	1),
(142,	'Mali',	'ML',	0,	134,	1),
(143,	'Myanmar',	'MM',	0,	150,	1),
(144,	'Mongolia',	'MN',	0,	145,	1),
(145,	'Macao',	'MO',	0,	128,	1),
(146,	'Northern Mariana Islands',	'MP',	0,	163,	1),
(147,	'Martinique',	'MQ',	0,	137,	1),
(148,	'Mauritania',	'MR',	0,	138,	1),
(149,	'Montserrat',	'MS',	0,	147,	1),
(150,	'Malta',	'MT',	0,	135,	1),
(151,	'Mauritius',	'MU',	0,	139,	1),
(152,	'Maldives',	'MV',	0,	133,	1),
(153,	'Malawi',	'MW',	0,	131,	1),
(154,	'Mexico',	'MX',	0,	141,	1),
(155,	'Malaysia',	'MY',	0,	132,	1),
(156,	'Mozambique',	'MZ',	0,	149,	1),
(157,	'Namibia',	'NA',	0,	151,	1),
(158,	'New Caledonia',	'NC',	0,	156,	1),
(159,	'Niger',	'NE',	0,	159,	1),
(160,	'Norfolk Island',	'NF',	0,	162,	1),
(161,	'Nigeria',	'NG',	0,	160,	1),
(162,	'Nicaragua',	'NI',	0,	158,	1),
(163,	'Netherlands',	'NL',	0,	154,	1),
(164,	'Norway',	'NO',	0,	164,	1),
(165,	'Nepal',	'NP',	0,	153,	1),
(166,	'Nauru',	'NR',	0,	152,	1),
(167,	'Niue',	'NU',	0,	161,	1),
(168,	'New Zealand',	'NZ',	0,	157,	1),
(169,	'Oman',	'OM',	0,	165,	1),
(170,	'Panama',	'PA',	0,	169,	1),
(171,	'Peru',	'PE',	0,	172,	1),
(172,	'French Polynesia',	'PF',	0,	76,	1),
(173,	'Papua New Guinea',	'PG',	0,	170,	1),
(174,	'Philippines',	'PH',	0,	173,	1),
(175,	'Pakistan',	'PK',	0,	166,	1),
(176,	'Poland',	'PL',	0,	175,	1),
(177,	'Saint Pierre and Miquelon',	'PM',	0,	187,	1),
(178,	'Pitcairn',	'PN',	0,	174,	1),
(179,	'Puerto Rico',	'PR',	0,	177,	1),
(180,	'Palestinian Territory, Occupied',	'PS',	0,	168,	1),
(181,	'Portugal',	'PT',	0,	176,	1),
(182,	'Palau',	'PW',	0,	167,	1),
(183,	'Paraguay',	'PY',	0,	171,	1),
(184,	'Qatar',	'QA',	0,	178,	1),
(185,	'Reunion',	'RE',	0,	179,	1),
(186,	'Romania',	'RO',	0,	180,	1),
(187,	'Serbia',	'RS',	0,	194,	1),
(188,	'Russian Federation',	'RU',	0,	181,	1),
(189,	'Rwanda',	'RW',	0,	182,	1),
(190,	'Saudi Arabia',	'SA',	0,	192,	1),
(191,	'Solomon Islands',	'SB',	0,	200,	1),
(192,	'Seychelles',	'SC',	0,	195,	1),
(193,	'Sudan',	'SD',	0,	206,	1),
(194,	'Sweden',	'SE',	0,	210,	1),
(195,	'Singapore',	'SG',	0,	197,	1),
(196,	'Saint Helena',	'SH',	0,	184,	1),
(197,	'Slovenia',	'SI',	0,	199,	1),
(198,	'Svalbard and Jan Mayen',	'SJ',	0,	208,	1),
(199,	'Slovakia',	'SK',	0,	198,	1),
(200,	'Sierra Leone',	'SL',	0,	196,	1),
(201,	'San Marino',	'SM',	0,	190,	1),
(202,	'Senegal',	'SN',	0,	193,	1),
(203,	'Somalia',	'SO',	0,	201,	1),
(204,	'Suriname',	'SR',	0,	207,	1),
(205,	'Sao Tome and Principe',	'ST',	0,	191,	1),
(206,	'El Salvador',	'SV',	0,	65,	1),
(207,	'Syrian Arab Republic',	'SY',	0,	212,	1),
(208,	'Swaziland',	'SZ',	0,	209,	1),
(209,	'Turks and Caicos Islands',	'TC',	0,	225,	1),
(210,	'Chad',	'TD',	0,	43,	1),
(211,	'French Southern Territories',	'TF',	0,	77,	1),
(212,	'Togo',	'TG',	0,	218,	1),
(213,	'Thailand',	'TH',	0,	216,	1),
(214,	'Tajikistan',	'TJ',	0,	214,	1),
(215,	'Tokelau',	'TK',	0,	219,	1),
(216,	'Timor-Leste',	'TL',	0,	217,	1),
(217,	'Turkmenistan',	'TM',	0,	224,	1),
(218,	'Tunisia',	'TN',	0,	222,	1),
(219,	'Tonga',	'TO',	0,	220,	1),
(220,	'Turkey',	'TR',	0,	223,	1),
(221,	'Trinidad and Tobago',	'TT',	0,	221,	1),
(222,	'Tuvalu',	'TV',	0,	226,	1),
(223,	'Taiwan, Province of China',	'TW',	0,	213,	1),
(224,	'Tanzania, United Republic of',	'TZ',	0,	215,	1),
(225,	'Ukraine',	'UA',	0,	228,	1),
(226,	'Uganda',	'UG',	0,	227,	1),
(227,	'United States Minor Outlying Islands',	'UM',	0,	232,	1),
(228,	'Andorra',	'AD',	0,	6,	1),
(229,	'Uruguay',	'UY',	0,	233,	1),
(230,	'Uzbekistan',	'UZ',	0,	234,	1),
(231,	'Holy See (Vatican City State)',	'VA',	0,	96,	1),
(232,	'Saint Vincent and the Grenadines',	'VC',	0,	188,	1),
(233,	'Venezuela',	'VE',	0,	236,	1),
(234,	'Virgin Islands, British',	'VG',	0,	238,	1),
(235,	'Virgin Islands, U.s.',	'VI',	0,	239,	1),
(236,	'Viet Nam',	'VN',	0,	237,	1),
(237,	'Vanuatu',	'VU',	0,	235,	1),
(238,	'Wallis and Futuna',	'WF',	0,	240,	1),
(239,	'Samoa',	'WS',	0,	189,	1),
(240,	'Yemen',	'YE',	0,	242,	1),
(241,	'Mayotte',	'YT',	0,	140,	1),
(242,	'South Africa',	'ZA',	0,	202,	1),
(243,	'Zambia',	'ZM',	0,	243,	1),
(244,	'Zimbabwe',	'ZW',	0,	244,	1);

INSERT INTO `{prefix}states` (`id`, `name`, `state_code`, `country_id`, `order`) VALUES
(1, 'Alaska', 'AK', 1, 2),
(2, 'Alabama', 'AL', 1, 1),
(3, 'Arkansas', 'AR', 1, 4),
(4, 'Arizona', 'AZ', 1, 3),
(5, 'California', 'CA', 1, 5),
(6, 'Colorado', 'CO', 1, 6),
(7, 'Connecticut', 'CT', 1, 7),
(8, 'District of Columbia', 'DC', 1, 9),
(9, 'Delaware', 'DE', 1, 8),
(10, 'Florida', 'FL', 1, 10),
(11, 'Georgia', 'GA', 1, 11),
(12, 'Hawaii', 'HI', 1, 12),
(13, 'Iowa', 'IA', 1, 16),
(14, 'Idaho', 'ID', 1, 13),
(15, 'Illinois', 'IL', 1, 14),
(16, 'Indiana', 'IN', 1, 15),
(17, 'Kansas', 'KS', 1, 17),
(18, 'Kentucky', 'KY', 1, 18),
(19, 'Louisiana', 'LA', 1, 19),
(20, 'Massachusetts', 'MA', 1, 22),
(21, 'Maryland', 'MD', 1, 21),
(22, 'Maine', 'ME', 1, 20),
(23, 'Michigan', 'MI', 1, 23),
(24, 'Minnesota', 'MN', 1, 24),
(25, 'Missouri', 'MO', 1, 26),
(26, 'Mississippi', 'MS', 1, 25),
(27, 'Montana', 'MT', 1, 27),
(28, 'North Carolina', 'NC', 1, 34),
(29, 'North Dakota', 'ND', 1, 35),
(30, 'Nebraska', 'NE', 1, 28),
(31, 'New Hampshire', 'NH', 1, 30),
(32, 'New Jersey', 'NJ', 1, 31),
(33, 'New Mexico', 'NM', 1, 32),
(34, 'Nevada', 'NV', 1, 29),
(35, 'New York', 'NY', 1, 33),
(36, 'Ohio', 'OH', 1, 36),
(37, 'Oklahoma', 'OK', 1, 37),
(38, 'Oregon', 'OR', 1, 38),
(39, 'Pennsylvania', 'PA', 1, 39),
(40, 'Rhode Island', 'RI', 1, 40),
(41, 'South Carolina', 'SC', 1, 41),
(42, 'South Dakota', 'SD', 1, 42),
(43, 'Tennessee', 'TN', 1, 43),
(44, 'Texas', 'TX', 1, 44),
(45, 'Utah', 'UT', 1, 45),
(46, 'Virginia', 'VA', 1, 47),
(47, 'Vermont', 'VT', 1, 46),
(48, 'Washington', 'WA', 1, 48),
(49, 'Wisconsin', 'WI', 1, 50),
(50, 'West Virginia', 'WV', 1, 49),
(51, 'Wyoming', 'WY', 1, 51);

INSERT INTO `{prefix}translations` (`table_name`, `column_name`, `foreign_key`, `locale`, `value`) VALUES
('countries','name',1,'en','United States'),
('countries','name',2,'en','United Arab Emirates'),
('countries','name',3,'en','Afghanistan'),
('countries','name',4,'en','Antigua and Barbuda'),
('countries','name',5,'en','Anguilla'),
('countries','name',6,'en','Albania'),
('countries','name',7,'en','Armenia'),
('countries','name',8,'en','Netherlands Antilles'),
('countries','name',9,'en','Angola'),
('countries','name',10,'en','Antarctica'),
('countries','name',11,'en','Argentina'),
('countries','name',12,'en','American Samoa'),
('countries','name',13,'en','Austria'),
('countries','name',14,'en','Australia'),
('countries','name',15,'en','Aruba'),
('countries','name',16,'en','Aland Islands'),
('countries','name',17,'en','Azerbaijan'),
('countries','name',18,'en','Bosnia and Herzegovina'),
('countries','name',19,'en','Barbados'),
('countries','name',20,'en','Bangladesh'),
('countries','name',21,'en','Belgium'),
('countries','name',22,'en','Burkina Faso'),
('countries','name',23,'en','Bulgaria'),
('countries','name',24,'en','Bahrain'),
('countries','name',25,'en','Burundi'),
('countries','name',26,'en','Benin'),
('countries','name',27,'en','Saint Barthelemy'),
('countries','name',28,'en','Bermuda'),
('countries','name',29,'en','Brunei Darussalam'),
('countries','name',30,'en','Bolivia'),
('countries','name',31,'en','Brazil'),
('countries','name',32,'en','Bahamas'),
('countries','name',33,'en','Bhutan'),
('countries','name',34,'en','Bouvet Island'),
('countries','name',35,'en','Botswana'),
('countries','name',36,'en','Belarus'),
('countries','name',37,'en','Belize'),
('countries','name',38,'en','Canada'),
('countries','name',39,'en','Cocos (Keeling) Islands'),
('countries','name',40,'en','Congo, the Democratic Republic of the'),
('countries','name',41,'en','Central African Republic'),
('countries','name',42,'en','Congo'),
('countries','name',43,'en','Switzerland'),
('countries','name',44,'en','Cote D\'Ivoire'),
('countries','name',45,'en','Cook Islands'),
('countries','name',46,'en','Chile'),
('countries','name',47,'en','Cameroon'),
('countries','name',48,'en','China'),
('countries','name',49,'en','Colombia'),
('countries','name',50,'en','Costa Rica'),
('countries','name',51,'en','Cuba'),
('countries','name',52,'en','Cape Verde'),
('countries','name',53,'en','Christmas Island'),
('countries','name',54,'en','Cyprus'),
('countries','name',55,'en','Czech Republic'),
('countries','name',56,'en','Germany'),
('countries','name',57,'en','Djibouti'),
('countries','name',58,'en','Denmark'),
('countries','name',59,'en','Dominica'),
('countries','name',60,'en','Dominican Republic'),
('countries','name',61,'en','Algeria'),
('countries','name',62,'en','Ecuador'),
('countries','name',63,'en','Estonia'),
('countries','name',64,'en','Egypt'),
('countries','name',65,'en','Western Sahara'),
('countries','name',66,'en','Eritrea'),
('countries','name',67,'en','Spain'),
('countries','name',68,'en','Ethiopia'),
('countries','name',69,'en','Finland'),
('countries','name',70,'en','Fiji'),
('countries','name',71,'en','Falkland Islands (Malvinas)'),
('countries','name',72,'en','Micronesia, Federated States of'),
('countries','name',73,'en','Faroe Islands'),
('countries','name',74,'en','France'),
('countries','name',75,'en','Gabon'),
('countries','name',76,'en','United Kingdom'),
('countries','name',77,'en','Grenada'),
('countries','name',78,'en','Georgia'),
('countries','name',79,'en','French Guiana'),
('countries','name',80,'en','Guernsey'),
('countries','name',81,'en','Ghana'),
('countries','name',82,'en','Gibraltar'),
('countries','name',83,'en','Greenland'),
('countries','name',84,'en','Gambia'),
('countries','name',85,'en','Guinea'),
('countries','name',86,'en','Guadeloupe'),
('countries','name',87,'en','Equatorial Guinea'),
('countries','name',88,'en','Greece'),
('countries','name',89,'en','South Georgia and the South Sandwich Islands'),
('countries','name',90,'en','Guatemala'),
('countries','name',91,'en','Guam'),
('countries','name',92,'en','Guinea-Bissau'),
('countries','name',93,'en','Guyana'),
('countries','name',94,'en','Hong Kong'),
('countries','name',95,'en','Heard Island and Mcdonald Islands'),
('countries','name',96,'en','Honduras'),
('countries','name',97,'en','Croatia'),
('countries','name',98,'en','Haiti'),
('countries','name',99,'en','Hungary'),
('countries','name',100,'en','Indonesia'),
('countries','name',101,'en','Ireland'),
('countries','name',102,'en','Israel'),
('countries','name',103,'en','Isle of Man'),
('countries','name',104,'en','India'),
('countries','name',105,'en','British Indian Ocean Territory'),
('countries','name',106,'en','Iraq'),
('countries','name',107,'en','Iran, Islamic Republic of'),
('countries','name',108,'en','Iceland'),
('countries','name',109,'en','Italy'),
('countries','name',110,'en','Jamaica'),
('countries','name',111,'en','Jordan'),
('countries','name',112,'en','Japan'),
('countries','name',113,'en','Kenya'),
('countries','name',114,'en','Kyrgyzstan'),
('countries','name',115,'en','Cambodia'),
('countries','name',116,'en','Kiribati'),
('countries','name',117,'en','Comoros'),
('countries','name',118,'en','Saint Kitts and Nevis'),
('countries','name',119,'en','Korea, Democratic People\'s Republic of'),
('countries','name',120,'en','Korea, Republic of'),
('countries','name',121,'en','Kuwait'),
('countries','name',122,'en','Cayman Islands'),
('countries','name',123,'en','Kazakhstan'),
('countries','name',124,'en','Lao People\'s Democratic Republic'),
('countries','name',125,'en','Lebanon'),
('countries','name',126,'en','Saint Lucia'),
('countries','name',127,'en','Liechtenstein'),
('countries','name',128,'en','Sri Lanka'),
('countries','name',129,'en','Liberia'),
('countries','name',130,'en','Lesotho'),
('countries','name',131,'en','Lithuania'),
('countries','name',132,'en','Luxembourg'),
('countries','name',133,'en','Latvia'),
('countries','name',134,'en','Libyan Arab Jamahiriya'),
('countries','name',135,'en','Morocco'),
('countries','name',136,'en','Monaco'),
('countries','name',137,'en','Moldova, Republic of'),
('countries','name',138,'en','Montenegro'),
('countries','name',139,'en','Madagascar'),
('countries','name',140,'en','Marshall Islands'),
('countries','name',141,'en','Macedonia, the Former Yugoslav Republic of'),
('countries','name',142,'en','Mali'),
('countries','name',143,'en','Myanmar'),
('countries','name',144,'en','Mongolia'),
('countries','name',145,'en','Macao'),
('countries','name',146,'en','Northern Mariana Islands'),
('countries','name',147,'en','Martinique'),
('countries','name',148,'en','Mauritania'),
('countries','name',149,'en','Montserrat'),
('countries','name',150,'en','Malta'),
('countries','name',151,'en','Mauritius'),
('countries','name',152,'en','Maldives'),
('countries','name',153,'en','Malawi'),
('countries','name',154,'en','Mexico'),
('countries','name',155,'en','Malaysia'),
('countries','name',156,'en','Mozambique'),
('countries','name',157,'en','Namibia'),
('countries','name',158,'en','New Caledonia'),
('countries','name',159,'en','Niger'),
('countries','name',160,'en','Norfolk Island'),
('countries','name',161,'en','Nigeria'),
('countries','name',162,'en','Nicaragua'),
('countries','name',163,'en','Netherlands'),
('countries','name',164,'en','Norway'),
('countries','name',165,'en','Nepal'),
('countries','name',166,'en','Nauru'),
('countries','name',167,'en','Niue'),
('countries','name',168,'en','New Zealand'),
('countries','name',169,'en','Oman'),
('countries','name',170,'en','Panama'),
('countries','name',171,'en','Peru'),
('countries','name',172,'en','French Polynesia'),
('countries','name',173,'en','Papua New Guinea'),
('countries','name',174,'en','Philippines'),
('countries','name',175,'en','Pakistan'),
('countries','name',176,'en','Poland'),
('countries','name',177,'en','Saint Pierre and Miquelon'),
('countries','name',178,'en','Pitcairn'),
('countries','name',179,'en','Puerto Rico'),
('countries','name',180,'en','Palestinian Territory, Occupied'),
('countries','name',181,'en','Portugal'),
('countries','name',182,'en','Palau'),
('countries','name',183,'en','Paraguay'),
('countries','name',184,'en','Qatar'),
('countries','name',185,'en','Reunion'),
('countries','name',186,'en','Romania'),
('countries','name',187,'en','Serbia'),
('countries','name',188,'en','Russian Federation'),
('countries','name',189,'en','Rwanda'),
('countries','name',190,'en','Saudi Arabia'),
('countries','name',191,'en','Solomon Islands'),
('countries','name',192,'en','Seychelles'),
('countries','name',193,'en','Sudan'),
('countries','name',194,'en','Sweden'),
('countries','name',195,'en','Singapore'),
('countries','name',196,'en','Saint Helena'),
('countries','name',197,'en','Slovenia'),
('countries','name',198,'en','Svalbard and Jan Mayen'),
('countries','name',199,'en','Slovakia'),
('countries','name',200,'en','Sierra Leone'),
('countries','name',201,'en','San Marino'),
('countries','name',202,'en','Senegal'),
('countries','name',203,'en','Somalia'),
('countries','name',204,'en','Suriname'),
('countries','name',205,'en','Sao Tome and Principe'),
('countries','name',206,'en','El Salvador'),
('countries','name',207,'en','Syrian Arab Republic'),
('countries','name',208,'en','Swaziland'),
('countries','name',209,'en','Turks and Caicos Islands'),
('countries','name',210,'en','Chad'),
('countries','name',211,'en','French Southern Territories'),
('countries','name',212,'en','Togo'),
('countries','name',213,'en','Thailand'),
('countries','name',214,'en','Tajikistan'),
('countries','name',215,'en','Tokelau'),
('countries','name',216,'en','Timor-Leste'),
('countries','name',217,'en','Turkmenistan'),
('countries','name',218,'en','Tunisia'),
('countries','name',219,'en','Tonga'),
('countries','name',220,'en','Turkey'),
('countries','name',221,'en','Trinidad and Tobago'),
('countries','name',222,'en','Tuvalu'),
('countries','name',223,'en','Taiwan, Province of China'),
('countries','name',224,'en','Tanzania, United Republic of'),
('countries','name',225,'en','Ukraine'),
('countries','name',226,'en','Uganda'),
('countries','name',227,'en','United States Minor Outlying Islands'),
('countries','name',228,'en','Andorra'),
('countries','name',229,'en','Uruguay'),
('countries','name',230,'en','Uzbekistan'),
('countries','name',231,'en','Holy See (Vatican City State)'),
('countries','name',232,'en','Saint Vincent and the Grenadines'),
('countries','name',233,'en','Venezuela'),
('countries','name',234,'en','Virgin Islands, British'),
('countries','name',235,'en','Virgin Islands, U.s.'),
('countries','name',236,'en','Viet Nam'),
('countries','name',237,'en','Vanuatu'),
('countries','name',238,'en','Wallis and Futuna'),
('countries','name',239,'en','Samoa'),
('countries','name',240,'en','Yemen'),
('countries','name',241,'en','Mayotte'),
('countries','name',242,'en','South Africa'),
('countries','name',243,'en','Zambia'),
('countries','name',244,'en','Zimbabwe'),
('permissions', 'message_error', (SELECT `id` FROM `{prefix}permissions` WHERE `key` = 'post.character_max') ,'en', 'You only can share a post that has max [x] character(s).'),
('permissions', 'message_error', (SELECT `id` FROM `{prefix}permissions` WHERE `key` = 'post.video_max_duration') ,'en', 'You only can share a video of a max [x] second(s) long.'),
('states','name',1,'en','Alaska'),
('states','name',2,'en','Alabama'),
('states','name',3,'en','Arkansas'),
('states','name',4,'en','Arizona'),
('states','name',5,'en','California'),
('states','name',6,'en','Colorado'),
('states','name',7,'en','Connecticut'),
('states','name',8,'en','District of Columbia'),
('states','name',9,'en','Delaware'),
('states','name',10,'en','Florida'),
('states','name',11,'en','Georgia'),
('states','name',12,'en','Hawaii'),
('states','name',13,'en','Iowa'),
('states','name',14,'en','Idaho'),
('states','name',15,'en','Illinois'),
('states','name',16,'en','Indiana'),
('states','name',17,'en','Kansas'),
('states','name',18,'en','Kentucky'),
('states','name',19,'en','Louisiana'),
('states','name',20,'en','Massachusetts'),
('states','name',21,'en','Maryland'),
('states','name',22,'en','Maine'),
('states','name',23,'en','Michigan'),
('states','name',24,'en','Minnesota'),
('states','name',25,'en','Missouri'),
('states','name',26,'en','Mississippi'),
('states','name',27,'en','Montana'),
('states','name',28,'en','North Carolina'),
('states','name',29,'en','North Dakota'),
('states','name',30,'en','Nebraska'),
('states','name',31,'en','New Hampshire'),
('states','name',32,'en','New Jersey'),
('states','name',33,'en','New Mexico'),
('states','name',34,'en','Nevada'),
('states','name',35,'en','New York'),
('states','name',36,'en','Ohio'),
('states','name',37,'en','Oklahoma'),
('states','name',38,'en','Oregon'),
('states','name',39,'en','Pennsylvania'),
('states','name',40,'en','Rhode Island'),
('states','name',41,'en','South Carolina'),
('states','name',42,'en','South Dakota'),
('states','name',43,'en','Tennessee'),
('states','name',44,'en','Texas'),
('states','name',45,'en','Utah'),
('states','name',46,'en','Virginia'),
('states','name',47,'en','Vermont'),
('states','name',48,'en','Washington'),
('states','name',49,'en','Wisconsin'),
('states','name',50,'en','West Virginia'),
('states','name',51,'en','Wyoming');

INSERT INTO `{prefix}model_maps` (`subject_type`, `model_class`) VALUES
('permissions', 'Packages\\ShaunSocial\\Core\\Models\\Permission');