text: /*
  SQLyog Ultimate v12.5.1 (64 bit)
  MySQL - 10.4.11-MariaDB : Database - db_praktikum_prognet
  *********************************************************************
  */
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_praktikum_prognet` /*!40100 DEFAULT CHARACTER SET latin1 */;
  
  USE `db_praktikum_prognet`;
  
  /*Table structure for table `admin_notifications` */
  
  DROP TABLE IF EXISTS `admin_notifications`;
  
  CREATE TABLE `admin_notifications` (
    `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_id` int(10) unsigned NOT NULL,
    `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `read_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `seller_notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`),
    KEY `notifiable_id` (`notifiable_id`),
    CONSTRAINT `admin_notifications_ibfk_1` FOREIGN KEY (`notifiable_id`) REFERENCES `admins` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `admin_notifications` */
  
  insert  into `admin_notifications`(`id`,`type`,`notifiable_type`,`notifiable_id`,`data`,`read_at`,`created_at`,`updated_at`) values 
  ('02fe3ca7-c964-4ead-b8e8-37d20f3dc2e1','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/2\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-08 10:59:51','2020-06-08 18:34:38','2020-06-08 10:59:51'),
  ('0aeca773-de10-488f-9cf3-e007f4cca74a','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/6\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-09 15:53:34','2020-06-09 13:23:30','2020-06-09 15:53:34'),
  ('28ea508b-a6cb-4623-ac21-7adeaa772c0a','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/6\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-09 15:53:34','2020-06-09 05:23:41','2020-06-09 15:53:34'),
  ('3ffe5802-3fed-483f-83ca-88cd4659a474','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/7\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-09 15:53:34','2020-06-09 13:32:55','2020-06-09 15:53:34'),
  ('4c70c8ed-fffd-460f-a24e-2dbba1df8d86','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/11\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Kedukk</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-12 06:26:06','2020-06-12 12:48:58','2020-06-12 06:26:06'),
  ('51cec527-828b-428e-88a3-a706b16c2d35','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/products/1\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'></h6><p class=\'font-weight-light small-text text-muted mb-0\'>Produk diberikan Review!</p></div></a>','2020-06-08 10:59:51','2020-06-08 10:44:31','2020-06-08 10:59:51'),
  ('5800f54d-6189-42be-a2ce-9eb52a411e4d','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/products/2\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'></h6><p class=\'font-weight-light small-text text-muted mb-0\'>Produk diberikan Review!</p></div></a>','2020-06-08 17:53:25','2020-06-08 17:03:15','2020-06-08 17:53:25'),
  ('5cdbb4bc-bbea-49e6-9608-07460e2158cf','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/8\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-12 04:40:53','2020-06-10 05:51:30','2020-06-12 04:40:53'),
  ('65c2c122-dc83-45b2-94fe-81be32798f85','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/12\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Kedukk</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-12 07:16:38','2020-06-12 07:11:24','2020-06-12 07:16:38'),
  ('682aa0de-61bf-4dd0-bd87-9b21d1ebe300','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/4\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>I Made Agus Guna Saputra</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-08 17:53:25','2020-06-08 16:46:08','2020-06-08 17:53:25'),
  ('6fa339af-e4e6-4357-a69a-532e5688e58e','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/products/2\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'></h6><p class=\'font-weight-light small-text text-muted mb-0\'>Produk diberikan Review!</p></div></a>','2020-06-12 04:40:53','2020-06-11 03:40:27','2020-06-12 04:40:53'),
  ('7469d6e2-87d2-474d-9f29-0aaabf1ad398','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/10\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Kedukk</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-12 04:45:39','2020-06-12 12:41:16','2020-06-12 04:45:39'),
  ('802ebe31-f423-4107-9d7f-86a29ea4a4e2','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/9\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Agus Guna Saputra</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-12 04:40:53','2020-06-11 03:19:55','2020-06-12 04:40:53'),
  ('93c7f3f8-cca8-408e-acfa-f87376a17c9c','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/products/7\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'></h6><p class=\'font-weight-light small-text text-muted mb-0\'>Produk diberikan Review!</p></div></a>','2020-06-12 07:16:38','2020-06-12 07:15:47','2020-06-12 07:16:38'),
  ('990ae2e4-21c4-4a1e-8147-8cced26f2984','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/9\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Agus Guna Saputra</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-12 04:40:53','2020-06-11 11:19:31','2020-06-12 04:40:53'),
  ('a234951a-d2f8-40e3-a608-3d45fe00c42f','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/10\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Kedukk</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-12 04:45:39','2020-06-12 04:43:38','2020-06-12 04:45:39'),
  ('b539dd41-cd1c-454e-953e-e4c492865895','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/11\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Kedukk</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-12 06:26:06','2020-06-12 04:50:02','2020-06-12 06:26:06'),
  ('be97dc99-5f3e-46e3-aabe-8bd544a088dc','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/1\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-08 10:59:51','2020-06-08 18:13:15','2020-06-08 10:59:51'),
  ('c47e4b76-516e-432c-aab1-8bd9e5c46680','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/12\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Kedukk</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-12 07:16:38','2020-06-12 15:10:45','2020-06-12 07:16:38'),
  ('c606b437-b9c1-48b3-b4fa-035749edf07f','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/3\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-08 17:53:25','2020-06-08 17:28:57','2020-06-08 17:53:25'),
  ('c8cf3bb1-313e-4f21-8ae6-6e8fca219134','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/3\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-08 17:53:25','2020-06-08 20:07:36','2020-06-08 17:53:25'),
  ('cd5de525-1be7-4a92-8364-6091772385eb','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/13\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Kedukk</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-12 07:52:19','2020-06-12 15:18:30','2020-06-12 07:52:19'),
  ('d34f051b-d679-4f8b-a694-74822666596e','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/4\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>I Made Agus Guna Saputra</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-08 17:53:25','2020-06-09 00:45:44','2020-06-08 17:53:25'),
  ('d72d03e4-4eae-451f-8271-769b0198ca40','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/5\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-09 15:53:34','2020-06-09 05:20:41','2020-06-09 15:53:34'),
  ('dbadad96-9a54-42e1-9446-9adb0ada9472','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/5\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Ada Transaksi Baru</p></div></a>','2020-06-09 15:53:34','2020-06-09 13:20:10','2020-06-09 15:53:34'),
  ('f5ae609e-af75-451f-8fd1-d15a678e3c30','App\\Notifications\\AdminNotification','App\\Admin',1,'<a class=\'dropdown-item\' href=\'/admin/transaksi/detail/1\'><div class=\'item-content flex-grow\'><h6 class=\'ellipsis font-weight-normal\'>Gusna Richman</h6><p class=\'font-weight-light small-text text-muted mb-0\'>Bukti Bayar Diupload</p></div></a>','2020-06-08 10:59:51','2020-06-08 10:13:37','2020-06-08 10:59:51');
  
  /*Table structure for table `admins` */
  
  DROP TABLE IF EXISTS `admins`;
  
  CREATE TABLE `admins` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `profile_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `sellers_email_unique` (`phone`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `admins` */
  
  insert  into `admins`(`id`,`username`,`password`,`name`,`profile_image`,`phone`,`remember_token`,`created_at`,`updated_at`,`status`) values 
  (1,'Kedukk','$2y$10$LOMWmm6OLctmN.Ck.J7mEu2DRdvtXGLNFcHxtDwXlTtCalbSRE6Pe','Admin Keduk','1584276259.png','088236109829','UqwFXmhmTI0QMKTBptiZUI44nx7A81gOluoW8haJ3IBlgcwHhIFb8jbYul0k','2020-03-15 12:41:41','2020-03-15 12:41:41',1);
  
  /*Table structure for table `carts` */
  
  DROP TABLE IF EXISTS `carts`;
  
  CREATE TABLE `carts` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(10) unsigned NOT NULL,
    `product_id` int(10) unsigned NOT NULL,
    `qty` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `status` enum('checkedout','notyet','cancelled') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `product_id` (`product_id`),
    CONSTRAINT `carts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
    CONSTRAINT `carts_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `carts` */
  
  insert  into `carts`(`id`,`user_id`,`product_id`,`qty`,`created_at`,`updated_at`,`status`,`deleted_at`) values 
  (1,14,2,3,'2020-06-09 05:18:51','2020-06-09 13:20:11','checkedout',NULL),
  (2,14,1,1,'2020-06-09 05:33:50','2020-06-09 05:35:13','cancelled',NULL),
  (3,14,1,1,'2020-06-09 05:36:54','2020-06-09 05:38:46','cancelled',NULL),
  (4,14,2,1,'2020-06-09 05:37:04','2020-06-09 05:37:14','cancelled',NULL),
  (5,14,2,1,'2020-06-09 05:38:18','2020-06-09 05:38:28','cancelled',NULL),
  (6,14,2,3,'2020-06-09 05:40:45','2020-06-09 05:42:35','cancelled',NULL),
  (7,14,1,1,'2020-06-09 05:41:04','2020-06-09 05:42:53','cancelled',NULL),
  (8,14,1,1,'2020-06-09 05:43:32','2020-06-09 05:53:40','cancelled',NULL),
  (9,14,2,1,'2020-06-09 05:43:37','2020-06-09 05:53:11','cancelled',NULL),
  (10,14,2,2,'2020-06-09 05:53:44','2020-06-09 05:56:53','cancelled',NULL),
  (11,14,1,1,'2020-06-09 05:54:04','2020-06-09 05:57:51','cancelled',NULL),
  (12,14,1,2,'2020-06-09 05:57:56','2020-06-09 05:58:03','cancelled',NULL),
  (13,14,1,1,'2020-06-09 05:59:03','2020-06-09 05:59:30','cancelled',NULL),
  (14,14,1,1,'2020-06-09 06:02:32','2020-06-09 06:02:37','cancelled',NULL),
  (15,14,1,1,'2020-06-09 06:03:01','2020-06-09 06:03:24','cancelled',NULL),
  (16,14,2,1,'2020-06-09 06:03:07','2020-06-09 06:03:16','cancelled',NULL),
  (17,14,1,1,'2020-06-09 06:04:58','2020-06-09 06:05:20','cancelled',NULL),
  (18,14,2,1,'2020-06-09 06:05:04','2020-06-09 06:05:11','cancelled',NULL),
  (19,14,2,1,'2020-06-09 06:05:37','2020-06-09 06:05:57','cancelled',NULL),
  (20,14,1,1,'2020-06-09 06:05:49','2020-06-09 06:06:04','cancelled',NULL),
  (21,15,34,1,'2020-06-09 14:58:49','2020-06-11 03:18:05','cancelled',NULL),
  (22,14,25,2,'2020-06-09 15:49:28','2020-06-09 16:16:47','cancelled',NULL),
  (23,14,1,46,'2020-06-09 16:18:26','2020-06-09 20:04:46','cancelled',NULL),
  (24,14,2,23,'2020-06-09 20:55:16','2020-06-09 21:32:06','cancelled',NULL),
  (25,14,19,6,'2020-06-09 20:59:09','2020-06-09 21:32:09','cancelled',NULL),
  (26,14,10,4,'2020-06-09 21:35:52','2020-06-10 05:51:31','checkedout',NULL),
  (27,14,6,5,'2020-06-09 21:50:45','2020-06-10 05:51:31','checkedout',NULL),
  (28,20,4,5,'2020-06-12 04:17:07','2020-06-12 12:41:16','checkedout',NULL),
  (29,20,8,6,'2020-06-12 04:17:17','2020-06-12 12:41:16','checkedout',NULL),
  (30,20,3,7,'2020-06-12 07:14:03','2020-06-12 07:17:54','cancelled',NULL),
  (31,20,5,3,'2020-06-12 07:14:12','2020-06-12 07:17:58','cancelled',NULL);
  
  /*Table structure for table `cities` */
  
  DROP TABLE IF EXISTS `cities`;
  
  CREATE TABLE `cities` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `province_id` int(10) unsigned NOT NULL,
    `city_id` int(10) unsigned NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=502 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `cities` */
  
  insert  into `cities`(`id`,`province_id`,`city_id`,`title`,`created_at`,`updated_at`) values 
  (1,1,17,'Badung','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (2,1,32,'Bangli','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (3,1,94,'Buleleng','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (4,1,114,'Denpasar','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (5,1,128,'Gianyar','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (6,1,161,'Jembrana','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (7,1,170,'Karangasem','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (8,1,197,'Klungkung','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (9,1,447,'Tabanan','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (10,2,27,'Bangka','2020-05-04 16:15:25','2020-05-04 16:15:25'),
  (11,2,28,'Bangka Barat','2020-05-04 16:15:26','2020-05-04 16:15:26'),
  (12,2,29,'Bangka Selatan','2020-05-04 16:15:26','2020-05-04 16:15:26'),
  (13,2,30,'Bangka Tengah','2020-05-04 16:15:26','2020-05-04 16:15:26'),
  (14,2,56,'Belitung','2020-05-04 16:15:26','2020-05-04 16:15:26'),
  (15,2,57,'Belitung Timur','2020-05-04 16:15:26','2020-05-04 16:15:26'),
  (16,2,334,'Pangkal Pinang','2020-05-04 16:15:26','2020-05-04 16:15:26'),
  (17,3,106,'Cilegon','2020-05-04 16:15:28','2020-05-04 16:15:28'),
  (18,3,232,'Lebak','2020-05-04 16:15:28','2020-05-04 16:15:28'),
  (19,3,331,'Pandeglang','2020-05-04 16:15:28','2020-05-04 16:15:28'),
  (20,3,402,'Serang','2020-05-04 16:15:28','2020-05-04 16:15:28'),
  (21,3,403,'Serang','2020-05-04 16:15:29','2020-05-04 16:15:29'),
  (22,3,455,'Tangerang','2020-05-04 16:15:29','2020-05-04 16:15:29'),
  (23,3,456,'Tangerang','2020-05-04 16:15:29','2020-05-04 16:15:29'),
  (24,3,457,'Tangerang Selatan','2020-05-04 16:15:29','2020-05-04 16:15:29'),
  (25,4,62,'Bengkulu','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (26,4,63,'Bengkulu Selatan','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (27,4,64,'Bengkulu Tengah','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (28,4,65,'Bengkulu Utara','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (29,4,175,'Kaur','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (30,4,183,'Kepahiang','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (31,4,233,'Lebong','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (32,4,294,'Muko Muko','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (33,4,379,'Rejang Lebong','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (34,4,397,'Seluma','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (35,5,39,'Bantul','2020-05-04 16:15:32','2020-05-04 16:15:32'),
  (36,5,135,'Gunung Kidul','2020-05-04 16:15:32','2020-05-04 16:15:32'),
  (37,5,210,'Kulon Progo','2020-05-04 16:15:32','2020-05-04 16:15:32'),
  (38,5,419,'Sleman','2020-05-04 16:15:32','2020-05-04 16:15:32'),
  (39,5,501,'Yogyakarta','2020-05-04 16:15:32','2020-05-04 16:15:32'),
  (40,6,151,'Jakarta Barat','2020-05-04 16:15:36','2020-05-04 16:15:36'),
  (41,6,152,'Jakarta Pusat','2020-05-04 16:15:36','2020-05-04 16:15:36'),
  (42,6,153,'Jakarta Selatan','2020-05-04 16:15:36','2020-05-04 16:15:36'),
  (43,6,154,'Jakarta Timur','2020-05-04 16:15:36','2020-05-04 16:15:36'),
  (44,6,155,'Jakarta Utara','2020-05-04 16:15:36','2020-05-04 16:15:36'),
  (45,6,189,'Kepulauan Seribu','2020-05-04 16:15:36','2020-05-04 16:15:36'),
  (46,7,77,'Boalemo','2020-05-04 16:15:37','2020-05-04 16:15:37'),
  (47,7,88,'Bone Bolango','2020-05-04 16:15:37','2020-05-04 16:15:37'),
  (48,7,129,'Gorontalo','2020-05-04 16:15:37','2020-05-04 16:15:37'),
  (49,7,130,'Gorontalo','2020-05-04 16:15:37','2020-05-04 16:15:37'),
  (50,7,131,'Gorontalo Utara','2020-05-04 16:15:37','2020-05-04 16:15:37'),
  (51,7,361,'Pohuwato','2020-05-04 16:15:37','2020-05-04 16:15:37'),
  (52,8,50,'Batang Hari','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (53,8,97,'Bungo','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (54,8,156,'Jambi','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (55,8,194,'Kerinci','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (56,8,280,'Merangin','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (57,8,293,'Muaro Jambi','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (58,8,393,'Sarolangun','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (59,8,442,'Sungaipenuh','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (60,8,460,'Tanjung Jabung Barat','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (61,8,461,'Tanjung Jabung Timur','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (62,8,471,'Tebo','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (63,9,22,'Bandung','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (64,9,23,'Bandung','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (65,9,24,'Bandung Barat','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (66,9,34,'Banjar','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (67,9,54,'Bekasi','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (68,9,55,'Bekasi','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (69,9,78,'Bogor','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (70,9,79,'Bogor','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (71,9,103,'Ciamis','2020-05-04 16:15:42','2020-05-04 16:15:42'),
  (72,9,104,'Cianjur','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (73,9,107,'Cimahi','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (74,9,108,'Cirebon','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (75,9,109,'Cirebon','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (76,9,115,'Depok','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (77,9,126,'Garut','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (78,9,149,'Indramayu','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (79,9,171,'Karawang','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (80,9,211,'Kuningan','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (81,9,252,'Majalengka','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (82,9,332,'Pangandaran','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (83,9,376,'Purwakarta','2020-05-04 16:15:43','2020-05-04 16:15:43'),
  (84,9,428,'Subang','2020-05-04 16:15:44','2020-05-04 16:15:44'),
  (85,9,430,'Sukabumi','2020-05-04 16:15:44','2020-05-04 16:15:44'),
  (86,9,431,'Sukabumi','2020-05-04 16:15:44','2020-05-04 16:15:44'),
  (87,9,440,'Sumedang','2020-05-04 16:15:44','2020-05-04 16:15:44'),
  (88,9,468,'Tasikmalaya','2020-05-04 16:15:44','2020-05-04 16:15:44'),
  (89,9,469,'Tasikmalaya','2020-05-04 16:15:44','2020-05-04 16:15:44'),
  (90,10,37,'Banjarnegara','2020-05-04 16:15:53','2020-05-04 16:15:53'),
  (91,10,41,'Banyumas','2020-05-04 16:15:53','2020-05-04 16:15:53'),
  (92,10,49,'Batang','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (93,10,76,'Blora','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (94,10,91,'Boyolali','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (95,10,92,'Brebes','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (96,10,105,'Cilacap','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (97,10,113,'Demak','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (98,10,134,'Grobogan','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (99,10,163,'Jepara','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (100,10,169,'Karanganyar','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (101,10,177,'Kebumen','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (102,10,181,'Kendal','2020-05-04 16:15:54','2020-05-04 16:15:54'),
  (103,10,196,'Klaten','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (104,10,209,'Kudus','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (105,10,249,'Magelang','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (106,10,250,'Magelang','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (107,10,344,'Pati','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (108,10,348,'Pekalongan','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (109,10,349,'Pekalongan','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (110,10,352,'Pemalang','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (111,10,375,'Purbalingga','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (112,10,377,'Purworejo','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (113,10,380,'Rembang','2020-05-04 16:15:55','2020-05-04 16:15:55'),
  (114,10,386,'Salatiga','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (115,10,398,'Semarang','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (116,10,399,'Semarang','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (117,10,427,'Sragen','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (118,10,433,'Sukoharjo','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (119,10,445,'Surakarta (Solo)','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (120,10,472,'Tegal','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (121,10,473,'Tegal','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (122,10,476,'Temanggung','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (123,10,497,'Wonogiri','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (124,10,498,'Wonosobo','2020-05-04 16:15:56','2020-05-04 16:15:56'),
  (125,11,31,'Bangkalan','2020-05-04 16:15:58','2020-05-04 16:15:58'),
  (126,11,42,'Banyuwangi','2020-05-04 16:15:58','2020-05-04 16:15:58'),
  (127,11,51,'Batu','2020-05-04 16:15:58','2020-05-04 16:15:58'),
  (128,11,74,'Blitar','2020-05-04 16:15:58','2020-05-04 16:15:58'),
  (129,11,75,'Blitar','2020-05-04 16:15:58','2020-05-04 16:15:58'),
  (130,11,80,'Bojonegoro','2020-05-04 16:15:58','2020-05-04 16:15:58'),
  (131,11,86,'Bondowoso','2020-05-04 16:15:58','2020-05-04 16:15:58'),
  (132,11,133,'Gresik','2020-05-04 16:15:58','2020-05-04 16:15:58'),
  (133,11,160,'Jember','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (134,11,164,'Jombang','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (135,11,178,'Kediri','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (136,11,179,'Kediri','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (137,11,222,'Lamongan','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (138,11,243,'Lumajang','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (139,11,247,'Madiun','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (140,11,248,'Madiun','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (141,11,251,'Magetan','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (142,11,255,'Malang','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (143,11,256,'Malang','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (144,11,289,'Mojokerto','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (145,11,290,'Mojokerto','2020-05-04 16:15:59','2020-05-04 16:15:59'),
  (146,11,305,'Nganjuk','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (147,11,306,'Ngawi','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (148,11,317,'Pacitan','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (149,11,330,'Pamekasan','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (150,11,342,'Pasuruan','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (151,11,343,'Pasuruan','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (152,11,363,'Ponorogo','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (153,11,369,'Probolinggo','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (154,11,370,'Probolinggo','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (155,11,390,'Sampang','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (156,11,409,'Sidoarjo','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (157,11,418,'Situbondo','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (158,11,441,'Sumenep','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (159,11,444,'Surabaya','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (160,11,487,'Trenggalek','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (161,11,489,'Tuban','2020-05-04 16:16:00','2020-05-04 16:16:00'),
  (162,11,492,'Tulungagung','2020-05-04 16:16:01','2020-05-04 16:16:01'),
  (163,12,61,'Bengkayang','2020-05-04 16:16:02','2020-05-04 16:16:02'),
  (164,12,168,'Kapuas Hulu','2020-05-04 16:16:02','2020-05-04 16:16:02'),
  (165,12,176,'Kayong Utara','2020-05-04 16:16:02','2020-05-04 16:16:02'),
  (166,12,195,'Ketapang','2020-05-04 16:16:02','2020-05-04 16:16:02'),
  (167,12,208,'Kubu Raya','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (168,12,228,'Landak','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (169,12,279,'Melawi','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (170,12,364,'Pontianak','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (171,12,365,'Pontianak','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (172,12,388,'Sambas','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (173,12,391,'Sanggau','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (174,12,395,'Sekadau','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (175,12,415,'Singkawang','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (176,12,417,'Sintang','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (177,13,18,'Balangan','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (178,13,33,'Banjar','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (179,13,35,'Banjarbaru','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (180,13,36,'Banjarmasin','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (181,13,43,'Barito Kuala','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (182,13,143,'Hulu Sungai Selatan','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (183,13,144,'Hulu Sungai Tengah','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (184,13,145,'Hulu Sungai Utara','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (185,13,203,'Kotabaru','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (186,13,446,'Tabalong','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (187,13,452,'Tanah Bumbu','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (188,13,454,'Tanah Laut','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (189,13,466,'Tapin','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (190,14,44,'Barito Selatan','2020-05-04 16:16:06','2020-05-04 16:16:06'),
  (191,14,45,'Barito Timur','2020-05-04 16:16:06','2020-05-04 16:16:06'),
  (192,14,46,'Barito Utara','2020-05-04 16:16:06','2020-05-04 16:16:06'),
  (193,14,136,'Gunung Mas','2020-05-04 16:16:06','2020-05-04 16:16:06'),
  (194,14,167,'Kapuas','2020-05-04 16:16:06','2020-05-04 16:16:06'),
  (195,14,174,'Katingan','2020-05-04 16:16:06','2020-05-04 16:16:06'),
  (196,14,205,'Kotawaringin Barat','2020-05-04 16:16:06','2020-05-04 16:16:06'),
  (197,14,206,'Kotawaringin Timur','2020-05-04 16:16:06','2020-05-04 16:16:06'),
  (198,14,221,'Lamandau','2020-05-04 16:16:07','2020-05-04 16:16:07'),
  (199,14,296,'Murung Raya','2020-05-04 16:16:07','2020-05-04 16:16:07'),
  (200,14,326,'Palangka Raya','2020-05-04 16:16:07','2020-05-04 16:16:07'),
  (201,14,371,'Pulang Pisau','2020-05-04 16:16:07','2020-05-04 16:16:07'),
  (202,14,405,'Seruyan','2020-05-04 16:16:07','2020-05-04 16:16:07'),
  (203,14,432,'Sukamara','2020-05-04 16:16:07','2020-05-04 16:16:07'),
  (204,15,19,'Balikpapan','2020-05-04 16:16:09','2020-05-04 16:16:09'),
  (205,15,66,'Berau','2020-05-04 16:16:09','2020-05-04 16:16:09'),
  (206,15,89,'Bontang','2020-05-04 16:16:09','2020-05-04 16:16:09'),
  (207,15,214,'Kutai Barat','2020-05-04 16:16:09','2020-05-04 16:16:09'),
  (208,15,215,'Kutai Kartanegara','2020-05-04 16:16:09','2020-05-04 16:16:09'),
  (209,15,216,'Kutai Timur','2020-05-04 16:16:10','2020-05-04 16:16:10'),
  (210,15,341,'Paser','2020-05-04 16:16:10','2020-05-04 16:16:10'),
  (211,15,354,'Penajam Paser Utara','2020-05-04 16:16:10','2020-05-04 16:16:10'),
  (212,15,387,'Samarinda','2020-05-04 16:16:10','2020-05-04 16:16:10'),
  (213,16,96,'Bulungan (Bulongan)','2020-05-04 16:16:12','2020-05-04 16:16:12'),
  (214,16,257,'Malinau','2020-05-04 16:16:12','2020-05-04 16:16:12'),
  (215,16,311,'Nunukan','2020-05-04 16:16:12','2020-05-04 16:16:12'),
  (216,16,450,'Tana Tidung','2020-05-04 16:16:12','2020-05-04 16:16:12'),
  (217,16,467,'Tarakan','2020-05-04 16:16:12','2020-05-04 16:16:12'),
  (218,17,48,'Batam','2020-05-04 16:16:14','2020-05-04 16:16:14'),
  (219,17,71,'Bintan','2020-05-04 16:16:14','2020-05-04 16:16:14'),
  (220,17,172,'Karimun','2020-05-04 16:16:14','2020-05-04 16:16:14'),
  (221,17,184,'Kepulauan Anambas','2020-05-04 16:16:14','2020-05-04 16:16:14'),
  (222,17,237,'Lingga','2020-05-04 16:16:14','2020-05-04 16:16:14'),
  (223,17,302,'Natuna','2020-05-04 16:16:15','2020-05-04 16:16:15'),
  (224,17,462,'Tanjung Pinang','2020-05-04 16:16:15','2020-05-04 16:16:15'),
  (225,18,21,'Bandar Lampung','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (226,18,223,'Lampung Barat','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (227,18,224,'Lampung Selatan','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (228,18,225,'Lampung Tengah','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (229,18,226,'Lampung Timur','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (230,18,227,'Lampung Utara','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (231,18,282,'Mesuji','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (232,18,283,'Metro','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (233,18,355,'Pesawaran','2020-05-04 16:16:16','2020-05-04 16:16:16'),
  (234,18,356,'Pesisir Barat','2020-05-04 16:16:17','2020-05-04 16:16:17'),
  (235,18,368,'Pringsewu','2020-05-04 16:16:17','2020-05-04 16:16:17'),
  (236,18,458,'Tanggamus','2020-05-04 16:16:17','2020-05-04 16:16:17'),
  (237,18,490,'Tulang Bawang','2020-05-04 16:16:17','2020-05-04 16:16:17'),
  (238,18,491,'Tulang Bawang Barat','2020-05-04 16:16:17','2020-05-04 16:16:17'),
  (239,18,496,'Way Kanan','2020-05-04 16:16:17','2020-05-04 16:16:17'),
  (240,19,14,'Ambon','2020-05-04 16:16:18','2020-05-04 16:16:18'),
  (241,19,99,'Buru','2020-05-04 16:16:18','2020-05-04 16:16:18'),
  (242,19,100,'Buru Selatan','2020-05-04 16:16:18','2020-05-04 16:16:18'),
  (243,19,185,'Kepulauan Aru','2020-05-04 16:16:18','2020-05-04 16:16:18'),
  (244,19,258,'Maluku Barat Daya','2020-05-04 16:16:18','2020-05-04 16:16:18'),
  (245,19,259,'Maluku Tengah','2020-05-04 16:16:18','2020-05-04 16:16:18'),
  (246,19,260,'Maluku Tenggara','2020-05-04 16:16:18','2020-05-04 16:16:18'),
  (247,19,261,'Maluku Tenggara Barat','2020-05-04 16:16:19','2020-05-04 16:16:19'),
  (248,19,400,'Seram Bagian Barat','2020-05-04 16:16:19','2020-05-04 16:16:19'),
  (249,19,401,'Seram Bagian Timur','2020-05-04 16:16:19','2020-05-04 16:16:19'),
  (250,19,488,'Tual','2020-05-04 16:16:19','2020-05-04 16:16:19'),
  (251,20,138,'Halmahera Barat','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (252,20,139,'Halmahera Selatan','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (253,20,140,'Halmahera Tengah','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (254,20,141,'Halmahera Timur','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (255,20,142,'Halmahera Utara','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (256,20,191,'Kepulauan Sula','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (257,20,372,'Pulau Morotai','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (258,20,477,'Ternate','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (259,20,478,'Tidore Kepulauan','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (260,21,1,'Aceh Barat','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (261,21,2,'Aceh Barat Daya','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (262,21,3,'Aceh Besar','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (263,21,4,'Aceh Jaya','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (264,21,5,'Aceh Selatan','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (265,21,6,'Aceh Singkil','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (266,21,7,'Aceh Tamiang','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (267,21,8,'Aceh Tengah','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (268,21,9,'Aceh Tenggara','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (269,21,10,'Aceh Timur','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (270,21,11,'Aceh Utara','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (271,21,20,'Banda Aceh','2020-05-04 16:16:24','2020-05-04 16:16:24'),
  (272,21,59,'Bener Meriah','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (273,21,72,'Bireuen','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (274,21,127,'Gayo Lues','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (275,21,230,'Langsa','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (276,21,235,'Lhokseumawe','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (277,21,300,'Nagan Raya','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (278,21,358,'Pidie','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (279,21,359,'Pidie Jaya','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (280,21,384,'Sabang','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (281,21,414,'Simeulue','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (282,21,429,'Subulussalam','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (283,22,68,'Bima','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (284,22,69,'Bima','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (285,22,118,'Dompu','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (286,22,238,'Lombok Barat','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (287,22,239,'Lombok Tengah','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (288,22,240,'Lombok Timur','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (289,22,241,'Lombok Utara','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (290,22,276,'Mataram','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (291,22,438,'Sumbawa','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (292,22,439,'Sumbawa Barat','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (293,23,13,'Alor','2020-05-04 16:16:32','2020-05-04 16:16:32'),
  (294,23,58,'Belu','2020-05-04 16:16:32','2020-05-04 16:16:32'),
  (295,23,122,'Ende','2020-05-04 16:16:32','2020-05-04 16:16:32'),
  (296,23,125,'Flores Timur','2020-05-04 16:16:33','2020-05-04 16:16:33'),
  (297,23,212,'Kupang','2020-05-04 16:16:33','2020-05-04 16:16:33'),
  (298,23,213,'Kupang','2020-05-04 16:16:33','2020-05-04 16:16:33'),
  (299,23,234,'Lembata','2020-05-04 16:16:33','2020-05-04 16:16:33'),
  (300,23,269,'Manggarai','2020-05-04 16:16:33','2020-05-04 16:16:33'),
  (301,23,270,'Manggarai Barat','2020-05-04 16:16:33','2020-05-04 16:16:33'),
  (302,23,271,'Manggarai Timur','2020-05-04 16:16:33','2020-05-04 16:16:33'),
  (303,23,301,'Nagekeo','2020-05-04 16:16:33','2020-05-04 16:16:33'),
  (304,23,304,'Ngada','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (305,23,383,'Rote Ndao','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (306,23,385,'Sabu Raijua','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (307,23,412,'Sikka','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (308,23,434,'Sumba Barat','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (309,23,435,'Sumba Barat Daya','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (310,23,436,'Sumba Tengah','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (311,23,437,'Sumba Timur','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (312,23,479,'Timor Tengah Selatan','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (313,23,480,'Timor Tengah Utara','2020-05-04 16:16:34','2020-05-04 16:16:34'),
  (314,24,16,'Asmat','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (315,24,67,'Biak Numfor','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (316,24,90,'Boven Digoel','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (317,24,111,'Deiyai (Deliyai)','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (318,24,117,'Dogiyai','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (319,24,150,'Intan Jaya','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (320,24,157,'Jayapura','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (321,24,158,'Jayapura','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (322,24,159,'Jayawijaya','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (323,24,180,'Keerom','2020-05-04 16:16:43','2020-05-04 16:16:43'),
  (324,24,193,'Kepulauan Yapen (Yapen Waropen)','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (325,24,231,'Lanny Jaya','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (326,24,263,'Mamberamo Raya','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (327,24,264,'Mamberamo Tengah','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (328,24,274,'Mappi','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (329,24,281,'Merauke','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (330,24,284,'Mimika','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (331,24,299,'Nabire','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (332,24,303,'Nduga','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (333,24,335,'Paniai','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (334,24,347,'Pegunungan Bintang','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (335,24,373,'Puncak','2020-05-04 16:16:44','2020-05-04 16:16:44'),
  (336,24,374,'Puncak Jaya','2020-05-04 16:16:45','2020-05-04 16:16:45'),
  (337,24,392,'Sarmi','2020-05-04 16:16:45','2020-05-04 16:16:45'),
  (338,24,443,'Supiori','2020-05-04 16:16:45','2020-05-04 16:16:45'),
  (339,24,484,'Tolikara','2020-05-04 16:16:45','2020-05-04 16:16:45'),
  (340,24,495,'Waropen','2020-05-04 16:16:45','2020-05-04 16:16:45'),
  (341,24,499,'Yahukimo','2020-05-04 16:16:45','2020-05-04 16:16:45'),
  (342,24,500,'Yalimo','2020-05-04 16:16:45','2020-05-04 16:16:45'),
  (343,25,124,'Fakfak','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (344,25,165,'Kaimana','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (345,25,272,'Manokwari','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (346,25,273,'Manokwari Selatan','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (347,25,277,'Maybrat','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (348,25,346,'Pegunungan Arfak','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (349,25,378,'Raja Ampat','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (350,25,424,'Sorong','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (351,25,425,'Sorong','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (352,25,426,'Sorong Selatan','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (353,25,449,'Tambrauw','2020-05-04 16:17:08','2020-05-04 16:17:08'),
  (354,25,474,'Teluk Bintuni','2020-05-04 16:17:09','2020-05-04 16:17:09'),
  (355,25,475,'Teluk Wondama','2020-05-04 16:17:09','2020-05-04 16:17:09'),
  (356,26,60,'Bengkalis','2020-05-04 16:17:09','2020-05-04 16:17:09'),
  (357,26,120,'Dumai','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (358,26,147,'Indragiri Hilir','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (359,26,148,'Indragiri Hulu','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (360,26,166,'Kampar','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (361,26,187,'Kepulauan Meranti','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (362,26,207,'Kuantan Singingi','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (363,26,350,'Pekanbaru','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (364,26,351,'Pelalawan','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (365,26,381,'Rokan Hilir','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (366,26,382,'Rokan Hulu','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (367,26,406,'Siak','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (368,27,253,'Majene','2020-05-04 16:17:11','2020-05-04 16:17:11'),
  (369,27,262,'Mamasa','2020-05-04 16:17:11','2020-05-04 16:17:11'),
  (370,27,265,'Mamuju','2020-05-04 16:17:11','2020-05-04 16:17:11'),
  (371,27,266,'Mamuju Utara','2020-05-04 16:17:12','2020-05-04 16:17:12'),
  (372,27,362,'Polewali Mandar','2020-05-04 16:17:12','2020-05-04 16:17:12'),
  (373,28,38,'Bantaeng','2020-05-04 16:17:14','2020-05-04 16:17:14'),
  (374,28,47,'Barru','2020-05-04 16:17:14','2020-05-04 16:17:14'),
  (375,28,87,'Bone','2020-05-04 16:17:14','2020-05-04 16:17:14'),
  (376,28,95,'Bulukumba','2020-05-04 16:17:14','2020-05-04 16:17:14'),
  (377,28,123,'Enrekang','2020-05-04 16:17:14','2020-05-04 16:17:14'),
  (378,28,132,'Gowa','2020-05-04 16:17:14','2020-05-04 16:17:14'),
  (379,28,162,'Jeneponto','2020-05-04 16:17:15','2020-05-04 16:17:15'),
  (380,28,244,'Luwu','2020-05-04 16:17:15','2020-05-04 16:17:15'),
  (381,28,245,'Luwu Timur','2020-05-04 16:17:15','2020-05-04 16:17:15'),
  (382,28,246,'Luwu Utara','2020-05-04 16:17:15','2020-05-04 16:17:15'),
  (383,28,254,'Makassar','2020-05-04 16:17:15','2020-05-04 16:17:15'),
  (384,28,275,'Maros','2020-05-04 16:17:16','2020-05-04 16:17:16'),
  (385,28,328,'Palopo','2020-05-04 16:17:16','2020-05-04 16:17:16'),
  (386,28,333,'Pangkajene Kepulauan','2020-05-04 16:17:16','2020-05-04 16:17:16'),
  (387,28,336,'Parepare','2020-05-04 16:17:16','2020-05-04 16:17:16'),
  (388,28,360,'Pinrang','2020-05-04 16:17:16','2020-05-04 16:17:16'),
  (389,28,396,'Selayar (Kepulauan Selayar)','2020-05-04 16:17:16','2020-05-04 16:17:16'),
  (390,28,408,'Sidenreng Rappang/Rapang','2020-05-04 16:17:17','2020-05-04 16:17:17'),
  (391,28,416,'Sinjai','2020-05-04 16:17:17','2020-05-04 16:17:17'),
  (392,28,423,'Soppeng','2020-05-04 16:17:17','2020-05-04 16:17:17'),
  (393,28,448,'Takalar','2020-05-04 16:17:17','2020-05-04 16:17:17'),
  (394,28,451,'Tana Toraja','2020-05-04 16:17:17','2020-05-04 16:17:17'),
  (395,28,486,'Toraja Utara','2020-05-04 16:17:17','2020-05-04 16:17:17'),
  (396,28,493,'Wajo','2020-05-04 16:17:17','2020-05-04 16:17:17'),
  (397,29,25,'Banggai','2020-05-04 16:17:19','2020-05-04 16:17:19'),
  (398,29,26,'Banggai Kepulauan','2020-05-04 16:17:19','2020-05-04 16:17:19'),
  (399,29,98,'Buol','2020-05-04 16:17:19','2020-05-04 16:17:19'),
  (400,29,119,'Donggala','2020-05-04 16:17:19','2020-05-04 16:17:19'),
  (401,29,291,'Morowali','2020-05-04 16:17:20','2020-05-04 16:17:20'),
  (402,29,329,'Palu','2020-05-04 16:17:20','2020-05-04 16:17:20'),
  (403,29,338,'Parigi Moutong','2020-05-04 16:17:20','2020-05-04 16:17:20'),
  (404,29,366,'Poso','2020-05-04 16:17:20','2020-05-04 16:17:20'),
  (405,29,410,'Sigi','2020-05-04 16:17:20','2020-05-04 16:17:20'),
  (406,29,482,'Tojo Una-Una','2020-05-04 16:17:20','2020-05-04 16:17:20'),
  (407,29,483,'Toli-Toli','2020-05-04 16:17:20','2020-05-04 16:17:20'),
  (408,30,53,'Bau-Bau','2020-05-04 16:17:21','2020-05-04 16:17:21'),
  (409,30,85,'Bombana','2020-05-04 16:17:21','2020-05-04 16:17:21'),
  (410,30,101,'Buton','2020-05-04 16:17:22','2020-05-04 16:17:22'),
  (411,30,102,'Buton Utara','2020-05-04 16:17:22','2020-05-04 16:17:22'),
  (412,30,182,'Kendari','2020-05-04 16:17:22','2020-05-04 16:17:22'),
  (413,30,198,'Kolaka','2020-05-04 16:17:22','2020-05-04 16:17:22'),
  (414,30,199,'Kolaka Utara','2020-05-04 16:17:22','2020-05-04 16:17:22'),
  (415,30,200,'Konawe','2020-05-04 16:17:22','2020-05-04 16:17:22'),
  (416,30,201,'Konawe Selatan','2020-05-04 16:17:22','2020-05-04 16:17:22'),
  (417,30,202,'Konawe Utara','2020-05-04 16:17:23','2020-05-04 16:17:23'),
  (418,30,295,'Muna','2020-05-04 16:17:23','2020-05-04 16:17:23'),
  (419,30,494,'Wakatobi','2020-05-04 16:17:23','2020-05-04 16:17:23'),
  (420,31,73,'Bitung','2020-05-04 16:17:30','2020-05-04 16:17:30'),
  (421,31,81,'Bolaang Mongondow (Bolmong)','2020-05-04 16:17:30','2020-05-04 16:17:30'),
  (422,31,82,'Bolaang Mongondow Selatan','2020-05-04 16:17:30','2020-05-04 16:17:30'),
  (423,31,83,'Bolaang Mongondow Timur','2020-05-04 16:17:30','2020-05-04 16:17:30'),
  (424,31,84,'Bolaang Mongondow Utara','2020-05-04 16:17:30','2020-05-04 16:17:30'),
  (425,31,188,'Kepulauan Sangihe','2020-05-04 16:17:30','2020-05-04 16:17:30'),
  (426,31,190,'Kepulauan Siau Tagulandang Biaro (Sitaro)','2020-05-04 16:17:30','2020-05-04 16:17:30'),
  (427,31,192,'Kepulauan Talaud','2020-05-04 16:17:30','2020-05-04 16:17:30'),
  (428,31,204,'Kotamobagu','2020-05-04 16:17:31','2020-05-04 16:17:31'),
  (429,31,267,'Manado','2020-05-04 16:17:31','2020-05-04 16:17:31'),
  (430,31,285,'Minahasa','2020-05-04 16:17:31','2020-05-04 16:17:31'),
  (431,31,286,'Minahasa Selatan','2020-05-04 16:17:31','2020-05-04 16:17:31'),
  (432,31,287,'Minahasa Tenggara','2020-05-04 16:17:31','2020-05-04 16:17:31'),
  (433,31,288,'Minahasa Utara','2020-05-04 16:17:32','2020-05-04 16:17:32'),
  (434,31,485,'Tomohon','2020-05-04 16:17:32','2020-05-04 16:17:32'),
  (435,32,12,'Agam','2020-05-04 16:17:54','2020-05-04 16:17:54'),
  (436,32,93,'Bukittinggi','2020-05-04 16:17:55','2020-05-04 16:17:55'),
  (437,32,116,'Dharmasraya','2020-05-04 16:17:55','2020-05-04 16:17:55'),
  (438,32,186,'Kepulauan Mentawai','2020-05-04 16:17:55','2020-05-04 16:17:55'),
  (439,32,236,'Lima Puluh Koto/Kota','2020-05-04 16:17:56','2020-05-04 16:17:56'),
  (440,32,318,'Padang','2020-05-04 16:17:56','2020-05-04 16:17:56'),
  (441,32,321,'Padang Panjang','2020-05-04 16:17:56','2020-05-04 16:17:56'),
  (442,32,322,'Padang Pariaman','2020-05-04 16:17:57','2020-05-04 16:17:57'),
  (443,32,337,'Pariaman','2020-05-04 16:17:57','2020-05-04 16:17:57'),
  (444,32,339,'Pasaman','2020-05-04 16:17:57','2020-05-04 16:17:57'),
  (445,32,340,'Pasaman Barat','2020-05-04 16:17:57','2020-05-04 16:17:57'),
  (446,32,345,'Payakumbuh','2020-05-04 16:17:58','2020-05-04 16:17:58'),
  (447,32,357,'Pesisir Selatan','2020-05-04 16:17:58','2020-05-04 16:17:58'),
  (448,32,394,'Sawah Lunto','2020-05-04 16:17:58','2020-05-04 16:17:58'),
  (449,32,411,'Sijunjung (Sawah Lunto Sijunjung)','2020-05-04 16:17:58','2020-05-04 16:17:58'),
  (450,32,420,'Solok','2020-05-04 16:17:58','2020-05-04 16:17:58'),
  (451,32,421,'Solok','2020-05-04 16:17:59','2020-05-04 16:17:59'),
  (452,32,422,'Solok Selatan','2020-05-04 16:17:59','2020-05-04 16:17:59'),
  (453,32,453,'Tanah Datar','2020-05-04 16:18:00','2020-05-04 16:18:00'),
  (454,33,40,'Banyuasin','2020-05-04 16:18:01','2020-05-04 16:18:01'),
  (455,33,121,'Empat Lawang','2020-05-04 16:18:01','2020-05-04 16:18:01'),
  (456,33,220,'Lahat','2020-05-04 16:18:01','2020-05-04 16:18:01'),
  (457,33,242,'Lubuk Linggau','2020-05-04 16:18:01','2020-05-04 16:18:01'),
  (458,33,292,'Muara Enim','2020-05-04 16:18:02','2020-05-04 16:18:02'),
  (459,33,297,'Musi Banyuasin','2020-05-04 16:18:02','2020-05-04 16:18:02'),
  (460,33,298,'Musi Rawas','2020-05-04 16:18:02','2020-05-04 16:18:02'),
  (461,33,312,'Ogan Ilir','2020-05-04 16:18:02','2020-05-04 16:18:02'),
  (462,33,313,'Ogan Komering Ilir','2020-05-04 16:18:02','2020-05-04 16:18:02'),
  (463,33,314,'Ogan Komering Ulu','2020-05-04 16:18:03','2020-05-04 16:18:03'),
  (464,33,315,'Ogan Komering Ulu Selatan','2020-05-04 16:18:03','2020-05-04 16:18:03'),
  (465,33,316,'Ogan Komering Ulu Timur','2020-05-04 16:18:03','2020-05-04 16:18:03'),
  (466,33,324,'Pagar Alam','2020-05-04 16:18:03','2020-05-04 16:18:03'),
  (467,33,327,'Palembang','2020-05-04 16:18:03','2020-05-04 16:18:03'),
  (468,33,367,'Prabumulih','2020-05-04 16:18:03','2020-05-04 16:18:03'),
  (469,34,15,'Asahan','2020-05-04 16:18:05','2020-05-04 16:18:05'),
  (470,34,52,'Batu Bara','2020-05-04 16:18:05','2020-05-04 16:18:05'),
  (471,34,70,'Binjai','2020-05-04 16:18:05','2020-05-04 16:18:05'),
  (472,34,110,'Dairi','2020-05-04 16:18:05','2020-05-04 16:18:05'),
  (473,34,112,'Deli Serdang','2020-05-04 16:18:05','2020-05-04 16:18:05'),
  (474,34,137,'Gunungsitoli','2020-05-04 16:18:05','2020-05-04 16:18:05'),
  (475,34,146,'Humbang Hasundutan','2020-05-04 16:18:05','2020-05-04 16:18:05'),
  (476,34,173,'Karo','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (477,34,217,'Labuhan Batu','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (478,34,218,'Labuhan Batu Selatan','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (479,34,219,'Labuhan Batu Utara','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (480,34,229,'Langkat','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (481,34,268,'Mandailing Natal','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (482,34,278,'Medan','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (483,34,307,'Nias','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (484,34,308,'Nias Barat','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (485,34,309,'Nias Selatan','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (486,34,310,'Nias Utara','2020-05-04 16:18:06','2020-05-04 16:18:06'),
  (487,34,319,'Padang Lawas','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (488,34,320,'Padang Lawas Utara','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (489,34,323,'Padang Sidempuan','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (490,34,325,'Pakpak Bharat','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (491,34,353,'Pematang Siantar','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (492,34,389,'Samosir','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (493,34,404,'Serdang Bedagai','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (494,34,407,'Sibolga','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (495,34,413,'Simalungun','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (496,34,459,'Tanjung Balai','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (497,34,463,'Tapanuli Selatan','2020-05-04 16:18:07','2020-05-04 16:18:07'),
  (498,34,464,'Tapanuli Tengah','2020-05-04 16:18:08','2020-05-04 16:18:08'),
  (499,34,465,'Tapanuli Utara','2020-05-04 16:18:08','2020-05-04 16:18:08'),
  (500,34,470,'Tebing Tinggi','2020-05-04 16:18:08','2020-05-04 16:18:08'),
  (501,34,481,'Toba Samosir','2020-05-04 16:18:08','2020-05-04 16:18:08');
  
  /*Table structure for table `couriers` */
  
  DROP TABLE IF EXISTS `couriers`;
  
  CREATE TABLE `couriers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `courier` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `couriers` */
  
  insert  into `couriers`(`id`,`code`,`courier`,`created_at`,`updated_at`,`deleted_at`) values 
  (1,'jne','JNE','2020-04-05 01:47:02','2020-04-25 17:48:25',NULL),
  (2,'pos','POS','2020-05-22 22:29:11','2020-05-22 22:29:13',NULL),
  (3,'tiki','TIKI','2020-05-22 22:32:39','2020-05-22 22:32:40',NULL);
  
  /*Table structure for table `discounts` */
  
  DROP TABLE IF EXISTS `discounts`;
  
  CREATE TABLE `discounts` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `id_product` int(10) unsigned DEFAULT NULL,
    `percentage` int(3) DEFAULT NULL,
    `start` date DEFAULT NULL,
    `end` date DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `id_product` (`id_product`),
    CONSTRAINT `discounts_ibfk_1` FOREIGN KEY (`id_product`) REFERENCES `products` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  
  /*Data for the table `discounts` */
  
  insert  into `discounts`(`id`,`id_product`,`percentage`,`start`,`end`,`created_at`,`updated_at`,`deleted_at`) values 
  (1,2,20,'2020-06-09','2020-06-30','2020-06-08 16:08:20','2020-06-08 16:08:20',NULL),
  (2,4,40,'2020-06-09','2020-07-09','2020-06-09 10:40:53','2020-06-09 10:40:53',NULL),
  (3,6,15,'2020-06-11','2020-07-25','2020-06-09 11:27:02','2020-06-09 11:27:02',NULL),
  (4,7,40,'2020-06-25','2020-08-10','2020-06-09 11:30:55','2020-06-09 11:30:55',NULL),
  (5,15,10,'2020-06-12','2020-06-24','2020-06-09 11:58:17','2020-06-09 11:58:17',NULL),
  (6,16,15,'2020-06-11','2020-08-27','2020-06-09 12:01:48','2020-06-09 12:01:48',NULL),
  (7,25,10,'2020-06-11','2020-08-10','2020-06-09 12:34:12','2020-06-09 12:34:12',NULL),
  (8,21,30,'2020-06-08','2020-06-30','2020-06-09 13:26:57','2020-06-09 13:26:57',NULL),
  (9,26,17,'2020-06-26','2020-08-10','2020-06-09 14:40:05','2020-06-09 14:40:05',NULL),
  (10,28,10,'2020-06-10','2020-08-17','2020-06-09 14:44:42','2020-06-09 14:44:42',NULL),
  (11,34,10,'2020-06-10','2020-08-20','2020-06-09 14:57:21','2020-06-09 14:57:21',NULL);
  
  /*Table structure for table `migrations` */
  
  DROP TABLE IF EXISTS `migrations`;
  
  CREATE TABLE `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `migrations` */
  
  insert  into `migrations`(`id`,`migration`,`batch`) values 
  (1,'2014_10_12_000000_create_users_table',1),
  (2,'2014_10_12_100000_create_password_resets_table',1),
  (3,'2019_02_15_123603_create_admins_table',1),
  (4,'2019_02_15_123744_create_sellers_table',1),
  (5,'2019_02_15_125445_create_products_table',1),
  (6,'2019_02_15_130341_create_product_images_table',1),
  (7,'2019_02_15_131114_create_transactions_table',1),
  (8,'2019_02_15_131132_create_transaction_details_table',1),
  (9,'2019_02_15_132352_create_product_categories_table',1),
  (10,'2019_02_15_132701_create_carts_table',1),
  (11,'2019_02_15_134220_create_wishlists_table',1),
  (12,'2019_02_16_044815_create_rates_table',1),
  (13,'2019_02_16_045411_create_product_reviews_table',1),
  (14,'2019_02_16_062504_create_qna_products_table',1),
  (15,'2019_02_16_063238_create_shopping_voucers_table',1),
  (16,'2019_02_16_064643_create_couriers_table',1),
  (17,'2019_02_16_102028_create_notifications_table',1),
  (18,'2019_02_16_103007_create_seller_notifications_table',1),
  (19,'2019_02_16_103024_create_user_notifications_table',1),
  (22,'2020_05_04_151256_create_provinces_table',2),
  (23,'2020_05_04_151420_create_cities_table',2);
  
  /*Table structure for table `password_resets` */
  
  DROP TABLE IF EXISTS `password_resets`;
  
  CREATE TABLE `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `password_resets` */
  
  /*Table structure for table `product_categories` */
  
  DROP TABLE IF EXISTS `product_categories`;
  
  CREATE TABLE `product_categories` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `product_categories` */
  
  insert  into `product_categories`(`id`,`category_name`,`created_at`,`updated_at`,`deleted_at`) values 
  (1,'Liptint','2020-06-08 10:08:34','2020-06-08 10:08:34',NULL),
  (2,'Brush','2020-06-08 14:33:34','2020-06-08 14:33:34',NULL),
  (3,'Two Way Cake','2020-06-09 08:40:58','2020-06-09 08:40:58',NULL),
  (4,'Blush On','2020-06-09 08:41:15','2020-06-09 08:41:15',NULL),
  (5,'Maskara','2020-06-09 08:41:25','2020-06-09 08:41:25',NULL),
  (6,'Sunscreen','2020-06-09 08:41:51','2020-06-09 08:43:10','2020-06-09 08:43:10'),
  (7,'Toner','2020-06-09 08:42:08','2020-06-09 08:43:04','2020-06-09 08:43:04'),
  (8,'Serum','2020-06-09 08:42:17','2020-06-09 08:43:33','2020-06-09 08:43:33'),
  (9,'Sleeping Mask','2020-06-09 08:42:29','2020-06-09 08:42:56','2020-06-09 08:42:56'),
  (10,'Powder','2020-06-09 08:42:48','2020-06-09 08:42:48',NULL),
  (11,'Concealer','2020-06-09 10:33:26','2020-06-09 10:33:26',NULL),
  (12,'Eyeshadow','2020-06-09 12:36:22','2020-06-09 12:36:22',NULL),
  (13,'Eyeliner','2020-06-09 13:14:58','2020-06-09 13:14:58',NULL),
  (14,'Foundation','2020-06-09 14:53:05','2020-06-09 14:53:05',NULL);
  
  /*Table structure for table `product_category_details` */
  
  DROP TABLE IF EXISTS `product_category_details`;
  
  CREATE TABLE `product_category_details` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(10) unsigned NOT NULL,
    `category_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    KEY `product_id` (`product_id`),
    KEY `category_id` (`category_id`),
    CONSTRAINT `product_category_details_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
    CONSTRAINT `product_category_details_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `product_categories` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
  
  /*Data for the table `product_category_details` */
  
  insert  into `product_category_details`(`id`,`product_id`,`category_id`,`created_at`,`updated_at`) values 
  (1,1,1,'2020-06-08 10:10:12','2020-06-08 10:10:12'),
  (5,3,3,'2020-06-09 08:50:36','2020-06-09 08:50:36'),
  (6,4,11,'2020-06-09 10:37:24','2020-06-09 10:37:24'),
  (7,2,2,'2020-06-09 10:39:28','2020-06-09 10:39:28'),
  (8,5,11,'2020-06-09 11:24:04','2020-06-09 11:24:04'),
  (9,6,11,'2020-06-09 11:26:38','2020-06-09 11:26:38'),
  (10,7,11,'2020-06-09 11:30:08','2020-06-09 11:30:08'),
  (11,8,11,'2020-06-09 11:34:53','2020-06-09 11:34:53'),
  (12,9,11,'2020-06-09 11:42:06','2020-06-09 11:42:06'),
  (13,10,3,'2020-06-09 11:43:36','2020-06-09 11:43:36'),
  (14,11,3,'2020-06-09 11:46:43','2020-06-09 11:46:43'),
  (15,12,3,'2020-06-09 11:49:19','2020-06-09 11:49:19'),
  (16,13,3,'2020-06-09 11:52:01','2020-06-09 11:52:01'),
  (17,14,4,'2020-06-09 11:56:14','2020-06-09 11:56:14'),
  (18,15,4,'2020-06-09 11:57:56','2020-06-09 11:57:56'),
  (19,16,4,'2020-06-09 12:01:20','2020-06-09 12:01:20'),
  (20,17,4,'2020-06-09 12:03:57','2020-06-09 12:03:57'),
  (21,18,1,'2020-06-09 12:07:11','2020-06-09 12:07:11'),
  (22,19,1,'2020-06-09 12:15:05','2020-06-09 12:15:05'),
  (23,20,1,'2020-06-09 12:17:33','2020-06-09 12:17:33'),
  (24,21,5,'2020-06-09 12:24:29','2020-06-09 12:24:29'),
  (25,22,5,'2020-06-09 12:25:48','2020-06-09 12:25:48'),
  (26,23,5,'2020-06-09 12:27:32','2020-06-09 12:27:32'),
  (27,24,10,'2020-06-09 12:30:24','2020-06-09 12:30:24'),
  (28,25,10,'2020-06-09 12:33:49','2020-06-09 12:33:49'),
  (29,26,12,'2020-06-09 12:38:21','2020-06-09 12:38:21'),
  (30,27,12,'2020-06-09 12:42:45','2020-06-09 12:42:45'),
  (31,28,12,'2020-06-09 12:44:43','2020-06-09 12:44:43'),
  (32,29,12,'2020-06-09 13:10:04','2020-06-09 13:10:04'),
  (33,30,12,'2020-06-09 13:12:10','2020-06-09 13:12:10'),
  (34,31,12,'2020-06-09 13:14:27','2020-06-09 13:14:27'),
  (35,32,13,'2020-06-09 13:16:54','2020-06-09 13:16:54'),
  (37,33,13,'2020-06-09 13:25:42','2020-06-09 13:25:42'),
  (38,34,13,'2020-06-09 14:52:19','2020-06-09 14:52:19'),
  (39,35,14,'2020-06-09 14:55:57','2020-06-09 14:55:57');
  
  /*Table structure for table `product_images` */
  
  DROP TABLE IF EXISTS `product_images`;
  
  CREATE TABLE `product_images` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(10) unsigned NOT NULL,
    `image_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `product_id` (`product_id`),
    CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=173 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `product_images` */
  
  insert  into `product_images`(`id`,`product_id`,`image_name`,`created_at`,`updated_at`) values 
  (1,1,'1591611012_wardah_liptint_1.jpg','2020-06-08 10:10:12','2020-06-08 10:10:12'),
  (2,1,'1591611012_wardah_liptint_2.jpg','2020-06-08 10:10:12','2020-06-08 10:10:12'),
  (3,2,'1591626884_oflame brush.Jpeg','2020-06-08 14:34:44','2020-06-08 14:34:44'),
  (4,2,'1591626884_oflame brush2.Jpeg','2020-06-08 14:34:44','2020-06-08 14:34:44'),
  (5,3,'1591692571_5f73638cfda5cd6133eb46da67e7fcbbxsun.jpg','2020-06-09 08:49:31','2020-06-09 08:49:31'),
  (6,4,'1591699044_ca73a1ad75a5f2f4b2981ccdc69b9f09.jpg','2020-06-09 10:37:24','2020-06-09 10:37:24'),
  (7,5,'1591701844_unnamed.jpg','2020-06-09 11:24:04','2020-06-09 11:24:04'),
  (8,6,'1591701998_l-a-girl-2950-5581081-1.jpg','2020-06-09 11:26:38','2020-06-09 11:26:38'),
  (9,7,'1591702208_NOVO-Concealer-Palette-Face-Makeup-Cover-Eye-Dark-Circles-Oil-control-Brighten-Natural-liquid-Concealer-Lasting.jpg_960x960.jpg','2020-06-09 11:30:08','2020-06-09 11:30:08'),
  (10,8,'1591702493_fitme.jpg','2020-06-09 11:34:53','2020-06-09 11:34:53'),
  (11,9,'1591702926_imagic.jpg','2020-06-09 11:42:06','2020-06-09 11:42:06'),
  (12,10,'1591703016_emina.jpg','2020-06-09 11:43:36','2020-06-09 11:43:36'),
  (13,11,'1591703203_pixi.PNG','2020-06-09 11:46:43','2020-06-09 11:46:43'),
  (14,12,'1591703359_product_1470034092_Make_Over__800x800.jpg','2020-06-09 11:49:19','2020-06-09 11:49:19'),
  (15,13,'1591703521_aramuze.png','2020-06-09 11:52:01','2020-06-09 11:52:01'),
  (16,14,'1591703774_61Ml1vunPxL._SX425_.jpg','2020-06-09 11:56:14','2020-06-09 11:56:14'),
  (17,15,'1591703876_Emina_Cheek_Lit_Pressed_Blush.jpg','2020-06-09 11:57:56','2020-06-09 11:57:56'),
  (18,16,'1591704080_L0559976.jpg','2020-06-09 12:01:20','2020-06-09 12:01:20'),
  (19,17,'1591704237_f2313e0af0af1617da3164f200bef5ac.jpg','2020-06-09 12:03:57','2020-06-09 12:03:57'),
  (20,18,'1591704431_1569037553897.jpeg','2020-06-09 12:07:11','2020-06-09 12:07:11'),
  (21,19,'1591704905_emina.PNG','2020-06-09 12:15:05','2020-06-09 12:15:05'),
  (22,20,'1591705053_ae6e5a593643d91831009cce20a25354.jpg','2020-06-09 12:17:33','2020-06-09 12:17:33'),
  (23,21,'1591705469_maskara mybeline.webp','2020-06-09 12:24:29','2020-06-09 12:24:29'),
  (24,22,'1591705548_product_1511860804_Wardah_Eye_800x800.jpg','2020-06-09 12:25:48','2020-06-09 12:25:48'),
  (25,23,'1591705652_WEB-BANNER_PRODUCT-560X690_mascara__560_690.jpg','2020-06-09 12:27:32','2020-06-09 12:27:32'),
  (26,24,'1591705824_ddf8d98b112b157e93ceccb4fb0cc179.jpg','2020-06-09 12:30:24','2020-06-09 12:30:24'),
  (27,25,'1591706029_wardah loose powder light feel warna-600x600.jpg','2020-06-09 12:33:49','2020-06-09 12:33:49'),
  (28,26,'1591706301_7e200b501e0e7ea98621bc0d7c885ebd.jpg','2020-06-09 12:38:21','2020-06-09 12:38:21'),
  (29,27,'1591706565_598460bdbf4e2e39c2576ef8b8ad39d6.jpg','2020-06-09 12:42:45','2020-06-09 12:42:45'),
  (30,28,'1591706683_make over.jpg','2020-06-09 12:44:43','2020-06-09 12:44:43'),
  (31,29,'1591708204_closeup_c0138cd43d6abffe19d24c9c2630598695b2f48c_1544691082_3c.webp','2020-06-09 13:10:04','2020-06-09 13:10:04'),
  (32,30,'1591708330_30029-large_default.jpg','2020-06-09 13:12:10','2020-06-09 13:12:10'),
  (33,31,'1591708467_FOTO_13.jpg','2020-06-09 13:14:27','2020-06-09 13:14:27'),
  (34,32,'1591708614_24775846_0ea40600-441e-4f0d-9655-87c93be0b42f_1181_1181.jpg','2020-06-09 13:16:54','2020-06-09 13:16:54'),
  (35,33,'1591708845_nature-republic-micro-slim-fit-eyeliner-005g.jpg','2020-06-09 13:20:45','2020-06-09 13:20:45'),
  (36,3,'1591709355_wardah_wardah-refill-lightening-two-way-cake-light-feel-03-sheer-pink---12gr_full02.jpg','2020-06-09 13:29:15','2020-06-09 13:29:15'),
  (37,3,'1591709468_2.31-BeFunky-collage-27.jpg','2020-06-09 13:31:08','2020-06-09 13:31:08'),
  (38,3,'1591709538_2.jpg','2020-06-09 13:32:18','2020-06-09 13:32:18'),
  (39,4,'1591709674_2fclr.jpg','2020-06-09 13:34:34','2020-06-09 13:34:34'),
  (40,4,'1591709674_2fclr3.jpg','2020-06-09 13:34:34','2020-06-09 13:34:34'),
  (41,4,'1591709773_4.jpg','2020-06-09 13:36:13','2020-06-09 13:36:13'),
  (42,4,'1591709838_5fclr.jpg','2020-06-09 13:37:18','2020-06-09 13:37:18'),
  (43,5,'1591710023_2NARS RADIANT CREAMY CONCEALER MINI 1.4 ml.jpg','2020-06-09 13:40:23','2020-06-09 13:40:23'),
  (44,5,'1591710023_3NARS RADIANT CREAMY CONCEALER MINI 1.4 ml.jpg','2020-06-09 13:40:23','2020-06-09 13:40:23'),
  (45,5,'1591710023_4NARS RADIANT CREAMY CONCEALER MINI 1.4 ml.jpg','2020-06-09 13:40:23','2020-06-09 13:40:23'),
  (46,5,'1591710023_5NARS RADIANT CREAMY CONCEALER MINI 1.4 ml.jpg','2020-06-09 13:40:23','2020-06-09 13:40:23'),
  (47,5,'1591710023_6NARS RADIANT CREAMY CONCEALER MINI 1.4 ml.webp','2020-06-09 13:40:23','2020-06-09 13:40:23'),
  (48,6,'1591710275_11.webp','2020-06-09 13:44:35','2020-06-09 13:44:35'),
  (49,6,'1591710275_12.jpg','2020-06-09 13:44:35','2020-06-09 13:44:35'),
  (50,6,'1591710275_13.jpg','2020-06-09 13:44:35','2020-06-09 13:44:35'),
  (51,6,'1591710275_14.webp','2020-06-09 13:44:35','2020-06-09 13:44:35'),
  (52,7,'1591710450_1.jpg','2020-06-09 13:47:30','2020-06-09 13:47:30'),
  (53,7,'1591710450_2.jpg','2020-06-09 13:47:30','2020-06-09 13:47:30'),
  (54,7,'1591710450_3.jpg','2020-06-09 13:47:30','2020-06-09 13:47:30'),
  (55,8,'1591710572_119d101471976bb16f19707c9d12a1f4.jpg','2020-06-09 13:49:32','2020-06-09 13:49:32'),
  (56,8,'1591710572_15452970_4fa28e94-f4f4-4a25-930f-60450175b3bb_800_800.jpg','2020-06-09 13:49:32','2020-06-09 13:49:32'),
  (57,8,'1591710572_43239228_34b24825-0431-43bc-b1eb-02ddf25d94e6_400_300.jpg','2020-06-09 13:49:32','2020-06-09 13:49:32'),
  (58,8,'1591710572_https_s1.bukalapak.com_img_12760994181_large_MAYBELLINE_Fit_Me_Concealer_LIGHT.jpeg','2020-06-09 13:49:32','2020-06-09 13:49:32'),
  (63,9,'1591710931_0a70971f342c0fa770546cfacfb800c7.jpg','2020-06-09 13:55:31','2020-06-09 13:55:31'),
  (64,9,'1591710931_5e903de75cf590acfa235adbe376157f.jpg','2020-06-09 13:55:31','2020-06-09 13:55:31'),
  (65,9,'1591710931_2467a58f82fca1149a2540bf5cef2498.jpg','2020-06-09 13:55:31','2020-06-09 13:55:31'),
  (66,9,'1591710931_a416151796ef25b97a9a10504ac5259d.jpg','2020-06-09 13:55:31','2020-06-09 13:55:31'),
  (67,10,'1591711067_data.jpeg.webp','2020-06-09 13:57:47','2020-06-09 13:57:47'),
  (68,10,'1591711067_e690435cdc19d0002182c24e46affe11.jpeg','2020-06-09 13:57:47','2020-06-09 13:57:47'),
  (69,10,'1591711067_f43485036e06db90f5df5e07417f57b6.jpg','2020-06-09 13:57:47','2020-06-09 13:57:47'),
  (70,10,'1591711067_P5160040.jpg','2020-06-09 13:57:47','2020-06-09 13:57:47'),
  (71,11,'1591711469_2caa16a7ecad8cd1f7e92902a3c5994b.jpeg','2020-06-09 14:04:29','2020-06-09 14:04:29'),
  (72,11,'1591711469_92e44c1a6cb540a76b7185aa27213dbd.jpg','2020-06-09 14:04:29','2020-06-09 14:04:29'),
  (73,11,'1591711469_TWC_Perfect_Last_Pixy-2.jpg','2020-06-09 14:04:29','2020-06-09 14:04:29'),
  (74,12,'1591711587_8e5055e2e1a366493daf74503643033e.jpg_340x340q80.jpg_.webp','2020-06-09 14:06:27','2020-06-09 14:06:27'),
  (75,12,'1591711587_54266481_153805598980087_5212140560181792981_n.jpg','2020-06-09 14:06:27','2020-06-09 14:06:27'),
  (76,12,'1591711587_d2349339a655a292507d25617ed9483c.jpg_720x720q80.jpg_.webp','2020-06-09 14:06:27','2020-06-09 14:06:27'),
  (77,12,'1591711587_nHBfsgAAiAAAAAQABumvCQACbvY.jpg','2020-06-09 14:06:27','2020-06-09 14:06:27'),
  (78,12,'1591711587_Promo_MAKE_OVER_MAKEOVER_PERFECT_COVER_TWO_WAY_CAKE_TWC_BEDA.jpg','2020-06-09 14:06:27','2020-06-09 14:06:27'),
  (79,13,'1591711744_3b057d3d62c07eaad8aa64a300d15ee4.jpg','2020-06-09 14:09:04','2020-06-09 14:09:04'),
  (80,13,'1591711744_9b8b6b25e6649b441260fda929ff7451.jpg','2020-06-09 14:09:04','2020-06-09 14:09:04'),
  (81,13,'1591711744_801111d067739c11443263a45ff76dc8.jpg','2020-06-09 14:09:04','2020-06-09 14:09:04'),
  (82,13,'1591711744_72856062_7a7d7701-947a-41d1-9cfc-913207fb865d_640_640.png','2020-06-09 14:09:04','2020-06-09 14:09:04'),
  (83,14,'1591711904_1ea57c230f569eaab82b780f8d06fcb8.jpg','2020-06-09 14:11:44','2020-06-09 14:11:44'),
  (84,14,'1591711904_8a82734ec906e96222c77083f72eafe2 (1).jpg','2020-06-09 14:11:44','2020-06-09 14:11:44'),
  (85,14,'1591711904_fe4f7c89985361e7b83d05c2d87d66c6.jpg','2020-06-09 14:11:44','2020-06-09 14:11:44'),
  (86,15,'1591712033_0bdf137ae521cb80f3ea74657ab5204b.jpg','2020-06-09 14:13:53','2020-06-09 14:13:53'),
  (87,15,'1591712033_169358_1e01c16f-0e66-4015-ac9c-bd2b1c800ec0_382_382.jpg','2020-06-09 14:13:53','2020-06-09 14:13:53'),
  (88,15,'1591712033_Emina_Cheek_Lit_Pressed_Blush.jpg','2020-06-09 14:13:53','2020-06-09 14:13:53'),
  (89,15,'1591712033_f110cc5270f3df051f4119d0ffba5c5b.jpeg','2020-06-09 14:13:53','2020-06-09 14:13:53'),
  (90,16,'1591712130_8ea47268fd8321ed05788dec12c6c5b4.png','2020-06-09 14:15:30','2020-06-09 14:15:30'),
  (91,16,'1591712130_images.jpg','2020-06-09 14:15:30','2020-06-09 14:15:30'),
  (92,16,'1591712130_s-l400.jpg','2020-06-09 14:15:30','2020-06-09 14:15:30'),
  (93,17,'1591712255_4d2555e1802c3aa8f91520af44645e0d.jpg','2020-06-09 14:17:35','2020-06-09 14:17:35'),
  (94,17,'1591712255_1044187_c0d2ebf9-74a2-497c-946f-3b5e8efeb4ae_700_700.jpg','2020-06-09 14:17:35','2020-06-09 14:17:35'),
  (95,17,'1591712255_4424677_b487e131-7bfa-4898-8251-c497959510ae_800_800.jpg','2020-06-09 14:17:35','2020-06-09 14:17:35'),
  (96,17,'1591712255_6151358_b7737ba9-4eb2-4e75-a373-dbc52a93df63_800_800.jpg','2020-06-09 14:17:35','2020-06-09 14:17:35'),
  (97,17,'1591712255_nHBfsgABIwAAAAkALtZqmwABBuA.jpg','2020-06-09 14:17:35','2020-06-09 14:17:35'),
  (98,18,'1591712421_1a910c6980180059ace1955f872664d2.jpg','2020-06-09 14:20:21','2020-06-09 14:20:21'),
  (99,18,'1591712421_4ab415976f6fde55acbf65d64381fc86.jpg','2020-06-09 14:20:21','2020-06-09 14:20:21'),
  (100,18,'1591712421_2591228_8c061874-a125-43b9-9a2f-8e266b968140_800_800.jpg','2020-06-09 14:20:21','2020-06-09 14:20:21'),
  (101,18,'1591712421_Novo-Merek-6-Warna-Batom-Super-Ice-Cream-Lip-Gloss-Tahan-Air-Tahan-Lama-Makeup-Lipstik.jpg','2020-06-09 14:20:21','2020-06-09 14:20:21'),
  (102,19,'1591712567_28c3ed2c482de0a78913188df7aadec3.jpg','2020-06-09 14:22:47','2020-06-09 14:22:47'),
  (103,19,'1591712567_-83181.webp','2020-06-09 14:22:47','2020-06-09 14:22:47'),
  (104,19,'1591712567_341838_fcce77e7-19a5-4ea1-9751-13805aabc0bf_1827_1827.jpg','2020-06-09 14:22:47','2020-06-09 14:22:47'),
  (105,19,'1591712567_emina_5.jpg','2020-06-09 14:22:47','2020-06-09 14:22:47'),
  (106,20,'1591712687_70157_peripera_peripera-peri-s-ink-airy-velve---_1516856952443793.jpg','2020-06-09 14:24:47','2020-06-09 14:24:47'),
  (107,20,'1591712687_d7ce8cfedae598bd694df37cadcf05f8.png','2020-06-09 14:24:47','2020-06-09 14:24:47'),
  (108,20,'1591712687_Peripera_Peris_Ink_the_Velvet_L_1.webp','2020-06-09 14:24:47','2020-06-09 14:24:47'),
  (109,20,'1591712687_PERIPERA-AIRY-INK-VELVET-13.jpg','2020-06-09 14:24:47','2020-06-09 14:24:47'),
  (110,20,'1591712687_product_1525619368942Peris-Ink-Velvetjpg.jpg','2020-06-09 14:24:47','2020-06-09 14:24:47'),
  (111,21,'1591712805_1e413f75e29c42cd53c21354cabcc7f7.jpeg','2020-06-09 14:26:45','2020-06-09 14:26:45'),
  (112,21,'1591712805_9c29b8eabddac79488778853f762fd64.jpg','2020-06-09 14:26:45','2020-06-09 14:26:45'),
  (113,21,'1591712805_1147c4993f5df0cdd4c4929afed285be.jpeg','2020-06-09 14:26:45','2020-06-09 14:26:45'),
  (114,21,'1591712805_20720087_37fc39c2-b6df-4932-87cc-67a16ca9c43e_480_360.jpg','2020-06-09 14:26:45','2020-06-09 14:26:45'),
  (115,22,'1591713023_Wardah EyeXpert Volume Expert Mascara Review 1.png','2020-06-09 14:30:23','2020-06-09 14:30:23'),
  (116,22,'1591713023_Wardah_Volume_Expert_Mascara_New_L_1.webp','2020-06-09 14:30:23','2020-06-09 14:30:23'),
  (117,22,'1591713023_Wardah-EyeXpert-The-Volume-Expert-Mascara.webp','2020-06-09 14:30:23','2020-06-09 14:30:23'),
  (118,22,'1591713023_Wardah-EyeXpert-The-Volume-Expert-Mascara-9.jpg','2020-06-09 14:30:23','2020-06-09 14:30:23'),
  (119,23,'1591713135_af2fdd02380bb8f9ad1a9dfde78e30fd.jpg','2020-06-09 14:32:15','2020-06-09 14:32:15'),
  (120,23,'1591713135_af8dc036e873e74a17a111e9ad7c5666.jpg','2020-06-09 14:32:15','2020-06-09 14:32:15'),
  (121,23,'1591713135_ca4cedf26c41407003bfe6a40784d832.jpg','2020-06-09 14:32:15','2020-06-09 14:32:15'),
  (122,24,'1591713309_amZzL3Q2MS8yMDAvOTI2MjU5MDEvMTUwNzU5LzYxOWEzODliLzVkZWU3M2UwTjhjNmZmMTZl.jpg','2020-06-09 14:35:09','2020-06-09 14:35:09'),
  (123,24,'1591713309_c2f838ab008ed2c04cb9b7c350de9e69.jpg','2020-06-09 14:35:09','2020-06-09 14:35:09'),
  (124,24,'1591713309_cdddf6fca727ad63a899ef5a6e035d9d.jpg','2020-06-09 14:35:09','2020-06-09 14:35:09'),
  (125,24,'1591713309_focallure_oil_setting_loose_powder_fa15_1532495332_f60812190.jpg','2020-06-09 14:35:09','2020-06-09 14:35:09'),
  (126,24,'1591713309_IMG20180628105921.jpg','2020-06-09 14:35:09','2020-06-09 14:35:09'),
  (127,24,'1591713309_product_1539156359_Focallure__800x800.jpg','2020-06-09 14:35:09','2020-06-09 14:35:09'),
  (128,25,'1591713429_72ec552df339ae50af0de08eb4b98f60.jpg','2020-06-09 14:37:09','2020-06-09 14:37:09'),
  (129,25,'1591713429_97a21d5af78f4acf7d5e17782c272deb.jpeg','2020-06-09 14:37:09','2020-06-09 14:37:09'),
  (130,25,'1591713429_000000534197_01_800.png','2020-06-09 14:37:09','2020-06-09 14:37:09'),
  (131,25,'1591713429_uploaded_cf71674318fb5e8de729896d38fc5f53.jpg','2020-06-09 14:37:09','2020-06-09 14:37:09'),
  (132,26,'1591713577_0caa1b58d395b896305bbe3f667eddd4.jpg','2020-06-09 14:39:37','2020-06-09 14:39:37'),
  (133,26,'1591713577_e47ef6282b209bba55cb61f77dc3dd1d.jpg','2020-06-09 14:39:37','2020-06-09 14:39:37'),
  (134,26,'1591713577_images.jpg','2020-06-09 14:39:37','2020-06-09 14:39:37'),
  (135,26,'1591713577_Maybelline-The-Blushed-Nudes.jpg','2020-06-09 14:39:37','2020-06-09 14:39:37'),
  (136,26,'1591713577_unnamed.jpg','2020-06-09 14:39:37','2020-06-09 14:39:37'),
  (137,27,'1591713711_5b276b941f82cfc2974c358d6733a0f8.jpg','2020-06-09 14:41:51','2020-06-09 14:41:51'),
  (138,27,'1591713711_5e173899713857e32c1b1e4a07b78788.jpg','2020-06-09 14:41:51','2020-06-09 14:41:51'),
  (139,27,'1591713711_526810bbaa2f4a9bff6c5ce44c53914d.jpeg','2020-06-09 14:41:51','2020-06-09 14:41:51'),
  (140,27,'1591713711_a93cc6f90b2ee4c53d0353af9ed41d08.jpg','2020-06-09 14:41:51','2020-06-09 14:41:51'),
  (141,28,'1591713860_17742-large_default.jpg','2020-06-09 14:44:20','2020-06-09 14:44:20'),
  (142,28,'1591713860_2563239_4ad8fbf4-f8dc-40bb-8e42-43d98b5e59bd_2048_0.jpg','2020-06-09 14:44:20','2020-06-09 14:44:20'),
  (143,28,'1591713860_make-over-eyecentric-3.jpg','2020-06-09 14:44:20','2020-06-09 14:44:20'),
  (144,29,'1591713979_604214916630_naked.jpg','2020-06-09 14:46:19','2020-06-09 14:46:19'),
  (145,29,'1591713979_a08516073aef48f0c2a21140f0732d74.jpg','2020-06-09 14:46:19','2020-06-09 14:46:19'),
  (146,29,'1591713979_c48bba34276a7dc6d6e0bcc136720648.jpg','2020-06-09 14:46:19','2020-06-09 14:46:19'),
  (147,29,'1591713979_i-021109-naked-palette-i-w-brush-1-940.jpg','2020-06-09 14:46:19','2020-06-09 14:46:19'),
  (148,29,'1591713979_naked1__46709.1512433631.jpg','2020-06-09 14:46:19','2020-06-09 14:46:19'),
  (149,30,'1591714072_1080_bc0e94050-c328-11e9-a22d-af605c05395ccdfbj.jpg','2020-06-09 14:47:52','2020-06-09 14:47:52'),
  (150,30,'1591714072_1231375_1f9a789a-0513-4707-80db-492e976cc998_700_700.jpg','2020-06-09 14:47:52','2020-06-09 14:47:52'),
  (151,30,'1591714072_7136504_da1103fa-0cd9-499d-80d1-889d29ced115_492_492.jpg','2020-06-09 14:47:52','2020-06-09 14:47:52'),
  (152,30,'1591714072_data.jpeg','2020-06-09 14:47:52','2020-06-09 14:47:52'),
  (153,30,'1591714072_wardah_exclusive_eyeshadow_palette_1572433886_2d96152e_progressive.jpg','2020-06-09 14:47:52','2020-06-09 14:47:52'),
  (154,33,'1591714213_4f1dfb4571e5cd49d68e0ba530e33278.jpg','2020-06-09 14:50:13','2020-06-09 14:50:13'),
  (155,33,'1591714213_nature-republic-2719-7404502-1.jpg','2020-06-09 14:50:13','2020-06-09 14:50:13'),
  (156,33,'1591714213_nature-republic-micro-slim-fit-eyeliner-005g.jpg','2020-06-09 14:50:13','2020-06-09 14:50:13'),
  (157,34,'1591714339_700.700_44ecce83ba5d4fdd96a6c17741bbdadf.jpg','2020-06-09 14:52:19','2020-06-09 14:52:19'),
  (158,34,'1591714339_1474602890_lg.jpg','2020-06-09 14:52:19','2020-06-09 14:52:19'),
  (159,34,'1591714339_ab5aef365cdad4122bc7f032d43af99a.jpg','2020-06-09 14:52:19','2020-06-09 14:52:19'),
  (160,34,'1591714339_IMG_20161111_110726_HDR.jpg','2020-06-09 14:52:19','2020-06-09 14:52:19'),
  (161,34,'1591714339_product_1491812992_mizzu_Perf_800x800.jpg','2020-06-09 14:52:19','2020-06-09 14:52:19'),
  (163,35,'1591714557_914ba823da7182cc6170977994cc9162.jpg_720x720q80.jpg_.webp','2020-06-09 14:55:57','2020-06-09 14:55:57'),
  (164,35,'1591714557_download.jpg','2020-06-09 14:55:57','2020-06-09 14:55:57'),
  (165,35,'1591714557_NYX_Professional_Makeup_Can_t_Stop_Won_t_Stop_Foundation_07_.jpg','2020-06-09 14:55:57','2020-06-09 14:55:57');
  
  /*Table structure for table `product_reviews` */
  
  DROP TABLE IF EXISTS `product_reviews`;
  
  CREATE TABLE `product_reviews` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(10) unsigned NOT NULL,
    `user_id` int(10) unsigned NOT NULL,
    `rate` int(1) NOT NULL,
    `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `rate_id` (`rate`),
    KEY `product_id` (`product_id`),
    CONSTRAINT `product_reviews_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
    CONSTRAINT `product_reviews_ibfk_3` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `product_reviews` */
  
  insert  into `product_reviews`(`id`,`product_id`,`user_id`,`rate`,`content`,`created_at`,`updated_at`,`status`,`deleted_at`) values 
  (1,1,14,5,'Produk mantap','2020-06-08 10:44:31','2020-06-08 10:44:31',NULL,NULL),
  (2,2,17,4,'Produk sesuai ekspektasi','2020-06-08 17:03:14','2020-06-08 17:03:14',NULL,NULL),
  (3,2,15,5,'Produk jek mantap','2020-06-11 03:40:27','2020-06-11 03:40:27',NULL,NULL),
  (4,7,20,5,'Mantap','2020-06-12 07:15:46','2020-06-12 07:15:46',NULL,NULL);
  
  /*Table structure for table `products` */
  
  DROP TABLE IF EXISTS `products`;
  
  CREATE TABLE `products` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` int(11) NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `product_rate` double DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `stock` int(10) DEFAULT NULL,
    `weight` int(3) DEFAULT NULL,
    `deleted_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `products` */
  
  insert  into `products`(`id`,`product_name`,`price`,`description`,`product_rate`,`created_at`,`updated_at`,`stock`,`weight`,`deleted_at`) values 
  (1,'Wardah Liptint',30000,'Liptint mantap',5,'2020-06-08 10:10:12','2020-06-09 05:24:11',47,1,NULL),
  (2,'Oriflame Brush',70000,'Brush nyaman',4.5,'2020-06-08 14:34:44','2020-06-11 03:40:27',25,1,NULL),
  (3,'Wardah Exclusive Two Way Cake (Refil)',50000,'Perpaduan antara bedak dan foundation yang dapat menutupi noda-noda di wajah secara sempurna. Hasil akhir wardah wardah exclusive two way cake tetap terlihat matte dan mempunyai tekstur lembut dan halus ketika digunakan pada wajahmu.',0,'2020-06-09 08:49:31','2020-06-09 08:50:36',10,12,NULL),
  (4,'Focallure Krim Concealer Wajah Sempurna',95760,'Concealer bebas minyak, mencerahkan warna kulit, pelembab, membuat riasan telanjang alami dan ringan',0,'2020-06-09 10:37:24','2020-06-12 04:44:02',10,24,NULL),
  (5,'NARS RADIANT CREAMY CONCEALER MINI 1.4 ml',210000,'Produk ini memberi kenyamanan pada wajah anda bersifat waterprof.',0,'2020-06-09 11:24:04','2020-06-09 11:24:04',50,0,NULL),
  (6,'La Girl Pro Concealer Creamy Beige',120000,'Crease – resistant, dengan tekstur yang creamy dan ringan. Formulanya tahan lama dan dapat menutupi lingkaran gelap di bawah mata, kulit kemerahan, dan ketidaksempurnaan pada kulit. Memberikan hasil sempurna, terlihat alami, menutupi warna kulit tidak rata, menutupi flek hitam, dan meminimalisir kerutan di sekitar mata. \r\nFormula blendable dan buildable –nya memberikan hasil yang sempurna, dan menyesuaikan dengan kebutuhan kulit. Concealer ini sudah termasuk dengan sebuah brush-tip lembut untuk aplikasi lebih mudah.',0,'2020-06-09 11:26:38','2020-06-09 11:26:38',31,8,NULL),
  (7,'NOVO Krim Concealer Cair Ringan',94998,'NOVO Weightless Complete Converage Concealer',5,'2020-06-09 11:30:08','2020-06-12 07:15:47',14,6,NULL),
  (8,'Concealer Mybelline Fit Me Penyamar Noda',83700,'Concealer bebas minyak ini cocok untuk menyamarkan ketidaksempurnaan pada kulit, Tidak membuat terlihat cakey, Langsung menyerap dan adaptasi pada kulit.\r\nWajah pun tampak sempurna alami dengan Fit Me Concealer dari Maybelline!\r\n\r\nKelebihan dari Concealer Maybelline Fit Me ini :\r\n-> Formula bebas minyak & wax \r\n-> Menutupi ketidaksempurnaan kulit secara sempurna tapi tetap menjaga #kulit dapat bernapas \r\n-> Base transparan dan pigmen ringan inovasi baru membuat hasil akhir makeup tampak super alami \r\n-> Non-comedogenic\r\n-> Lolos uji dermatologis, fragrance-free',0,'2020-06-09 11:34:53','2020-06-12 04:44:02',19,8,NULL),
  (9,'IMAGIC Concealer Cair',23000,'Produk ini sifatnya matte, kulit, tahan lama tidak mudah untuk menghitamkan, waktu makeup yang lama.',0,'2020-06-09 11:42:06','2020-06-09 11:42:06',18,7,NULL),
  (10,'Emina City Chich CC Cake Butterscotch',49500,'Perpaduan unik bedak dan foundation memberikan efek halus dan tidak berminyak. Penambahan Apricot oil membantu menjaga kelembaban, mudah diratakan dan tahan lama.',0,'2020-06-09 11:43:35','2020-06-09 11:43:35',23,12,NULL),
  (11,'PIXY UV WHITENING 4 BEAUTY BENEFITS TWO WAY CAKE PERFECT LAST REFILL',25000,'Bedak padat dari series 4 benefit ini memiliki formula yang bisa memberikan efek full covarage dan bisa menutupi imperfection diwajah kalian. Selain itu bedak ini bisa membuat wajah kalian nampak lebih halus dan menyamarkan pori-pori. Pixy Uv Whitening Two Way Cake ini memiliki beberapa shade diantaranya :\r\n\r\n-	Fair Orchre \r\n-	Natural Buff\r\n-	Sand Beige',0,'2020-06-09 11:46:43','2020-06-09 11:46:43',15,9,NULL),
  (12,'MAKEOVER Perfect Cover Two Way Cake',123000,'Kombinasi unggul foundation dan bedak yang menyatu dengan sempurna dengan kulit, menghasilkan makeup yang lembut dan halus sekaligus menjaga wajah tetap segar dan sempurna. Partikel-partikelnya membantu menyerap kelebihan minyak, menyamarkan ketidaksempurnaan kulit dan menutupi setiap inci kulit dengan sempurna tanpa membuat merasa menggunakan makeup tebal. Formula yang tidak larut dalam air membantu menjaga kelembaban kulit dan mencegah dehidrasi kulit. Tanpa perlu touch up, two way cake long lasting ini bisa menjadi rekan terbaik kapanpun dimanapun.',0,'2020-06-09 11:49:19','2020-06-09 11:49:19',10,12,NULL),
  (13,'Aramuze Two Way Cake',53500,'Perpaduan lengkap bedak dan foundation dalam satu produk dengan mikro partikel yang dapat menutupi kekurangan pada kulit wajah sehingga menghasilkan hasil make up yang natural, mulus dan tahan lama. Diperkaya Vit E, UV filter serta moisturizer yang dapat merawat kulit wajah, menjaga kelembaban wajah dan melindunginya dari sinar matahari. Teksturnya yang lembut dan ringan sangat nyaman untuk dipakai seharian.',0,'2020-06-09 11:52:01','2020-06-09 11:52:01',20,9,NULL),
  (14,'Original NARS Blush On Orgasm blusher Powder Blusher Deep Throat',240000,'Kualitas super terbaik, mampu membuat penampilan anda semakin maksimal.',0,'2020-06-09 11:56:14','2020-06-09 11:56:14',10,5,NULL),
  (15,'Emina Cheek Lit Pressed Blush',36000,'1. Dapat digunakan oleh semua jenis kulit, namun akan terllihat sangat baik pada kulit yang cenderung berminyak\r\n2. Hasil yang didapatkan halus, tipis, dan tidak berminyak\r\n3. Memiliki enam pilihan warna yang bisa disesuaikan dengan kepribadian dan suasana hati\r\n4. Warna yang intens',0,'2020-06-09 11:57:56','2020-06-09 11:57:56',27,4,NULL),
  (16,'NYX Professional MakeUp Sweet Cheeks Creamy Powder Blush Matte',140000,'Sweet Cheeks Creamy Powder Blush, blush-on terbaru dari NYX Professional Makeup dengan formula super halus, mudah di blend, pigmented, dan hasil akhir matte.',0,'2020-06-09 12:01:20','2020-06-09 12:01:20',18,4,NULL),
  (17,'ORIGINAL BPOM Focallure Single Color Face Blush Powder FA25 Blush On',116000,'Aplikasi halus mulus membuat wajah Anda tampak sehat dan bersinar sepanjang hari.\r\n-Perona pipi mewah yang menampilkan beragam warna\r\n-Blends Mulus.\r\nBubuk Finishing-Kilau',0,'2020-06-09 12:03:56','2020-06-09 12:03:56',15,4,NULL),
  (18,'NOVO CUTE ICE CREAM SHAPE LIP TINT',20000,'* The Liptint Yang Terbuat Dari Ekstrak Buah, Dapat Membantu Anda Membuat Pesona Rias Labial Yang Sempurna.\r\n* Anda Dapat Minum Atau Makan Tanpa Menyentuh, Karena liptint Ini Tahan Air Dan Tahan Lama Untuk Setidaknya 8 jam.\r\n* Sehat Untuk Tubuh Manusia Dan Tidak mengandung Aditif.',0,'2020-06-09 12:07:11','2020-06-12 04:50:35',18,5,NULL),
  (19,'EMINA Liptint',40000,'Hasil yang ringan dan menyegarkan, Lembut digunakan seperti mousse, dan Memberikan nutrisi dan kelembaban',0,'2020-06-09 12:15:05','2020-06-09 12:15:05',14,5,NULL),
  (20,'PERI\'S INK PERIPERA LIPTINT / LIP TINT PERI PERA',20000,'✔️ liptint dengan tekstur creamy yang lembut di bibir dengan warna intens sejak olesan pertama\r\n✔️ melembabkan, sehingga memberikan hasil matte tahan lama tanpa membuat bibir kering\r\n✔️ formula yang lembut dan ringan membuat bibir seperti tidak menggunakan apapun',0,'2020-06-09 12:17:33','2020-06-09 12:17:33',13,5,NULL),
  (21,'Maybelline Hypercurl Volum Express Mascara Hyper Curl Maskara',80000,'Maskara dengan formula waterproof, membuat bulu mata 3X lebih tebal, lebih lentik dari akar hingga ujung bulu mata, tahan hingga 18 jam memberikan tampilan bulu mata tampak lebih tebal dan panjang.',0,'2020-06-09 12:24:29','2020-06-09 12:24:29',20,4,NULL),
  (22,'Maskara Wardah Eyexpert',85000,'Wardah EyeXpertvolume Expert Mascara merupakan inovasi mascara wardah dengan kombinasi teknologi dan formulasi yang dapat menyempurnakan tampilan akhir bulu mata lebih bervolume, black intense color dan lentik sepanjang hari. Hasil aplikasi tidak mudah luntur dan menggumpal sehingga lebih tahan lama.',0,'2020-06-09 12:25:48','2020-06-09 12:25:48',21,7,NULL),
  (23,'ORIGINAL MAKE OVER ULTIMATE LASH MASCARA MAKEOVER MASKARA',148000,'* Menjadikan bulu mata terlihat tebal, lentik, cantik dan menawan\r\n* Formula waterproof, membuat maskara tahan lama\r\n* Mudah diaplikasikan tanpa menggumpal\r\n* Warna hitam yang lebih natural',0,'2020-06-09 12:27:32','2020-06-09 12:27:32',12,7,NULL),
  (24,'FOCALLURE Super Fine Loose Powder',100000,'Dapatkan wajah bercahaya, menyala dari dalam dengan bubuk penyempurnaan terlaris dari Sugar box. Bubuk penyempurnaan revolusioner yang secara dramatis meminimalkan tanda-tanda penuaan.',0,'2020-06-09 12:30:24','2020-06-09 12:30:24',20,7,NULL),
  (25,'Wardah Everyday Luminous Face Powder',42000,'Menghasilkan make up yang matte dan ringan. Terdiri dari butiran-butiran halus non comedogenic. Terdiri dari butiran-butiran halus non-comedogenic. Dapat digunakan setelah atau tanpa foundation, dan juga sebagai sentuhan akhir make-up.',0,'2020-06-09 12:33:49','2020-06-09 12:33:49',10,7,NULL),
  (26,'Maybelline The Blushed Nudes Eyeshadow Palette Eyes Make Up - Pink',200000,'Mudah diaplikasikan dan tahan lama. Anda bisa menggunakan berbagai pilihan warna pink yang feminin lengkap dengan brush untuk memudahkan pemakaian.Gunakan palet eyeshadow yang satu ini saat menghadiri acara maupun untuk pemakaian sehari-hari.',0,'2020-06-09 12:38:21','2020-06-09 12:38:21',8,8,NULL),
  (27,'FOCALLURE Eyeshadow Palette With Brush',150000,'Perpaduan indah dari beberapa warna Neutral-Glam yang Dapat Dipakai.\r\nKeseimbangan matte yang sempurna membuat penampilan anda maksimal',0,'2020-06-09 12:42:45','2020-06-09 15:51:16',5,14,NULL),
  (28,'Make Over Eyeshadow Palette',146000,'Palet eyeshadow dengan tekstur yang lembut sehingga nyaman saat diaplikasikan di kelopak mata. Formula yang mudah diblend untuk mendapatkan ragam riasan mata yang optimal. Tahan lama di kelopak mata dan crease resistant. Terdiri dari 8 warna netral dan earth-toned yang menawan yaitu warna Bone, Ivory Frost, Candy Rose, Champagne, Hot Stone, Copper, Espresso, dan Caviar. Warna-warna pilihan tersebut saling melengkapi dan bisa digunakan untuk highlight sudut dalam mata, highlight tulang alis, maupun mengisi warna alis.',0,'2020-06-09 12:44:43','2020-06-09 12:44:43',13,13,NULL),
  (29,'Naked Eyeshadow',100000,'Beauty Treats Naked Eyeshadow terdiri dalam 2 Varian, masing-masing terdiri 12 warna yang sangat menarik, kombinasi dari warna yang soft sampai warna dark. Warna tahan lama dan menempel semurna, serta sudah mendapatkan kuas dan kaca lohh, Beauties.',0,'2020-06-09 13:10:04','2020-06-09 13:10:04',10,14,NULL),
  (30,'Wardah Exclusive Eyeshadow Palette',99500,'Eyeshadow palette denga 8 warna yang intense dan tahan lama. Hasilkan beragam kombinasi warna eyeshadow untuk berbagai kebutuhan. Formulanya yang lembut menjadikan eyeshadow mudah diaplikasikan pada Kelopak Mata',0,'2020-06-09 13:12:10','2020-06-09 13:12:10',18,14,NULL),
  (31,'Eyeshadow Quad by YOU Makeups',55000,'Selling Point:\r\n1. Four Step Pratical Color\r\nWarna eyeshadow dalam 1 palette untuk menciptakan beragam tampilan sesuai keinginan.\r\n2. Rich Pigmentation\r\nMemiliki pigmentasi yang tinggi untuk riasan mata yang indah.\r\n2. Silky and Blendable\r\nMemiliki tekstur lembut yang mudah dibaurkan untuk hasil yang lebih optimal',0,'2020-06-09 13:14:27','2020-06-09 13:14:27',13,6,NULL),
  (32,'Dear Me Beauty Perfect Matte Eyeliner Black',89000,'Tunjukkan garis yang sempurna setiap saat dengan Perfect Matte Eyeliner, eyeliner cair yang terbuat dari pigmen hitam yang sangat pekat yang menghasilkan garis yang tahan lama dengan hasil warna yang intens.',0,'2020-06-09 13:16:54','2020-06-09 14:48:21',15,6,'2020-06-09 14:48:21'),
  (33,'NATURE REPUBLIC Micro Slim Fit Eyeliner',148000,'NATURE REPUBLIC MICRO SLIM FIT EYELINER 01 BLACK\r\n- 1.5mm micro pencil gives soft touch on eye area.\r\n- Gel type eyeliner lasts long and makes clear lines',0,'2020-06-09 13:20:45','2020-06-09 13:25:42',5,4,NULL),
  (34,'MIZZU - Eyeliner Perfect Wear',58000,'Dengan kuas pena yang lembut, eyeliner ini sangat cocok untuk pemula maupun profesional makeup artist. Eyeliner ini dapat membuat garis yang rapih dan tegas untuk membentuk mata Anda menjadi semakin indah.',0,'2020-06-09 14:52:19','2020-06-09 14:52:19',9,5,NULL),
  (35,'NYX Professional Makeup Can\'t Stop Won\'t Stop Liquid Foundation Make Up',158000,'Can\'t Stop Won\'t Stop adalah foundation yang memiliki hasil full coverage yang dapat menutupi flek, bekas jerawat, dan lingkaran hitam dibawah mata. Teruji ketahanannya selama 24 jam.\r\nTekstur yang ringan, sangat nyaman digunakan sepanjang hari. Hasil akhir matte dapat mencegah kilap dan minyak berlebih pada wajah.Cocok untuk segala jenis kulit.',0,'2020-06-09 14:55:57','2020-06-09 15:52:28',7,14,NULL);
  
  /*Table structure for table `provinces` */
  
  DROP TABLE IF EXISTS `provinces`;
  
  CREATE TABLE `provinces` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `province_id` int(10) unsigned NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `provinces` */
  
  insert  into `provinces`(`id`,`province_id`,`title`,`created_at`,`updated_at`) values 
  (1,1,'Bali','2020-05-04 16:15:22','2020-05-04 16:15:22'),
  (2,2,'Bangka Belitung','2020-05-04 16:15:23','2020-05-04 16:15:23'),
  (3,3,'Banten','2020-05-04 16:15:26','2020-05-04 16:15:26'),
  (4,4,'Bengkulu','2020-05-04 16:15:29','2020-05-04 16:15:29'),
  (5,5,'DI Yogyakarta','2020-05-04 16:15:30','2020-05-04 16:15:30'),
  (6,6,'DKI Jakarta','2020-05-04 16:15:33','2020-05-04 16:15:33'),
  (7,7,'Gorontalo','2020-05-04 16:15:36','2020-05-04 16:15:36'),
  (8,8,'Jambi','2020-05-04 16:15:37','2020-05-04 16:15:37'),
  (9,9,'Jawa Barat','2020-05-04 16:15:40','2020-05-04 16:15:40'),
  (10,10,'Jawa Tengah','2020-05-04 16:15:44','2020-05-04 16:15:44'),
  (11,11,'Jawa Timur','2020-05-04 16:15:57','2020-05-04 16:15:57'),
  (12,12,'Kalimantan Barat','2020-05-04 16:16:01','2020-05-04 16:16:01'),
  (13,13,'Kalimantan Selatan','2020-05-04 16:16:03','2020-05-04 16:16:03'),
  (14,14,'Kalimantan Tengah','2020-05-04 16:16:05','2020-05-04 16:16:05'),
  (15,15,'Kalimantan Timur','2020-05-04 16:16:07','2020-05-04 16:16:07'),
  (16,16,'Kalimantan Utara','2020-05-04 16:16:10','2020-05-04 16:16:10'),
  (17,17,'Kepulauan Riau','2020-05-04 16:16:12','2020-05-04 16:16:12'),
  (18,18,'Lampung','2020-05-04 16:16:15','2020-05-04 16:16:15'),
  (19,19,'Maluku','2020-05-04 16:16:17','2020-05-04 16:16:17'),
  (20,20,'Maluku Utara','2020-05-04 16:16:19','2020-05-04 16:16:19'),
  (21,21,'Nanggroe Aceh Darussalam (NAD)','2020-05-04 16:16:22','2020-05-04 16:16:22'),
  (22,22,'Nusa Tenggara Barat (NTB)','2020-05-04 16:16:25','2020-05-04 16:16:25'),
  (23,23,'Nusa Tenggara Timur (NTT)','2020-05-04 16:16:29','2020-05-04 16:16:29'),
  (24,24,'Papua','2020-05-04 16:16:35','2020-05-04 16:16:35'),
  (25,25,'Papua Barat','2020-05-04 16:16:45','2020-05-04 16:16:45'),
  (26,26,'Riau','2020-05-04 16:17:09','2020-05-04 16:17:09'),
  (27,27,'Sulawesi Barat','2020-05-04 16:17:10','2020-05-04 16:17:10'),
  (28,28,'Sulawesi Selatan','2020-05-04 16:17:12','2020-05-04 16:17:12'),
  (29,29,'Sulawesi Tengah','2020-05-04 16:17:17','2020-05-04 16:17:17'),
  (30,30,'Sulawesi Tenggara','2020-05-04 16:17:20','2020-05-04 16:17:20'),
  (31,31,'Sulawesi Utara','2020-05-04 16:17:23','2020-05-04 16:17:23'),
  (32,32,'Sumatera Barat','2020-05-04 16:17:32','2020-05-04 16:17:32'),
  (33,33,'Sumatera Selatan','2020-05-04 16:18:00','2020-05-04 16:18:00'),
  (34,34,'Sumatera Utara','2020-05-04 16:18:03','2020-05-04 16:18:03');
  
  /*Table structure for table `response` */
  
  DROP TABLE IF EXISTS `response`;
  
  CREATE TABLE `response` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `review_id` int(10) unsigned NOT NULL,
    `admin_id` int(10) unsigned NOT NULL,
    `content` text NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    KEY `review_id` (`review_id`),
    KEY `admin_id` (`admin_id`),
    CONSTRAINT `response_ibfk_1` FOREIGN KEY (`review_id`) REFERENCES `product_reviews` (`id`),
    CONSTRAINT `response_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  
  /*Data for the table `response` */
  
  insert  into `response`(`id`,`review_id`,`admin_id`,`content`,`created_at`,`updated_at`) values 
  (1,1,1,'Terimakasih telah berbelanja','2020-06-08 10:46:29','2020-06-08 10:46:29'),
  (2,2,1,'Terimakasih telah berbelanja','2020-06-08 18:31:33','2020-06-08 18:31:33'),
  (3,2,1,'Terimakasih telah berbelanja','2020-06-08 18:31:43','2020-06-08 18:31:43'),
  (4,3,1,'Terimakasih telah berbelanja','2020-06-11 04:00:57','2020-06-11 04:00:57'),
  (5,4,1,'Terimakasih telah berbelanja','2020-06-12 07:16:32','2020-06-12 07:16:32');
  
  /*Table structure for table `transaction_details` */
  
  DROP TABLE IF EXISTS `transaction_details`;
  
  CREATE TABLE `transaction_details` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `transaction_id` int(10) unsigned NOT NULL,
    `product_id` int(10) unsigned NOT NULL,
    `qty` int(11) NOT NULL,
    `discount` int(3) DEFAULT NULL,
    `selling_price` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `id_transaction` (`transaction_id`),
    KEY `id_product` (`product_id`),
    CONSTRAINT `transaction_details_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`),
    CONSTRAINT `transaction_details_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `transaction_details` */
  
  insert  into `transaction_details`(`id`,`transaction_id`,`product_id`,`qty`,`discount`,`selling_price`,`created_at`,`updated_at`) values 
  (1,1,1,1,0,30000,'2020-06-08 18:13:15','2020-06-08 18:13:15'),
  (2,2,1,1,0,30000,'2020-06-08 18:34:38','2020-06-08 18:34:38'),
  (3,3,1,1,0,30000,'2020-06-08 20:07:36','2020-06-08 20:07:36'),
  (4,4,2,1,20,70000,'2020-06-09 00:45:44','2020-06-09 00:45:44'),
  (5,5,2,3,20,70000,'2020-06-09 13:20:10','2020-06-09 13:20:10'),
  (6,6,1,1,0,30000,'2020-06-09 13:23:30','2020-06-09 13:23:30'),
  (7,7,1,1,0,30000,'2020-06-09 13:32:55','2020-06-09 13:32:55'),
  (8,8,10,4,0,49500,'2020-06-10 05:51:30','2020-06-10 05:51:30'),
  (9,8,6,5,15,120000,'2020-06-10 05:51:31','2020-06-10 05:51:31'),
  (10,9,2,1,20,70000,'2020-06-11 11:19:31','2020-06-11 11:19:31'),
  (11,10,4,5,40,95760,'2020-06-12 12:41:16','2020-06-12 12:41:16'),
  (12,10,8,6,0,83700,'2020-06-12 12:41:16','2020-06-12 12:41:16'),
  (13,11,18,1,0,20000,'2020-06-12 12:48:59','2020-06-12 12:48:59'),
  (14,12,7,1,40,94998,'2020-06-12 15:10:45','2020-06-12 15:10:45'),
  (15,13,2,1,20,70000,'2020-06-12 15:18:30','2020-06-12 15:18:30');
  
  /*Table structure for table `transactions` */
  
  DROP TABLE IF EXISTS `transactions`;
  
  CREATE TABLE `transactions` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `timeout` datetime NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `regency` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `province` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `total` double(12,2) NOT NULL,
    `shipping_cost` double(12,2) NOT NULL,
    `sub_total` double(12,2) NOT NULL,
    `user_id` int(20) unsigned NOT NULL,
    `courier_id` int(10) unsigned NOT NULL,
    `proof_of_payment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `status` enum('unverified','verified','delivered','success','expired','canceled') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `telp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `courier_id` (`courier_id`),
    KEY `user_id` (`user_id`),
    CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`courier_id`) REFERENCES `couriers` (`id`),
    CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `transactions` */
  
  insert  into `transactions`(`id`,`timeout`,`address`,`regency`,`province`,`total`,`shipping_cost`,`sub_total`,`user_id`,`courier_id`,`proof_of_payment`,`created_at`,`updated_at`,`status`,`telp`) values 
  (1,'2020-06-09 18:13:15','Jalan Danau Poso No 31 Sanur','Bulungan (Bulongan)','Kalimantan Utara',81000.00,51000.00,30000.00,14,1,'1591611216_home_slider.jpg','2020-06-08 18:13:15','2020-06-08 10:41:55','success','081246873224'),
  (2,'2020-06-09 18:34:38','Jalan Danau Poso No 31 Sanur','Bulungan (Bulongan)','Kalimantan Utara',84000.00,54000.00,30000.00,14,2,NULL,'2020-06-08 18:34:38','2020-06-08 10:59:07','canceled','081246873224'),
  (3,'2020-06-09 20:07:35','Jalan Danau Poso No 31 Sanur','Gorontalo Utara','Gorontalo',102000.00,72000.00,30000.00,14,2,'1591637337_IMG_9383.JPG','2020-06-08 20:07:35','2020-06-08 17:52:14','success','081246873224'),
  (4,'2020-06-10 00:45:44','Jalan Danau Poso No 31 Sanur','Lingga','Kepulauan Riau',98000.00,42000.00,56000.00,17,1,'1591634768_IMG_9830.jpg','2020-06-09 00:45:44','2020-06-08 17:02:55','success','081246873234'),
  (5,'2020-06-10 13:20:10','Jalan Danau Poso No 31 Zimbabwe','Pringsewu','Lampung',95000.00,39000.00,56000.00,14,2,'1591680041_3. snap info kubernetes.png','2020-06-09 13:20:10','2020-06-09 05:22:28','success','081246873224'),
  (6,'2020-06-10 13:23:30','Jalan Danau Poso No 31 Sanur','Nunukan','Kalimantan Utara',99000.00,69000.00,30000.00,14,3,'1591680221_4. kubernetes status.png','2020-06-09 13:23:30','2020-06-09 05:24:30','success','081246873234'),
  (7,'2020-06-10 13:32:55','Jalan Danau Poso No 31 Sanur','Boalemo','Gorontalo',98000.00,68000.00,30000.00,14,3,NULL,'2020-06-09 13:32:55','2020-06-09 05:33:25','canceled','081246873234'),
  (8,'2020-06-10 14:13:35','Jalan Danau Poso No 31 Sanur','Bandar Lampung','Lampung',287500.00,37000.00,250500.00,14,2,NULL,'2020-06-10 05:51:28','2020-06-10 05:51:28','unverified','081246873224'),
  (9,'2020-06-12 01:13:28','Jalan Siulan','Ambon','Maluku',106000.00,50000.00,56000.00,15,1,'1591845595_IMG_9830.jpg','2020-06-11 11:19:28','2020-06-11 03:39:21','success','081246873224'),
  (10,'2020-06-13 12:41:16','Jalan Danau Poso No 31 Sanur','Tulang Bawang Barat','Lampung',843480.00,54000.00,789480.00,20,1,'1591937018_set ip host only win.png','2020-06-12 12:41:16','2020-06-12 04:44:18','success','081246873234'),
  (11,'2020-06-13 12:48:58','Jalan Danau Poso No 31 Sanur','Batam','Kepulauan Riau',74000.00,54000.00,20000.00,20,2,'1591937402_ip windows.png','2020-05-21 12:48:58','2020-06-12 04:50:40','delivered','081246873224'),
  (12,'2020-06-13 15:10:45','Jalan Danau Poso No 31 Sanur','Kuningan','Jawa Barat',106998.80,50000.00,56998.80,20,1,'1591945884_ip windows.png','2019-06-12 15:10:45','2020-06-12 07:13:20','success','081246873224'),
  (13,'2020-06-13 15:18:30','Jalan Danau Poso No 31 Sanur','Denpasar','Bali',106000.00,50000.00,56000.00,20,1,NULL,'2020-06-12 15:18:30','2020-06-12 07:18:50','canceled','081246873224');
  
  /*Table structure for table `user_notifications` */
  
  DROP TABLE IF EXISTS `user_notifications`;
  
  CREATE TABLE `user_notifications` (
    `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_id` int(11) unsigned NOT NULL,
    `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `read_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `user_notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`),
    KEY `notifiable_id` (`notifiable_id`),
    CONSTRAINT `user_notifications_ibfk_1` FOREIGN KEY (`notifiable_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `user_notifications` */
  
  insert  into `user_notifications`(`id`,`type`,`notifiable_type`,`notifiable_id`,`data`,`read_at`,`created_at`,`updated_at`) values 
  ('1577fbfb-bc3e-4d2b-85b8-86e6c8289335','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/13\'>Status Transaksimu dengan id 13 telah diupdate</a>',NULL,'2020-06-12 07:18:50','2020-06-12 07:18:50'),
  ('2447e7e8-b94c-4b38-9c41-348fa221b7cb','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/5\'>Status Transaksimu dengan id 5 telah diupdate</a>','2020-06-09 05:24:35','2020-06-09 05:22:27','2020-06-09 05:24:35'),
  ('32e71fc8-211b-4503-9ee6-924174da5937','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/6\'>Status Transaksimu dengan id 6 telah diupdate</a>','2020-06-09 05:24:35','2020-06-09 05:24:11','2020-06-09 05:24:35'),
  ('3d1c0e24-f853-4e4f-9156-c0191fc09bc3','App\\Notifications\\UserNotification','App\\User',17,'<a href =\'/transaksi/detail/4\'>Status Transaksimu dengan id 4 telah diupdate</a>',NULL,'2020-06-08 17:02:55','2020-06-08 17:02:55'),
  ('44b46982-cea8-448c-8050-bd6407a49415','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/11\'>Status Transaksimu dengan id 11 telah diupdate</a>','2020-06-12 07:08:58','2020-06-12 04:50:40','2020-06-12 07:08:58'),
  ('486ab5e0-9987-43f0-9045-d76aeb00f5e5','App\\Notifications\\UserNotification','App\\User',17,'<a href =\'/product/2\'>Reviewmu di produk Oriflame Brush telah direspon oleh admin</a>',NULL,'2020-06-08 18:31:34','2020-06-08 18:31:34'),
  ('4915d5f8-f8a9-4b16-98f6-317d66b9fff5','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/2\'>Status Transaksimu dengan id 2 telah diupdate</a>','2020-06-08 12:01:06','2020-06-08 10:59:07','2020-06-08 12:01:06'),
  ('4e5c215c-1b6c-4a7c-bc1b-9b595242588b','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/10\'>Status Transaksimu dengan id 10 telah diupdate</a>','2020-06-12 04:45:26','2020-06-12 04:44:18','2020-06-12 04:45:26'),
  ('50683801-bf3a-4f3c-98c8-c07198db20e5','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/5\'>Status Transaksimu dengan id 5 telah diupdate</a>','2020-06-09 05:24:35','2020-06-09 05:21:57','2020-06-09 05:24:35'),
  ('5176989d-c0a2-44e2-9ed7-f103bf179b31','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/1\'>Status Transaksimu dengan id 1 telah diupdate</a>','2020-06-08 10:44:42','2020-06-08 10:41:55','2020-06-08 10:44:42'),
  ('53515ba3-adfc-4b7c-a515-8b93b167a0ac','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/12\'>Status Transaksimu dengan id 12 telah diupdate</a>','2020-06-12 07:17:29','2020-06-12 07:12:08','2020-06-12 07:17:29'),
  ('5633ee13-efd7-4719-ae80-f18b00cae8d9','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/3\'>Status Transaksimu dengan id 3 telah diupdate</a>','2020-06-08 18:21:04','2020-06-08 17:51:14','2020-06-08 18:21:04'),
  ('59bd0e44-7ed4-4c93-b58b-8878381743d2','App\\Notifications\\UserNotification','App\\User',15,'<a href =\'/product/2\'>Reviewmu di produk Oriflame Brush telah direspon oleh admin</a>','2020-06-11 04:26:20','2020-06-11 04:00:57','2020-06-11 04:26:20'),
  ('640dfa0a-3e13-412f-baef-67b1f7b6e8ca','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/12\'>Status Transaksimu dengan id 12 telah diupdate</a>','2020-06-12 07:17:29','2020-06-12 07:13:20','2020-06-12 07:17:29'),
  ('64597bf1-dd4b-4bde-9c2d-b9dfa8c6f544','App\\Notifications\\UserNotification','App\\User',17,'<a href =\'/transaksi/detail/4\'>Status Transaksimu dengan id 4 telah diupdate</a>',NULL,'2020-06-08 17:01:06','2020-06-08 17:01:06'),
  ('77a56472-a158-4eaf-91b2-16adfc4f626a','App\\Notifications\\UserNotification','App\\User',15,'<a href =\'/transaksi/detail/9\'>Status Transaksimu dengan id 9 telah diupdate</a>','2020-06-11 04:26:20','2020-06-11 03:21:31','2020-06-11 04:26:20'),
  ('81b7cf34-ed30-4364-85bf-336037b6c685','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/5\'>Status Transaksimu dengan id 5 telah diupdate</a>','2020-06-09 05:24:35','2020-06-09 05:22:01','2020-06-09 05:24:35'),
  ('82953df0-1aa0-4bfa-be5d-8618723f9b2d','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/1\'>Status Transaksimu dengan id 1 telah diupdate</a>','2020-06-08 10:44:42','2020-06-08 10:24:10','2020-06-08 10:44:42'),
  ('833369c8-b943-423d-90de-a273322f7812','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/6\'>Status Transaksimu dengan id 6 telah diupdate</a>','2020-06-09 05:24:35','2020-06-09 05:24:18','2020-06-09 05:24:35'),
  ('8b687ea8-568e-44b1-bff0-239e6fc9e040','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/10\'>Status Transaksimu dengan id 10 telah diupdate</a>','2020-06-12 04:45:26','2020-06-12 04:44:02','2020-06-12 04:45:26'),
  ('986d2c61-4bf2-4f0e-a509-89293f5c070f','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/3\'>Status Transaksimu dengan id 3 telah diupdate</a>','2020-06-08 18:21:04','2020-06-08 17:48:50','2020-06-08 18:21:04'),
  ('9a7d1327-b1d8-4555-b4a3-ffba243a0fbb','App\\Notifications\\UserNotification','App\\User',17,'<a href =\'/transaksi/detail/4\'>Status Transaksimu dengan id 4 telah diupdate</a>',NULL,'2020-06-08 17:02:39','2020-06-08 17:02:39'),
  ('9d63558a-1926-4ce2-834e-d96f58b85b25','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/3\'>Status Transaksimu dengan id 3 telah diupdate</a>','2020-06-08 18:21:04','2020-06-08 17:52:14','2020-06-08 18:21:04'),
  ('a11258b4-d6f8-4fa9-a6ca-438f4b96a7f8','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/1\'>Status Transaksimu dengan id 1 telah diupdate</a>','2020-06-08 10:44:42','2020-06-08 10:24:04','2020-06-08 10:44:42'),
  ('ac2a1074-b161-40b5-86b4-9e6685c5e9fc','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/12\'>Status Transaksimu dengan id 12 telah diupdate</a>','2020-06-12 07:17:29','2020-06-12 07:12:57','2020-06-12 07:17:29'),
  ('aceadc6a-89c6-4cae-b033-6934cfe0583e','App\\Notifications\\UserNotification','App\\User',15,'<a href =\'/transaksi/detail/9\'>Status Transaksimu dengan id 9 telah diupdate</a>','2020-06-11 04:26:20','2020-06-11 03:22:58','2020-06-11 04:26:20'),
  ('c228f5f1-3638-415c-8732-b7eab2de8e43','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/6\'>Status Transaksimu dengan id 6 telah diupdate</a>','2020-06-09 05:24:35','2020-06-09 05:24:30','2020-06-09 05:24:35'),
  ('ccc2c6df-7ee4-4f2e-8f5f-340104b67c3d','App\\Notifications\\UserNotification','App\\User',17,'<a href =\'/product/2\'>Reviewmu di produk Oriflame Brush telah direspon oleh admin</a>',NULL,'2020-06-08 18:31:43','2020-06-08 18:31:43'),
  ('d61001ea-18bc-4bf9-9fb6-0bf672ba2393','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/11\'>Status Transaksimu dengan id 11 telah diupdate</a>','2020-06-12 07:08:58','2020-06-12 04:50:35','2020-06-12 07:08:58'),
  ('d952ed5a-bc96-4281-b817-55794e6a5e9b','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/transaksi/detail/10\'>Status Transaksimu dengan id 10 telah diupdate</a>','2020-06-12 04:45:26','2020-06-12 04:44:07','2020-06-12 04:45:26'),
  ('e3ee7f1c-9938-4099-aaff-0ae1e0906b4b','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/product/1\'>Reviewmu di produk Wardah Liptint telah direspon oleh admin</a>','2020-06-08 10:58:06','2020-06-08 10:46:29','2020-06-08 10:58:06'),
  ('e8cf6c00-1693-4af7-b210-94b2ce79bbae','App\\Notifications\\UserNotification','App\\User',14,'<a href =\'/transaksi/detail/7\'>Status Transaksimu dengan id 7 telah diupdate</a>','2020-06-09 06:24:36','2020-06-09 05:33:25','2020-06-09 06:24:36'),
  ('fb44e74c-b0a7-4910-bc68-e4027b99ffab','App\\Notifications\\UserNotification','App\\User',15,'<a href =\'/transaksi/detail/9\'>Status Transaksimu dengan id 9 telah diupdate</a>','2020-06-11 04:26:20','2020-06-11 03:39:21','2020-06-11 04:26:20'),
  ('fc945ae1-d71c-4828-afdf-c3a573b3c1f6','App\\Notifications\\UserNotification','App\\User',20,'<a href =\'/product/7\'>Reviewmu di produk NOVO Krim Concealer Cair Ringan telah direspon oleh admin</a>','2020-06-12 07:17:29','2020-06-12 07:16:32','2020-06-12 07:17:29');
  
  /*Table structure for table `users` */
  
  DROP TABLE IF EXISTS `users`;
  
  CREATE TABLE `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `profile_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  /*Data for the table `users` */
  
  insert  into `users`(`id`,`name`,`email`,`profile_image`,`status`,`email_verified_at`,`password`,`remember_token`,`created_at`,`updated_at`,`deleted_at`) values 
  (14,'Gusna Richman','gusnarichm@gmail.com','def.png','Sudah Terdaftar','2020-06-07 13:39:13','$2y$10$URXL/YojAJGlgoHHkWiSEOiiFahIRugE9IUuFPeSmnsii4jsSQmkO','jV3SO8U2KfkN4jz9szxgJ51HBuFEqiF5vpXD7WAwIoLmVCN1HHau1xJCh5MV','2020-06-07 13:38:36','2020-06-08 10:51:14',NULL),
  (15,'Agus Guna Saputra','gusnarichman3@gmail.com','def.png','Sudah Terdaftar','2020-06-08 18:29:02','$2y$10$f7cHKGalc3PsntEwh/2Uze773TByjUG8SNasj2LPEb2sCWSoipZxm',NULL,'2020-06-08 10:26:27','2020-06-08 10:26:27',NULL),
  (16,'Guna Saputra','gugu@nana.lk','def.png','Sudah Terdaftar',NULL,'$2y$10$6ghwW/FIxNW26mtBBh7X3eWNuPpCiFKjsBCZiW28xxS4e5ZIQyR8e',NULL,'2020-06-08 15:28:16','2020-06-08 15:28:16',NULL),
  (17,'I Made Agus Guna Saputra','gusnarichman2@gmail.com','1591634541.JPG','Sudah Terdaftar','2020-06-09 00:40:32','$2y$10$AnDrGeoGCvCnC3MVIpbFBOqjTV2Mmbjcufj7aZUM2izPxc6GSXllq',NULL,'2020-06-08 16:38:25','2020-06-08 16:42:23',NULL),
  (18,'asdgaskdg','testing12@dash.coma','def.png','Sudah Terdaftar',NULL,'$2y$10$u5aDyu5tAoqUvHHdOfHzCePm1T1Yg7Ti40thKSfZtj9fK02QQtSOK',NULL,'2020-06-08 17:20:51','2020-06-08 17:20:51',NULL),
  (19,'Doddy','doddy@pratama.com','def.png','Sudah Terdaftar',NULL,'$2y$10$2/9Ko84QzjFnFdUB7u/kDeDvu7Sca2VhXdEZeQ/.h7V9Dzdrd6tpO',NULL,'2020-06-10 12:33:58','2020-06-10 12:33:58',NULL),
  (20,'Kedukk','bincrackerguna10@gmail.com','def.png','Sudah Terdaftar','2020-06-12 04:15:56','$2y$10$.4ffbvFVouPdXlV8s6lvpuykOgkpDtCpvPN4snvWTTK8r6SsXSAKO',NULL,'2020-06-12 04:14:49','2020-06-12 04:15:56',NULL),
  (21,'Yunia','gusnarichman@gmail.com','def.png','Sudah Terdaftar','2020-06-12 07:32:23','$2y$10$Ize2rRkMtqsQQP9cCxdhceFw6fEOQFZfhS0vUT1RUemb1ughpUQJW',NULL,'2020-06-12 07:31:21','2020-06-12 07:32:23',NULL),
  (22,'Bebebebe','sebotis151@uxdes54.com','def.png','Sudah Terdaftar','2020-06-15 17:18:37','$2y$10$DAqajkbsjg6W7EmoWtMoluqB6/r6xbu2M8fp5lKkBYk3QOG/IAXp2',NULL,'2020-06-15 17:17:56','2020-06-15 17:18:37',NULL),
  (23,'beyak','bezer73@bebe.com','def.png','Sudah Terdaftar',NULL,'$2y$10$uujZGENY7mAYxn7/Uus7HONWV4ELLP7arUtv2Uq4iZSkQD4DH8u56',NULL,'2020-06-15 17:19:11','2020-06-15 17:19:11',NULL);
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  