-- Adminer 4.2.4 MySQL dump

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

CREATE TABLE `kategori` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `level` tinyint(3) DEFAULT '1',
  `urutan` int(11) DEFAULT '1',
  `deskripsi` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `kategori` (`id`, `nama`, `slug`, `parent_id`, `level`, `urutan`, `deskripsi`, `created_at`, `updated_at`) VALUES
(1,	'Akuntansi',	'akuntansi',	NULL,	1,	4,	NULL,	'2019-02-12 21:01:02',	'2019-02-12 21:34:16'),
(2,	'Human Resource',	'human-resource',	NULL,	1,	4,	NULL,	'2019-02-12 21:03:58',	'2019-02-12 21:34:28'),
(3,	'Risk Management',	'risk-management',	1,	2,	7,	NULL,	'2019-02-12 21:04:32',	'2019-02-12 21:34:10'),
(4,	'Asuransi',	'asuransi',	1,	2,	2,	NULL,	'2019-02-12 21:04:52',	'2019-02-12 21:16:53'),
(5,	'Appraisals',	'appraisals',	2,	2,	1,	NULL,	'2019-02-12 21:05:01',	'2019-02-12 21:18:59'),
(6,	'Audit',	'audit',	1,	2,	3,	NULL,	'2019-02-12 21:17:01',	'2019-02-12 21:17:01'),
(7,	'Finance',	'finance',	1,	2,	4,	NULL,	'2019-02-12 21:17:17',	'2019-02-12 21:17:17'),
(8,	'Budget and Planning',	'budget-and-planning',	1,	2,	5,	NULL,	'2019-02-12 21:17:26',	'2019-02-12 21:17:26'),
(9,	'Perpajakan',	'perpajakan',	1,	2,	6,	NULL,	'2019-02-12 21:17:50',	'2019-02-12 21:17:50'),
(10,	'Career Management',	'career-management',	2,	2,	2,	NULL,	'2019-02-12 21:19:25',	'2019-02-12 21:19:25'),
(11,	'Couching and Counsellings',	'couching-and-counsellings',	2,	2,	4,	NULL,	'2019-02-12 21:19:58',	'2019-02-12 21:21:45'),
(12,	'HR Management',	'hr-management',	2,	2,	4,	NULL,	'2019-02-12 21:21:55',	'2019-02-12 21:21:55'),
(13,	'Employment Law',	'employment-law',	2,	2,	5,	NULL,	'2019-02-12 21:22:06',	'2019-02-12 21:22:06'),
(14,	'Culture',	'culture',	2,	2,	6,	NULL,	'2019-02-12 21:22:21',	'2019-02-12 21:22:21'),
(15,	'IT & Telco',	'it-telco',	NULL,	1,	4,	NULL,	'2019-02-12 21:23:05',	'2019-02-12 21:34:43'),
(16,	'Web Developer',	'web-developer',	15,	2,	1,	NULL,	'2019-02-12 21:23:38',	'2019-02-12 21:23:38'),
(17,	'Networking',	'networking',	15,	2,	2,	NULL,	'2019-02-12 21:23:47',	'2019-02-12 21:23:47'),
(18,	'Android',	'android',	15,	2,	3,	NULL,	'2019-02-12 21:24:00',	'2019-02-12 21:24:00'),
(19,	'Database',	'database',	15,	2,	4,	NULL,	'2019-02-12 21:24:14',	'2019-02-12 21:24:14'),
(20,	'Operating System',	'operating-system',	15,	2,	5,	NULL,	'2019-02-12 21:24:24',	'2019-02-12 21:24:24'),
(21,	'Security',	'security',	15,	2,	6,	NULL,	'2019-02-12 21:24:38',	'2019-02-12 21:24:38');

