Created
June 17, 2020 00:57
-
-
Save blogcacanid/9582a80fb91466fa5abfb2f76c28ab5f to your computer and use it in GitHub Desktop.
products.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE `products` ( | |
`product_id` int(5) NOT NULL AUTO_INCREMENT, | |
`product_name` varchar(100) DEFAULT NULL, | |
`product_price` int(11) DEFAULT NULL, | |
`created_at` timestamp DEFAULT NULL, | |
`updated_at` timestamp DEFAULT NULL, | |
PRIMARY KEY (`product_id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
-- Dumping data for table `product` | |
INSERT INTO `products` (`product_id`, `product_name`, `product_price`, `created_at`, `updated_at`) VALUES | |
(1, 'SO KLIN Bio-matic Front Load 2kg Box', 59500, '2020-06-16 21:17:48', NULL), | |
(2, 'SO KLIN Softergent 1.8kg Bag', 36500, '2020-06-16 21:17:48', NULL), | |
(3, 'SO KLIN Softerner 800g Bag', 17000, '2020-06-16 21:17:48', NULL), | |
(4, 'SO KLIN Bi0-matic Liquid 800ml pch', 23500, '2020-06-16 21:17:48', NULL), | |
(5, 'SO KLIN Liquid 800ml pch', 17700, '2020-06-16 21:17:48', NULL), | |
(6, 'ROYALE Pelembut Pakaian 800ml pch', 25500, '2020-06-16 21:17:48', NULL), | |
(7, 'SO KLIN RAPIKA Pelicin Pakaian 400ml', 6000, '2020-06-16 21:17:48', NULL), | |
(8, 'MAMA LEMON 800ml pch', 11900, '2020-06-16 21:17:48', NULL), | |
(9, 'MORIN Jam Strawberry 170g btl', 19000, '2020-06-16 21:17:48', NULL), | |
(10, 'MORIN Jam Hazelnut with Cocoa 150g btl', 22500, '2020-06-16 21:17:48', NULL), | |
(11, 'MORIN Jam Choco Peanut 150g btl', 17700, '2020-06-16 21:17:48', NULL), | |
(12, 'NUSANTARA Madu Murni 250ml btl', 58500, '2020-06-16 21:17:48', NULL), | |
(13, 'NUSANTARA Madu Murni Royal Jelly Bee Pollen 250ml btl', 68500, '2020-06-16 21:17:48', NULL), | |
(14, 'PIKOPI Kopi Instant 3 in 1 10x20g pck', 8800, '2020-06-16 21:17:48', NULL), | |
(15, 'LUWAK White Koffie Tarik Malaka 6x30g pck', 12900, '2020-06-16 21:17:48', NULL), | |
(16, 'TOP Coffee 2 in 1 Kopi+Gula 10s pck', 8200, '2020-06-16 21:17:48', NULL), | |
(17, 'ARLA PUREGROW Susu Bubuk Organik 360g box', 138500, '2020-06-16 21:17:48', NULL), | |
(18, 'NUTELLA Jam Spread Kecil Hazelnut 200g btl', 10000, '2020-06-16 21:17:48', NULL), | |
(19, 'ICHITAN Thai Milk Tea/Coffe/Green Tea 310ml btl', 8500, '2020-06-16 21:17:48', NULL), | |
(20, 'AQUA Air Mineral 24x600ml kemasan karton', 20000, '2020-06-16 21:17:48', NULL), | |
(21, 'PIATOS Snack Kentang Sapi Panggang 35g pcs', 6000, '2020-06-16 21:17:48', NULL), | |
(22, 'MORISCA Lapis Legit Singkong Srikaya 365g pcs', 26900, '2020-06-16 21:17:48', NULL), | |
(23, 'INACO Mini Jelly 15s pack', 7500, '2020-06-16 21:17:48', NULL), | |
(24, 'MAMASUKA Bon Nori Original/Spicy 30g btl', 15000, '2020-06-16 21:17:48', NULL), | |
(25, 'ROSE Tepung Beras 500g pcs', 9500, '2020-06-16 21:17:48', NULL), | |
(26, 'SARIWANGI Teh Celup Asli 30x1.85g box', 6000, '2020-06-16 21:17:48', NULL), | |
(27, 'ENERGEN Cereal & Susu Instant 10s pcs', 16000, '2020-06-16 21:17:48', NULL), | |
(28, 'INDOMILK Susu Cair 1 L tpk semua varian', 16700, '2020-06-16 21:17:48', NULL), | |
(29, 'ADEN SARI CHING KU Lemon 350ml btl', 6800, '2020-06-16 21:17:48', NULL), | |
(30, 'FRESTEA 500ml btl semua varian', 6000, '2020-06-16 21:17:48', NULL), | |
(31, 'BANGO Kecap Manis Refill 575/550ml pch', 23500, '2020-06-16 21:17:48', NULL), | |
(32, 'ABC Sardines 425g klg semua varian', 20800, '2020-06-16 21:17:48', NULL), | |
(33, 'KRAFT Keju Quick Melt 165g box', 27300, '2020-06-16 21:17:48', NULL), | |
(34, 'CADBURY Dairy Milk Chocolate 62g pck', 14900, '2020-06-16 21:17:48', NULL), | |
(35, 'REGAL Biscuit Marie 230g pck', 18400, '2020-06-16 21:17:48', NULL), | |
(36, 'QTELA Keripik Singkong 60g pck', 5800, '2020-06-16 21:17:48', NULL), | |
(37, 'PEPSODENT Pasta Gigi White 225g tub', 13400, '2020-06-16 21:17:48', NULL), | |
(38, 'HEAD & SHOULDERS Shampoo 160/165ml btl', 26500, '2020-06-16 21:17:48', NULL), | |
(39, 'CAP LANG Minyak Kayu Putih 120ml btl', 51500, '2020-06-16 21:17:48', NULL), | |
(40, 'MERRY Pants Good Skin S26/M22/L20 bag', 50500, '2020-06-16 21:17:48', NULL), | |
(41, 'YOFARIA Activ8 170ml btl', 6900, '2020-06-16 21:17:48', NULL), | |
(42, 'PRIMA RASA Fruit Cocktail 220 cup', 7500, '2020-06-16 21:17:48', NULL), | |
(43, 'AUTAN Lotion Anti Nyamuk SS Floral & Protect 50ml tub', 9900, '2020-06-16 21:17:48', NULL), | |
(44, 'GLADE Automatic Spray Refill Ocean Escape 145ml klg', 32500, '2020-06-16 21:17:48', NULL); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment