-- Adminer 4.2.4 MySQL dump

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

CREATE TABLE `artikel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` text COLLATE utf8_unicode_ci NOT NULL,
  `judul` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8_unicode_ci NOT NULL,
  `konten` text COLLATE utf8_unicode_ci NOT NULL,
  `gambar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `artikel_kategori_id` int(11) NOT NULL,
  `tag` text COLLATE utf8_unicode_ci NOT NULL,
  `dibaca` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `artikel` (`id`, `slug`, `judul`, `deskripsi`, `konten`, `gambar`, `artikel_kategori_id`, `tag`, `dibaca`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1,	'internet-masa-kini',	'Internet Masa Kini',	'Morbi vestibulum volutpat enim. Vestibulum volutpat pretium libero. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec posuere vulputate arcu. Curabitur a felis in nunc fringilla tristique.',	'<p>dMorbi vestibulum volutpat enim. Vestibulum volutpat pretium libero. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec posuere vulputate arcu. Curabitur a felis in nunc fringilla tristique.</p>\r\n\r\n<p>Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Maecenas ullamcorper, dui et placerat feugiat, eros pede varius nisi, condimentum viverra felis nunc et lorem. Vestibulum purus quam, scelerisque ut, mollis sed, nonummy id, metus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Suspendisse faucibus, nunc et pellentesque egestas, lacus ante convallis tellus, vitae iaculis lacus elit id tortor.</p>\r\n\r\n<p>Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Quisque rutrum. Curabitur blandit mollis lacus. Fusce vulputate eleifend sapien. Nunc egestas, augue at pellentesque laoreet, felis eros vehicula leo, at malesuada velit leo quis pede.</p>\r\n\r\n<p>Fusce egestas elit eget lorem. Morbi ac felis. Sed mollis, eros et ultrices tempus, mauris ipsum aliquam libero, non adipiscing dolor urna a orci. Maecenas egestas arcu quis ligula mattis placerat. Fusce neque.</p>\r\n\r\n<p>Nullam accumsan lorem in dui. Maecenas malesuada. Phasellus accumsan cursus velit. Cras varius. Donec posuere vulputate arcu.</p>\r\n',	'9q-CGuBotzGTs82kJXMXT_FUMnZUADNt.jpg',	3,	'[\"internet\",\"revolusi\",\"industri\"]',	0,	'2019-03-06 20:07:11',	'2019-03-06 20:07:11',	1,	1),
(2,	'perkembangan-oracle-di-indonesia',	'Perkembangan Oracle di Indonesia',	'Donec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.',	'<p>Doonec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.&nbsp;Donec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.</p>\r\n\r\n<p>Donec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.&nbsp;Donec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.</p>\r\n\r\n<p>Donec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.&nbsp;Donec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.</p>\r\n\r\n<p>Donec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.&nbsp;Donec mollis hendrerit risus. In ut quam vitae odio lacinia tincidunt. Ut id nisl quis enim dignissim sagittis. Phasellus accumsan cursus velit. Phasellus dolor.</p>\r\n',	'o3rXJUx5AAaJQDUnfUzTmq3MViutf0fs.jpg',	3,	'[\"oracle\",\"indonesia\",\"4.0\"]',	0,	'2019-03-08 06:27:03',	'2019-03-08 06:27:03',	1,	1);

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

INSERT INTO `artikel_kategori` (`id`, `slug`, `nama`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1,	'pendidikan',	'Pendidikan',	'2019-03-06 20:03:24',	'2019-03-06 20:03:24',	1,	1),
(2,	'training',	'Training',	'2019-03-06 20:03:38',	'2019-03-06 20:03:38',	1,	1),
(3,	'teknologi',	'Teknologi',	'2019-03-06 20:03:53',	'2019-03-06 20:03:53',	1,	1);

CREATE TABLE `artikel_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `artikel_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `artikel_id` (`artikel_id`),
  KEY `tag_id` (`tag_id`),
  CONSTRAINT `artikel_tag_ibfk_1` FOREIGN KEY (`artikel_id`) REFERENCES `artikel` (`id`),
  CONSTRAINT `artikel_tag_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


CREATE TABLE `banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gambar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `banner` (`id`, `judul`, `gambar`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1,	'Banner Pertama',	'orgRm7L-ii8ZJUHyaWZ8lWq5eNJHgrn-.jpg',	'2019-03-07 17:07:01',	'2019-03-15 08:29:58',	1,	1),
(2,	'Banner Kedua',	'IPR3jyUs6Zd2GeBxd8jXfj7eedGYCmqY.jpg',	'2019-03-08 06:19:36',	'2019-03-15 08:30:16',	1,	1),
(3,	'Banner Ketiga',	'0_oWYHl61qIUvNeo-bL8pviRSSKht26C.jpg',	'2019-03-15 08:34:37',	'2019-03-18 05:06:16',	1,	1),
(4,	'Banner keempat',	'hS4rPY-NqfC78sewFEaIzgLAuF8TrZkx.png',	'2019-03-18 05:06:53',	'2019-03-18 05:06:53',	1,	1);

CREATE TABLE `dokumen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vendor_id` (`vendor_id`),
  CONSTRAINT `dokumen_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `vendor` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `dokumen` (`id`, `vendor_id`, `nama`, `file`, `created_at`, `updated_at`) VALUES
(2,	1,	'Ijazah',	'22h719-ByQEVGSVQqoqCtbNE9IfjxZ4M.log',	'2019-03-11 14:23:16',	'2019-03-11 14:23:16'),
(3,	1,	'Tanda Daftar Perusahaan (TDP)',	'5u6XIMAEe9_k5U94PtFYqAaAclXfVrWZ.php',	'2019-03-11 14:29:01',	'2019-03-11 14:29:01'),
(4,	1,	'Nomor Induk Berusaha (NIB)',	'7EPOzq6LZ9w2VLnSciiMP8JBVLoYajMP.pdf',	'2019-03-11 14:35:34',	'2019-03-11 14:35:34'),
(5,	5,	'Tanda Daftar Perusahaan (TDP)',	'im8-6aY2rQlVXVQncvIfbe9Gzu1pKNZL.pdf',	'2019-03-19 15:38:43',	'2019-03-19 15:38:43'),
(6,	6,	'Akta Notaris',	'z88jGkr54hPosVFw3KZctotYvGkE14GY.pdf',	'2019-03-20 03:55:22',	'2019-03-20 03:55:22'),
(7,	7,	'Akta Notaris',	'zhdzfh11hOT-XAY34TjNmTQquc9WOT7R.pdf',	'2019-03-25 09:00:17',	'2019-03-25 09:00:17'),
(8,	8,	'Akta Notaris',	'_qYyK8khP1XPumj_wWWSODuQ92z46iDV.pdf',	'2019-04-02 04:23:51',	'2019-04-02 04:23:51');

CREATE TABLE `form_afiliasi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `peserta_id` int(11) DEFAULT NULL,
  `catatan` text,
  `catatan_admin` text,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `peserta_id` (`peserta_id`),
  CONSTRAINT `form_afiliasi_ibfk_1` FOREIGN KEY (`peserta_id`) REFERENCES `peserta` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `form_afiliasi` (`id`, `peserta_id`, `catatan`, `catatan_admin`, `status`, `created_at`, `updated_at`) VALUES
(1,	7,	'saya semangat',	'Kuota afiliate di kota Anda sudah maksimal',	1,	'2019-03-23 00:56:13',	'2019-03-23 00:56:29'),
(2,	7,	'untuk memenuhi kebutuhan keluarga',	'Anda belum kompeten',	1,	'2019-03-23 00:58:50',	'2019-03-23 00:59:04'),
(3,	7,	'saya afiliate pertama di Surabaya',	NULL,	1,	'2019-03-23 01:03:50',	'2019-03-23 01:04:08'),
(4,	9,	'saya sudah iku lama, mau jadi reseller',	NULL,	1,	'2019-04-02 06:12:38',	'2019-04-02 06:13:12');

CREATE TABLE `form_withdraw` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jenis` varchar(255) DEFAULT NULL COMMENT 'peserta / vendor',
  `foreign_key` int(11) DEFAULT NULL,
  `jumlah` int(11) DEFAULT NULL,
  `catatan` text,
  `catatan_admin` text,
  `status` int(11) DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `form_withdraw` (`id`, `jenis`, `foreign_key`, `jumlah`, `catatan`, `catatan_admin`, `status`, `created_at`, `updated_at`) VALUES
