text: -- phpMyAdmin SQL Dump
  -- version 5.0.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost
  -- Generation Time: May 07, 2020 at 01:52 AM
  -- Server version: 5.7.24
  -- PHP Version: 7.2.19
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!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 */;
  
  --
  -- Database: `toko`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `list`
  --
  
  CREATE TABLE `list` (
    `No` int(20) UNSIGNED NOT NULL,
    `Item` varchar(100) NOT NULL,
    `qty` bigint(20) NOT NULL,
    `price` bigint(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `list`
  --
  
  INSERT INTO `list` (`No`, `Item`, `qty`, `price`) VALUES
  (1, 'ABC Kecap Asin Botol (135ml)', 1, 6000),
  (2, 'ABC Saus Sambal Asli (135ml)', 1, 6000),
  (3, 'AJI-NO-MOTO® 5000 (131gr)', 2, 5000),
  (4, 'Asam Cuka Botol', 1, 2000),
  (5, 'Asam Jawa', 1, 1000),
  (6, 'Asam Kandis Bumbu Masak 1000', 2, 1000),
  (7, 'Attack Jaz1 Semerbak Cinta (850gr)', 1, 16000),
  (8, 'Ayam Potong Segar', 18, 8000),
  (9, 'Baby Corn Jagung Muda Sayuran', 4, 4000),
  (10, 'Bakso Ayam Asli \"Mbok Sum\"', 1, 5000),
  (11, 'BANGO Kecap Manis Refill (220ml)', 2, 12000),
  (12, 'Batang Serai', 7, 2000),
  (13, 'Bawang Bombay (250gr)', 4, 12000),
  (14, 'Bawang Merah (250gr)', 16, 10000),
  (15, 'Bawang Putih (250gr)', 9, 10000),
  (16, 'Belfoods Kentang Goreng Beku (500gr)', 1, 22000),
  (17, 'Belfoods Uenaaak Sosis Ayam (500gr isi 15pcs)', 1, 20000),
  (18, 'Beras Premium Cap Ikan Belida (10kg)', 1, 110000),
  (19, 'Beras Premium Cap Ikan Belida (5Kg)', 1, 60000),
  (20, 'BIMOLI Classic Minyak Goreng (2 Liter)', 3, 25000),
  (21, 'Bogasari Tepung Segitiga Biru (1kg)', 1, 10000),
  (22, 'Brokoli Hijau (1Kg)', 5, 20000),
  (23, 'Buah Pepaya (1kg)', 4, 9000),
  (24, 'Bumbu Asam Potong 1000', 1, 1000),
  (25, 'Bumbu Bunga Lawang 1000', 10, 1000),
  (26, 'Bumbu Kapulaga 1000', 6, 1000),
  (27, 'Bumbu Kayu Manis 1000', 5, 1000),
  (28, 'Bumbu Ketumbar 1000', 1, 1000),
  (29, 'Bumbu Masak Langkok-langkok', 11, 1000),
  (30, 'Bumbu Sop Halus 1000', 2, 1000),
  (31, 'Bumbu Sup Kasar 1000', 2, 1000),
  (32, 'Bunga Kol (1kg)', 3, 20000),
  (33, 'Cabe Hijau Keriting (250gr)', 1, 8000),
  (34, 'Cabe Merah (1Kg)', 3, 36000),
  (35, 'Cabe Merah (250gr)', 2, 9000),
  (36, 'Cabe Merah (500gr)', 1, 18000),
  (37, 'Cabe Rawit Hijau (100gr)', 1, 4000),
  (38, 'Cabe Rawit Hijau Bukit (100gr)', 3, 5000),
  (39, 'Ciptadent Herbal Pasta Gigi (190gr)', 1, 13000),
  (40, 'Daun Bawang Prei (100gr)', 7, 3000),
  (41, 'Daun Bawang Prei (250gr)', 3, 5000),
  (42, 'Daun Kemangi', 2, 2500),
  (43, 'Daun Serah', 10, 2000),
  (44, 'FOR VITA Margarine (200gr)', 2, 5000),
  (45, 'Gula Merah (250ml)', 3, 6000),
  (46, 'Gula Pasir Kristal (1Kg)', 1, 18000),
  (47, 'Gula Pasir Kristal (500gr)', 1, 9000),
  (48, 'Ikan Air Tawar Lele Segar (500gr)', 4, 11000),
  (49, 'Ikan Air Tawar Nila Segar (500gr)', 6, 17000),
  (50, 'Ikan Laut Serai bulat Segar (500gr)', 3, 15500),
  (51, 'INDOFOOD Bumbu Penyedap Kaldu Ayam (/pcs)', 2, 500),
  (52, 'INDOFOOD Bumbu Penyedap Kaldu Sapi (/pcs)', 2, 500),
  (53, 'Indofood Bumbu Racik Ayam Goreng (26gr)', 2, 2000),
  (54, 'Indofood Bumbu Racik Tempe Goreng (20gr)', 2, 1000),
  (55, 'Jahe (100gr)', 2, 4000),
  (56, 'Jamur Tiram Putih', 3, 4000),
  (57, 'Jeruk Nipis (250gr)', 5, 4000),
  (58, 'Kacang Hijau (1kg)', 1, 22000),
  (59, 'Kacang Tanah Kupas (500gr)', 1, 14000),
  (60, 'Kapal Api Special Kopi Bubuk (165gr)', 1, 12000),
  (61, 'Kembang Tahu Kering', 1, 5000),
  (62, 'Kentang (1kg)', 8, 12000),
  (63, 'KOBE Super Crispy Kentucky Tepung Bumbu (75gr)', 2, 3000),
  (64, 'Kubis Kol Organik (1Kg)', 3, 5000),
  (65, 'Kunyit (100gr)', 5, 1500),
  (66, 'Labu Siam / jipang (1Kg)', 4, 7000),
  (67, 'Labu Siam / jipang (500gr)', 4, 4000),
  (68, 'Lagie Cokelat Meses Safari (100gr)', 2, 5000),
  (69, 'Langkuas (100gr)', 4, 2000),
  (70, 'Lifebuoy Shampoo Sachet', 1, 5500),
  (71, 'MAMA LEMON Jeruk Nipis (470ml)', 1, 9000),
  (72, 'MamaSuka Mayonais Saus (100gr)', 1, 7000),
  (73, 'Mie Lidi Cap Buah Duku (500gr)', 1, 6000),
  (74, 'Mie Rose Brand Super Bihun (250gr)', 2, 6000),
  (75, 'Mie Telor	Cap 3 Ayam (200gr)', 2, 5000),
  (76, 'Mie Telur Saga Indo Makmur (160gr)', 3, 4000),
  (77, 'Pak Tani Gunung Tepung Tapioka (500gr)', 2, 8000),
  (78, 'PEPSODENT Natural Herbal Pasta Gigi (120gr)', 2, 12000),
  (79, 'Petai (250gr)', 7, 10000),
  (80, 'ROMA Malkist Crackers (135gr)', 3, 6000),
  (81, 'ROMA Sandwich Chocolate Biskuit (216gr)', 1, 6000),
  (82, 'ROMA Sandwich Peanut Biskuit (216gr)', 1, 6000),
  (83, 'ROYCO Bumbu Rasa Ayam (230gr)', 1, 9000),
  (84, 'Sajiku Bumbu Ayam Goreng (24gr)', 2, 2000),
  (85, 'Sajiku Tepung Bumbu Serbaguna (80gr)', 5, 3000),
  (86, 'Sania Tepung Terigu Serbaguna Aneka Makanan (1kg)', 1, 10000),
  (87, 'Sawi Hijau (1kg)', 3, 10000),
  (88, 'Sawi Putih Organik (1kg)', 2, 10000),
  (89, 'Sayur Baby Pak Coy', 1, 2500),
  (90, 'Sayur Bayam Segar', 5, 2500),
  (91, 'Sayur Buncis (250gr)', 4, 4000),
  (92, 'Sayur Nangka Muda Potong', 1, 1500),
  (93, 'Sayur Pare (500gr)', 2, 7000),
  (94, 'Sayur Wortel (500gr)', 9, 8000),
  (95, 'Sayuran Daun Kangkung', 2, 2500),
  (96, 'Sayuran Jengkol (10 Biji)', 3, 6000),
  (97, 'Sayuran Kacang Panjang', 2, 2000),
  (98, 'Sayuran Terong Ungu (250gr)', 6, 3000),
  (99, 'Soda Kue 1000', 1, 1000),
  (100, 'SUHUN Super ABC (50gr)', 3, 1500),
  (101, 'SUHUN Super Cap Cangkir Keramik', 3, 5000),
  (102, 'SUN Kara Santan Kelapa Siap Pakai (200ml)', 2, 8000),
  (103, 'Tahu Asli H.B (isi 10)', 3, 6500),
  (104, 'Tahu MOJAN\'K Asli Khas bandung (isi 10)', 3, 6000),
  (105, 'Tauge Sayuran (250gr)', 11, 2000),
  (106, 'Telur Ayam Negeri Curah [1 Papan isi 30 Butir]', 2, 43000),
  (107, 'Telur Ayam Negeri Curah [30 Butir]', 6, 43000),
  (108, 'Telur Puyuh isi 20 Butir', 2, 7000),
  (109, 'Tempe Daun', 11, 2000),
  (110, 'Tepung Panir Kue (500gr)', 1, 9000),
  (111, 'Terong lalap Hijau (250gr)', 1, 3000),
  (112, 'Timun Sayuran (500gr)', 2, 5000),
  (113, 'Tomat Hijau (500gr)', 1, 5000),
  (114, 'Tomat Merah (1Kg)', 1, 9000),
  (115, 'Tomat Merah (500gr)', 5, 5000),
  (116, 'Ubi Rambat Merah (500gr)', 4, 4000),
  (117, 'Ubi Rambat Putih (500gr)', 2, 4000);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `orders`
  --
  
  CREATE TABLE `orders` (
    `orderNumber` int(11) NOT NULL,
    `orderStatus` varchar(15) NOT NULL,
    `orderDate` timestamp NOT NULL,
    `item` int(11) NOT NULL,
    `SKU` varchar(30) NOT NULL,
    `ItemName` varchar(50) NOT NULL,
    `qty` int(11) NOT NULL,
    `itemCost` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `orders`
  --
  
  INSERT INTO `orders` (`orderNumber`, `orderStatus`, `orderDate`, `item`, `SKU`, `ItemName`, `qty`, `itemCost`) VALUES
  (10989, 'Completed', '2020-04-11 06:41:00', 1, 'Ikan TW 02', 'Ikan Air Tawar Lele Segar (500gr)', 2, 11000),
  (10989, 'Completed', '2020-04-11 06:41:00', 2, 'Telur 2', 'Telur Ayam Negeri Curah [1 Papan isi 30 Butir]', 1, 43000),
  (10989, 'Completed', '2020-04-11 06:41:00', 3, '', 'Batang Serai', 3, 2000),
  (10989, 'Completed', '2020-04-11 06:41:00', 4, '', 'Bawang Bombay (250gr)', 1, 12000),
  (10989, 'Completed', '2020-04-11 06:41:00', 5, '', 'Bawang Merah (250gr)', 3, 10000),
  (10989, 'Completed', '2020-04-11 06:41:00', 6, '', 'Bawang Putih (250gr)', 2, 10000),
  (10989, 'Completed', '2020-04-11 06:41:00', 7, '', 'Bumbu Masak Langkok-langkok', 5, 1000),
  (10989, 'Completed', '2020-04-11 06:41:00', 8, '', 'Cabe Rawit Hijau Bukit (100gr)', 2, 5000),
  (10989, 'Completed', '2020-04-11 06:41:00', 9, '', 'Cabe Merah (1Kg)', 1, 36000),
  (10989, 'Completed', '2020-04-11 06:41:00', 10, '', 'Petai (250gr)', 1, 10000),
  (10989, 'Completed', '2020-04-11 06:41:00', 11, '', 'Kunyit (100gr)', 2, 1500),
  (10989, 'Completed', '2020-04-11 06:41:00', 12, '', 'Timun Sayuran (500gr)', 1, 5000),
  (10989, 'Completed', '2020-04-11 06:41:00', 13, '', 'Sayuran Jengkol (10 Biji)', 1, 6000),
  (10981, 'Completed', '2020-04-11 03:57:00', 1, '', 'Langkuas (100gr)', 1, 2000),
  (10981, 'Completed', '2020-04-11 03:57:00', 2, 'Bumbu M 22', 'Bumbu Ketumbar 1000', 1, 1000),
  (10981, 'Completed', '2020-04-11 03:57:00', 3, '', 'Bumbu Masak Langkok-langkok', 2, 1000),
  (10981, 'Completed', '2020-04-11 03:57:00', 4, '', 'Bawang Merah (250gr)', 2, 10000),
  (10981, 'Completed', '2020-04-11 03:57:00', 5, '', 'Daun Kemangi', 1, 2500),
  (10981, 'Completed', '2020-04-11 03:57:00', 6, '', 'Daun Bawang Prei (100gr)', 1, 3000),
  (10981, 'Completed', '2020-04-11 03:57:00', 7, '', 'Jahe (100gr)', 1, 4000),
  (10981, 'Completed', '2020-04-11 03:57:00', 8, '', 'Petai (250gr)', 2, 10000),
  (10981, 'Completed', '2020-04-11 03:57:00', 9, '', 'Tomat Hijau (500gr)', 1, 5000),
  (10981, 'Completed', '2020-04-11 03:57:00', 10, '', 'Buah Pepaya (1kg)', 2, 9000),
  (10981, 'Completed', '2020-04-11 03:57:00', 11, '', 'Tomat Merah (500gr)', 1, 5000),
  (10981, 'Completed', '2020-04-11 03:57:00', 12, '', 'Bawang Putih (250gr)', 1, 10000),
  (10981, 'Completed', '2020-04-11 03:57:00', 13, '', 'Brokoli Hijau (1Kg)', 1, 20000),
  (10981, 'Completed', '2020-04-11 03:57:00', 14, 'Bumbu M 29', 'Bumbu Asam Potong 1000', 1, 1000),
  (10981, 'Completed', '2020-04-11 03:57:00', 15, '', 'Sayur Pare (500gr)', 2, 7000),
  (10981, 'Completed', '2020-04-11 03:57:00', 16, '', 'Labu Siam / jipang (1Kg)', 4, 7000),
  (10973, 'Completed', '2020-04-11 02:28:00', 1, '', 'Baby Corn Jagung Muda Sayuran', 1, 4000),
  (10973, 'Completed', '2020-04-11 02:28:00', 2, '', 'Batang Serai', 1, 2000),
  (10973, 'Completed', '2020-04-11 02:28:00', 3, '', 'Bawang Merah (250gr)', 4, 10000),
  (10973, 'Completed', '2020-04-11 02:28:00', 4, '', 'Brokoli Hijau (1Kg)', 1, 20000),
  (10973, 'Completed', '2020-04-11 02:28:00', 5, '', 'Bunga Kol (1kg)', 1, 20000),
  (10973, 'Completed', '2020-04-11 02:28:00', 6, '', 'Cabe Merah (1Kg)', 1, 36000),
  (10973, 'Completed', '2020-04-11 02:28:00', 7, '', 'Daun Bawang Prei (250gr)', 1, 5000),
  (10973, 'Completed', '2020-04-11 02:28:00', 8, '', 'Jeruk Nipis (250gr)', 2, 4000),
  (10973, 'Completed', '2020-04-11 02:28:00', 9, '', 'Kentang (1kg)', 1, 12000),
  (10973, 'Completed', '2020-04-11 02:28:00', 10, '', 'Langkuas (100gr)', 2, 2000),
  (10973, 'Completed', '2020-04-11 02:28:00', 11, '', 'Kunyit (100gr)', 2, 1500),
  (10973, 'Completed', '2020-04-11 02:28:00', 12, '', 'Petai (250gr)', 1, 10000),
  (10973, 'Completed', '2020-04-11 02:28:00', 13, '', 'Sayur Buncis (250gr)', 1, 4000),
  (10973, 'Completed', '2020-04-11 02:28:00', 14, '', 'Sayur Wortel (500gr)', 2, 8000),
  (10973, 'Completed', '2020-04-11 02:28:00', 15, '', 'Sayuran Terong Ungu (250gr)', 1, 3000),
  (10884, 'Completed', '2020-04-09 13:59:00', 1, '', 'Ayam Potong Segar', 4, 8000),
  (10884, 'Completed', '2020-04-09 13:59:00', 2, 'Telur Puyuh 1', 'Telur Puyuh isi 20 Butir', 1, 7000),
  (10884, 'Completed', '2020-04-09 13:59:00', 3, '', 'Batang Serai', 3, 2000),
  (10884, 'Completed', '2020-04-09 13:59:00', 4, '', 'Bawang Bombay (250gr)', 1, 12000),
  (10884, 'Completed', '2020-04-09 13:59:00', 5, '', 'Bawang Putih (250gr)', 1, 10000),
  (10884, 'Completed', '2020-04-09 13:59:00', 6, '', 'Bunga Kol (1kg)', 1, 20000),
  (10884, 'Completed', '2020-04-09 13:59:00', 7, '', 'Tempe Daun', 1, 2000),
  (10884, 'Completed', '2020-04-09 13:59:00', 8, '', 'Tauge Sayuran (250gr)', 1, 2000),
  (10884, 'Completed', '2020-04-09 13:59:00', 9, '', 'Sayuran Terong Ungu (250gr)', 3, 3000),
  (10884, 'Completed', '2020-04-09 13:59:00', 10, '', 'Sayur Wortel (500gr)', 1, 8000),
  (10884, 'Completed', '2020-04-09 13:59:00', 11, 'Ikan L 02', 'Ikan Laut Serai bulat Segar (500gr)', 2, 15500),
  (10884, 'Completed', '2020-04-09 13:59:00', 12, '', 'Belfoods Uenaaak Sosis Ayam (500gr isi 15pcs)', 1, 20000),
  (10884, 'Completed', '2020-04-09 13:59:00', 13, '', 'Langkuas (100gr)', 1, 2000),
  (10796, 'Completed', '2020-04-08 12:13:00', 1, 'Telur 2', 'Telur Ayam Negeri Curah [1 Papan isi 30 Butir]', 1, 43000),
  (10796, 'Completed', '2020-04-08 12:13:00', 2, '', 'Buah Pepaya (1kg)', 1, 9000),
  (10796, 'Completed', '2020-04-08 12:13:00', 3, '', 'Baby Corn Jagung Muda Sayuran', 1, 4000),
  (10796, 'Completed', '2020-04-08 12:13:00', 4, '', 'Bawang Bombay (250gr)', 1, 12000),
  (10796, 'Completed', '2020-04-08 12:13:00', 5, '', 'Bawang Merah (250gr)', 1, 10000),
  (10796, 'Completed', '2020-04-08 12:13:00', 6, '', 'Bawang Putih (250gr)', 1, 10000),
  (10796, 'Completed', '2020-04-08 12:13:00', 7, '', 'Cabe Merah (250gr)', 1, 9000),
  (10796, 'Completed', '2020-04-08 12:13:00', 8, '', 'Kentang (1kg)', 1, 12000),
  (10796, 'Completed', '2020-04-08 12:13:00', 9, '', 'Sayur Nangka Muda Potong', 1, 1500),
  (10796, 'Completed', '2020-04-08 12:13:00', 10, '', 'Ubi Rambat Merah (500gr)', 2, 4000),
  (10796, 'Completed', '2020-04-08 12:13:00', 11, '', 'Tomat Merah (500gr)', 1, 5000),
  (10796, 'Completed', '2020-04-08 12:13:00', 12, '', 'Sayuran Kacang Panjang', 1, 2000),
  (10796, 'Completed', '2020-04-08 12:13:00', 13, '', 'Sayuran Terong Ungu (250gr)', 1, 3000),
  (10796, 'Completed', '2020-04-08 12:13:00', 14, '', 'Tauge Sayuran (250gr)', 1, 2000),
  (10796, 'Completed', '2020-04-08 12:13:00', 15, '', 'Tempe Daun', 1, 2000),
  (10796, 'Completed', '2020-04-08 12:13:00', 16, '', 'Sayur Buncis (250gr)', 1, 4000),
  (10796, 'Completed', '2020-04-08 12:13:00', 17, '', 'Sayur Bayam Segar', 1, 2500),
  (10796, 'Completed', '2020-04-08 12:13:00', 18, '', 'Sawi Putih Organik (1kg)', 1, 10000),
  (10796, 'Completed', '2020-04-08 12:13:00', 19, '', 'Petai (250gr)', 1, 10000),
  (10796, 'Completed', '2020-04-08 12:13:00', 20, '', 'Labu Siam / jipang (500gr)', 1, 4000),
  (10796, 'Completed', '2020-04-08 12:13:00', 21, '', 'Jeruk Nipis (250gr)', 1, 4000),
  (10796, 'Completed', '2020-04-08 12:13:00', 22, '', 'Daun Kemangi', 1, 2500),
  (10796, 'Completed', '2020-04-08 12:13:00', 23, '', 'Daun Bawang Prei (100gr)', 1, 3000),
  (10796, 'Completed', '2020-04-08 12:13:00', 24, '', 'Cabe Rawit Hijau Bukit (100gr)', 1, 5000),
  (10796, 'Completed', '2020-04-08 12:13:00', 25, 'Bumbu M 08', 'Sajiku Bumbu Ayam Goreng (24gr)', 2, 2000),
  (10796, 'Completed', '2020-04-08 12:13:00', 26, 'Dapur 14', 'FOR VITA Margarine (200gr)', 1, 5000),
  (10796, 'Completed', '2020-04-08 12:13:00', 27, 'Dapur 01-02', 'Gula Pasir Kristal (1Kg)', 1, 18000),
  (10796, 'Completed', '2020-04-08 12:13:00', 28, 'Dapur 03', 'Gula Merah (250ml)', 1, 6000),
  (10796, 'Completed', '2020-04-08 12:13:00', 29, '', 'Lagie Cokelat Meses Safari (100gr)', 2, 5000),
  (10796, 'Completed', '2020-04-08 12:13:00', 30, '', 'MamaSuka Mayonais Saus (100gr)', 1, 7000),
  (10796, 'Completed', '2020-04-08 12:13:00', 31, 'Dapur 26', 'Soda Kue 1000', 1, 1000),
  (10796, 'Completed', '2020-04-08 12:13:00', 32, '', 'Tahu Asli H.B (isi 10)', 2, 6500),
  (10796, 'Completed', '2020-04-08 12:13:00', 33, '', 'Bakso Ayam Asli \"Mbok Sum\"', 1, 5000),
  (10796, 'Completed', '2020-04-08 12:13:00', 34, '', 'ROMA Sandwich Chocolate Biskuit (216gr)', 1, 6000),
  (10796, 'Completed', '2020-04-08 12:13:00', 35, '', 'ROMA Sandwich Peanut Biskuit (216gr)', 1, 6000),
  (10796, 'Completed', '2020-04-08 12:13:00', 36, '', 'ROMA Malkist Crackers (135gr)', 1, 6000),
  (10796, 'Completed', '2020-04-08 12:13:00', 37, '', 'PEPSODENT Natural Herbal Pasta Gigi (120gr)', 2, 12000),
  (10796, 'Completed', '2020-04-08 12:13:00', 38, 'Ikan TW 03', 'Ikan Air Tawar Nila Segar (500gr)', 2, 17000),
  (10796, 'Completed', '2020-04-08 12:13:00', 39, '', 'Ayam Potong Segar', 4, 8000),
  (10796, 'Completed', '2020-04-08 12:13:00', 40, '', 'Sayur Wortel (500gr)', 2, 8000),
  (10776, 'Completed', '2020-04-08 09:37:00', 1, 'Dapur 21', 'Mie Lidi Cap Buah Duku (500gr)', 1, 6000),
  (10776, 'Completed', '2020-04-08 09:37:00', 2, '', 'Brokoli Hijau (1Kg)', 1, 20000),
  (10776, 'Completed', '2020-04-08 09:37:00', 3, '', 'Daun Bawang Prei (250gr)', 1, 5000),
  (10776, 'Completed', '2020-04-08 09:37:00', 4, '', 'Kubis Kol Organik (1Kg)', 1, 5000),
  (10776, 'Completed', '2020-04-08 09:37:00', 5, '', 'Labu Siam / jipang (500gr)', 1, 4000),
  (10776, 'Completed', '2020-04-08 09:37:00', 6, '', 'Sawi Putih Organik (1kg)', 1, 10000),
  (10776, 'Completed', '2020-04-08 09:37:00', 7, '', 'Sawi Hijau (1kg)', 1, 10000),
  (10776, 'Completed', '2020-04-08 09:37:00', 8, '', 'Sayur Bayam Segar', 2, 2500),
  (10776, 'Completed', '2020-04-08 09:37:00', 9, '', 'Sayur Buncis (250gr)', 1, 4000),
  (10776, 'Completed', '2020-04-08 09:37:00', 10, '', 'Sayuran Daun Kangkung', 2, 2500),
  (10776, 'Completed', '2020-04-08 09:37:00', 11, '', 'Sayuran Kacang Panjang', 1, 2000),
  (10776, 'Completed', '2020-04-08 09:37:00', 12, '', 'Sayuran Terong Ungu (250gr)', 1, 3000),
  (10776, 'Completed', '2020-04-08 09:37:00', 13, '', 'Tauge Sayuran (250gr)', 2, 2000),
  (10776, 'Completed', '2020-04-08 09:37:00', 14, '', 'Kentang (1kg)', 1, 12000),
  (10763, 'Completed', '2020-04-08 05:15:00', 1, '', 'Ciptadent Herbal Pasta Gigi (190gr)', 1, 13000),
  (10763, 'Completed', '2020-04-08 05:15:00', 2, '', 'Attack Jaz1 Semerbak Cinta (850gr)', 1, 16000),
  (10763, 'Completed', '2020-04-08 05:15:00', 3, '', 'MAMA LEMON Jeruk Nipis (470ml)', 1, 9000),
  (10763, 'Completed', '2020-04-08 05:15:00', 4, '', 'BIMOLI Classic Minyak Goreng (2 Liter)', 1, 25000),
  (10763, 'Completed', '2020-04-08 05:15:00', 5, 'Telur 2', 'Telur Ayam Negeri Curah [30 Butir]', 1, 43000),
  (10763, 'Completed', '2020-04-08 05:15:00', 6, 'B.Saus 01', 'ABC Saus Sambal Asli (135ml)', 1, 6000),
  (10763, 'Completed', '2020-04-08 05:15:00', 7, 'B.Kecap MR 01-2', 'BANGO Kecap Manis Refill (220ml)', 1, 12000),
  (10763, 'Completed', '2020-04-08 05:15:00', 8, 'Beras 05-3', 'Beras Premium Cap Ikan Belida (5Kg)', 1, 60000),
  (10763, 'Completed', '2020-04-08 05:15:00', 9, '', 'Kapal Api Special Kopi Bubuk (165gr)', 1, 12000),
  (10763, 'Completed', '2020-04-08 05:15:00', 10, '', 'Lifebuoy Shampoo Sachet', 1, 5500),
  (10763, 'Completed', '2020-04-08 05:15:00', 11, '', 'Bawang Putih (250gr)', 1, 10000),
  (10763, 'Completed', '2020-04-08 05:15:00', 12, '', 'Bawang Merah (250gr)', 1, 10000),
  (10763, 'Completed', '2020-04-08 05:15:00', 13, 'Dapur 01-01', 'Gula Pasir Kristal (500gr)', 1, 9000),
  (10763, 'Completed', '2020-04-08 05:15:00', 14, '', 'Kacang Hijau (1kg)', 1, 22000),
  (10763, 'Completed', '2020-04-08 05:15:00', 15, 'Dapur 03', 'Gula Merah (250ml)', 2, 6000),
  (10763, 'Completed', '2020-04-08 05:15:00', 16, 'Bumbu T 10', 'Sania Tepung Terigu Serbaguna Aneka Makanan (1kg)', 1, 10000),
  (10763, 'Completed', '2020-04-08 05:15:00', 17, 'Dapur 19', 'Mie Telor	Cap 3 Ayam (200gr)', 2, 5000),
  (10763, 'Completed', '2020-04-08 05:15:00', 18, 'Dapur 20', 'Mie Rose Brand Super Bihun (250gr)', 2, 6000),
  (10763, 'Completed', '2020-04-08 05:15:00', 19, '', 'Daun Bawang Prei (100gr)', 1, 3000),
  (10753, 'Completed', '2020-04-08 03:58:00', 1, 'Telur 2', 'Telur Ayam Negeri Curah [30 Butir]', 1, 43000),
  (10753, 'Completed', '2020-04-08 03:58:00', 2, '', 'Bawang Merah (250gr)', 1, 10000),
  (10753, 'Completed', '2020-04-08 03:58:00', 3, '', 'Bawang Putih (250gr)', 1, 10000),
  (10753, 'Completed', '2020-04-08 03:58:00', 4, '', 'Cabe Merah (250gr)', 1, 9000),
  (10753, 'Completed', '2020-04-08 03:58:00', 5, '', 'Jahe (100gr)', 1, 4000),
  (10753, 'Completed', '2020-04-08 03:58:00', 6, '', 'Kembang Tahu Kering', 1, 5000),
  (10753, 'Completed', '2020-04-08 03:58:00', 7, '', 'Sayur Wortel (500gr)', 1, 8000),
  (10753, 'Completed', '2020-04-08 03:58:00', 8, '', 'Tomat Merah (500gr)', 1, 5000),
  (10753, 'Completed', '2020-04-08 03:58:00', 9, 'Dapur 14', 'FOR VITA Margarine (200gr)', 1, 5000),
  (10753, 'Completed', '2020-04-08 03:58:00', 10, '', 'Belfoods Kentang Goreng Beku (500gr)', 1, 22000),
  (10753, 'Completed', '2020-04-08 03:58:00', 11, '', 'Kentang (1kg)', 1, 12000),
  (10753, 'Completed', '2020-04-08 03:58:00', 12, '', 'Jeruk Nipis (250gr)', 1, 4000),
  (10753, 'Completed', '2020-04-08 03:58:00', 13, 'Ikan TW 02', 'Ikan Air Tawar Lele Segar (500gr)', 1, 11000),
  (10753, 'Completed', '2020-04-08 03:58:00', 14, 'Ikan TW 03', 'Ikan Air Tawar Nila Segar (500gr)', 1, 17000),
  (10753, 'Completed', '2020-04-08 03:58:00', 15, 'Telur Puyuh 1', 'Telur Puyuh isi 20 Butir', 1, 7000),
  (10753, 'Completed', '2020-04-08 03:58:00', 16, 'Bumbu M 37', 'Asam Cuka Botol', 1, 2000),
  (10753, 'Completed', '2020-04-08 03:58:00', 17, 'Dapur 17', 'Mie Telur Saga Indo Makmur (160gr)', 3, 4000),
  (10753, 'Completed', '2020-04-08 03:58:00', 18, '', 'Ayam Potong Segar', 2, 8000),
  (10753, 'Completed', '2020-04-08 03:58:00', 19, '', 'Sayur Buncis (250gr)', 1, 4000),
  (10753, 'Completed', '2020-04-08 03:58:00', 20, '', 'Labu Siam / jipang (500gr)', 1, 4000),
  (10753, 'Completed', '2020-04-08 03:58:00', 21, '', 'Tempe Daun', 2, 2000),
  (10753, 'Completed', '2020-04-08 03:58:00', 22, '', 'Tauge Sayuran (250gr)', 1, 2000),
  (10753, 'Completed', '2020-04-08 03:58:00', 23, '', 'Bumbu Masak Langkok-langkok', 1, 1000),
  (10753, 'Completed', '2020-04-08 03:58:00', 24, '', 'Daun Bawang Prei (100gr)', 1, 3000),
  (10745, 'Completed', '2020-04-08 03:00:00', 1, 'Telur 2', 'Telur Ayam Negeri Curah [30 Butir]', 2, 43000),
  (10745, 'Completed', '2020-04-08 03:00:00', 2, 'Beras 05', 'Beras Premium Cap Ikan Belida (10kg)', 1, 110000),
  (10732, 'Completed', '2020-04-08 00:23:00', 1, '', 'Buah Pepaya (1kg)', 1, 9000),
  (10732, 'Completed', '2020-04-08 00:23:00', 2, 'Telur 2', 'Telur Ayam Negeri Curah [30 Butir]', 1, 43000),
  (10732, 'Completed', '2020-04-08 00:23:00', 3, '', 'Bawang Merah (250gr)', 2, 10000),
  (10732, 'Completed', '2020-04-08 00:23:00', 4, '', 'Bawang Putih (250gr)', 1, 10000),
  (10732, 'Completed', '2020-04-08 00:23:00', 5, '', 'Tomat Merah (500gr)', 1, 5000),
  (10732, 'Completed', '2020-04-08 00:23:00', 6, '', 'BIMOLI Classic Minyak Goreng (2 Liter)', 1, 25000),
  (10732, 'Completed', '2020-04-08 00:23:00', 7, 'Bumbu T 14-1', 'Sajiku Tepung Bumbu Serbaguna (80gr)', 5, 3000),
  (10732, 'Completed', '2020-04-08 00:23:00', 8, 'Dapur 08', 'Bogasari Tepung Segitiga Biru (1kg)', 1, 10000),
  (10732, 'Completed', '2020-04-08 00:23:00', 9, 'Dapur 24-1', 'Tepung Panir Kue (500gr)', 1, 9000),
  (10732, 'Completed', '2020-04-08 00:23:00', 10, '', 'Tauge Sayuran (250gr)', 1, 2000),
  (10732, 'Completed', '2020-04-08 00:23:00', 11, '', 'Terong lalap Hijau (250gr)', 1, 3000),
  (10732, 'Completed', '2020-04-08 00:23:00', 12, '', 'Brokoli Hijau (1Kg)', 1, 20000),
  (10732, 'Completed', '2020-04-08 00:23:00', 13, '', 'Sayur Wortel (500gr)', 1, 8000),
  (10732, 'Completed', '2020-04-08 00:23:00', 14, '', 'SUHUN Super Cap Cangkir Keramik', 3, 5000),
  (10732, 'Completed', '2020-04-08 00:23:00', 15, 'Bumbu M 03', 'ROYCO Bumbu Rasa Ayam (230gr)', 1, 9000),
  (10732, 'Completed', '2020-04-08 00:23:00', 16, '', 'Kentang (1kg)', 2, 12000),
  (10732, 'Completed', '2020-04-08 00:23:00', 17, '', 'AJI-NO-MOTO® 5000 (131gr)', 2, 5000),
  (10732, 'Completed', '2020-04-08 00:23:00', 18, 'B.Kecap MR 01-2', 'BANGO Kecap Manis Refill (220ml)', 1, 12000),
  (10732, 'Completed', '2020-04-08 00:23:00', 19, '', 'Daun Bawang Prei (100gr)', 1, 3000),
  (10732, 'Completed', '2020-04-08 00:23:00', 20, '', 'Bumbu Masak Langkok-langkok', 1, 1000),
  (10732, 'Completed', '2020-04-08 00:23:00', 21, '', 'Cabe Merah (500gr)', 1, 18000),
  (10732, 'Completed', '2020-04-08 00:23:00', 22, '', 'Kubis Kol Organik (1Kg)', 1, 5000),
  (10732, 'Completed', '2020-04-08 00:23:00', 23, '', 'Tempe Daun', 5, 2000),
  (10699, 'Completed', '2020-04-07 15:55:00', 1, '', 'Ubi Rambat Merah (500gr)', 2, 4000),
  (10699, 'Completed', '2020-04-07 15:55:00', 2, '', 'Tauge Sayuran (250gr)', 2, 2000),
  (10699, 'Completed', '2020-04-07 15:55:00', 3, 'Bumbu M 25', 'Bumbu Bunga Lawang 1000', 10, 1000),
  (10699, 'Completed', '2020-04-07 15:55:00', 4, 'Bumbu M 32', 'Bumbu Kayu Manis 1000', 5, 1000),
  (10699, 'Completed', '2020-04-07 15:55:00', 5, 'Bumbu M 24', 'Bumbu Kapulaga 1000', 5, 1000),
  (10699, 'Completed', '2020-04-07 15:55:00', 6, 'Ikan TW 03', 'Ikan Air Tawar Nila Segar (500gr)', 3, 17000),
  (10699, 'Completed', '2020-04-07 15:55:00', 7, '', 'Bawang Bombay (250gr)', 1, 12000),
  (10699, 'Completed', '2020-04-07 15:55:00', 8, '', 'Cabe Hijau Keriting (250gr)', 1, 8000),
  (10699, 'Completed', '2020-04-07 15:55:00', 9, '', 'Jeruk Nipis (250gr)', 1, 4000),
  (10699, 'Completed', '2020-04-07 15:55:00', 10, '', 'Timun Sayuran (500gr)', 1, 5000),
  (10699, 'Completed', '2020-04-07 15:55:00', 11, '', 'Sayur Wortel (500gr)', 1, 8000),
  (10699, 'Completed', '2020-04-07 15:55:00', 12, '', 'Tahu MOJAN\'K Asli Khas bandung (isi 10)', 1, 6000),
  (10699, 'Completed', '2020-04-07 15:55:00', 13, '', 'Daun Serah', 9, 2000),
  (10699, 'Completed', '2020-04-07 15:55:00', 14, '', 'Daun Bawang Prei (100gr)', 2, 3000),
  (10674, 'Completed', '2020-04-07 15:09:00', 1, 'Ikan TW 02', 'Ikan Air Tawar Lele Segar (500gr)', 1, 11000),
  (10674, 'Completed', '2020-04-07 15:09:00', 2, 'Telur 2', 'Telur Ayam Negeri Curah [30 Butir]', 1, 43000),
  (10674, 'Completed', '2020-04-07 15:09:00', 3, 'B.Kecap 01', 'ABC Kecap Asin Botol (135ml)', 1, 6000),
  (10674, 'Completed', '2020-04-07 15:09:00', 4, '', 'Asam Jawa', 1, 1000),
  (10674, 'Completed', '2020-04-07 15:09:00', 5, 'Bumbu M 30', 'Asam Kandis Bumbu Masak 1000', 2, 1000),
  (10674, 'Completed', '2020-04-07 15:09:00', 6, 'Bumbu M 34', 'Bumbu Sop Halus 1000', 2, 1000),
  (10674, 'Completed', '2020-04-07 15:09:00', 7, 'Bumbu M 26', 'Bumbu Sup Kasar 1000', 2, 1000),
  (10674, 'Completed', '2020-04-07 15:09:00', 8, 'Bumbu M 18', 'Indofood Bumbu Racik Ayam Goreng (26gr)', 2, 2000),
  (10674, 'Completed', '2020-04-07 15:09:00', 9, '', 'Kacang Tanah Kupas (500gr)', 1, 14000),
  (10674, 'Completed', '2020-04-07 15:09:00', 10, 'Dapur 12', 'Pak Tani Gunung Tepung Tapioka (500gr)', 2, 8000),
  (10674, 'Completed', '2020-04-07 15:09:00', 11, '', 'SUHUN Super ABC (50gr)', 3, 1500),
  (10674, 'Completed', '2020-04-07 15:09:00', 12, '', 'SUN Kara Santan Kelapa Siap Pakai (200ml)', 2, 8000),
  (10674, 'Completed', '2020-04-07 15:09:00', 13, '', 'Tahu MOJAN\'K Asli Khas bandung (isi 10)', 2, 6000),
  (10674, 'Completed', '2020-04-07 15:09:00', 14, '', 'Bawang Merah (250gr)', 2, 10000),
  (10674, 'Completed', '2020-04-07 15:09:00', 15, '', 'Bawang Putih (250gr)', 1, 10000),
  (10674, 'Completed', '2020-04-07 15:09:00', 16, '', 'Bumbu Masak Langkok-langkok', 2, 1000),
  (10674, 'Completed', '2020-04-07 15:09:00', 17, '', 'Cabe Merah (1Kg)', 1, 36000),
  (10674, 'Completed', '2020-04-07 15:09:00', 18, '', 'Cabe Rawit Hijau (100gr)', 1, 4000),
  (10674, 'Completed', '2020-04-07 15:09:00', 19, '', 'Daun Bawang Prei (250gr)', 1, 5000),
  (10674, 'Completed', '2020-04-07 15:09:00', 20, '', 'Daun Serah', 1, 2000),
  (10674, 'Completed', '2020-04-07 15:09:00', 21, '', 'Jamur Tiram Putih', 2, 4000),
  (10674, 'Completed', '2020-04-07 15:09:00', 22, '', 'Kentang (1kg)', 1, 12000),
  (10674, 'Completed', '2020-04-07 15:09:00', 23, '', 'Sawi Hijau (1kg)', 1, 10000),
  (10674, 'Completed', '2020-04-07 15:09:00', 24, '', 'Petai (250gr)', 2, 10000),
  (10674, 'Completed', '2020-04-07 15:09:00', 25, '', 'Sayur Bayam Segar', 2, 2500),
  (10674, 'Completed', '2020-04-07 15:09:00', 26, '', 'Sayuran Jengkol (10 Biji)', 2, 6000),
  (10674, 'Completed', '2020-04-07 15:09:00', 27, '', 'Tauge Sayuran (250gr)', 3, 2000),
  (10674, 'Completed', '2020-04-07 15:09:00', 28, '', 'Tempe Daun', 2, 2000),
  (10674, 'Completed', '2020-04-07 15:09:00', 29, '', 'Tomat Merah (500gr)', 1, 5000),
  (10674, 'Completed', '2020-04-07 15:09:00', 30, '', 'Ubi Rambat Putih (500gr)', 2, 4000),
  (10674, 'Completed', '2020-04-07 15:09:00', 31, 'Bumbu T 02', 'KOBE Super Crispy Kentucky Tepung Bumbu (75gr)', 2, 3000),
  (10627, 'Completed', '2020-04-07 03:15:00', 1, '', 'Ayam Potong Segar', 8, 8000),
  (10627, 'Completed', '2020-04-07 03:15:00', 2, 'Ikan L 02', 'Ikan Laut Serai bulat Segar (500gr)', 1, 15500),
  (10627, 'Completed', '2020-04-07 03:15:00', 3, '', 'Jamur Tiram Putih', 1, 4000),
  (10627, 'Completed', '2020-04-07 03:15:00', 4, '', 'Kentang (1kg)', 1, 12000),
  (10627, 'Completed', '2020-04-07 03:15:00', 5, '', 'Sayur Baby Pak Coy', 1, 2500),
  (10627, 'Completed', '2020-04-07 03:15:00', 6, '', 'Kunyit (100gr)', 1, 1500),
  (10627, 'Completed', '2020-04-07 03:15:00', 7, 'Bumbu M 24', 'Bumbu Kapulaga 1000', 1, 1000),
  (10627, 'Completed', '2020-04-07 03:15:00', 8, '', 'INDOFOOD Bumbu Penyedap Kaldu Sapi (/pcs)', 2, 500),
  (10627, 'Completed', '2020-04-07 03:15:00', 9, '', 'INDOFOOD Bumbu Penyedap Kaldu Ayam (/pcs)', 2, 500),
  (10627, 'Completed', '2020-04-07 03:15:00', 10, 'Bumbu M 19', 'Indofood Bumbu Racik Tempe Goreng (20gr)', 2, 1000),
  (10457, 'Completed', '2020-04-05 13:53:00', 1, '', 'Baby Corn Jagung Muda Sayuran', 2, 4000),
  (10457, 'Completed', '2020-04-05 13:53:00', 2, '', 'Brokoli Hijau (1Kg)', 1, 20000),
  (10457, 'Completed', '2020-04-05 13:53:00', 3, '', 'Bunga Kol (1kg)', 1, 20000),
  (10457, 'Completed', '2020-04-05 13:53:00', 4, '', 'Kubis Kol Organik (1Kg)', 1, 5000),
  (10457, 'Completed', '2020-04-05 13:53:00', 5, '', 'Labu Siam / jipang (500gr)', 1, 4000),
  (10457, 'Completed', '2020-04-05 13:53:00', 6, '', 'Sawi Hijau (1kg)', 1, 10000),
  (10457, 'Completed', '2020-04-05 13:53:00', 7, '', 'Sayur Wortel (500gr)', 1, 8000),
  (10457, 'Completed', '2020-04-05 13:53:00', 8, '', 'Tomat Merah (1Kg)', 1, 9000),
  (10457, 'Completed', '2020-04-05 13:53:00', 9, '', 'Tahu Asli H.B (isi 10)', 1, 6500),
  (10457, 'Completed', '2020-04-05 13:53:00', 10, '', 'BIMOLI Classic Minyak Goreng (2 Liter)', 1, 25000),
  (10457, 'Completed', '2020-04-05 13:53:00', 11, '', 'ROMA Malkist Crackers (135gr)', 2, 6000);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `list`
  --
  ALTER TABLE `list`
    ADD PRIMARY KEY (`No`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `list`
  --
  ALTER TABLE `list`
    MODIFY `No` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=128;
  COMMIT;
  
  /*!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 */;
  