CREATE TABLE `kota` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jenis` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `provinsi_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_city_province1_idx` (`provinsi_id`),
  CONSTRAINT `fk_city_province1` FOREIGN KEY (`provinsi_id`) REFERENCES `provinsi` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `kota` (`id`, `jenis`, `nama`, `provinsi_id`) VALUES
(1,	'Kabupaten',	'Aceh Barat',	21),
(2,	'Kabupaten',	'Aceh Barat Daya',	21),
(3,	'Kabupaten',	'Aceh Besar',	21),
(4,	'Kabupaten',	'Aceh Jaya',	21),
(5,	'Kabupaten',	'Aceh Selatan',	21),
(6,	'Kabupaten',	'Aceh Singkil',	21),
(7,	'Kabupaten',	'Aceh Tamiang',	21),
(8,	'Kabupaten',	'Aceh Tengah',	21),
(9,	'Kabupaten',	'Aceh Tenggara',	21),
(10,	'Kabupaten',	'Aceh Timur',	21),
(11,	'Kabupaten',	'Aceh Utara',	21),
(12,	'Kabupaten',	'Agam',	32),
(13,	'Kabupaten',	'Alor',	23),
(14,	'Kota',	'Ambon',	19),
(15,	'Kabupaten',	'Asahan',	34),
(16,	'Kabupaten',	'Asmat',	24),
(17,	'Kabupaten',	'Badung',	1),
(18,	'Kabupaten',	'Balangan',	13),
(19,	'Kota',	'Balikpapan',	15),
(20,	'Kota',	'Banda Aceh',	21),
(21,	'Kota',	'Bandar Lampung',	18),
(22,	'Kabupaten',	'Bandung',	9),
(23,	'Kota',	'Bandung',	9),
(24,	'Kabupaten',	'Bandung Barat',	9),
(25,	'Kabupaten',	'Banggai',	29),
(26,	'Kabupaten',	'Banggai Kepulauan',	29),
(27,	'Kabupaten',	'Bangka',	2),
(28,	'Kabupaten',	'Bangka Barat',	2),
(29,	'Kabupaten',	'Bangka Selatan',	2),
(30,	'Kabupaten',	'Bangka Tengah',	2),
(31,	'Kabupaten',	'Bangkalan',	11),
(32,	'Kabupaten',	'Bangli',	1),
(33,	'Kabupaten',	'Banjar',	13),
(34,	'Kota',	'Banjar',	9),
(35,	'Kota',	'Banjarbaru',	13),
(36,	'Kota',	'Banjarmasin',	13),
(37,	'Kabupaten',	'Banjarnegara',	10),
(38,	'Kabupaten',	'Bantaeng',	28),
(39,	'Kabupaten',	'Bantul',	5),
(40,	'Kabupaten',	'Banyuasin',	33),
(41,	'Kabupaten',	'Banyumas',	10),
(42,	'Kabupaten',	'Banyuwangi',	11),
(43,	'Kabupaten',	'Barito Kuala',	13),
(44,	'Kabupaten',	'Barito Selatan',	14),
(45,	'Kabupaten',	'Barito Timur',	14),
(46,	'Kabupaten',	'Barito Utara',	14),
(47,	'Kabupaten',	'Barru',	28),
(48,	'Kota',	'Batam',	17),
(49,	'Kabupaten',	'Batang',	10),
(50,	'Kabupaten',	'Batang Hari',	8),
(51,	'Kota',	'Batu',	11),
(52,	'Kabupaten',	'Batu Bara',	34),
(53,	'Kota',	'Bau-Bau',	30),
(54,	'Kabupaten',	'Bekasi',	9),
(55,	'Kota',	'Bekasi',	9),
(56,	'Kabupaten',	'Belitung',	2),
(57,	'Kabupaten',	'Belitung Timur',	2),
(58,	'Kabupaten',	'Belu',	23),
(59,	'Kabupaten',	'Bener Meriah',	21),
(60,	'Kabupaten',	'Bengkalis',	26),
(61,	'Kabupaten',	'Bengkayang',	12),
(62,	'Kota',	'Bengkulu',	4),
(63,	'Kabupaten',	'Bengkulu Selatan',	4),
(64,	'Kabupaten',	'Bengkulu Tengah',	4),
(65,	'Kabupaten',	'Bengkulu Utara',	4),
(66,	'Kabupaten',	'Berau',	15),
(67,	'Kabupaten',	'Biak Numfor',	24),
(68,	'Kabupaten',	'Bima',	22),
(69,	'Kota',	'Bima',	22),
(70,	'Kota',	'Binjai',	34),
(71,	'Kabupaten',	'Bintan',	17),
(72,	'Kabupaten',	'Bireuen',	21),
(73,	'Kota',	'Bitung',	31),
(74,	'Kabupaten',	'Blitar',	11),
(75,	'Kota',	'Blitar',	11),
(76,	'Kabupaten',	'Blora',	10),
(77,	'Kabupaten',	'Boalemo',	7),
(78,	'Kabupaten',	'Bogor',	9),
(79,	'Kota',	'Bogor',	9),
(80,	'Kabupaten',	'Bojonegoro',	11),
(81,	'Kabupaten',	'Bolaang Mongondow (Bolmong)',	31),
(82,	'Kabupaten',	'Bolaang Mongondow Selatan',	31),
(83,	'Kabupaten',	'Bolaang Mongondow Timur',	31),
(84,	'Kabupaten',	'Bolaang Mongondow Utara',	31),
(85,	'Kabupaten',	'Bombana',	30),
(86,	'Kabupaten',	'Bondowoso',	11),
(87,	'Kabupaten',	'Bone',	28),
(88,	'Kabupaten',	'Bone Bolango',	7),
(89,	'Kota',	'Bontang',	15),
(90,	'Kabupaten',	'Boven Digoel',	24),
(91,	'Kabupaten',	'Boyolali',	10),
(92,	'Kabupaten',	'Brebes',	10),
(93,	'Kota',	'Bukittinggi',	32),
(94,	'Kabupaten',	'Buleleng',	1),
(95,	'Kabupaten',	'Bulukumba',	28),
(96,	'Kabupaten',	'Bulungan (Bulongan)',	16),
(97,	'Kabupaten',	'Bungo',	8),
(98,	'Kabupaten',	'Buol',	29),
(99,	'Kabupaten',	'Buru',	19),
(100,	'Kabupaten',	'Buru Selatan',	19),
(101,	'Kabupaten',	'Buton',	30),
(102,	'Kabupaten',	'Buton Utara',	30),
(103,	'Kabupaten',	'Ciamis',	9),
(104,	'Kabupaten',	'Cianjur',	9),
(105,	'Kabupaten',	'Cilacap',	10),
(106,	'Kota',	'Cilegon',	3),
(107,	'Kota',	'Cimahi',	9),
(108,	'Kabupaten',	'Cirebon',	9),
(109,	'Kota',	'Cirebon',	9),
(110,	'Kabupaten',	'Dairi',	34),
(111,	'Kabupaten',	'Deiyai (Deliyai)',	24),
(112,	'Kabupaten',	'Deli Serdang',	34),
(113,	'Kabupaten',	'Demak',	10),
(114,	'Kota',	'Denpasar',	1),
(115,	'Kota',	'Depok',	9),
(116,	'Kabupaten',	'Dharmasraya',	32),
(117,	'Kabupaten',	'Dogiyai',	24),
(118,	'Kabupaten',	'Dompu',	22),
(119,	'Kabupaten',	'Donggala',	29),
(120,	'Kota',	'Dumai',	26),
(121,	'Kabupaten',	'Empat Lawang',	33),
(122,	'Kabupaten',	'Ende',	23),
(123,	'Kabupaten',	'Enrekang',	28),
(124,	'Kabupaten',	'Fakfak',	25),
(125,	'Kabupaten',	'Flores Timur',	23),
(126,	'Kabupaten',	'Garut',	9),
(127,	'Kabupaten',	'Gayo Lues',	21),
(128,	'Kabupaten',	'Gianyar',	1),
(129,	'Kabupaten',	'Gorontalo',	7),
(130,	'Kota',	'Gorontalo',	7),
(131,	'Kabupaten',	'Gorontalo Utara',	7),
(132,	'Kabupaten',	'Gowa',	28),
(133,	'Kabupaten',	'Gresik',	11),
(134,	'Kabupaten',	'Grobogan',	10),
(135,	'Kabupaten',	'Gunung Kidul',	5),
(136,	'Kabupaten',	'Gunung Mas',	14),
(137,	'Kota',	'Gunungsitoli',	34),
(138,	'Kabupaten',	'Halmahera Barat',	20),
(139,	'Kabupaten',	'Halmahera Selatan',	20),
(140,	'Kabupaten',	'Halmahera Tengah',	20),
(141,	'Kabupaten',	'Halmahera Timur',	20),
(142,	'Kabupaten',	'Halmahera Utara',	20),
(143,	'Kabupaten',	'Hulu Sungai Selatan',	13),
(144,	'Kabupaten',	'Hulu Sungai Tengah',	13),
(145,	'Kabupaten',	'Hulu Sungai Utara',	13),
(146,	'Kabupaten',	'Humbang Hasundutan',	34),
(147,	'Kabupaten',	'Indragiri Hilir',	26),
(148,	'Kabupaten',	'Indragiri Hulu',	26),
(149,	'Kabupaten',	'Indramayu',	9),
(150,	'Kabupaten',	'Intan Jaya',	24),
(151,	'Kota',	'Jakarta Barat',	6),
(152,	'Kota',	'Jakarta Pusat',	6),
(153,	'Kota',	'Jakarta Selatan',	6),
(154,	'Kota',	'Jakarta Timur',	6),
(155,	'Kota',	'Jakarta Utara',	6),
(156,	'Kota',	'Jambi',	8),
(157,	'Kabupaten',	'Jayapura',	24),
(158,	'Kota',	'Jayapura',	24),
(159,	'Kabupaten',	'Jayawijaya',	24),
(160,	'Kabupaten',	'Jember',	11),
(161,	'Kabupaten',	'Jembrana',	1),
(162,	'Kabupaten',	'Jeneponto',	28),
(163,	'Kabupaten',	'Jepara',	10),
(164,	'Kabupaten',	'Jombang',	11),
(165,	'Kabupaten',	'Kaimana',	25),
(166,	'Kabupaten',	'Kampar',	26),
(167,	'Kabupaten',	'Kapuas',	14),
(168,	'Kabupaten',	'Kapuas Hulu',	12),
(169,	'Kabupaten',	'Karanganyar',	10),
(170,	'Kabupaten',	'Karangasem',	1),
(171,	'Kabupaten',	'Karawang',	9),
(172,	'Kabupaten',	'Karimun',	17),
(173,	'Kabupaten',	'Karo',	34),
(174,	'Kabupaten',	'Katingan',	14),
(175,	'Kabupaten',	'Kaur',	4),
(176,	'Kabupaten',	'Kayong Utara',	12),
(177,	'Kabupaten',	'Kebumen',	10),
(178,	'Kabupaten',	'Kediri',	11),
(179,	'Kota',	'Kediri',	11),
(180,	'Kabupaten',	'Keerom',	24),
(181,	'Kabupaten',	'Kendal',	10),
(182,	'Kota',	'Kendari',	30),
(183,	'Kabupaten',	'Kepahiang',	4),
(184,	'Kabupaten',	'Kepulauan Anambas',	17),
(185,	'Kabupaten',	'Kepulauan Aru',	19),
(186,	'Kabupaten',	'Kepulauan Mentawai',	32),
(187,	'Kabupaten',	'Kepulauan Meranti',	26),
(188,	'Kabupaten',	'Kepulauan Sangihe',	31),
(189,	'Kabupaten',	'Kepulauan Seribu',	6),
(190,	'Kabupaten',	'Kepulauan Siau Tagulandang Biaro (Sitaro)',	31),
(191,	'Kabupaten',	'Kepulauan Sula',	20),
(192,	'Kabupaten',	'Kepulauan Talaud',	31),
(193,	'Kabupaten',	'Kepulauan Yapen (Yapen Waropen)',	24),
(194,	'Kabupaten',	'Kerinci',	8),
(195,	'Kabupaten',	'Ketapang',	12),
(196,	'Kabupaten',	'Klaten',	10),
(197,	'Kabupaten',	'Klungkung',	1),
(198,	'Kabupaten',	'Kolaka',	30),
(199,	'Kabupaten',	'Kolaka Utara',	30),
(200,	'Kabupaten',	'Konawe',	30),
(201,	'Kabupaten',	'Konawe Selatan',	30),
(202,	'Kabupaten',	'Konawe Utara',	30),
(203,	'Kabupaten',	'Kotabaru',	13),
(204,	'Kota',	'Kotamobagu',	31),
(205,	'Kabupaten',	'Kotawaringin Barat',	14),
(206,	'Kabupaten',	'Kotawaringin Timur',	14),
(207,	'Kabupaten',	'Kuantan Singingi',	26),
(208,	'Kabupaten',	'Kubu Raya',	12),
(209,	'Kabupaten',	'Kudus',	10),
(210,	'Kabupaten',	'Kulon Progo',	5),
(211,	'Kabupaten',	'Kuningan',	9),
(212,	'Kabupaten',	'Kupang',	23),
(213,	'Kota',	'Kupang',	23),
(214,	'Kabupaten',	'Kutai Barat',	15),
(215,	'Kabupaten',	'Kutai Kartanegara',	15),
(216,	'Kabupaten',	'Kutai Timur',	15),
(217,	'Kabupaten',	'Labuhan Batu',	34),
(218,	'Kabupaten',	'Labuhan Batu Selatan',	34),
(219,	'Kabupaten',	'Labuhan Batu Utara',	34),
(220,	'Kabupaten',	'Lahat',	33),
(221,	'Kabupaten',	'Lamandau',	14),
(222,	'Kabupaten',	'Lamongan',	11),
(223,	'Kabupaten',	'Lampung Barat',	18),
(224,	'Kabupaten',	'Lampung Selatan',	18),
(225,	'Kabupaten',	'Lampung Tengah',	18),
(226,	'Kabupaten',	'Lampung Timur',	18),
(227,	'Kabupaten',	'Lampung Utara',	18),
(228,	'Kabupaten',	'Landak',	12),
(229,	'Kabupaten',	'Langkat',	34),
(230,	'Kota',	'Langsa',	21),
(231,	'Kabupaten',	'Lanny Jaya',	24),
(232,	'Kabupaten',	'Lebak',	3),
(233,	'Kabupaten',	'Lebong',	4),
(234,	'Kabupaten',	'Lembata',	23),
(235,	'Kota',	'Lhokseumawe',	21),
(236,	'Kabupaten',	'Lima Puluh Koto/Kota',	32),
(237,	'Kabupaten',	'Lingga',	17),
(238,	'Kabupaten',	'Lombok Barat',	22),
(239,	'Kabupaten',	'Lombok Tengah',	22),
(240,	'Kabupaten',	'Lombok Timur',	22),
(241,	'Kabupaten',	'Lombok Utara',	22),
(242,	'Kota',	'Lubuk Linggau',	33),
(243,	'Kabupaten',	'Lumajang',	11),
(244,	'Kabupaten',	'Luwu',	28),
(245,	'Kabupaten',	'Luwu Timur',	28),
(246,	'Kabupaten',	'Luwu Utara',	28),
(247,	'Kabupaten',	'Madiun',	11),
(248,	'Kota',	'Madiun',	11),
(249,	'Kabupaten',	'Magelang',	10),
(250,	'Kota',	'Magelang',	10),
(251,	'Kabupaten',	'Magetan',	11),
(252,	'Kabupaten',	'Majalengka',	9),
(253,	'Kabupaten',	'Majene',	27),
(254,	'Kota',	'Makassar',	28),
(255,	'Kabupaten',	'Malang',	11),
(256,	'Kota',	'Malang',	11),
(257,	'Kabupaten',	'Malinau',	16),
(258,	'Kabupaten',	'Maluku Barat Daya',	19),
(259,	'Kabupaten',	'Maluku Tengah',	19),
(260,	'Kabupaten',	'Maluku Tenggara',	19),
(261,	'Kabupaten',	'Maluku Tenggara Barat',	19),
(262,	'Kabupaten',	'Mamasa',	27),
(263,	'Kabupaten',	'Mamberamo Raya',	24),
(264,	'Kabupaten',	'Mamberamo Tengah',	24),
(265,	'Kabupaten',	'Mamuju',	27),
(266,	'Kabupaten',	'Mamuju Utara',	27),
(267,	'Kota',	'Manado',	31),
(268,	'Kabupaten',	'Mandailing Natal',	34),
(269,	'Kabupaten',	'Manggarai',	23),
(270,	'Kabupaten',	'Manggarai Barat',	23),
(271,	'Kabupaten',	'Manggarai Timur',	23),
(272,	'Kabupaten',	'Manokwari',	25),
(273,	'Kabupaten',	'Manokwari Selatan',	25),
(274,	'Kabupaten',	'Mappi',	24),
(275,	'Kabupaten',	'Maros',	28),
(276,	'Kota',	'Mataram',	22),
(277,	'Kabupaten',	'Maybrat',	25),
(278,	'Kota',	'Medan',	34),
(279,	'Kabupaten',	'Melawi',	12),
(280,	'Kabupaten',	'Merangin',	8),
(281,	'Kabupaten',	'Merauke',	24),
(282,	'Kabupaten',	'Mesuji',	18),
(283,	'Kota',	'Metro',	18),
(284,	'Kabupaten',	'Mimika',	24),
(285,	'Kabupaten',	'Minahasa',	31),
(286,	'Kabupaten',	'Minahasa Selatan',	31),
(287,	'Kabupaten',	'Minahasa Tenggara',	31),
(288,	'Kabupaten',	'Minahasa Utara',	31),
(289,	'Kabupaten',	'Mojokerto',	11),
(290,	'Kota',	'Mojokerto',	11),
(291,	'Kabupaten',	'Morowali',	29),
(292,	'Kabupaten',	'Muara Enim',	33),
(293,	'Kabupaten',	'Muaro Jambi',	8),
(294,	'Kabupaten',	'Muko Muko',	4),
(295,	'Kabupaten',	'Muna',	30),
(296,	'Kabupaten',	'Murung Raya',	14),
(297,	'Kabupaten',	'Musi Banyuasin',	33),
(298,	'Kabupaten',	'Musi Rawas',	33),
(299,	'Kabupaten',	'Nabire',	24),
(300,	'Kabupaten',	'Nagan Raya',	21),
(301,	'Kabupaten',	'Nagekeo',	23),
(302,	'Kabupaten',	'Natuna',	17),
(303,	'Kabupaten',	'Nduga',	24),
(304,	'Kabupaten',	'Ngada',	23),
(305,	'Kabupaten',	'Nganjuk',	11),
(306,	'Kabupaten',	'Ngawi',	11),
(307,	'Kabupaten',	'Nias',	34),
(308,	'Kabupaten',	'Nias Barat',	34),
(309,	'Kabupaten',	'Nias Selatan',	34),
(310,	'Kabupaten',	'Nias Utara',	34),
(311,	'Kabupaten',	'Nunukan',	16),
(312,	'Kabupaten',	'Ogan Ilir',	33),
(313,	'Kabupaten',	'Ogan Komering Ilir',	33),
(314,	'Kabupaten',	'Ogan Komering Ulu',	33),
(315,	'Kabupaten',	'Ogan Komering Ulu Selatan',	33),
(316,	'Kabupaten',	'Ogan Komering Ulu Timur',	33),
(317,	'Kabupaten',	'Pacitan',	11),
(318,	'Kota',	'Padang',	32),
(319,	'Kabupaten',	'Padang Lawas',	34),
(320,	'Kabupaten',	'Padang Lawas Utara',	34),
(321,	'Kota',	'Padang Panjang',	32),
(322,	'Kabupaten',	'Padang Pariaman',	32),
(323,	'Kota',	'Padang Sidempuan',	34),
(324,	'Kota',	'Pagar Alam',	33),
(325,	'Kabupaten',	'Pakpak Bharat',	34),
(326,	'Kota',	'Palangka Raya',	14),
(327,	'Kota',	'Palembang',	33),
(328,	'Kota',	'Palopo',	28),
(329,	'Kota',	'Palu',	29),
(330,	'Kabupaten',	'Pamekasan',	11),
(331,	'Kabupaten',	'Pandeglang',	3),
(332,	'Kabupaten',	'Pangandaran',	9),
(333,	'Kabupaten',	'Pangkajene Kepulauan',	28),
(334,	'Kota',	'Pangkal Pinang',	2),
(335,	'Kabupaten',	'Paniai',	24),
(336,	'Kota',	'Parepare',	28),
(337,	'Kota',	'Pariaman',	32),
(338,	'Kabupaten',	'Parigi Moutong',	29),
(339,	'Kabupaten',	'Pasaman',	32),
(340,	'Kabupaten',	'Pasaman Barat',	32),
(341,	'Kabupaten',	'Paser',	15),
(342,	'Kabupaten',	'Pasuruan',	11),
(343,	'Kota',	'Pasuruan',	11),
(344,	'Kabupaten',	'Pati',	10),
(345,	'Kota',	'Payakumbuh',	32),
(346,	'Kabupaten',	'Pegunungan Arfak',	25),
(347,	'Kabupaten',	'Pegunungan Bintang',	24),
(348,	'Kabupaten',	'Pekalongan',	10),
(349,	'Kota',	'Pekalongan',	10),
(350,	'Kota',	'Pekanbaru',	26),
(351,	'Kabupaten',	'Pelalawan',	26),
(352,	'Kabupaten',	'Pemalang',	10),
(353,	'Kota',	'Pematang Siantar',	34),
(354,	'Kabupaten',	'Penajam Paser Utara',	15),
(355,	'Kabupaten',	'Pesawaran',	18),
(356,	'Kabupaten',	'Pesisir Barat',	18),
(357,	'Kabupaten',	'Pesisir Selatan',	32),
(358,	'Kabupaten',	'Pidie',	21),
(359,	'Kabupaten',	'Pidie Jaya',	21),
(360,	'Kabupaten',	'Pinrang',	28),
(361,	'Kabupaten',	'Pohuwato',	7),
(362,	'Kabupaten',	'Polewali Mandar',	27),
(363,	'Kabupaten',	'Ponorogo',	11),
(364,	'Kabupaten',	'Pontianak',	12),
(365,	'Kota',	'Pontianak',	12),
(366,	'Kabupaten',	'Poso',	29),
(367,	'Kota',	'Prabumulih',	33),
(368,	'Kabupaten',	'Pringsewu',	18),
(369,	'Kabupaten',	'Probolinggo',	11),
(370,	'Kota',	'Probolinggo',	11),
(371,	'Kabupaten',	'Pulang Pisau',	14),
(372,	'Kabupaten',	'Pulau Morotai',	20),
(373,	'Kabupaten',	'Puncak',	24),
(374,	'Kabupaten',	'Puncak Jaya',	24),
(375,	'Kabupaten',	'Purbalingga',	10),
(376,	'Kabupaten',	'Purwakarta',	9),
(377,	'Kabupaten',	'Purworejo',	10),
(378,	'Kabupaten',	'Raja Ampat',	25),
(379,	'Kabupaten',	'Rejang Lebong',	4),
(380,	'Kabupaten',	'Rembang',	10),
(381,	'Kabupaten',	'Rokan Hilir',	26),
(382,	'Kabupaten',	'Rokan Hulu',	26),
(383,	'Kabupaten',	'Rote Ndao',	23),
(384,	'Kota',	'Sabang',	21),
(385,	'Kabupaten',	'Sabu Raijua',	23),
(386,	'Kota',	'Salatiga',	10),
(387,	'Kota',	'Samarinda',	15),
(388,	'Kabupaten',	'Sambas',	12),
(389,	'Kabupaten',	'Samosir',	34),
(390,	'Kabupaten',	'Sampang',	11),
(391,	'Kabupaten',	'Sanggau',	12),
(392,	'Kabupaten',	'Sarmi',	24),
(393,	'Kabupaten',	'Sarolangun',	8),
(394,	'Kota',	'Sawah Lunto',	32),
(395,	'Kabupaten',	'Sekadau',	12),
(396,	'Kabupaten',	'Selayar (Kepulauan Selayar)',	28),
(397,	'Kabupaten',	'Seluma',	4),
(398,	'Kabupaten',	'Semarang',	10),
(399,	'Kota',	'Semarang',	10),
(400,	'Kabupaten',	'Seram Bagian Barat',	19),
(401,	'Kabupaten',	'Seram Bagian Timur',	19),
(402,	'Kabupaten',	'Serang',	3),
(403,	'Kota',	'Serang',	3),
(404,	'Kabupaten',	'Serdang Bedagai',	34),
(405,	'Kabupaten',	'Seruyan',	14),
(406,	'Kabupaten',	'Siak',	26),
(407,	'Kota',	'Sibolga',	34),
(408,	'Kabupaten',	'Sidenreng Rappang/Rapang',	28),
(409,	'Kabupaten',	'Sidoarjo',	11),
(410,	'Kabupaten',	'Sigi',	29),
(411,	'Kabupaten',	'Sijunjung (Sawah Lunto Sijunjung)',	32),
(412,	'Kabupaten',	'Sikka',	23),
(413,	'Kabupaten',	'Simalungun',	34),
(414,	'Kabupaten',	'Simeulue',	21),
(415,	'Kota',	'Singkawang',	12),
(416,	'Kabupaten',	'Sinjai',	28),
(417,	'Kabupaten',	'Sintang',	12),
(418,	'Kabupaten',	'Situbondo',	11),
(419,	'Kabupaten',	'Sleman',	5),
(420,	'Kabupaten',	'Solok',	32),
(421,	'Kota',	'Solok',	32),
(422,	'Kabupaten',	'Solok Selatan',	32),
(423,	'Kabupaten',	'Soppeng',	28),
(424,	'Kabupaten',	'Sorong',	25),
(425,	'Kota',	'Sorong',	25),
(426,	'Kabupaten',	'Sorong Selatan',	25),
(427,	'Kabupaten',	'Sragen',	10),
(428,	'Kabupaten',	'Subang',	9),
(429,	'Kota',	'Subulussalam',	21),
(430,	'Kabupaten',	'Sukabumi',	9),
(431,	'Kota',	'Sukabumi',	9),
(432,	'Kabupaten',	'Sukamara',	14),
(433,	'Kabupaten',	'Sukoharjo',	10),
(434,	'Kabupaten',	'Sumba Barat',	23),
(435,	'Kabupaten',	'Sumba Barat Daya',	23),
(436,	'Kabupaten',	'Sumba Tengah',	23),
(437,	'Kabupaten',	'Sumba Timur',	23),
(438,	'Kabupaten',	'Sumbawa',	22),
(439,	'Kabupaten',	'Sumbawa Barat',	22),
(440,	'Kabupaten',	'Sumedang',	9),
(441,	'Kabupaten',	'Sumenep',	11),
(442,	'Kota',	'Sungaipenuh',	8),
(443,	'Kabupaten',	'Supiori',	24),
(444,	'Kota',	'Surabaya',	11),
(445,	'Kota',	'Surakarta (Solo)',	10),
(446,	'Kabupaten',	'Tabalong',	13),
(447,	'Kabupaten',	'Tabanan',	1),
(448,	'Kabupaten',	'Takalar',	28),
(449,	'Kabupaten',	'Tambrauw',	25),
(450,	'Kabupaten',	'Tana Tidung',	16),
(451,	'Kabupaten',	'Tana Toraja',	28),
(452,	'Kabupaten',	'Tanah Bumbu',	13),
(453,	'Kabupaten',	'Tanah Datar',	32),
(454,	'Kabupaten',	'Tanah Laut',	13),
(455,	'Kabupaten',	'Tangerang',	3),
(456,	'Kota',	'Tangerang',	3),
(457,	'Kota',	'Tangerang Selatan',	3),
(458,	'Kabupaten',	'Tanggamus',	18),
(459,	'Kota',	'Tanjung Balai',	34),
(460,	'Kabupaten',	'Tanjung Jabung Barat',	8),
(461,	'Kabupaten',	'Tanjung Jabung Timur',	8),
(462,	'Kota',	'Tanjung Pinang',	17),
(463,	'Kabupaten',	'Tapanuli Selatan',	34),
(464,	'Kabupaten',	'Tapanuli Tengah',	34),
(465,	'Kabupaten',	'Tapanuli Utara',	34),
(466,	'Kabupaten',	'Tapin',	13),
(467,	'Kota',	'Tarakan',	16),
(468,	'Kabupaten',	'Tasikmalaya',	9),
(469,	'Kota',	'Tasikmalaya',	9),
(470,	'Kota',	'Tebing Tinggi',	34),
(471,	'Kabupaten',	'Tebo',	8),
(472,	'Kabupaten',	'Tegal',	10),
(473,	'Kota',	'Tegal',	10),
(474,	'Kabupaten',	'Teluk Bintuni',	25),
(475,	'Kabupaten',	'Teluk Wondama',	25),
(476,	'Kabupaten',	'Temanggung',	10),
(477,	'Kota',	'Ternate',	20),
(478,	'Kota',	'Tidore Kepulauan',	20),
(479,	'Kabupaten',	'Timor Tengah Selatan',	23),
(480,	'Kabupaten',	'Timor Tengah Utara',	23),
(481,	'Kabupaten',	'Toba Samosir',	34),
(482,	'Kabupaten',	'Tojo Una-Una',	29),
(483,	'Kabupaten',	'Toli-Toli',	29),
(484,	'Kabupaten',	'Tolikara',	24),
(485,	'Kota',	'Tomohon',	31),
(486,	'Kabupaten',	'Toraja Utara',	28),
(487,	'Kabupaten',	'Trenggalek',	11),
(488,	'Kota',	'Tual',	19),
(489,	'Kabupaten',	'Tuban',	11),
(490,	'Kabupaten',	'Tulang Bawang',	18),
(491,	'Kabupaten',	'Tulang Bawang Barat',	18),
(492,	'Kabupaten',	'Tulungagung',	11),
(493,	'Kabupaten',	'Wajo',	28),
(494,	'Kabupaten',	'Wakatobi',	30),
(495,	'Kabupaten',	'Waropen',	24),
(496,	'Kabupaten',	'Way Kanan',	18),
(497,	'Kabupaten',	'Wonogiri',	10),
(498,	'Kabupaten',	'Wonosobo',	10),
(499,	'Kabupaten',	'Yahukimo',	24),
(500,	'Kabupaten',	'Yalimo',	24),
(501,	'Kota',	'Yogyakarta',	5);

CREATE TABLE `menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(50) NOT NULL,
  `deskripsi` text,
  `controller` varchar(255) DEFAULT NULL,
  `actions` text,
  `default_action` varchar(255) DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `level` int(11) DEFAULT '1',
  `status_tampil` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=744;

