-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(5) NOT NULL,
  `name` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`) VALUES
(1, 'Afghanistan (‫افغانستان‬‎)'),
(2, 'Åland Islands (Åland)'),
(3, 'Albania (Shqipëria)'),
(4, 'Algeria (‫الجزائر‬‎)'),
(5, 'American Samoa'),
(6, 'Andorra'),
(7, 'Angola'),
(8, 'Anguilla'),
(9, 'Antarctica'),
(10, 'Antigua and Barbuda'),
(11, 'Argentina'),
(12, 'Armenia (Հայաստան)'),
(13, 'Aruba'),
(14, 'Ascension Island'),
(15, 'Australia'),
(16, 'Austria (Österreich)'),
(17, 'Azerbaijan (Azərbaycan)'),
(18, 'Bahamas'),
(19, 'Bahrain (‫البحرين‬‎)'),
(20, 'Bangladesh (বাংলাদেশ)'),
(21, 'Barbados'),
(22, 'Belarus (Беларусь)'),
(23, 'Belgium (België)'),
(24, 'Belize'),
(25, 'Benin (Bénin)'),
(26, 'Bermuda'),
(27, 'Bhutan (འབྲུག)'),
(28, 'Bolivia'),
(29, 'Bosnia and Herzegovina (Босна и Херцеговина)'),
(30, 'Botswana'),
(31, 'Bouvet Island'),
(32, 'Brazil (Brasil)'),
(33, 'British Indian Ocean Territory'),
(34, 'British Virgin Islands'),
(35, 'Brunei'),
(36, 'Bulgaria (България)'),
(37, 'Burkina Faso'),
(38, 'Burundi (Uburundi)'),
(39, 'Cambodia (កម្ពុជា)'),
(40, 'Cameroon (Cameroun)'),
(41, 'Canada'),
(42, 'Canary Islands (Islas Canarias)'),
(43, 'Cape Verde (Kabu Verdi)'),
(44, 'Caribbean Netherlands'),
(45, 'Cayman Islands'),
(46, 'Central African Republic (République centrafricaine)'),
(47, 'Ceuta and Melilla (Ceuta y Melilla)'),
(48, 'Chad (Tchad)'),
(49, 'Chile'),
(50, 'China (中国)'),
(51, 'Christmas Island'),
(52, 'Clipperton Island (Île Clipperton)'),
(53, 'Cocos [Keeling] Islands'),
(54, 'Colombia'),
(55, 'Comoros (‫جزر القمر‬‎)'),
(56, 'Congo [DRC] (Jamhuri ya Kidemokrasia ya Kongo)'),
(57, 'Congo [Republic] (Congo-Brazzaville)'),
(58, 'Cook Islands'),
(59, 'Costa Rica'),
(60, 'Côte d’Ivoire'),
(61, 'Croatia (Hrvatska)'),
(62, 'Cuba'),
(63, 'Curaçao'),
(64, 'Cyprus (Κύπρος)'),
(65, 'Czech Republic (Česká republika)'),
(66, 'Denmark (Danmark)'),
(67, 'Diego Garcia'),
(68, 'Djibouti'),
(69, 'Dominica'),
(70, 'Dominican Republic (República Dominicana)'),
(71, 'Ecuador'),
(72, 'Egypt (‫مصر‬‎)'),
(73, 'El Salvador'),
(74, 'Equatorial Guinea (Guinea Ecuatorial)'),
(75, 'Eritrea'),
(76, 'Estonia (Eesti)'),
(77, 'Ethiopia'),
(78, 'Falkland Islands [Islas Malvinas]'),
(79, 'Faroe Islands (Føroyar)'),
(80, 'Fiji'),
(81, 'Finland (Suomi)'),
(82, 'France'),
(83, 'French Guiana (Guyane française)'),
(84, 'French Polynesia (Polynésie française)'),
(85, 'French Southern Territories (Terres australes françaises)'),
(86, 'Gabon'),
(87, 'Gambia'),
(88, 'Georgia (საქართველო)'),
(89, 'Germany (Deutschland)'),
(90, 'Ghana (Gaana)'),
(91, 'Gibraltar'),
(92, 'Greece (Ελλάδα)'),
(93, 'Greenland (Kalaallit Nunaat)'),
(94, 'Grenada'),
(95, 'Guadeloupe'),
(96, 'Guam'),
(97, 'Guatemala'),
(98, 'Guernsey'),
(99, 'Guinea (Guinée)'),
(100, 'Guinea-Bissau (Guiné Bissau)'),
(101, 'Guyana'),
(102, 'Haiti'),
(103, 'Heard Island and McDonald Islands'),
(104, 'Honduras'),
(105, 'Hong Kong (香港)'),
(106, 'Hungary (Magyarország)'),
(107, 'Iceland (Ísland)'),
(108, 'India (भारत)'),
(109, 'Indonesia'),
(110, 'Iran (‫ایران‬‎)'),
(111, 'Iraq (‫العراق‬‎)'),
(112, 'Ireland'),
(113, 'Isle of Man'),
(114, 'Israel (‫ישראל‬‎)'),
(115, 'Italy (Italia)'),
(116, 'Jamaica'),
(117, 'Japan (日本)'),
(118, 'Jersey'),
(119, 'Jordan (‫الأردن‬‎)'),
(120, 'Kazakhstan (Казахстан)'),
(121, 'Kenya'),
(122, 'Kiribati'),
(123, 'Kosovo (Косово)'),
(124, 'Kuwait (‫الكويت‬‎)'),
(125, 'Kyrgyzstan'),
(126, 'Laos (ສ.ປ.ປ ລາວ)'),
(127, 'Latvia (Latvija)'),
(128, 'Lebanon (‫لبنان‬‎)'),
(129, 'Lesotho'),
(130, 'Liberia'),
(131, 'Libya (‫ليبيا‬‎)'),
(132, 'Liechtenstein'),
(133, 'Lithuania (Lietuva)'),
(134, 'Luxembourg'),
(135, 'Macau (澳門)'),
(136, 'Macedonia [FYROM] (Македонија)'),
(137, 'Madagascar (Madagasikara)'),
(138, 'Malawi'),
(139, 'Malaysia'),
(140, 'Maldives'),
(141, 'Mali'),
(142, 'Malta'),
(143, 'Marshall Islands'),
(144, 'Martinique'),
(145, 'Mauritania (‫موريتانيا‬‎)'),
(146, 'Mauritius (Moris)'),
(147, 'Mayotte'),
(148, 'Mexico (México)'),
(149, 'Micronesia'),
(150, 'Moldova (Republica Moldova)'),
(151, 'Monaco'),
(152, 'Mongolia (Монгол)'),
(153, 'Montenegro (Crna Gora)'),
(154, 'Montserrat'),
(155, 'Morocco (‫المغرب‬‎)'),
(156, 'Mozambique (Moçambique)'),
(157, 'Myanmar [Burma] (မြန်မာ)'),
(158, 'Namibia'),
(159, 'Nauru'),
(160, 'Nepal (नेपाल)'),
(161, 'Netherlands (Nederland)'),
(162, 'New Caledonia (Nouvelle-Calédonie)'),
(163, 'New Zealand'),
(164, 'Nicaragua'),
(165, 'Niger (Nijar)'),
(166, 'Nigeria'),
(167, 'Niue'),
(168, 'Norfolk Island'),
(169, 'Northern Mariana Islands'),
(170, 'North Korea (조선 민주주의 인민 공화국)'),
(171, 'Norway (Norge)'),
(172, 'Oman (‫عُمان‬‎)'),
(173, 'Pakistan (‫پاکستان‬‎)'),
(174, 'Palau'),
(175, 'Palestine (‫فلسطين‬‎)'),
(176, 'Panama (Panamá)'),
(177, 'Papua New Guinea'),
(178, 'Paraguay'),
(179, 'Peru (Perú)'),
(180, 'Philippines'),
(181, 'Pitcairn Islands'),
(182, 'Poland (Polska)'),
(183, 'Portugal'),
(184, 'Puerto Rico'),
(185, 'Qatar (‫قطر‬‎)'),
(186, 'Réunion'),
(187, 'Romania (România)'),
(188, 'Russia (Россия)'),
(189, 'Rwanda'),
(190, 'Saint Barthélemy (Saint-Barthélémy)'),
(191, 'Saint Helena'),
(192, 'Saint Kitts and Nevis'),
(193, 'Saint Lucia'),
(194, 'Saint Martin (Saint-Martin [partie française])'),
(195, 'Saint Pierre and Miquelon (Saint-Pierre-et-Miquelon)'),
(196, 'Saint Vincent and the Grenadines'),
(197, 'Samoa'),
(198, 'San Marino'),
(199, 'São Tomé and Príncipe (São Tomé e Príncipe)'),
(200, 'Saudi Arabia (‫المملكة العربية السعودية‬‎)'),
(201, 'Senegal (Sénégal)'),
(202, 'Serbia (Србија)'),
(203, 'Seychelles'),
(204, 'Sierra Leone'),
(205, 'Singapore'),
(206, 'Sint Maarten'),
(207, 'Slovakia (Slovensko)'),
(208, 'Slovenia (Slovenija)'),
(209, 'Solomon Islands'),
(210, 'Somalia (Soomaaliya)'),
(211, 'South Africa'),
(212, 'South Georgia and the South Sandwich Islands'),
(213, 'South Korea (대한민국)'),
(214, 'South Sudan (‫جنوب السودان‬‎)'),
(215, 'Spain (España)'),
(216, 'Sri Lanka (ශ්‍රී ලංකාව)'),
(217, 'Sudan (‫السودان‬‎)'),
(218, 'Suriname'),
(219, 'Svalbard and Jan Mayen (Svalbard og Jan Mayen)'),
(220, 'Swaziland'),
(221, 'Sweden (Sverige)'),
(222, 'Switzerland (Schweiz)'),
(223, 'Syria (‫سوريا‬‎)'),
(224, 'Taiwan (台灣)'),
(225, 'Tajikistan'),
(226, 'Tanzania'),
(227, 'Thailand (ไทย)'),
(228, 'Timor-Leste'),
(229, 'Togo'),
(230, 'Tokelau'),
(231, 'Tonga'),
(232, 'Trinidad and Tobago'),
(233, 'Tristan da Cunha'),
(234, 'Tunisia (‫تونس‬‎)'),
(235, 'Turkey (Türkiye)'),
(236, 'Turkmenistan'),
(237, 'Turks and Caicos Islands'),
(238, 'Tuvalu'),
(239, 'U.S. Outlying Islands'),
(240, 'U.S. Virgin Islands'),
(241, 'Uganda'),
(242, 'Ukraine (Україна)'),
(243, 'United Arab Emirates (‫الإمارات العربية المتحدة‬‎)'),
(244, 'United Kingdom'),
(245, 'United States'),
(246, 'Uruguay'),
(247, 'Uzbekistan (Ўзбекистон)'),
(248, 'Vanuatu'),
(249, 'Vatican City (Città del Vaticano)'),
(250, 'Venezuela'),
(251, 'Vietnam (Việt Nam)'),
(252, 'Wallis and Futuna'),
(253, 'Western Sahara (‫الصحراء الغربية‬‎)'),
(254, 'Yemen (‫اليمن‬‎)'),
(255, 'Zambia'),
(256, 'Zimbabwe');

-- --------------------------------------------------------

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `raw_name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_type` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_ext` varchar(20) NOT NULL,
  `file_size` varchar(20) NOT NULL,
  `is_image` tinyint(1) NOT NULL,
  `image_width` smallint(5) UNSIGNED DEFAULT NULL,
  `image_height` smallint(5) UNSIGNED DEFAULT NULL,
  `image_type` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `user_id`, `raw_name`, `file_name`, `file_type`, `file_path`, `file_ext`, `file_size`, `is_image`, `image_width`, `image_height`, `image_type`) VALUES
(1, 0, 'Sambutan_Kepala_Lembaga_Layanan_Pendidikan_Tinggi_Wilayah_III_(WISUDA)_2019', 'Sambutan_Kepala_Lembaga_Layanan_Pendidikan_Tinggi_Wilayah_III_(WISUDA)_2019.pdf', 'application/pdf', '/TRILOGI/Rektor/UNDANGAN/', '.pdf', '1913.08', 0, NULL, NULL, '');

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`,`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=257;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233;
COMMIT;

