text: -- MariaDB dump 10.17  Distrib 10.5.5-MariaDB, for osx10.15 (x86_64)
  --
  -- Host: 127.0.0.1    Database: projek
  -- ------------------------------------------------------
  -- Server version	10.5.5-MariaDB
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!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 */;
  
  --
  -- Table structure for table `tb_alamat`
  --
  
  DROP TABLE IF EXISTS `tb_alamat`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_alamat` (
    `id_alamat` int(11) NOT NULL AUTO_INCREMENT,
    `id_pembeli` int(11) NOT NULL,
    `alamat_lengkap` text NOT NULL,
    `rincian_alamat` text NOT NULL,
    `lat` varchar(20) NOT NULL,
    `long` varchar(20) NOT NULL,
    PRIMARY KEY (`id_alamat`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_alamat`
  --
  
  LOCK TABLES `tb_alamat` WRITE;
  /*!40000 ALTER TABLE `tb_alamat` DISABLE KEYS */;
  INSERT INTO `tb_alamat` VALUES (1,1,'Jalan Dua Mas Putra','Kosan berwarna Abu-abu','-3.7550099','114.7662845'),(4,3,'Jln. Bina Bersama RT.02 RW.01 Desa Sarikandi Kec. Kurau','Didepan rumah yang ada pohon beringin','-3.6055826','114.6971873'),(5,3,'Jln. Dua Mas Putra','Kosan warna abu-abu','-3.6055826','114.6971873'),(6,-1,'Pelaihari Pelaihari,Tanah Laut Regency,South Kalimantan,Indonesia','Deket Tembok','-3.7901775','114.7380385'),(7,-1,' E9,Belimbing Baru,Sungai Pinang,Banjar,Kalimantan Selatan,Indonesia,70675','','-3.0926522132106093','115.28377995767212'),(8,25,'Teras Teras,Boyolali Regency,Central Java,Indonesia','','-7.540383299999998','110.6586087'),(9,25,'Angsau Angsau,Pelaihari,Tanah Laut Regency,South Kalimantan,Indonesia','','-3.7935672','114.7795914'),(10,19,'Pelaihari Pelaihari,Tanah Laut Regency,South Kalimantan,Indonesia','Mantap','-3.7901775','114.7380385'),(11,28,' 52,Jalan Ahmad Yani,Angsau,Kecamatan Pelaihari,Kabupaten Tanah Laut,Kalimantan Selatan,Indonesia,70812','','3.789029199999999','114.776061'),(12,29,' Unnamed Road,Pabahanan,Kecamatan Pelaihari,Kabupaten Tanah Laut,Kalimantan Selatan,Indonesia,70815','','3.772699599999999','114.771341');
  /*!40000 ALTER TABLE `tb_alamat` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_kategori`
  --
  
  DROP TABLE IF EXISTS `tb_kategori`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_kategori` (
    `id_kategori` int(11) NOT NULL AUTO_INCREMENT,
    `nama_kategori` varchar(50) NOT NULL,
    `slug` varchar(50) NOT NULL,
    `icon` varchar(20) NOT NULL,
    PRIMARY KEY (`id_kategori`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_kategori`
  --
  
  LOCK TABLES `tb_kategori` WRITE;
  /*!40000 ALTER TABLE `tb_kategori` DISABLE KEYS */;
  INSERT INTO `tb_kategori` VALUES (1,'Makanan','makanan','8.svg'),(2,'Minuman','minuman','5.svg'),(3,'Pakaian','pakaian','7.svg'),(4,'Seafood','Seafood','4.svg'),(6,'Minuman Es','minuman-es','1.svg'),(7,'Minuman Dingin','minuman-dingin','1.svg');
  /*!40000 ALTER TABLE `tb_kategori` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_medsos`
  --
  
  DROP TABLE IF EXISTS `tb_medsos`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_medsos` (
    `id_medsos` int(11) NOT NULL AUTO_INCREMENT,
    `medsos` varchar(50) NOT NULL,
    `url` text NOT NULL,
    `icon` text NOT NULL,
    PRIMARY KEY (`id_medsos`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_medsos`
  --
  
  LOCK TABLES `tb_medsos` WRITE;
  /*!40000 ALTER TABLE `tb_medsos` DISABLE KEYS */;
  INSERT INTO `tb_medsos` VALUES (3,'Instagram','https://www.instagram.com/adiguna152/','instagram.svg'),(4,'Facebook','https://www.facebook.com/msadiguna.fromsarikandi','Facebook.svg'),(5,'WhatApps','https://api.whatsapp.com/send?phone=6285245462842','WhatsApp.svg'),(6,'line','line.com','instagram.svg');
  /*!40000 ALTER TABLE `tb_medsos` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_pembayaran`
  --
  
  DROP TABLE IF EXISTS `tb_pembayaran`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_pembayaran` (
    `id_pembayaran` int(11) NOT NULL AUTO_INCREMENT,
    `kode_pembayaran` varchar(50) DEFAULT NULL,
    `id_pesanan` int(11) NOT NULL,
    `jenis_pembayaran` varchar(20) NOT NULL,
    `tanggal_pembayaran` datetime DEFAULT current_timestamp(),
    `status_pembayaran` varchar(20) NOT NULL,
    `checkout_url` text DEFAULT NULL,
    `account_number` varchar(255) DEFAULT NULL,
    `expired_pembayaran` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id_pembayaran`)
  ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_pembayaran`
  --
  
  LOCK TABLES `tb_pembayaran` WRITE;
  /*!40000 ALTER TABLE `tb_pembayaran` DISABLE KEYS */;
  INSERT INTO `tb_pembayaran` VALUES (2,'ovo-ewallet-1603353604-1678811808',11,'OVO','2020-10-22 08:00:06','PENDING',NULL,NULL,NULL),(3,'linkaja-ewallet-1603355509-1835002799',12,'LINKAJA','2020-10-22 08:31:51','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/d88131e1-bba4-4aca-96ed-865ce0939563',NULL,NULL),(4,'linkaja-ewallet-1603355541-1503702071',13,'LINKAJA','2020-10-22 08:32:23','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/f897932a-802e-4625-945e-daf836728fe7',NULL,NULL),(5,'linkaja-ewallet-1603355616-337973535',14,'LINKAJA','2020-10-22 08:33:37','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/8e316c4f-616c-400f-a1ea-4ecca369d1b6',NULL,NULL),(6,'linkaja-ewallet-1603355804-428871190',15,'LINKAJA','2020-10-22 08:36:46','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/db1c7e69-7114-4681-8abe-532292566d63',NULL,NULL),(7,'linkaja-ewallet-1603356458-1907025393',16,'LINKAJA','2020-10-22 08:47:40','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/475e0563-7041-45b1-9fdb-9b249d287133',NULL,NULL),(8,'linkaja-ewallet-1603356843-1365151914',17,'LINKAJA','2020-10-22 08:54:34','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/08d5c334-0769-4f5c-9329-e80857a4e712',NULL,NULL),(9,'linkaja-ewallet-1603356991-468288546',18,'LINKAJA','2020-10-22 08:56:33','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/e96aa788-34cb-48c3-9746-e411543be9b4',NULL,NULL),(10,'linkaja-ewallet-1603357077-525615870',19,'LINKAJA','2020-10-22 08:57:58','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/ff65b337-04ba-4476-b2c2-c61e097a6674',NULL,NULL),(11,'linkaja-ewallet-1603357153-1330922297',20,'LINKAJA','2020-10-22 08:59:16','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/6b8fa48c-7c66-40a5-a6e8-eccc92940c47',NULL,NULL),(12,'linkaja-ewallet-1603357246-1529388928',21,'LINKAJA','2020-10-22 09:00:48','FAILED','https://ewallet-linkaja-dev.xendit.co/checkouts/9c0ef706-d30b-49bd-8fea-f148f4ebbe44',NULL,NULL),(13,'linkaja-ewallet-1603357328-2046577849',22,'LINKAJA','2020-10-22 09:02:09','SUCCESS_COMPLETED','https://ewallet-linkaja-dev.xendit.co/checkouts/8c1bcc79-da55-438c-a814-a80c6a2a22e4',NULL,NULL),(14,'linkaja-ewallet-1603357407-211544931',23,'LINKAJA','2020-10-22 09:03:59','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/9b2ed3d7-6419-4d6d-a278-aa3ab694d9bd',NULL,NULL),(15,'linkaja-ewallet-1603358237-418767827',24,'LINKAJA','2020-10-22 09:17:19','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/7385dd23-7457-4b0a-b00d-2e2276ec7b36',NULL,NULL),(16,'linkaja-ewallet-1603358286-266686618',25,'LINKAJA','2020-10-22 09:18:08','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/14ab5201-7752-4aa2-bb74-158e56d71b13',NULL,NULL),(17,'linkaja-ewallet-1603358304-110029616',26,'LINKAJA','2020-10-22 09:18:26','SUCCESS_COMPLETED','https://ewallet-linkaja-dev.xendit.co/checkouts/32b11f6b-3648-47ad-ab9d-0b7a2ec22e30',NULL,NULL),(18,'linkaja-ewallet-1603358322-1683245877',27,'LINKAJA','2020-10-22 09:18:44','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/ce3b8c1d-b3ff-45c2-906e-8e562ec5c01e',NULL,NULL),(19,'linkaja-ewallet-1603358351-1071062616',28,'LINKAJA','2020-10-22 09:19:13','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/5532e614-7763-40e8-ab29-e3a10525bbef',NULL,NULL),(20,'linkaja-ewallet-1603358367-1321709855',29,'LINKAJA','2020-10-22 09:19:29','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/ef588b77-0bcb-4e62-af44-1cc1095703a1',NULL,NULL),(21,'linkaja-ewallet-1603358377-1272838503',30,'LINKAJA','2020-10-22 09:20:09','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/a42b7fe7-d3e5-471f-90ac-08ac45b24a69',NULL,NULL),(22,'linkaja-ewallet-1603358471-454390012',31,'LINKAJA','2020-10-22 09:21:13','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/4b3e7a8b-c996-423c-8cc4-c89de87200e3',NULL,NULL),(23,'linkaja-ewallet-1603358491-1140602723',32,'LINKAJA','2020-10-22 09:21:33','PENDING','https://ewallet-linkaja-dev.xendit.co/checkouts/66d11609-ade3-4790-aa48-e230888d24b5',NULL,NULL),(24,'ovo-ewallet-1603358555-569895606',33,'OVO','2020-10-22 09:22:37','COMPLETED','NULL',NULL,NULL),(25,'ovo-ewallet-1603360190-1654037261',34,'OVO','2020-10-22 09:49:51','COMPLETED','NULL',NULL,NULL),(26,'MANDIRI-bank1603360483-1210423251',36,'MANDIRI','2020-10-22 09:54:44','PENDING',NULL,'889089999675676','2051-10-21T17:00:00.000Z'),(27,'MANDIRI-bank1603360618-1496816200',37,'MANDIRI','2020-10-22 09:56:59','PENDING',NULL,'889089999519457','2051-10-21T17:00:00.000Z'),(28,'MANDIRI-bank1603360829-94812040',38,'MANDIRI','2020-10-22 10:00:31','PENDING',NULL,'889089999360261','2051-10-21T17:00:00.000Z'),(29,'MANDIRI-bank1603360838-1974337923',39,'MANDIRI','2020-10-22 10:00:39','PENDING',NULL,'889089999746862','2051-10-21T17:00:00.000Z'),(30,'MANDIRI-bank1603360846-335712828',40,'MANDIRI','2020-10-22 10:00:47','SUCCESS',NULL,'889089999735519','2051-10-21T17:00:00.000Z'),(31,'MANDIRI-bank1603360857-1621083648',41,'MANDIRI','2020-10-22 10:00:58','PENDING',NULL,'889089999755466','2051-10-21T17:00:00.000Z'),(32,'BCA-bank1603363342-661343236',42,'COD','2020-10-22 10:42:23','Sudah Dibayar',NULL,'107669999729502','2051-10-21T17:00:00.000Z'),(33,'BCA-bank1604371350-1780609960',43,'BCA','2020-11-03 02:42:31','PENDING',NULL,'107669999541637','2051-11-02T17:00:00.000Z'),(34,'MANDIRI-bank1604378760-362222838',46,'MANDIRI','2020-11-03 04:46:01','PENDING',NULL,'889089999865790','2051-11-02T17:00:00.000Z'),(35,'BRI-bank1604379087-393896656',47,'BRI','2020-11-03 04:51:27','PENDING',NULL,'262159999240500','2051-11-02T17:00:00.000Z'),(36,'BNI-bank1604379431-501062950',48,'BNI','2020-11-03 04:57:12','PENDING',NULL,'8808999992547162','2051-11-02T17:00:00.000Z'),(37,'MANDIRI-bank1604379507-1293034042',49,'MANDIRI','2020-11-03 04:58:28','PENDING',NULL,'889089999577912','2051-11-02T17:00:00.000Z'),(38,'BRI-bank1604379607-36688379',50,'BRI','2020-11-03 05:00:08','PENDING',NULL,'262159999573636','2051-11-02T17:00:00.000Z');
  /*!40000 ALTER TABLE `tb_pembayaran` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_pembeli`
  --
  
  DROP TABLE IF EXISTS `tb_pembeli`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_pembeli` (
    `id_pembeli` int(11) NOT NULL AUTO_INCREMENT,
    `id_pengguna` int(11) DEFAULT NULL,
    `nama_pembeli` varchar(50) NOT NULL,
    `no_telpon` varchar(20) NOT NULL,
    `email` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id_pembeli`)
  ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_pembeli`
  --
  
  LOCK TABLES `tb_pembeli` WRITE;
  /*!40000 ALTER TABLE `tb_pembeli` DISABLE KEYS */;
  INSERT INTO `tb_pembeli` VALUES (1,NULL,'Adiguna','6285245462842','msadiguna152@gmail.com'),(3,NULL,'Syahbani Adiguna','6295245462842','dev@gopedia.id'),(18,NULL,'Dio','0878-7687-6876',NULL),(19,NULL,'Dio','0878-7687-6876',NULL),(20,NULL,'Dio','0878-7687-6800',NULL),(21,NULL,'Dio','0878-7687-6876',NULL),(22,NULL,'Paijo','0989-8298-382',NULL),(23,NULL,'Paijo','1231-2312-3123',NULL),(24,NULL,'Paijo','0832-8793-842',NULL),(25,NULL,'Paijo','0887-8767-5656',NULL),(26,6,'Adiguna v3','085252283152','ms'),(27,7,'Muhammad Syahbani Adiguna','085252283152','msadiguna152@gmail.com'),(28,NULL,'Tersimpan','0988-3947-9873',NULL),(29,NULL,'John Chena','0838-7628-3746',NULL);
  /*!40000 ALTER TABLE `tb_pembeli` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_pengaturan`
  --
  
  DROP TABLE IF EXISTS `tb_pengaturan`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_pengaturan` (
    `id_pengaturan` int(11) NOT NULL,
    `nama_bisnis` varchar(50) NOT NULL,
    `no_wa` varchar(20) NOT NULL,
    `alamat_toko` text NOT NULL,
    `kota` varchar(50) NOT NULL,
    `provinsi` varchar(50) NOT NULL,
    `latitude` varchar(20) NOT NULL,
    `longitude` varchar(20) NOT NULL,
    `tipe_ongkir` int(11) DEFAULT NULL,
    `harga_ongkir_flat` varchar(20) DEFAULT NULL,
    `harga_ongkir_perkm` varchar(20) DEFAULT NULL,
    `google_api_key` text DEFAULT NULL,
    `xendit_api` text DEFAULT NULL,
    `icon` text DEFAULT NULL,
    PRIMARY KEY (`id_pengaturan`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_pengaturan`
  --
  
  LOCK TABLES `tb_pengaturan` WRITE;
  /*!40000 ALTER TABLE `tb_pengaturan` DISABLE KEYS */;
  INSERT INTO `tb_pengaturan` VALUES (1,'Testing Nama Aplikasi','6285245462842','Jln. Bina Bersama RT.01 RW.02 Desa Sarikandi Kecamatan Kurau','Tanah Laut','Kalimantan Selatan','-3.799686','114.746696',2,'2000','3000','1234456','123456789','logo_d.png');
  /*!40000 ALTER TABLE `tb_pengaturan` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_pengguna`
  --
  
  DROP TABLE IF EXISTS `tb_pengguna`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_pengguna` (
    `id_pengguna` int(11) NOT NULL AUTO_INCREMENT,
    `nama_pengguna` varchar(50) NOT NULL,
    `foto_pengguna` varchar(100) DEFAULT NULL,
    `username` varchar(100) NOT NULL,
    `password` varchar(100) NOT NULL,
    `email` varchar(100) NOT NULL,
    `no_telpon` varchar(20) NOT NULL,
    `level` varchar(10) NOT NULL,
    PRIMARY KEY (`id_pengguna`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_pengguna`
  --
  
  LOCK TABLES `tb_pengguna` WRITE;
  /*!40000 ALTER TABLE `tb_pengguna` DISABLE KEYS */;
  INSERT INTO `tb_pengguna` VALUES (1,'Adiguna','logo_d.png','1','c4ca4238a0b923820dcc509a6f75849b','msadiguna152@gmail.com','085245462842','Admin'),(2,'Adiguna Kurir',NULL,'2','2','msadiguna152@gmail.com','1234','Kurir'),(3,'Adiguna Kurir v2','logo_d.png','3','202cb962ac59075b964b07152d234b70','msadiguna152@gmail.com','1234','Kurir'),(5,'Adiguna','aa5E5Cyybn.jpg','2','d41d8cd98f00b204e9800998ecf8427e','gomarket.id@gopedia.id','1123','Kurir'),(6,'Adiguna v3','user.png','ms','202cb962ac59075b964b07152d234b70','ms','085252283152','Pembeli'),(7,'Muhammad Syahbani Adiguna','KRN_7852edit.jpg','msadiguna152@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','msadiguna152@gmail.com','085252283152','Pembeli');
  /*!40000 ALTER TABLE `tb_pengguna` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_pesanan`
  --
  
  DROP TABLE IF EXISTS `tb_pesanan`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_pesanan` (
    `id_pesanan` int(11) NOT NULL AUTO_INCREMENT,
    `id_alamat` int(11) NOT NULL,
    `id_pengguna` int(11) DEFAULT NULL,
    `total_pembayaran` varchar(50) NOT NULL,
    `tanggal_pesanan` datetime NOT NULL,
    `status` varchar(50) NOT NULL,
    `ongkir` int(20) NOT NULL,
    `voucher` varchar(20) NOT NULL,
    `catatan` text DEFAULT NULL,
    `timestamp_pesanan` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id_pesanan`)
  ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_pesanan`
  --
  
  LOCK TABLES `tb_pesanan` WRITE;
  /*!40000 ALTER TABLE `tb_pesanan` DISABLE KEYS */;
  INSERT INTO `tb_pesanan` VALUES (8,9,NULL,'89150','2020-10-22 07:40:33','PENDING',11150,'0','Tahu dan segalanya harus disimpan dalam tempat hangat.		','2020-11-03 04:14:35'),(11,9,NULL,'89150','2020-10-22 08:00:05','Pemesanan',11150,'0','Tahu dan segalanya harus disimpan dalam tempat hangat.','2020-11-03 04:14:35'),(12,9,NULL,'89150','1970-01-01 00:00:00','Pemesanan',11150,'0','Tahu dan segalanya harus disimpan dalam tempat hangat.		','2020-11-03 04:14:35'),(13,9,NULL,'89150','2020-10-22 08:32:23','Pemesanan',11150,'0','Tahu dan segalanya harus disimpan dalam tempat hangat.		','2020-11-03 04:14:35'),(14,9,NULL,'89150','2020-10-22 08:33:37','Pemesanan',11150,'0','Tahu dan segalanya harus disimpan dalam tempat hangat.		','2020-11-03 04:14:35'),(15,9,NULL,'89150','2020-10-22 08:36:46','Pemesanan',11150,'0','Tahu dan segalanya harus disimpan dalam tempat hangat.		','2020-11-03 04:14:35'),(16,10,NULL,'9290','2020-10-22 08:47:40','Pemesanan',4290,'0','Yang enak ya anunya?','2020-11-03 04:14:35'),(17,10,NULL,'9290','2020-10-22 08:54:34','Pemesanan',4290,'0','Yang enak ya anunya?','2020-11-03 04:14:35'),(18,10,NULL,'18290','2020-10-22 08:56:33','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(19,10,NULL,'18290','2020-10-22 08:57:58','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(20,10,NULL,'18290','2020-10-22 08:59:16','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(21,10,NULL,'18290','2020-10-22 09:00:48','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(22,10,NULL,'18290','2020-10-22 09:02:09','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(23,10,NULL,'18290','2020-10-22 09:03:59','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(24,10,NULL,'18290','2020-10-22 09:17:19','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(25,10,NULL,'18290','2020-10-22 09:18:08','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(26,10,NULL,'18290','2020-10-22 09:18:26','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(27,10,NULL,'18290','2020-10-22 09:18:44','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(28,10,NULL,'18290','2020-10-22 09:19:13','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(29,10,NULL,'18290','2020-10-22 09:19:29','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(30,10,NULL,'18290','2020-10-22 09:20:09','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(31,10,NULL,'18290','2020-10-22 09:21:13','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(32,10,NULL,'18290','2020-10-22 09:21:33','Pemesanan',4290,'0','Yang enak ya anunya?		','2020-11-03 04:14:35'),(33,10,NULL,'18290','2020-10-22 09:22:37','Pemesanan',4290,'0','Yang enak ya anunya?				','2020-11-03 04:14:35'),(34,10,NULL,'18290','2020-10-22 09:49:51','Pemesanan',4290,'0','Yang enak ya anunya?				','2020-11-03 04:14:35'),(36,10,NULL,'18290','2020-10-22 09:54:44','Pemesanan',4290,'0','Yang enak ya anunya?						','2020-11-03 04:14:35'),(37,10,NULL,'18290','2020-10-22 09:56:59','Pemesanan',4290,'0','Yang enak ya anunya?						','2020-11-03 04:14:35'),(38,10,NULL,'18290','2020-10-22 10:00:31','Pemesanan',4290,'0','Yang enak ya anunya?						','2020-11-03 04:14:35'),(39,10,3,'18290','2020-10-22 10:00:39','1',4290,'0','Yang enak ya anunya?						','2020-11-03 04:14:35'),(40,10,NULL,'18290','2020-10-22 10:00:47','Pemesanan',4290,'0','Yang enak ya anunya?						','2020-11-03 04:14:35'),(41,10,2,'18290','2020-10-22 10:00:58','1',4290,'0','Yang enak ya anunya?						','2020-11-03 04:14:35'),(42,10,3,'48290','2020-10-22 10:42:23','4',4290,'0','Yang enak ya anunya?						','2020-11-03 04:14:35'),(43,11,NULL,'2550334','2020-11-03 02:42:31','1',2534335,'0','test','2020-11-03 04:14:35'),(44,11,NULL,'2550334','2020-11-03 02:42:31','1',2534335,'0','test','2020-11-03 04:14:41'),(45,11,NULL,'2550334','2020-11-03 02:42:31','1',2534335,'0','test','2020-11-03 04:14:49'),(46,12,NULL,'2542875','2020-11-03 04:46:01','1',2528876,'0','test','2020-11-03 04:46:01'),(47,12,NULL,'2530875','2020-11-03 04:51:27','1',2528876,'0',NULL,'2020-11-03 04:51:27'),(48,12,NULL,'2532875','2020-11-03 04:57:12','1',2528876,'0',NULL,'2020-11-03 04:57:12'),(49,12,NULL,'2532875','2020-11-03 04:58:28','1',2528876,'0',NULL,'2020-11-03 04:58:28'),(50,12,NULL,'2537875','2020-11-03 05:00:08','1',2528876,'0',NULL,'2020-11-03 05:00:08');
  /*!40000 ALTER TABLE `tb_pesanan` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_produk`
  --
  
  DROP TABLE IF EXISTS `tb_produk`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_produk` (
    `id_produk` int(11) NOT NULL AUTO_INCREMENT,
    `id_kategori` int(11) NOT NULL,
    `nama_produk` varchar(50) NOT NULL,
    `harga` varchar(50) NOT NULL,
    `harga_promosi` varchar(50) NOT NULL,
    `deskripsi` text NOT NULL,
    `gambar` varchar(100) NOT NULL,
    `promosi` int(11) NOT NULL,
    `terlaris` int(11) NOT NULL,
    `slug_p` text DEFAULT NULL,
    PRIMARY KEY (`id_produk`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_produk`
  --
  
  LOCK TABLES `tb_produk` WRITE;
  /*!40000 ALTER TABLE `tb_produk` DISABLE KEYS */;
  INSERT INTO `tb_produk` VALUES (1,1,'Wadai Untuk','1000','1000','Testing','v1.jpg',0,0,'wadai-untuk-GCevT'),(2,1,'Okkey Jelly Drink','2000','2000',' Minuman Ringan Penunda LaparMinuman Ringan Penunda LaparMinuman Ringan Penunda LaparMinuman Ringan Penunda LaparMinuman Ringan Penunda Lapar','v1.jpg',1,1,'okkey-jelly-drink-e9PmM'),(3,2,'Es Kelapa Muda','2000','2000','test','v1.jpg',1,1,'es-kelapa-muda-ZEt9K'),(4,2,'Es Satrup','5000','5000','Minuman dingin rasa satrup, pelepas lelah.','aa5E5Cyybn.jpg',1,1,'es-satrup-jgdu5'),(5,2,'Es Kelapa Muda','10000','10000','testingggg','aa5E5Cyybn.jpg',0,0,'es-kelapa-muda-ZNgcf'),(6,4,'Tahu Ayam','5000','5000','tahu rasa ayam','aa5E5Cyybn.jpg',1,1,'tahu-ayam-sP45m'),(7,7,'Tahu Ayam','5000','2000','tahu rasa ayam','aa5E5Cyybn.jpg',1,0,'tahu-ayam-zpu6F');
  /*!40000 ALTER TABLE `tb_produk` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_rincian_pesanan`
  --
  
  DROP TABLE IF EXISTS `tb_rincian_pesanan`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_rincian_pesanan` (
    `id_rincian_pesanan` int(11) NOT NULL AUTO_INCREMENT,
    `id_pesanan` int(11) NOT NULL,
    `id_produk` int(11) NOT NULL,
    `banyak` varchar(20) NOT NULL,
    `sub_total` varchar(20) NOT NULL,
    PRIMARY KEY (`id_rincian_pesanan`)
  ) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_rincian_pesanan`
  --
  
  LOCK TABLES `tb_rincian_pesanan` WRITE;
  /*!40000 ALTER TABLE `tb_rincian_pesanan` DISABLE KEYS */;
  INSERT INTO `tb_rincian_pesanan` VALUES (1,1,1,'2','300000'),(2,1,2,'3','10000'),(3,2,1,'2','2000'),(4,2,3,'8','16000'),(5,2,4,'8','40000'),(6,2,5,'2','20000'),(7,3,1,'2','2000'),(8,3,3,'8','16000'),(9,3,4,'8','40000'),(10,3,5,'2','20000'),(11,4,1,'2','2000'),(12,4,3,'8','16000'),(13,4,4,'8','40000'),(14,4,5,'2','20000'),(15,5,1,'2','2000'),(16,5,3,'8','16000'),(17,5,4,'8','40000'),(18,5,5,'2','20000'),(19,6,1,'2','2000'),(20,6,3,'8','16000'),(21,6,4,'8','40000'),(22,6,5,'2','20000'),(23,7,1,'2','2000'),(24,7,3,'8','16000'),(25,7,4,'8','40000'),(26,7,5,'2','20000'),(27,8,1,'2','2000'),(28,8,3,'8','16000'),(29,8,4,'8','40000'),(30,8,5,'2','20000'),(31,11,1,'2','2000'),(32,11,3,'8','16000'),(33,11,4,'8','40000'),(34,11,5,'2','20000'),(35,12,1,'2','2000'),(36,12,3,'8','16000'),(37,12,4,'8','40000'),(38,12,5,'2','20000'),(39,13,1,'2','2000'),(40,13,3,'8','16000'),(41,13,4,'8','40000'),(42,13,5,'2','20000'),(43,14,1,'2','2000'),(44,14,3,'8','16000'),(45,14,4,'8','40000'),(46,14,5,'2','20000'),(47,15,1,'2','2000'),(48,15,3,'8','16000'),(49,15,4,'8','40000'),(50,15,5,'2','20000'),(51,16,1,'1','1000'),(52,16,2,'4','4000'),(53,17,1,'1','1000'),(54,17,2,'4','4000'),(55,18,1,'3','3000'),(56,18,2,'5','5000'),(57,18,3,'3','6000'),(58,19,1,'3','3000'),(59,19,2,'5','5000'),(60,19,3,'3','6000'),(61,20,1,'3','3000'),(62,20,2,'5','5000'),(63,20,3,'3','6000'),(64,21,1,'3','3000'),(65,21,2,'5','5000'),(66,21,3,'3','6000'),(67,22,1,'3','3000'),(68,22,2,'5','5000'),(69,22,3,'3','6000'),(70,23,1,'3','3000'),(71,23,2,'5','5000'),(72,23,3,'3','6000'),(73,24,1,'3','3000'),(74,24,2,'5','5000'),(75,24,3,'3','6000'),(76,25,1,'3','3000'),(77,25,2,'5','5000'),(78,25,3,'3','6000'),(79,26,1,'3','3000'),(80,26,2,'5','5000'),(81,26,3,'3','6000'),(82,27,1,'3','3000'),(83,27,2,'5','5000'),(84,27,3,'3','6000'),(85,28,1,'3','3000'),(86,28,2,'5','5000'),(87,28,3,'3','6000'),(88,29,1,'3','3000'),(89,29,2,'5','5000'),(90,29,3,'3','6000'),(91,30,1,'3','3000'),(92,30,2,'5','5000'),(93,30,3,'3','6000'),(94,31,1,'3','3000'),(95,31,2,'5','5000'),(96,31,3,'3','6000'),(97,32,1,'3','3000'),(98,32,2,'5','5000'),(99,32,3,'3','6000'),(100,33,1,'3','3000'),(101,33,2,'5','5000'),(102,33,3,'3','6000'),(103,34,1,'3','3000'),(104,34,2,'5','5000'),(105,34,3,'3','6000'),(106,36,1,'3','3000'),(107,36,2,'5','5000'),(108,36,3,'3','6000'),(109,37,1,'3','3000'),(110,37,2,'5','5000'),(111,37,3,'3','6000'),(112,38,1,'3','3000'),(113,38,2,'5','5000'),(114,38,3,'3','6000'),(115,39,1,'3','3000'),(116,39,2,'5','5000'),(117,39,3,'3','6000'),(118,40,1,'3','3000'),(119,40,2,'5','5000'),(120,40,3,'3','6000'),(121,41,1,'3','3000'),(124,42,1,'3','3000'),(125,42,2,'5','5000'),(126,42,3,'3','6000'),(127,42,5,'3','30000'),(128,43,6,'2','10000'),(129,43,7,'3','6000'),(130,46,6,'2','10000'),(131,46,7,'2','4000'),(132,47,7,'1','2000'),(133,48,3,'2','4000'),(134,49,7,'2','4000'),(135,50,3,'1','2000'),(136,50,6,'1','5000'),(137,50,7,'1','2000');
  /*!40000 ALTER TABLE `tb_rincian_pesanan` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tb_sliders`
  --
  
  DROP TABLE IF EXISTS `tb_sliders`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tb_sliders` (
    `id_sliders` int(11) NOT NULL AUTO_INCREMENT,
    `url_sliders` text DEFAULT NULL,
    `gambar_sliders` text NOT NULL,
    `keterangan_sliders` text NOT NULL,
    PRIMARY KEY (`id_sliders`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tb_sliders`
  --
  
  LOCK TABLES `tb_sliders` WRITE;
  /*!40000 ALTER TABLE `tb_sliders` DISABLE KEYS */;
  INSERT INTO `tb_sliders` VALUES (1,'https://www.google.com/search?q=nasi+uduk&rlz=1C1GCEA_enID900ID900&oq=nasi+uduk&aqs=chrome..69i57.2081j0j1&sourceid=chrome&ie=UTF-8','aa5E5Cyybn.jpg','test'),(2,'https://www.google.com/search?q=nasi+uduk&rlz=1C1GCEA_enID900ID900&oq=nasi+uduk&aqs=chrome..69i57.2081j0j1&sourceid=chrome&ie=UTF-8','aa5E5Cyybn.jpg','Bagus1'),(3,'testing.cpm','aa5E5Cyybn.jpg','Makanan Ringan');
  /*!40000 ALTER TABLE `tb_sliders` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2020-11-03 13:07:10
  