INSERT INTO `menu` (`id`, `nama`, `deskripsi`, `controller`, `actions`, `default_action`, `icon`, `parent_id`, `level`, `status_tampil`, `created_at`, `updated_at`) VALUES
(1,	'Beranda',	'',	'site',	'[\"index\"]',	'index',	'fa fa-home',	NULL,	1,	1,	'2018-12-18 16:12:35',	'2018-12-26 09:33:30'),
(2,	'Role',	'',	'role',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-user-md',	4,	2,	1,	'2018-12-18 16:13:09',	'2018-12-26 09:36:52'),
(3,	'Menu',	'',	'menu',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-th-list',	4,	2,	1,	'2018-12-20 06:33:57',	'2018-12-26 09:37:18'),
(4,	'User & Role',	'',	'',	'\"\"',	'',	'fa fa-lock',	NULL,	1,	1,	'2018-12-20 07:07:19',	'2018-12-29 11:19:23'),
(5,	'Role Menu',	'',	'role-menu',	'[\"create\",\"index\",\"update\",\"delete\",\"up\",\"down\",\"view\"]',	'index',	'fa fa-check-square-o',	4,	2,	1,	'2018-12-20 07:18:45',	'2018-12-26 09:38:03'),
(6,	'User',	'',	'user',	'[\"create\",\"index\",\"update\",\"delete\",\"change-password\",\"view\"]',	'index',	'fa fa-users',	4,	2,	1,	'2018-12-20 09:09:21',	'2019-01-12 14:15:31'),
(19,	'Vendor',	NULL,	'vendor',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-bank',	NULL,	1,	1,	'2019-01-12 14:16:56',	'2019-02-01 03:46:50'),
(20,	'Peserta',	NULL,	'peserta',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-users',	23,	2,	0,	'2019-01-12 14:17:22',	'2019-02-01 03:29:46'),
(21,	'Trainer',	NULL,	'trainer',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-graduation-cap',	23,	2,	0,	'2019-01-12 14:20:48',	'2019-02-01 03:29:54'),
(22,	'Training',	NULL,	'training',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-cube',	NULL,	1,	1,	'2019-01-12 14:21:30',	'2019-01-12 14:21:30'),
(23,	'Detail Training',	NULL,	'',	'\"\"',	'',	'fa fa-cube',	NULL,	1,	0,	'2019-02-01 03:29:28',	'2019-02-01 03:29:28'),
(24,	'Kategori',	NULL,	'kategori',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-tags',	NULL,	1,	1,	'2019-02-12 20:31:22',	'2019-02-12 20:32:01');

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `migration` (`version`, `apply_time`) VALUES
('m000000_000000_base',	1545108178),
('m130524_201442_init',	1545108181),
('m181211_160017_create_table_setting',	1545108182);

CREATE TABLE `peserta_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `peserta_training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `peserta_id` int(11) NOT NULL,
  `training_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `peserta_id` (`peserta_id`),
  KEY `training_id` (`training_id`),
  CONSTRAINT `peserta_training_ibfk_1` FOREIGN KEY (`peserta_id`) REFERENCES `peserta` (`id`),
  CONSTRAINT `peserta_training_ibfk_2` FOREIGN KEY (`training_id`) REFERENCES `training` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `provinsi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `provinsi` (`id`, `nama`) VALUES
(1,	'Bali'),
(2,	'Bangka Belitung'),
(3,	'Banten'),
(4,	'Bengkulu'),
(5,	'DI Yogyakarta'),
(6,	'DKI Jakarta'),
(7,	'Gorontalo'),
(8,	'Jambi'),
(9,	'Jawa Barat'),
(10,	'Jawa Tengah'),
(11,	'Jawa Timur'),
(12,	'Kalimantan Barat'),
(13,	'Kalimantan Selatan'),
(14,	'Kalimantan Tengah'),
(15,	'Kalimantan Timur'),
(16,	'Kalimantan Utara'),
(17,	'Kepulauan Riau'),
(18,	'Lampung'),
(19,	'Maluku'),
(20,	'Maluku Utara'),
(21,	'Nanggroe Aceh Darussalam (NAD)'),
(22,	'Nusa Tenggara Barat (NTB)'),
(23,	'Nusa Tenggara Timur (NTT)'),
(24,	'Papua'),
(25,	'Papua Barat'),
(26,	'Riau'),
(27,	'Sulawesi Barat'),
(28,	'Sulawesi Selatan'),
(29,	'Sulawesi Tengah'),
(30,	'Sulawesi Tenggara'),
(31,	'Sulawesi Utara'),
(32,	'Sumatera Barat'),
(33,	'Sumatera Selatan'),
(34,	'Sumatera Utara');

CREATE TABLE `riwayat_pembayaran_vendor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jenis` varchar(255) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` text NOT NULL,
  `training_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `training_id` (`training_id`),
  CONSTRAINT `riwayat_pembayaran_vendor_ibfk_1` FOREIGN KEY (`training_id`) REFERENCES `training` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(50) NOT NULL,
  `deskripsi` text,
  `status` smallint(6) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `role` (`id`, `nama`, `deskripsi`, `status`, `created_at`, `updated_at`) VALUES
(1,	'Super Admin',	'Super admin yang mempunyai semua hak di dalam aplikasi',	1,	'2018-12-18 16:11:28',	'2018-12-29 11:11:40'),
(2,	'Admin',	'Admin Umum\r\n',	1,	'2018-12-20 08:27:06',	'2018-12-29 11:11:16');

CREATE TABLE `role_menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) unsigned DEFAULT NULL,
  `menu_id` int(11) unsigned DEFAULT NULL,
  `parameter` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `posisi` int(11) unsigned DEFAULT NULL,
  `privileges` varchar(255) NOT NULL COMMENT 'misal: crud',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `role_id` (`role_id`),
  KEY `menu_id` (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=744;

INSERT INTO `role_menu` (`id`, `role_id`, `menu_id`, `parameter`, `label`, `posisi`, `privileges`, `created_at`, `updated_at`) VALUES
(4,	1,	4,	'',	'',	3,	'\"\"',	'2018-12-20 07:22:17',	'2018-12-26 09:47:19'),
(6,	1,	2,	'',	'',	4,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2018-12-20 07:45:09',	'2018-12-29 11:11:28'),
(7,	1,	5,	'',	'',	6,	'[\"create\",\"index\",\"update\",\"delete\",\"up\",\"down\",\"view\"]',	'0000-00-00 00:00:00',	'2018-12-21 10:05:45'),
(9,	1,	6,	'',	'User',	2,	'[\"create\",\"index\",\"update\",\"delete\",\"change-password\",\"view\"]',	'2018-12-20 09:22:42',	'2018-12-26 09:49:00'),
(17,	1,	1,	'',	'',	1,	'[\"index\"]',	'2018-12-20 16:06:16',	'2018-12-26 09:34:05'),
(18,	2,	1,	'',	'',	1,	'[\"index\"]',	'2018-12-20 16:11:03',	'2018-12-26 09:33:58'),
(26,	1,	3,	'',	'',	5,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2018-12-20 21:21:30',	'2018-12-22 09:40:11'),
(39,	1,	22,	'',	'',	7,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-01-12 14:22:03',	'2019-01-12 14:22:03'),
(40,	1,	19,	'',	'',	8,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-01-12 14:22:23',	'2019-01-12 14:22:23'),
(41,	1,	20,	'',	'',	9,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-01-12 14:22:32',	'2019-01-12 14:22:32'),
(42,	1,	21,	'',	'',	10,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-01-12 14:22:49',	'2019-01-12 14:22:49'),
(43,	1,	24,	'',	'',	11,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-02-12 20:31:37',	'2019-02-12 20:31:37');

CREATE TABLE `setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) DEFAULT NULL,
  `deskripsi` varchar(255) DEFAULT NULL,
  `nilai` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `trainer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) NOT NULL,
  `alamat` text NOT NULL,
  `telepon` varchar(255) NOT NULL,
  `bidang` varchar(255) NOT NULL,
  `kompetensi` varchar(255) NOT NULL,
  `pendidikan` varchar(255) NOT NULL,
  `sertifikat` varchar(255) NOT NULL,
  `pengalaman` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `trainer_training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trainer_id` int(11) NOT NULL,
  `training_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `trainer_id` (`trainer_id`),
  KEY `training_id` (`training_id`),
  CONSTRAINT `trainer_training_ibfk_1` FOREIGN KEY (`trainer_id`) REFERENCES `trainer` (`id`),
  CONSTRAINT `trainer_training_ibfk_2` FOREIGN KEY (`training_id`) REFERENCES `training` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) NOT NULL,
  `poster` varchar(255) NOT NULL,
  `deskripsi` text NOT NULL,
  `konten` text NOT NULL,
  `peserta_minimum` int(11) NOT NULL,
  `peserta_maksimum` int(11) NOT NULL,
  `provinsi_id` int(11) NOT NULL,
  `kota_id` int(11) NOT NULL,
  `alamat` text NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `tanggal_mulai` date NOT NULL,
  `tanggal_selesai` date NOT NULL,
  `biaya` int(11) NOT NULL,
  `diskon` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `kategori_id` int(11) NOT NULL,
  `training_status_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vendor_id` (`vendor_id`),
  KEY `training_status_id` (`training_status_id`),
  KEY `kategori_id` (`kategori_id`),
  KEY `provinsi_id` (`provinsi_id`),
  KEY `kota_id` (`kota_id`),
  CONSTRAINT `training_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `vendor` (`id`),
  CONSTRAINT `training_ibfk_2` FOREIGN KEY (`training_status_id`) REFERENCES `training_status` (`id`),
  CONSTRAINT `training_ibfk_3` FOREIGN KEY (`kategori_id`) REFERENCES `kategori` (`id`),
  CONSTRAINT `training_ibfk_4` FOREIGN KEY (`provinsi_id`) REFERENCES `provinsi` (`id`),
  CONSTRAINT `training_ibfk_5` FOREIGN KEY (`kota_id`) REFERENCES `kota` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `training` (`id`, `nama`, `poster`, `deskripsi`, `konten`, `peserta_minimum`, `peserta_maksimum`, `provinsi_id`, `kota_id`, `alamat`, `latitude`, `longitude`, `tanggal_mulai`, `tanggal_selesai`, `biaya`, `diskon`, `vendor_id`, `kategori_id`, `training_status_id`, `created_at`, `updated_at`) VALUES
(2,	'CCNA School Level 1',	'oAaXvZAmGEl1_inixIDoXu6KvtiEQXdr.jpg',	'Praesent congue erat at massa. Aenean vulputate eleifend tellus. Praesent blandit laoreet nibh. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna. Sed mollis, eros et ultrices tempus, mauris ipsum aliquam libero, non adipiscing dolor urna a orci.',	'<p>Praesent congue erat at massa. Aenean vulputate eleifend tellus. Praesent blandit laoreet nibh. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna. Sed mollis, eros et ultrices tempus, mauris ipsum aliquam libero, non adipiscing dolor urna a orci.</p>\r\n\r\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>Judul A</td>\r\n			<td>Judul B</td>\r\n		</tr>\r\n		<tr>\r\n			<td>abc</td>\r\n			<td>def</td>\r\n		</tr>\r\n		<tr>\r\n			<td>ddd</td>\r\n			<td>fff</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p><strong>Praesent congue erat at massa.</strong> Aenean vulputate eleifend tellus. Praesent blandit laoreet nibh. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna. Sed mollis, eros et ultrices tempus, mauris ipsum aliquam libero, non adipiscing dolor urna a orci.</p>\r\n\r\n<p>Praesent congue erat at massa. Aenean vulputate eleifend tellus. Praesent blandit laoreet nibh. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna. Sed mollis, eros et ultrices tempus, mauris ipsum aliquam libero, non adipiscing dolor urna a orci.</p>\r\n',	5,	100,	6,	152,	'Praesent congue erat at massa. Aenean vulputate eleifend tellus. Praesent blandit laoreet nibh. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna. Sed mollis, eros et ultrices tempus, mauris ipsum aliquam libero, non adipiscing dolor urna a orci.',	'-7.28608',	'111.74659050000002',	'2019-02-19',	'2019-02-19',	233000,	0,	1,	3,	1,	'2019-02-12 23:32:31',	'2019-02-13 06:35:49'),
(3,	'Oracle Basic 1',	'yRY8799RFmZaHO4Zc9CUXMQ6fkwDAhgb.jpg',	'Vestibulum dapibus nunc ac augue. Aenean tellus metus, bibendum sed, posuere ac, mattis non, nunc. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna. Nullam sagittis. Fusce egestas elit eget lorem.',	'<p>asdf&nbsp;Vestibulum dapibus nunc ac augue. Aenean tellus metus, bibendum sed, posuere ac, mattis non, nunc. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna. Nullam sagittis. Fusce egestas elit eget lorem.</p>\r\n',	5,	100,	10,	113,	'Vestibulum dapibus nunc ac augue. Aenean tellus metus, bibendum sed, posuere ac, mattis non, nunc. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna. Nullam sagittis. Fusce egestas elit eget lorem.',	'-7.28608',	'110.69190300000002',	'2019-02-20',	'2019-02-20',	300000,	0,	1,	19,	1,	'2019-02-13 11:01:00',	'2019-02-13 11:01:00');

CREATE TABLE `training_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) NOT NULL,
  `warna` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `training_status` (`id`, `nama`, `warna`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1,	'Pending',	'label-default',	'2019-02-01 11:00:38',	'2019-02-01 11:00:38',	1,	1),
(2,	'Terkonfirmasi',	'label-primary',	'2019-02-01 11:00:54',	'2019-02-01 11:00:54',	1,	1),
(3,	'Berlangsung',	'label-warning',	'2019-02-01 11:01:24',	'2019-02-01 11:01:24',	1,	1),
(4,	'Gagal',	'label-danger',	'2019-02-01 11:01:46',	'2019-02-01 11:01:46',	1,	1),
(5,	'Sukses',	'label-success',	'2019-02-01 11:01:59',	'2019-02-01 11:01:59',	1,	1);

CREATE TABLE `transaksi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jenis` varchar(255) NOT NULL COMMENT 'peserta / vendor / admin',
  `debet` int(11) NOT NULL DEFAULT '0',
  `kredit` int(11) NOT NULL DEFAULT '0',
  `keterangan` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `transaksi` (`id`, `jenis`, `debet`, `kredit`, `keterangan`, `created_at`, `updated_at`) VALUES
(1,	'peserta',	200000,	0,	'topup saldo peserta',	'2019-02-24 23:43:29',	'2019-02-24 23:43:29'),
(2,	'peserta',	150000,	0,	'topup saldo peserta',	'2019-02-24 23:55:14',	'2019-02-24 23:55:14'),
(3,	'peserta',	100000,	0,	'topup saldo peserta',	'2019-02-24 23:55:54',	'2019-02-24 23:55:54'),
(4,	'peserta',	200000,	0,	'topup saldo peserta',	'2019-02-25 00:00:40',	'2019-02-25 00:00:40');

-- 2019-02-27 00:47:34