(1,	'peserta',	7,	100000,	'untuk beli jajan',	NULL,	1,	'2019-03-22 14:07:14',	'2019-03-22 14:09:02'),
(2,	'peserta',	7,	100000,	'tes lagi',	'Saldo tidak cukup',	1,	'2019-03-22 14:27:36',	'2019-03-22 14:29:14'),
(3,	'peserta',	7,	100000,	'test',	'Saldo tidak cukup',	1,	'2019-03-22 14:31:31',	'2019-03-22 14:31:45'),
(4,	'peserta',	7,	100000,	'hai\r\n',	'Saldo tidak cukup',	1,	'2019-03-22 14:36:37',	'2019-03-22 14:36:48'),
(5,	'peserta',	7,	100000,	'percobaan terakhir',	'sehari maksimal 3x withdraw',	1,	'2019-03-22 14:38:09',	'2019-03-22 14:38:42'),
(6,	'vendor',	1,	0,	'tes saja',	'karena hanya 0 rupiah',	1,	'2019-03-22 15:08:12',	'2019-03-22 15:08:36'),
(7,	'peserta',	4,	500000,	'saya topupnya kebanyakan, hanya ikut satu training saja',	'nanti tanggal 25 baru bisa dicairkan',	1,	'2019-03-22 23:55:51',	'2019-03-22 23:58:33'),
(8,	'peserta',	4,	300000,	'ini sudah tanggal 25',	NULL,	1,	'2019-03-22 23:59:59',	'2019-03-23 00:00:20'),
(9,	'peserta',	4,	200000,	'untuk beli jajan',	NULL,	1,	'2019-03-23 00:14:27',	'2019-03-23 00:14:48'),
(10,	'vendor',	6,	20000,	'untuk sewa venue dan talent',	NULL,	1,	'2019-03-23 22:36:52',	'2019-03-23 22:38:25'),
(11,	'vendor',	6,	5000,	'untuk bayar transportasi',	'Belum bisa, karena kemarin baru saja withdraw',	1,	'2019-03-23 23:04:42',	'2019-03-23 23:05:22'),
(12,	'peserta',	7,	300000,	'mau daftar peserta lain',	NULL,	0,	'2019-03-23 23:20:42',	'2019-03-23 23:20:42'),
(13,	'peserta',	9,	100000,	'untuk biaya transportasi ke tempat training',	NULL,	1,	'2019-03-25 16:14:16',	'2019-03-25 16:15:14'),
(14,	'peserta',	9,	200000,	'butuh uang',	NULL,	1,	'2019-04-02 06:18:40',	'2019-04-02 06:19:07');

CREATE TABLE `halaman` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` text COLLATE utf8_unicode_ci NOT NULL,
  `judul` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8_unicode_ci NOT NULL,
  `konten` text COLLATE utf8_unicode_ci NOT NULL,
  `gambar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tag` text COLLATE utf8_unicode_ci NOT NULL,
  `dibaca` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `halaman` (`id`, `slug`, `judul`, `deskripsi`, `konten`, `gambar`, `tag`, `dibaca`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1,	'cara-daftar-training',	'Cara Daftar Training',	'Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.',	'<p>Cara&nbsp;Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.&nbsp;Cara&nbsp;Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.</p>\r\n\r\n<p>Cara&nbsp;Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.&nbsp;Cara&nbsp;Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.</p>\r\n\r\n<p>Cara&nbsp;Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.&nbsp;Cara&nbsp;Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.</p>\r\n\r\n<p>Cara&nbsp;Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.&nbsp;Cara&nbsp;Nullam accumsan lorem in dui. Ut varius tincidunt libero. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Fusce fermentum. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.</p>\r\n',	'ODc4So2gJTMJb07mqs3H3yLEyIxyi9L7.jpg',	'[\"training\",\"cara\",\"daftar\"]',	0,	'2019-03-08 07:41:17',	'2019-03-08 07:41:17',	1,	1),
(2,	'tentang-kami',	'Tentang Kami',	'Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.',	'<p>Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.</p>\r\n\r\n<p>Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.</p>\r\n\r\n<p>Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.</p>\r\n\r\n<p>Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.</p>\r\n',	'XCbP81Ff8nLQ3wgGmyDkyXJSXKTNqHHp.jpg',	'[\"tentang\",\"trainingku\"]',	0,	'2019-03-08 07:44:31',	'2019-03-17 05:27:45',	1,	1),
(3,	'syarat-dan-ketentuan',	'Syarat dan Ketentuan',	'Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus. Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.',	'<p>Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.</p>\r\n\r\n<p>Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.</p>\r\n\r\n<p>Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.</p>\r\n\r\n<p>Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.&nbsp;Maecenas nec odio et ante tincidunt tempus. Etiam feugiat lorem non metus. Sed augue ipsum, egestas nec, vestibulum et, malesuada adipiscing, dui. Curabitur turpis. Sed lectus.</p>\r\n',	'3r2_orrD697g0xaEbgLSb4uxtDnKtybm.jpg',	'[\"syarat\",\"ketentuan\",\"terms\",\"condition\",\"trainingku\"]',	0,	'2019-03-08 07:45:12',	'2019-03-17 05:27:59',	1,	1);

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'),
(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'),
(25,	'Transaksi',	NULL,	'transaksi',	'[\"index\",\"view\"]',	'index',	'fa fa-money',	NULL,	1,	1,	'2019-03-06 15:53:49',	'2019-03-06 15:53:49'),
(26,	'Publikasi',	NULL,	'',	'\"\"',	'',	'fa fa-rss-square',	NULL,	1,	1,	'2019-03-06 20:16:19',	'2019-03-06 20:16:19'),
(27,	'Artikel',	NULL,	'artikel',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-file-text-o',	26,	2,	1,	'2019-03-06 20:16:47',	'2019-03-06 20:16:47'),
(28,	'Slider',	NULL,	'slider',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-file-text-o',	26,	2,	1,	'2019-03-07 17:01:22',	'2019-03-07 17:01:22'),
(29,	'Banner',	NULL,	'banner',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-file-text-o',	26,	2,	1,	'2019-03-07 17:01:42',	'2019-03-07 17:01:42'),
(30,	'Halaman',	NULL,	'halaman',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-file-text-o',	26,	2,	1,	'2019-03-08 07:39:31',	'2019-03-08 07:39:31'),
(31,	'Peserta',	NULL,	'peserta',	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-users',	NULL,	1,	1,	'2019-03-12 12:58:46',	'2019-03-12 12:58:46'),
(32,	'Notifikasi SMS',	NULL,	'notifikasi-sms',	'[\"index\",\"view\",\"update\",\"delete\"]',	'index',	'fa fa-envelope',	NULL,	1,	1,	'2019-03-13 10:43:10',	'2019-03-13 10:44:01'),
(33,	'Permohonan Withdraw',	NULL,	'form-withdraw',	'[\"index\",\"create\",\"view\",\"update\",\"delete\",\"done\"]',	'index',	'fa fa-tags',	NULL,	1,	1,	'2019-03-22 10:54:15',	'2019-03-22 20:18:37'),
(34,	'Permohonan Afiliasi',	NULL,	'form-afiliasi',	'[\"index\",\"create\",\"view\",\"update\",\"delete\",\"done\"]',	'index',	'fa fa-tags',	NULL,	1,	1,	'2019-03-22 10:54:38',	'2019-03-22 20:18:42');

CREATE TABLE `midtrans_notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `peserta_id` int(11) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `status_code` varchar(255) NOT NULL,
  `status_message` varchar(255) NOT NULL,
  `gross_amount` varchar(255) NOT NULL,
  `payment_type` varchar(255) NOT NULL,
  `transaction_time` varchar(255) NOT NULL,
  `transaction_status` varchar(255) NOT NULL,
  `approval_code` varchar(255) NOT NULL,
  `signature_key` varchar(255) NOT NULL,
  `bank` varchar(255) NOT NULL,
  `va_number` varchar(255) NOT NULL,
  `payment_code` varchar(255) NOT NULL,
  `store` varchar(255) NOT NULL,
  `fraud_status` varchar(255) NOT NULL,
  `eci` varchar(255) NOT NULL,
  `masked_card` varchar(255) NOT NULL,
  `full_text` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `peserta_id` (`peserta_id`),
  CONSTRAINT `midtrans_notification_ibfk_1` FOREIGN KEY (`peserta_id`) REFERENCES `peserta` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `midtrans_notification` (`id`, `peserta_id`, `order_id`, `transaction_id`, `status_code`, `status_message`, `gross_amount`, `payment_type`, `transaction_time`, `transaction_status`, `approval_code`, `signature_key`, `bank`, `va_number`, `payment_code`, `store`, `fraud_status`, `eci`, `masked_card`, `full_text`, `created_at`, `updated_at`) VALUES
(1,	7,	'ORDER-6XB4NYT35S',	'1bf3ea9b-7998-4a0d-bfc9-23b6c42d177d',	'200',	'midtrans payment notification',	'1000000.00',	'bank_transfer',	'2019-03-22 21:01:56',	'settlement',	'',	'01b3a1af61636499d5c11351885f391be9c03f16f95ede550aa329f76fa529d3df2acfd77d1fd1ae0e2ffdf43e8316d0ecdf03e278f4e005889b7c74e5d5f6d6',	'bca',	'644197450909422',	'',	'',	'accept',	'',	'',	'\"{\\\"va_numbers\\\":[{\\\"va_number\\\":\\\"644197450909422\\\",\\\"bank\\\":\\\"bca\\\"}],\\\"transaction_time\\\":\\\"2019-03-22 21:01:56\\\",\\\"transaction_status\\\":\\\"settlement\\\",\\\"transaction_id\\\":\\\"1bf3ea9b-7998-4a0d-bfc9-23b6c42d177d\\\",\\\"status_message\\\":\\\"midtrans payment notification\\\",\\\"status_code\\\":\\\"200\\\",\\\"signature_key\\\":\\\"01b3a1af61636499d5c11351885f391be9c03f16f95ede550aa329f76fa529d3df2acfd77d1fd1ae0e2ffdf43e8316d0ecdf03e278f4e005889b7c74e5d5f6d6\\\",\\\"settlement_time\\\":\\\"2019-03-22 21:02:28\\\",\\\"payment_type\\\":\\\"bank_transfer\\\",\\\"payment_amounts\\\":[],\\\"order_id\\\":\\\"ORDER-6XB4NYT35S\\\",\\\"gross_amount\\\":\\\"1000000.00\\\",\\\"fraud_status\\\":\\\"accept\\\"}\"',	'2019-03-22 14:01:51',	'2019-03-22 14:02:29'),
(2,	4,	'ORDER-IOQZA06TC8',	'2db66d7c-6316-47be-91ed-8622b59b52cf',	'200',	'midtrans payment notification',	'1000000.00',	'bank_transfer',	'2019-03-23 06:51:57',	'settlement',	'',	'6e049a97a76ee037fbbd4ce6b30217592d424a518d457eb5bc93df22ee1989c44b34dd902a6302717a8b96f0fe44751bb24d2adde99084ecf903cf8d5238de8f',	'bca',	'644197450409394',	'',	'',	'accept',	'',	'',	'\"{\\\"va_numbers\\\":[{\\\"va_number\\\":\\\"644197450409394\\\",\\\"bank\\\":\\\"bca\\\"}],\\\"transaction_time\\\":\\\"2019-03-23 06:51:57\\\",\\\"transaction_status\\\":\\\"settlement\\\",\\\"transaction_id\\\":\\\"2db66d7c-6316-47be-91ed-8622b59b52cf\\\",\\\"status_message\\\":\\\"midtrans payment notification\\\",\\\"status_code\\\":\\\"200\\\",\\\"signature_key\\\":\\\"6e049a97a76ee037fbbd4ce6b30217592d424a518d457eb5bc93df22ee1989c44b34dd902a6302717a8b96f0fe44751bb24d2adde99084ecf903cf8d5238de8f\\\",\\\"settlement_time\\\":\\\"2019-03-23 06:52:19\\\",\\\"payment_type\\\":\\\"bank_transfer\\\",\\\"payment_amounts\\\":[],\\\"order_id\\\":\\\"ORDER-IOQZA06TC8\\\",\\\"gross_amount\\\":\\\"1000000.00\\\",\\\"fraud_status\\\":\\\"accept\\\"}\"',	'2019-03-22 23:51:52',	'2019-03-22 23:52:20'),
(3,	4,	'ORDER-XJA3YDBEQN',	'b09834a5-995d-46be-858f-4e73285ea717',	'200',	'midtrans payment notification',	'500000.00',	'bank_transfer',	'2019-03-23 07:10:42',	'settlement',	'',	'ff716e17f9bf48ca99b71f8f02c9cc2db262c0e2a2fd6d3189f9b7c4c191d2cf48fabbae3485b976160021ea9c279d2b79c0f485942a7fb2f388ada491b36f4c',	'bca',	'644197450693818',	'',	'',	'accept',	'',	'',	'\"{\\\"va_numbers\\\":[{\\\"va_number\\\":\\\"644197450693818\\\",\\\"bank\\\":\\\"bca\\\"}],\\\"transaction_time\\\":\\\"2019-03-23 07:10:42\\\",\\\"transaction_status\\\":\\\"settlement\\\",\\\"transaction_id\\\":\\\"b09834a5-995d-46be-858f-4e73285ea717\\\",\\\"status_message\\\":\\\"midtrans payment notification\\\",\\\"status_code\\\":\\\"200\\\",\\\"signature_key\\\":\\\"ff716e17f9bf48ca99b71f8f02c9cc2db262c0e2a2fd6d3189f9b7c4c191d2cf48fabbae3485b976160021ea9c279d2b79c0f485942a7fb2f388ada491b36f4c\\\",\\\"settlement_time\\\":\\\"2019-03-23 07:11:44\\\",\\\"payment_type\\\":\\\"bank_transfer\\\",\\\"payment_amounts\\\":[],\\\"order_id\\\":\\\"ORDER-XJA3YDBEQN\\\",\\\"gross_amount\\\":\\\"500000.00\\\",\\\"fraud_status\\\":\\\"accept\\\"}\"',	'2019-03-23 00:10:37',	'2019-03-23 00:11:45'),
(4,	4,	'ORDER-10RY79G3AV',	'3e278bdb-90e3-4a16-aadb-870d1c9b29e6',	'200',	'midtrans payment notification',	'350000.00',	'bank_transfer',	'2019-03-23 07:12:50',	'settlement',	'',	'7e8b862de6a56bb58a68485dcb9d371fa0a2e28cadd47de9850fd52842d061d8351680fee5cea26ff2542cb0a73615f4683b1f33a0ad2bad09d6b709c96c1280',	'bca',	'644197450068536',	'',	'',	'accept',	'',	'',	'\"{\\\"va_numbers\\\":[{\\\"va_number\\\":\\\"644197450068536\\\",\\\"bank\\\":\\\"bca\\\"}],\\\"transaction_time\\\":\\\"2019-03-23 07:12:50\\\",\\\"transaction_status\\\":\\\"settlement\\\",\\\"transaction_id\\\":\\\"3e278bdb-90e3-4a16-aadb-870d1c9b29e6\\\",\\\"status_message\\\":\\\"midtrans payment notification\\\",\\\"status_code\\\":\\\"200\\\",\\\"signature_key\\\":\\\"7e8b862de6a56bb58a68485dcb9d371fa0a2e28cadd47de9850fd52842d061d8351680fee5cea26ff2542cb0a73615f4683b1f33a0ad2bad09d6b709c96c1280\\\",\\\"settlement_time\\\":\\\"2019-03-23 07:13:17\\\",\\\"payment_type\\\":\\\"bank_transfer\\\",\\\"payment_amounts\\\":[],\\\"order_id\\\":\\\"ORDER-10RY79G3AV\\\",\\\"gross_amount\\\":\\\"350000.00\\\",\\\"fraud_status\\\":\\\"accept\\\"}\"',	'2019-03-23 00:12:36',	'2019-03-23 00:13:17'),
(5,	9,	'ORDER-JTLGV08N59',	'bbe42e58-9ddc-4009-b41b-effa37771b9f',	'200',	'midtrans payment notification',	'500000.00',	'bank_transfer',	'2019-03-25 22:54:33',	'settlement',	'',	'f4b74e85d5774e573f60822da55c7f6e5bd59447ea97e77e506042d71b43ea781ba8bba3b4a11b099f57a5939871460e9529631289963eaf7c4ebc7ae484368f',	'bca',	'644197450162106',	'',	'',	'accept',	'',	'',	'\"{\\\"va_numbers\\\":[{\\\"va_number\\\":\\\"644197450162106\\\",\\\"bank\\\":\\\"bca\\\"}],\\\"transaction_time\\\":\\\"2019-03-25 22:54:33\\\",\\\"transaction_status\\\":\\\"settlement\\\",\\\"transaction_id\\\":\\\"bbe42e58-9ddc-4009-b41b-effa37771b9f\\\",\\\"status_message\\\":\\\"midtrans payment notification\\\",\\\"status_code\\\":\\\"200\\\",\\\"signature_key\\\":\\\"f4b74e85d5774e573f60822da55c7f6e5bd59447ea97e77e506042d71b43ea781ba8bba3b4a11b099f57a5939871460e9529631289963eaf7c4ebc7ae484368f\\\",\\\"settlement_time\\\":\\\"2019-03-25 22:58:10\\\",\\\"payment_type\\\":\\\"bank_transfer\\\",\\\"payment_amounts\\\":[],\\\"order_id\\\":\\\"ORDER-JTLGV08N59\\\",\\\"gross_amount\\\":\\\"500000.00\\\",\\\"fraud_status\\\":\\\"accept\\\"}\"',	'2019-03-25 15:53:50',	'2019-03-25 15:58:12'),
(6,	9,	'ORDER-U8GSN9HALF',	'4cea0e28-f302-4ef4-b06a-a0c37d55d925',	'200',	'midtrans payment notification',	'100000.00',	'bank_transfer',	'2019-04-02 13:06:19',	'settlement',	'',	'dd7d972e51012d2f04b5cb503f96c1b493cc1d7a7fd310069398bc44ef8bd28ee11233913f22e94022cf26f27a3ef55439c1ff0ee67e929b2e567ef0d009497c',	'bca',	'644197450575468',	'',	'',	'accept',	'',	'',	'\"{\\\"va_numbers\\\":[{\\\"va_number\\\":\\\"644197450575468\\\",\\\"bank\\\":\\\"bca\\\"}],\\\"transaction_time\\\":\\\"2019-04-02 13:06:19\\\",\\\"transaction_status\\\":\\\"settlement\\\",\\\"transaction_id\\\":\\\"4cea0e28-f302-4ef4-b06a-a0c37d55d925\\\",\\\"status_message\\\":\\\"midtrans payment notification\\\",\\\"status_code\\\":\\\"200\\\",\\\"signature_key\\\":\\\"dd7d972e51012d2f04b5cb503f96c1b493cc1d7a7fd310069398bc44ef8bd28ee11233913f22e94022cf26f27a3ef55439c1ff0ee67e929b2e567ef0d009497c\\\",\\\"settlement_time\\\":\\\"2019-04-02 13:08:18\\\",\\\"payment_type\\\":\\\"bank_transfer\\\",\\\"payment_amounts\\\":[],\\\"order_id\\\":\\\"ORDER-U8GSN9HALF\\\",\\\"gross_amount\\\":\\\"100000.00\\\",\\\"fraud_status\\\":\\\"accept\\\"}\"',	'2019-04-02 06:05:52',	'2019-04-02 06:08:19');

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 `notifikasi_sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jenis_penerima` varchar(255) NOT NULL COMMENT 'admin/vendor/peserta',
  `foreign_key` int(11) NOT NULL,
  `telepon` varchar(255) NOT NULL,
  `konten` varchar(255) NOT NULL,
  `waktu_kirim` datetime NOT NULL,
  `status_kirim` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `notifikasi_sms` (`id`, `jenis_penerima`, `foreign_key`, `telepon`, `konten`, `waktu_kirim`, `status_kirim`, `created_at`, `updated_at`) VALUES
(1,	'peserta',	7,	'085736775369',	'TRAININGKU.ID%20-%20Anda%20baru%20saja%20topup%20sebesar%20Rp.%201.000.000.%20Segera%20lakukan%20pembayaran.%20Terima%20kasih.',	'2019-03-22 09:01:57',	1,	'2019-03-22 14:01:57',	'2019-03-22 14:02:01'),
(2,	'peserta',	7,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%20100.000%20telah%20disetujui.%20Mohon%20tunggu%20pembayaran%20maksimal%201x24%20jam.%20Terima%20kasih.',	'2019-03-22 09:09:40',	1,	'2019-03-22 14:09:40',	'2019-03-22 14:10:02'),
(3,	'peserta',	7,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%20100.000%20tidak%20disetujui%20dengan%20alasan%3A%20sehari%20maksimal%203x%20withdraw.%20Terima%20kasih.',	'2019-03-22 09:38:42',	1,	'2019-03-22 14:38:42',	'2019-03-22 14:39:02'),
(4,	'vendor',	1,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%200%20tidak%20disetujui%20dengan%20alasan%3A%20karena%20hanya%200%20rupiah.%20Terima%20kasih.',	'2019-03-22 10:08:36',	1,	'2019-03-22 15:08:36',	'2019-03-22 15:09:02'),
(5,	'peserta',	7,	'085736775369',	'TRAININGKU.ID%20-%20Pagi%20Fakhrudin.%20Besok%202019-03-30%20adalah%20jadwal%20training%20The%20Core%20of%20Human%20Resource.%20Terima%20kasih.',	'2019-03-29 08:00:00',	1,	'2019-03-22 23:19:50',	'2019-03-28 17:00:04'),
(6,	'peserta',	7,	'085736775369',	'TRAININGKU.ID%20-%20Pagi%20Fakhrudin.%20Besok%202019-03-30%20adalah%20jadwal%20training%20The%20Core%20of%20Human%20Resource.%20Terima%20kasih.',	'2019-03-29 08:00:00',	1,	'2019-03-22 23:26:59',	'2019-03-28 17:00:04'),
(7,	'peserta',	4,	'085736775369',	'TRAININGKU.ID%20-%20Anda%20baru%20saja%20topup%20sebesar%20Rp.%201.000.000.%20Segera%20lakukan%20pembayaran.%20Terima%20kasih.',	'2019-03-23 06:51:59',	1,	'2019-03-22 23:51:59',	'2019-03-22 23:52:01'),
(8,	'peserta',	4,	'085736775369',	'TRAININGKU.ID%20-%20Pagi%20Muhamad%20Arief%20Fakhrudin.%20Besok%202019-03-30%20adalah%20jadwal%20training%20The%20Core%20of%20Human%20Resource.%20Terima%20kasih.',	'2019-03-29 08:00:00',	1,	'2019-03-22 23:53:11',	'2019-03-28 17:00:04'),
(9,	'peserta',	4,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%20500.000%20tidak%20disetujui%20dengan%20alasan%3A%20nanti%20tanggal%2025%20baru%20bisa%20dicairkan.%20Terima%20kasih.',	'2019-03-23 06:58:33',	1,	'2019-03-22 23:58:33',	'2019-03-22 23:59:01'),
(10,	'peserta',	4,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%20300.000%20telah%20disetujui.%20Mohon%20tunggu%20pembayaran%20maksimal%201x24%20jam.%20Terima%20kasih.',	'2019-03-23 07:00:20',	1,	'2019-03-23 00:00:20',	'2019-03-23 00:01:01'),
(11,	'peserta',	4,	'085736775369',	'TRAININGKU.ID%20-%20Anda%20baru%20saja%20topup%20sebesar%20Rp.%20500.000.%20Segera%20lakukan%20pembayaran.%20Terima%20kasih.',	'2019-03-23 07:10:44',	1,	'2019-03-23 00:10:44',	'2019-03-23 00:11:02'),
(12,	'peserta',	4,	'085736775369',	'TRAININGKU.ID%20-%20Anda%20baru%20saja%20topup%20sebesar%20Rp.%20350.000.%20Segera%20lakukan%20pembayaran.%20Terima%20kasih.',	'2019-03-23 07:12:52',	1,	'2019-03-23 00:12:52',	'2019-03-23 00:13:01'),
(13,	'peserta',	4,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%20200.000%20telah%20disetujui.%20Mohon%20tunggu%20pembayaran%20maksimal%201x24%20jam.%20Terima%20kasih.',	'2019-03-23 07:14:48',	1,	'2019-03-23 00:14:48',	'2019-03-23 00:15:01'),
(14,	'peserta',	1,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20afiliasi%20Anda%20tidak%20disetujui%20dengan%20alasan%3A%20Kuota%20afiliate%20di%20kota%20Anda%20sudah%20maksimal.%20Terima%20kasih.',	'2019-03-23 07:56:29',	1,	'2019-03-23 00:56:30',	'2019-03-23 00:57:01'),
(15,	'peserta',	2,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20afiliasi%20Anda%20tidak%20disetujui%20dengan%20alasan%3A%20Anda%20belum%20kompeten.%20Terima%20kasih.',	'2019-03-23 07:59:04',	1,	'2019-03-23 00:59:04',	'2019-03-23 01:00:03'),
(16,	'peserta',	7,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20afiliasi%20Anda%20telah%20disetujui%2C%20kode%20afiliasi%20Anda%2029da6bcc7e.%20Terima%20kasih.',	'2019-03-23 08:04:08',	1,	'2019-03-23 01:04:08',	'2019-03-23 01:05:01'),
(17,	'peserta',	7,	'085736775369',	'TRAININGKU.ID%20-%20Pagi%20Fakhrudin.%20Besok%202019-03-30%20adalah%20jadwal%20training%20Query%20SQL%20Dasar%20MySQL.%20Terima%20kasih.',	'2019-03-29 08:00:00',	1,	'2019-03-23 04:40:52',	'2019-03-28 17:00:04'),
(18,	'peserta',	4,	'085736775369',	'TRAININGKU.ID%20-%20Pagi%20Muhamad%20Arief%20Fakhrudin.%20Besok%202019-03-30%20adalah%20jadwal%20training%20Query%20SQL%20Dasar%20MySQL.%20Terima%20kasih.',	'2019-03-29 08:00:00',	1,	'2019-03-23 04:42:15',	'2019-03-28 17:00:04'),
(19,	'vendor',	6,	'085736775369',	'TRAININGKU.ID%20-%20Saldo%20Anda%20bertambah%20Rp.%2010.000%20untuk%20pembayaran%20training%20Query%20SQL%20Dasar%20MySQL.%20Anda%20bisa%20mengajukan%20withdraw%20jika%20dibutuhkan.',	'2019-03-23 08:07:22',	1,	'2019-03-23 13:07:22',	'2019-03-23 13:08:02'),
(20,	'vendor',	6,	'085736775369',	'TRAININGKU.ID%20-%20Saldo%20Anda%20bertambah%20Rp.%2010.000%20untuk%20pembayaran%20training%20Query%20SQL%20Dasar%20MySQL.%20Anda%20bisa%20mengajukan%20withdraw%20jika%20dibutuhkan.',	'2019-03-24 05:34:38',	1,	'2019-03-23 22:34:38',	'2019-03-23 22:35:01'),
(21,	'vendor',	6,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%2020.000%20telah%20disetujui.%20Mohon%20tunggu%20pembayaran%20maksimal%201x24%20jam.%20Terima%20kasih.',	'2019-03-24 05:38:25',	1,	'2019-03-23 22:38:25',	'2019-03-23 22:39:02'),
(22,	'vendor',	6,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%205.000%20tidak%20disetujui%20dengan%20alasan%3A%20Belum%20bisa%2C%20karena%20kemarin%20baru%20saja%20withdraw.%20Terima%20kasih.',	'2019-03-24 06:05:22',	1,	'2019-03-23 23:05:22',	'2019-03-23 23:06:02'),
(23,	'peserta',	9,	'085736775369',	'TRAININGKU.ID%20-%20Anda%20baru%20saja%20topup%20sebesar%20Rp.%20500.000.%20Segera%20lakukan%20pembayaran.%20Terima%20kasih.',	'2019-03-25 10:54:34',	1,	'2019-03-25 15:54:34',	'2019-03-25 15:55:01'),
(24,	'peserta',	9,	'085736775369',	'TRAININGKU.ID%20-%20Pagi%20Arief%20Fakhrudin.%20Besok%202019-04-01%20adalah%20jadwal%20training%20Professional%20Software%20Development%20in%20NET.%20Terima%20kasih.',	'2019-03-25 08:00:00',	1,	'2019-03-25 16:00:00',	'2019-03-25 16:10:02'),
(25,	'peserta',	9,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%20100.000%20telah%20disetujui.%20Mohon%20tunggu%20pembayaran%20maksimal%201x24%20jam.%20Terima%20kasih.',	'2019-03-25 11:15:14',	1,	'2019-03-25 16:15:14',	'2019-03-25 16:16:01'),
(26,	'vendor',	7,	'085736775369',	'TRAININGKU.ID%20-%20Saldo%20Anda%20bertambah%20Rp.%2020.000%20untuk%20pembayaran%20training%20Professional%20Software%20Development%20in%20NET.%20Anda%20bisa%20mengajukan%20withdraw%20jika%20dibutuhkan.',	'2019-03-25 11:29:14',	1,	'2019-03-25 16:29:14',	'2019-03-25 16:30:02'),
(27,	'peserta',	9,	'085736775369',	'TRAININGKU.ID%20-%20Pagi%20Arief%20Fakhrudin.%20Besok%202019-04-09%20adalah%20jadwal%20training%20Pelatihan%20Senjata%20API.%20Terima%20kasih.',	'2019-04-08 08:00:00',	0,	'2019-04-02 06:04:36',	'2019-04-02 06:04:36'),
(28,	'peserta',	9,	'085736775369',	'TRAININGKU.ID%20-%20Anda%20baru%20saja%20topup%20sebesar%20Rp.%20100.000.%20Segera%20lakukan%20pembayaran.%20Terima%20kasih.',	'2019-04-02 01:06:21',	1,	'2019-04-02 06:06:21',	'2019-04-02 06:07:02'),
(29,	'peserta',	9,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20afiliasi%20Anda%20telah%20disetujui%2C%20kode%20afiliasi%20Anda%2098c9d158c9.%20Terima%20kasih.',	'2019-04-02 01:13:12',	1,	'2019-04-02 06:13:12',	'2019-04-02 06:14:02'),
(30,	'peserta',	9,	'085736775369',	'TRAININGKU.ID%20-%20Permohonan%20withdraw%20Anda%20sebesar%20Rp.%20200.000%20telah%20disetujui.%20Mohon%20tunggu%20pembayaran%20maksimal%201x24%20jam.%20Terima%20kasih.',	'2019-04-02 01:19:07',	1,	'2019-04-02 06:19:07',	'2019-04-02 06:20:02'),
(31,	'vendor',	7,	'085736775369',	'TRAININGKU.ID%20-%20Saldo%20Anda%20bertambah%20Rp.%2010.000%20untuk%20pembayaran%20training%20Pelatihan%20Senjata%20API.%20Anda%20bisa%20mengajukan%20withdraw%20jika%20dibutuhkan.',	'2019-04-02 01:24:35',	1,	'2019-04-02 06:24:35',	'2019-04-02 06:25:03'),
(32,	'vendor',	8,	'089606696705',	'Test',	'2019-04-02 06:35:21',	0,	'2019-04-02 06:35:21',	'2019-04-02 06:35:21');

CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `peserta_id` int(11) NOT NULL,
  `kode_order` varchar(255) NOT NULL,
  `kode_transaksi` varchar(255) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `jenis` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `peserta_id` (`peserta_id`),
  CONSTRAINT `order_ibfk_1` FOREIGN KEY (`peserta_id`) REFERENCES `peserta` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `order` (`id`, `peserta_id`, `kode_order`, `kode_transaksi`, `jumlah`, `jenis`, `status`, `created_at`, `updated_at`) VALUES
(1,	1,	'ORDER-PV63JQN7Y4',	'',	5000,	'',	'pending',	'2019-03-12 07:07:16',	'2019-03-12 07:07:16');

CREATE TABLE `peserta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `password` text,
  `nama` varchar(255) DEFAULT NULL,
  `alamat` text,
  `telepon` varchar(255) DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `saldo` int(11) DEFAULT NULL,
  `afiliasi` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `peserta` (`id`, `email`, `password`, `nama`, `alamat`, `telepon`, `foto`, `saldo`, `afiliasi`, `status`, `created_at`, `updated_at`) VALUES
(1,	'arief@gmail.com',	'$2y$13$w7P9.Cbmqq5RuIrsUGxQpOvt8R6hhoYGbKq39MjttkhcrQ97SolhS',	'Arief',	'adfs',	'085736775369',	'boK1aTDax0kVYBZBCvBdB7IC2tsZ6SKv.jpg',	0,	'2a2e5b5718',	0,	'2019-02-09 23:24:33',	'2019-03-12 05:22:50'),
(2,	'dewi@gmail.com',	'$2y$13$2n7JNgGVikyJBndX3q51nOonEwfV3RYIluLxRayeOyhRCOImJiuuu',	'Dewi Wijayanti',	'',	'085736775369',	'',	0,	'',	0,	'2019-03-06 16:02:05',	'2019-03-06 16:10:35'),
(3,	'yasmin@gmail.com',	'$2y$13$NYsZsQNRLeCY6cQ1BlpGOespFKSOIJL80bIpvqkQ6jw1ddYxkfOPa',	'Yasmin',	'Perum Jade Ville',	'085736775369',	'EbVIMI50UM9F3nGb5TKQiok6nZ6sjrW_.jpeg',	0,	'',	0,	'2019-03-12 15:34:05',	'2019-03-12 15:34:47'),
(4,	'muhammadarieffakhrudin@gmail.com',	'$2y$13$z..z32ibRdxuBwRoljvhxus7XL23QyCI6rdC8uFLQ9LCQTlAQElNa',	'Muhamad Arief Fakhrudin',	'',	'085736775369',	'',	1275000,	'0a0cf3e87e',	1,	'2019-03-13 12:32:46',	'2019-03-23 04:42:15'),
(7,	'ahmad@gmail.com',	'$2y$13$hf93OmbJ3yN5vy1.gAsZTe9oHJDHmCL92bWGv6ViOU.eKig6TmogK',	'Ahmad',	'Jln. Soekarno Hatta 34 Surabaya',	'085736775369',	'8FqlvvPZpGUmlC5oZA5l3wQBwDhBywB4.jpg',	825000,	'29da6bcc7e',	1,	'2019-03-19 15:28:33',	'2019-03-23 04:40:52'),
(8,	'syahdan.if16@student.unusa.ac.id',	'$2y$13$m4oWaJIg6kJ3tmhpKmVw0OYvLOZpZaOk0mpAKu1m4J06oNh6/iEpa',	'Syahdan',	'Jln. Ketintang 34 Surabaya',	'08998937095',	'gI0WXYFxc-wmmpV3gtAXheQBrBTVPa0n.jpg',	0,	'96667905df',	1,	'2019-03-20 04:02:22',	'2019-03-20 04:25:45'),
(9,	'fakhrvdin@gmail.com',	'$2y$13$9jL5QvfJJwSzGy4.NhYteesm2d2gNQ53nhgHBkJmAAYDOIoVgoZ8i',	'Arief Fakhrudin',	'Jln. Kejawan Putih Tambak Gang 3 No 29 Surabaya',	'085736775369',	'CKm_gKfqgITtYpnv5WRqf19HvZ30EAPt.png',	214000,	'98c9d158c9',	1,	'2019-03-25 15:49:23',	'2019-04-02 06:19:07');

CREATE TABLE `peserta_training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `peserta_id` int(11) NOT NULL,
  `training_id` int(11) NOT NULL,
  `sertifikat` varchar(255) NOT NULL,
  `catatan` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '1=Lulus, 0=Tidak Lulus',
  `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;

INSERT INTO `peserta_training` (`id`, `peserta_id`, `training_id`, `sertifikat`, `catatan`, `status`, `created_at`, `updated_at`) VALUES
(3,	7,	8,	'',	'',	0,	'2019-03-22 23:26:59',	'2019-03-22 23:26:59'),
(4,	4,	8,	'',	'',	0,	'2019-03-22 23:53:11',	'2019-03-22 23:53:11'),
(5,	7,	9,	'',	'',	0,	'2019-03-23 04:40:52',	'2019-03-23 04:40:52'),
(6,	4,	9,	'',	'',	0,	'2019-03-23 04:42:15',	'2019-03-23 04:42:15'),
(7,	9,	13,	'Fia2ItlT2c4m3TL0L8hKSC8GjlYfPODV.pdf',	'Peserta mengikuti semua kegiatan training dengan baik',	1,	'2019-03-25 16:00:00',	'2019-03-25 16:05:18'),
(8,	9,	14,	'',	'',	0,	'2019-04-02 06:04:36',	'2019-04-02 06:04:36');

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 `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'),
(40,	1,	19,	'',	'',	7,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-01-12 14:22:23',	'2019-04-02 06:22:18'),
(43,	1,	24,	'',	'',	9,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-02-12 20:31:37',	'2019-04-02 06:22:18'),
(44,	1,	25,	'',	'',	10,	'[\"index\",\"view\"]',	'2019-03-06 15:53:59',	'2019-04-02 06:22:18'),
(45,	1,	26,	'',	'',	12,	'\"\"',	'2019-03-06 20:16:57',	'2019-04-02 06:22:18'),
(46,	1,	27,	'',	'',	13,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-03-06 20:17:02',	'2019-04-02 06:22:18'),
(47,	1,	28,	'',	'',	14,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-03-07 17:01:51',	'2019-04-02 06:22:18'),
(48,	1,	29,	'',	'',	15,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-03-07 17:01:55',	'2019-04-02 06:22:18'),
(49,	1,	30,	'',	'',	16,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-03-08 07:39:41',	'2019-04-02 06:22:18'),
(50,	1,	31,	'',	'',	8,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-03-12 12:58:59',	'2019-04-02 06:22:18'),
(51,	1,	32,	'',	'',	11,	'[\"index\",\"view\",\"update\",\"delete\"]',	'2019-03-13 10:43:22',	'2019-04-02 06:22:18'),
(52,	1,	33,	'',	'',	17,	'[\"index\",\"create\",\"view\",\"update\",\"delete\",\"done\"]',	'2019-03-22 10:54:51',	'2019-04-02 06:22:18'),
(53,	1,	34,	'',	'',	18,	'[\"index\",\"create\",\"view\",\"update\",\"delete\",\"done\"]',	'2019-03-22 10:54:56',	'2019-04-02 06:22:18'),
(54,	1,	22,	'',	'',	19,	'[\"index\",\"create\",\"view\",\"update\",\"delete\"]',	'2019-04-02 06:23:08',	'2019-04-02 06:23:08');

CREATE TABLE `setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deskripsi` text COLLATE utf8_unicode_ci,
  `nilai` text COLLATE utf8_unicode_ci,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `setting` (`id`, `key`, `nama`, `deskripsi`, `nilai`, `status`, `created_at`, `updated_at`) VALUES
(1,	'komisi-training',	'Komisi training',	'Persentase default komisi masing-masing training. Persentase ini bisa diubah oleh vendor di masing-masing training sesuai keinginan vendor. Nilai dalam persen.',	'5',	1,	'2019-03-23 09:52:12',	'2019-03-23 09:54:30'),
(2,	'bonus-afiliasi',	'Bonus afiliasi',	'Jumlah default bonus afiliasi yang didapatkan oleh afiliate dari setiap training yang daftar atas rekomendasinya. Nilai dalam rupiah.',	'10000',	1,	'2019-03-23 09:53:50',	'2019-03-23 09:53:50'),
(3,	'nomor-whatsapp',	'Nomor whatsapp',	'Nomor whatsapp yang ditampilkan di footer halaman public',	'085777666333',	1,	'2019-03-23 09:55:49',	'2019-03-23 09:55:49'),
(4,	'email-cs',	'Email customer service',	'Email customer service yang diletakkan di footer web public',	'cs@trainingku.id',	1,	'2019-03-23 09:56:32',	'2019-03-23 09:56:32');

CREATE TABLE `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gambar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `slider` (`id`, `judul`, `gambar`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1,	'Hasil Training Memuaskan',	'EAy6YzwkpJ8e0u_6Tw0dulZBta8WTh0U.jpg',	'2019-03-07 17:04:08',	'2019-03-15 08:32:49',	1,	1),
(2,	'Foto Peserta Training Terbaru',	'EuVS3ufRhxbxAIzAEzmr3waJe5NV0xhz.jpg',	'2019-03-11 13:35:20',	'2019-03-15 08:32:35',	1,	1),
(3,	'Training Paket PHP & MySQL',	'Fg_zbGhZnaUdbLMGyKy0RmWeAZCrCKSg.jpg',	'2019-03-15 08:31:03',	'2019-03-15 08:32:10',	1,	1);

CREATE TABLE `trainer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) NOT NULL,
  `telepon` varchar(255) NOT NULL,
  `jabatan` varchar(255) NOT NULL,
  `biografi` text NOT NULL,
  `training_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `training_id` (`training_id`),
  CONSTRAINT `trainer_ibfk_1` FOREIGN KEY (`training_id`) REFERENCES `training` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `trainer` (`id`, `nama`, `telepon`, `jabatan`, `biografi`, `training_id`, `created_at`, `updated_at`) VALUES
(1,	'Fahd Pahdepie',	'02348453443',	'',	'Aenean tellus metus, bibendum sed, posuere ac, mattis non, nunc. Vivamus euismod mauris. Curabitur vestibulum aliquam leo. Fusce fermentum. Pellentesque commodo eros a enim.',	6,	'2019-03-18 05:11:38',	'2019-03-18 05:11:38'),
(2,	'Rizal Pandawa',	'02348453443',	'',	'Vestibulum dapibus nunc ac augue. Nullam tincidunt adipiscing enim. Duis leo. Sed mollis, eros et ultrices tempus, mauris ipsum aliquam libero, non adipiscing dolor urna a orci. Donec elit libero, sodales nec, volutpat a, suscipit non, turpis.',	6,	'2019-03-18 05:11:48',	'2019-03-18 05:11:48'),
(3,	'Dewi Wijayanti',	'032482',	'',	'Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.',	9,	'2019-03-23 04:37:20',	'2019-03-23 04:37:20'),
(4,	'Sinta',	'02348327',	'',	'Nunc nec neque. Sed in libero ut nibh placerat accumsan. Aenean posuere, tortor sed cursus feugiat, nunc augue blandit nunc, eu sollicitudin urna dolor sagittis lacus. Vivamus consectetuer hendrerit lacus. Cras non dolor.',	10,	'2019-03-25 08:20:59',	'2019-03-25 08:20:59'),
(5,	'Budi Utama',	'03247238',	'',	'Mauris turpis nunc, blandit et, volutpat molestie, porta ut, ligula. Aenean tellus metus, bibendum sed, posuere ac, mattis non, nunc. Aenean posuere, tortor sed cursus feugiat, nunc augue blandit nunc, eu sollicitudin urna dolor sagittis lacus. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nulla neque dolor, sagittis eget, iaculis quis, molestie non, velit.',	13,	'2019-03-25 09:12:36',	'2019-03-25 09:12:36'),
(6,	'Jundi Harsya',	'023472384',	'',	'Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.',	14,	'2019-04-02 04:31:03',	'2019-04-02 04:31:03');

CREATE TABLE `training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) DEFAULT NULL,
  `poster` varchar(255) DEFAULT NULL,
  `deskripsi` text,
  `konten` text,
  `peserta_minimum` int(11) DEFAULT NULL,
  `peserta_maksimum` int(11) DEFAULT NULL,
  `provinsi_id` int(11) DEFAULT NULL,
  `kota_id` int(11) DEFAULT NULL,
  `alamat` text,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `tanggal_mulai` date DEFAULT NULL,
  `tanggal_selesai` date DEFAULT NULL,
  `tanggal_daftar_maksimum` date DEFAULT NULL,
  `biaya` int(11) DEFAULT NULL,
  `komisi` int(11) DEFAULT NULL,
  `vendor_id` int(11) DEFAULT NULL,
  `kategori_id` int(11) DEFAULT NULL,
  `training_status_id` int(11) DEFAULT 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`, `tanggal_daftar_maksimum`, `biaya`, `komisi`, `vendor_id`, `kategori_id`, `training_status_id`, `created_at`, `updated_at`) VALUES
(2,	'CCNA School Level 3',	'0yQnT4Y1WSfT3WDTg-7_crSFuNEY4Bfo.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-03-15',	'2019-03-15',	'2019-03-12',	50000,	0,	1,	3,	2,	'2019-02-12 23:32:31',	'2019-03-17 04:21:48'),
(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-03-15',	'2019-03-15',	'2019-03-12',	90000,	0,	1,	19,	2,	'2019-02-13 11:01:00',	'2019-03-17 04:21:48'),
(4,	'Pelatihan OS Elementary Juno',	'4ckuYi5kV8pK5ci5p_klSLhodLKf9vjP.jpg',	'Vestibulum fringilla pede sit amet augue. Morbi nec metus. Vestibulum facilisis, purus nec pulvinar iaculis, ligula mi congue nunc, vitae euismod ligula urna in dolor. Pellentesque auctor neque nec urna. Aenean vulputate eleifend tellus.',	'<p>Vestibulum fringilla pede sit amet augue. Morbi nec metus. Vestibulum facilisis, purus nec pulvinar iaculis, ligula mi congue nunc, vitae euismod ligula urna in dolor. Pellentesque auctor neque nec urna. Aenean vulputate eleifend tellus.</p>\r\n\r\n<p>Vestibulum fringilla pede sit amet augue. Morbi nec metus. Vestibulum facilisis, purus nec pulvinar iaculis, ligula mi congue nunc, vitae euismod ligula urna in dolor. Pellentesque auctor neque nec urna. Aenean vulputate eleifend tellus.</p>\r\n\r\n<p>Vestibulum fringilla pede sit amet augue. Morbi nec metus. Vestibulum facilisis, purus nec pulvinar iaculis, ligula mi congue nunc, vitae euismod ligula urna in dolor. Pellentesque auctor neque nec urna. Aenean vulputate eleifend tellus.</p>\r\n',	5,	100,	17,	172,	'Vestibulum fringilla pede sit amet augue. Morbi nec metus. Vestibulum facilisis, purus nec pulvinar iaculis, ligula mi congue nunc, vitae euismod ligula urna in dolor. Pellentesque auctor neque nec urna. Aenean vulputate eleifend tellus.',	'-6.806333851354288',	'111.52686393750002',	'2019-03-15',	'2019-03-15',	'2019-03-12',	25000,	0,	1,	20,	2,	'2019-03-14 07:29:38',	'2019-03-17 04:21:48'),
(5,	'Audisi MC Wisuda UNAS',	'dGnr3QCfiRNsTe4UhtKYYlyPBaqnC1MX.jpg',	'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetu',	'<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32.</p>\r\n',	5,	100,	9,	171,	'Jln. Puputan Margarana 34 Karawang',	'-6.762696268216734',	'108.09912956250002',	'2019-03-24',	'2019-03-24',	'2019-03-21',	25000,	0,	1,	12,	2,	'2019-03-17 04:40:05',	'2019-03-17 05:42:02'),
(6,	'Pelatihan Pemadam Kebakaran',	'I0MdjWOEtSiZ5ww3PDKPw8Or1aHRDOCX.jpg',	'Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.',	'<p>Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.</p>\r\n\r\n<p>Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.&nbsp;Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.</p>\r\n\r\n<p>Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.</p>\r\n\r\n<p>Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.</p>\r\n\r\n<p>Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.</p>\r\n\r\n<p>Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.&nbsp;Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.</p>\r\n',	5,	100,	11,	247,	'Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce id purus. Donec interdum, metus et hendrerit aliquet, dolor diam sagittis ligula, eget egestas libero turpis vel mi. Curabitur turpis. Quisque malesuada placerat nisl. Praesent nec nisl a purus blandit viverra.',	'-7.808853170781452',	'111.83448112500002',	'2019-03-25',	'2019-03-25',	'2019-03-22',	35000,	0,	1,	13,	2,	'2019-03-18 05:08:39',	'2019-03-19 15:42:45'),
(7,	'Pelatihan SDM Andal',	'uucEl165R0E55r-a4juQv5uR_DtumOBq.jpg',	'Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.',	'<p>Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.</p>\r\n\r\n<p>Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.&nbsp;Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.</p>\r\n\r\n<p>Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.&nbsp;Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.</p>\r\n\r\n<p>Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.&nbsp;Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.</p>\r\n\r\n<p>Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.</p>\r\n\r\n<p>Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.&nbsp;Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.&nbsp;Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.</p>\r\n\r\n<p>Integer tincidunt. Phasellus leo dolor, tempus non, auctor et, hendrerit quis, nisi. In dui magna, posuere eget, vestibulum et, tempor auctor, justo. Etiam iaculis nunc ac metus. Donec mi odio, faucibus at, scelerisque quis, convallis in, nisi.</p>\r\n',	5,	100,	18,	355,	'Jln. Panjang Sewu 43 Biltar Jawa Timur',	'-7.7829633852842',	'112.3665732322258',	'2019-03-26',	'2019-03-26',	'2019-03-23',	40000,	0,	5,	12,	2,	'2019-03-19 15:41:20',	'2019-03-19 15:42:57'),
(8,	'The Core of Human Resource',	'Uv4Bg9Bx_4RwNRyrgrq5Al4bM-YhWKFp.jpg',	'Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.',	'<p>Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.</p>\r\n\r\n<p>Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.&nbsp;Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.&nbsp;Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.</p>\r\n\r\n<p>Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.&nbsp;Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.&nbsp;Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.</p>\r\n\r\n<p>Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.</p>\r\n\r\n<p>Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.</p>\r\n\r\n<p>Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.&nbsp;Nunc nec neque. Praesent ut ligula non mi varius sagittis. Nullam tincidunt adipiscing enim. Pellentesque libero tortor, tincidunt et, tincidunt eget, semper nec, quam. Etiam vitae tortor.</p>\r\n',	5,	100,	9,	149,	'Jln. Semenanjung Barata 34 Kota Indramayu Jawa Barat',	'-6.719054743606168',	'106.73682487500002',	'2019-03-30',	'2019-03-30',	'2019-03-26',	35000,	0,	5,	10,	2,	'2019-03-19 15:47:52',	'2019-03-19 15:48:06'),
(9,	'Query SQL Dasar MySQL',	'adCWNN66TfZXExE5bjf24H8hwS8rjZaj.jpg',	'Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.',	'<p>Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.</p>\r\n\r\n<p>Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.&nbsp;Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.</p>\r\n\r\n<p>Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.</p>\r\n\r\n<p>Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.&nbsp;Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.&nbsp;Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.</p>\r\n\r\n<p>Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.&nbsp;Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.&nbsp;Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.</p>\r\n\r\n<p>Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.&nbsp;Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.</p>\r\n\r\n<p>Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.</p>\r\n\r\n<p>Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.&nbsp;Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.</p>\r\n',	5,	100,	3,	456,	'Pellentesque commodo eros a enim. Vestibulum dapibus nunc ac augue. Vestibulum eu odio. Etiam vitae tortor. Fusce vulputate eleifend sapien.',	'-6.457124223879785',	'107.87940300000002',	'2019-03-30',	'2019-03-30',	'2019-03-27',	40000,	5,	6,	19,	2,	'2019-03-23 04:37:04',	'2019-03-23 04:40:11'),
(10,	'Mikrotik MTCNA & MTCNE',	'PUmC2NADYZtVtEqVgeeJqDpcoaQjoD0n.jpg',	'Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.',	'<p>Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.</p>\r\n\r\n<p>Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.</p>\r\n\r\n<p>Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.</p>\r\n\r\n<p>Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.</p>\r\n\r\n<p>Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.</p>\r\n\r\n<p>Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.</p>\r\n\r\n<p>Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.&nbsp;Nullam quis ante. Nullam tincidunt adipiscing enim. Phasellus accumsan cursus velit. Praesent adipiscing. Quisque id mi.</p>\r\n',	5,	100,	11,	444,	'Jln. Soekarno Hatta 34 Surabaya',	'-8.026484950779292',	'113.63623893750002',	'2019-04-01',	'2019-04-01',	'2019-03-29',	20000,	5,	6,	6,	2,	'2019-03-25 08:20:15',	'2019-03-25 08:33:36'),
(11,	'Marketing Courses',	'jQjKl1BNMLgP15WH19QrDMM4YNvWve4g.jpg',	'Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.',	'<p>Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.</p>\r\n\r\n<p>Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.</p>\r\n\r\n<p>Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.</p>\r\n\r\n<p>Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.</p>\r\n\r\n<p>Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.&nbsp;Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.</p>\r\n',	5,	100,	11,	409,	'Duis arcu tortor, suscipit eget, imperdiet nec, imperdiet iaculis, ipsum. Ut id nisl quis enim dignissim sagittis. Vestibulum dapibus nunc ac augue. Vivamus euismod mauris. Quisque libero metus, condimentum nec, tempor a, commodo mollis, magna.',	'-8.026484950779292',	'113.28467643750002',	'2019-04-01',	'2019-04-01',	'2019-03-29',	50000,	5,	6,	8,	2,	'2019-03-25 08:22:29',	'2019-03-25 08:33:27'),
(12,	'From Strategic Planning to Execution',	'wFSObB2Aatc4qXaZL1SwoYdY417F-0O5.jpg',	'Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.',	'<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n\r\n<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.&nbsp;Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n\r\n<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.&nbsp;Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n\r\n<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n\r\n<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n\r\n<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n\r\n<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n\r\n<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n\r\n<p>Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.&nbsp;Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.&nbsp;Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.</p>\r\n',	5,	100,	10,	209,	'Etiam sollicitudin, ipsum eu pulvinar rutrum, tellus ipsum laoreet sapien, quis venenatis ante odio sit amet eros. Aenean commodo ligula eget dolor. Vestibulum eu odio. Praesent metus tellus, elementum eu, semper a, adipiscing nec, purus. Praesent porttitor, nulla vitae posuere iaculis, arcu nisl dignissim dolor, a pretium mi sem ut ipsum.',	'-7.547545583838686',	'110.00410568063512',	'2019-04-11',	'2019-04-11',	'2019-04-06',	40000,	5,	6,	7,	2,	'2019-03-25 08:28:54',	'2019-03-25 08:33:19'),
(13,	'Professional Software Development in NET',	'Uky86u65UjBWYzJlvouilMy-FlTkuTna.jpg',	'Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.',	'<p>Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.&nbsp;Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.</p>\r\n\r\n<p>Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.&nbsp;Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.&nbsp;Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.&nbsp;Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.</p>\r\n\r\n<p>Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.</p>\r\n',	5,	100,	11,	133,	'Praesent nec nisl a purus blandit viverra. Praesent vestibulum dapibus nibh. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, quis gravida magna mi a libero. In auctor lobortis lacus. Aliquam eu nunc.',	'-7.547545583838686',	'112.05420768750002',	'2019-04-01',	'2019-04-01',	'2019-03-29',	48000,	5,	7,	16,	5,	'2019-03-25 09:09:01',	'2019-03-28 01:57:10'),
(14,	'Pelatihan Senjata API',	'hmowv0TQG5ntRVXArG3qzBIcSQJn6SYF.jpg',	'Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.',	'<p>Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.</p>\r\n\r\n<p>Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.&nbsp;Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.</p>\r\n\r\n<p>Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.&nbsp;Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.</p>\r\n\r\n<p>Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.&nbsp;Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.</p>\r\n\r\n<p>Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.&nbsp;Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.&nbsp;Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.</p>\r\n',	5,	100,	9,	171,	'Maecenas egestas arcu quis ligula mattis placerat. Vestibulum fringilla pede sit amet augue. Suspendisse enim turpis, dictum sed, iaculis a, condimentum nec, nisi. Nullam tincidunt adipiscing enim. Praesent adipiscing.',	'-6.1253551016703796',	'111.14106502556841',	'2019-04-09',	'2019-04-09',	'2019-04-06',	38000,	5,	7,	17,	2,	'2019-04-02 04:30:30',	'2019-04-02 04:34:18');

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',	'badge-default',	'2019-02-01 11:00:38',	'2019-02-01 11:00:38',	1,	1),
(2,	'Publish',	'badge-success',	'2019-02-01 11:00:54',	'2019-02-01 11:00:54',	1,	1),
(3,	'Berlangsung',	'badge-warning',	'2019-02-01 11:01:24',	'2019-02-01 11:01:24',	1,	1),
(4,	'Gagal',	'badge-danger',	'2019-02-01 11:01:46',	'2019-02-01 11:01:46',	1,	1),
(5,	'Sukses',	'badge-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) DEFAULT NULL COMMENT 'peserta / vendor',
  `debet` int(11) DEFAULT '0' COMMENT 'id peserta / vendor',
  `kredit` int(11) DEFAULT '0',
  `keterangan` text,
  `foreign_key` int(11) DEFAULT NULL,
  `training_id` int(11) DEFAULT NULL COMMENT 'jika berhubungan dengan training',
  `user_id` int(11) DEFAULT NULL COMMENT 'id admin yang melakukan withdraw',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `training_id` (`training_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `transaksi_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `transaksi_ibfk_1` FOREIGN KEY (`training_id`) REFERENCES `training` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `transaksi` (`id`, `jenis`, `debet`, `kredit`, `keterangan`, `foreign_key`, `training_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1,	'peserta',	1000000,	0,	'topup saldo peserta',	7,	NULL,	NULL,	'2019-03-22 14:02:29',	'2019-03-22 14:02:29'),
(3,	'peserta',	0,	100000,	'withdraw saldo peserta',	7,	NULL,	1,	'2019-03-22 14:09:40',	'2019-03-22 14:09:40'),
(5,	'peserta',	0,	35000,	'join training: The Core of Human Resource',	7,	8,	NULL,	'2019-03-22 23:26:59',	'2019-03-22 23:26:59'),
(6,	'peserta',	1000000,	0,	'topup saldo peserta',	4,	NULL,	NULL,	'2019-03-22 23:52:20',	'2019-03-22 23:52:20'),
(7,	'peserta',	0,	35000,	'join training: The Core of Human Resource',	4,	8,	NULL,	'2019-03-22 23:53:11',	'2019-03-22 23:53:11'),
(8,	'peserta',	0,	300000,	'withdraw saldo peserta',	4,	NULL,	1,	'2019-03-23 00:00:20',	'2019-03-23 00:00:20'),
(9,	'peserta',	500000,	0,	'topup saldo peserta',	4,	NULL,	NULL,	'2019-03-23 00:11:45',	'2019-03-23 00:11:45'),
(10,	'peserta',	350000,	0,	'topup saldo peserta',	4,	NULL,	NULL,	'2019-03-23 00:13:17',	'2019-03-23 00:13:17'),
(11,	'peserta',	0,	200000,	'withdraw saldo peserta',	4,	NULL,	1,	'2019-03-23 00:14:48',	'2019-03-23 00:14:48'),
(12,	'peserta',	0,	40000,	'join training: Query SQL Dasar MySQL',	7,	9,	NULL,	'2019-03-23 04:40:52',	'2019-03-23 04:40:52'),
(13,	'peserta',	0,	40000,	'join training: Query SQL Dasar MySQL',	4,	9,	NULL,	'2019-03-23 04:42:15',	'2019-03-23 04:42:15'),
(15,	'vendor',	15000,	0,	'pembayaran 1',	6,	9,	1,	'2019-03-23 12:50:16',	'2019-03-23 12:50:16'),
(16,	'vendor',	10000,	0,	'pembayaran 2',	6,	9,	1,	'2019-03-23 13:07:22',	'2019-03-23 13:07:22'),
(17,	'vendor',	10000,	0,	'pembayaran 3',	6,	9,	1,	'2019-03-23 22:34:38',	'2019-03-23 22:34:38'),
(18,	'vendor',	0,	20000,	'withdraw',	6,	NULL,	1,	'2019-03-23 22:38:25',	'2019-03-23 22:38:25'),
(19,	'peserta',	500000,	0,	'topup',	9,	NULL,	NULL,	'2019-03-25 15:58:12',	'2019-03-25 15:58:12'),
(20,	'peserta',	0,	48000,	'join training: Professional Software Development in NET',	9,	13,	NULL,	'2019-03-25 16:00:00',	'2019-03-25 16:00:00'),
(21,	'peserta',	0,	100000,	'withdraw',	9,	NULL,	1,	'2019-03-25 16:15:14',	'2019-03-25 16:15:14'),
(22,	'vendor',	20000,	0,	'pembayaran 1',	7,	13,	1,	'2019-03-25 16:29:14',	'2019-03-25 16:29:14'),
(23,	'peserta',	0,	38000,	'join training: Pelatihan Senjata API',	9,	14,	NULL,	'2019-04-02 06:04:36',	'2019-04-02 06:04:36'),
(24,	'peserta',	100000,	0,	'topup',	9,	NULL,	NULL,	'2019-04-02 06:08:19',	'2019-04-02 06:08:19'),
(25,	'peserta',	0,	200000,	'withdraw',	9,	NULL,	1,	'2019-04-02 06:19:07',	'2019-04-02 06:19:07'),
(26,	'vendor',	10000,	0,	'pembayaran 1',	7,	14,	1,	'2019-04-02 06:24:35',	'2019-04-02 06:24:35');

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gender` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `telepon` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `jabatan` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `foto` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `foto_small` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `password_reset_token` (`password_reset_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `user` (`id`, `role_id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `nip`, `nama`, `email`, `gender`, `telepon`, `jabatan`, `foto`, `foto_small`, `status`, `created_at`, `updated_at`) VALUES
(1,	1,	'admin',	'',	'$2y$13$qaQC4pI3HA0js6cSLeprEO57EWDh20rRBWBpkC/nUBH4BSKCa7OJS',	NULL,	'',	'Arief Fakhrudin',	'admin@indotraining.co.id',	'1',	'',	'',	'large-2IJ41UYMtd6J4BjqPoPy2L7adz-EWJmN.jpg',	'small-2IJ41UYMtd6J4BjqPoPy2L7adz-EWJmN.jpg',	10,	'2018-12-18',	'2019-01-11'),
(2,	2,	'dewi',	'',	'$2y$13$WkWBHiHMmoykU3JqsJXvaOV1nk3rk6yD2tGYOhYfanAtkUGKcl3xG',	NULL,	'PTS343',	'Dewi Wijayanti',	'dewiwijayanti@gmail.com',	'2',	'0238923782',	'',	'',	'small-p_ngZ0ADp4L7vYg-A2yOQanUtc3AOBol.jpg',	10,	'2018-12-20',	'2018-12-20');

CREATE TABLE `vendor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `password` text NOT NULL,
  `nama` varchar(255) NOT NULL,
  `alamat` text NOT NULL,
  `telepon` varchar(255) NOT NULL,
  `foto` varchar(255) NOT NULL,
  `saldo` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `verifikasi` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vendor` (`id`, `email`, `password`, `nama`, `alamat`, `telepon`, `foto`, `saldo`, `status`, `verifikasi`, `created_at`, `updated_at`) VALUES
(1,	'sariroti@gmail.com',	'$2y$13$w7P9.Cbmqq5RuIrsUGxQpOvt8R6hhoYGbKq39MjttkhcrQ97SolhS',	'PT. Sari Roti',	'Jln. Pegangsaan Timur 34 Jakarta',	'085736775369',	'BZ0-iiL_nP5pYpeb8sQwLltAPMbVhBYT.jpg',	0,	1,	1,	'2019-02-01 03:50:21',	'2019-03-19 14:49:35'),
(2,	'pertamina@gmail.com',	'$2y$13$w7P9.Cbmqq5RuIrsUGxQpOvt8R6hhoYGbKq39MjttkhcrQ97SolhS',	'PT. Pertamina Tbk.',	'Jln. Ahmad Yani 34 Surabaya',	'085736775369',	'',	0,	1,	0,	'2019-02-01 03:53:12',	'2019-03-23 23:25:54'),
(3,	'primateknik@gmail.com',	'$2y$13$UgpYxg5OfAyMhzLhyff/gO86EOBwUJ7XEfwEENWJ3VI7K3hKF60Sa',	'Prima Teknik',	'',	'085736775369',	'',	0,	0,	0,	'2019-03-08 16:13:23',	'2019-03-08 16:17:42'),
(5,	'ahmad@outlook.com',	'$2y$13$MeMzcCNxNBL/PKJdrqxH1eDQgVqxYmjhfGmkPLwMTP8q5AE28Gd3m',	'PT. Ahmad',	'Jln. Puputan Margarana Kute Bali Indonesia',	'085736775369',	'9fdZukrhD75RWjOAD8R76yJq_8xrKESg.jpg',	0,	1,	1,	'2019-03-19 15:17:26',	'2019-03-19 15:38:56'),
(6,	'vicodelta@gmail.com',	'$2y$13$LcPSEJw72TYqSyoya4NL..ZHRh.c.K4tgYOfa4pv8CYtfXcyEvq2u',	'PT. Vico Delta',	'Jln. Komputer Desktop 34 Surabaya',	'085736775369',	'fQIDGk2qEShl21vJotpgr0O6n9JR86fJ.jpg',	15000,	1,	1,	'2019-03-20 03:29:10',	'2019-03-23 22:38:25'),
(7,	'fakhrvdin@outlook.com',	'$2y$13$IBA5gC1norZybtIzjrdCWeKYfpaDo3GDGNMkiUWvnfc0GHJ1Am1fu',	'PT. Web Media',	'Jln. Soekarno Hatta 34 Surabaya',	'085736775369',	'EEbKq4iq-U6ewhq8L33XoGsS0PcBJM3B.png',	30000,	1,	1,	'2019-03-25 08:52:54',	'2019-04-02 06:24:35'),
(8,	'ma.kaafi@yahoo.co.id',	'$2y$13$cmZZ6HXrxk2iPSMh3kbMoOvAf.MdSd.KseymfeiNlrVwlw9/5ZvES',	'Kaafi',	'JL. Semampir Tengah',	'089606696705',	'aDRcPnMOgBrPM1sWL7vUMZOTq9OgkdXE.png',	0,	1,	1,	'2019-04-02 04:12:59',	'2019-04-02 04:26:04');

-- 2019-04-02 07:25:24
