DN6z8AAn

1-- MySQL dump 10.13  Distrib 5.6.35, for osx10.9 (x86_64)
2--
3-- Host: localhost    Database: toko_kn
4-- ------------------------------------------------------
5-- Server version	5.6.35
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `kategori`
20--
21
22DROP TABLE IF EXISTS `kategori`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `kategori` (
26  `id_kategori` int(11) NOT NULL AUTO_INCREMENT,
27  `nama` varchar(50) NOT NULL,
28  PRIMARY KEY (`id_kategori`)
29) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Dumping data for table `kategori`
34--
35
36LOCK TABLES `kategori` WRITE;
37/*!40000 ALTER TABLE `kategori` DISABLE KEYS */;
38INSERT INTO `kategori` VALUES (1,'Elektronik'),(2,'Fashion'),(3,'Makanan'),(4,'Minuman');
39/*!40000 ALTER TABLE `kategori` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `produk`
44--
45
46DROP TABLE IF EXISTS `produk`;
47/*!40101 SET @saved_cs_client     = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `produk` (
50  `id_produk` int(11) NOT NULL AUTO_INCREMENT,
51  `nama` varchar(100) NOT NULL,
52  `harga` int(11) NOT NULL,
53  `kuantitas` int(11) NOT NULL,
54  `id_kategori` int(11) NOT NULL,
55  `image` varchar(255) NOT NULL,
56  PRIMARY KEY (`id_produk`)
57) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `produk`
62--
63
64LOCK TABLES `produk` WRITE;
65/*!40000 ALTER TABLE `produk` DISABLE KEYS */;
66INSERT INTO `produk` VALUES (8,'Baju',60000,20,2,'76baju.jpg'),(9,'Celana Jeans',120000,25,2,'53celana-jeans.jpg'),(10,'Celana Cargo',100000,20,2,'99celana-cargo.jpg'),(11,'Jaket Kulit',230000,15,2,'37jaket-kulit.jpg'),(12,'Bandana',10000,50,2,'33bandana.jpg'),(14,'Pocophone',6250000,5,1,'70pocophone.jpg'),(15,'Iphone X',12320000,10,1,'29iphone-x.png'),(16,'Burger',50000,35,3,'82burger.jpg'),(18,'French Fries',20000,32,3,'50french-fries.jpg'),(19,'Milkshake',5000,12,4,'69milkshake.jpg'),(20,'Green Tea',12000,46,4,'30green-tea.jpg'),(21,'Drone',2400000,26,1,'91drone.jpg'),(23,'Arduino Uno',160000,12,1,'34arduino-uno.jpg'),(26,'Asus ROG',46999000,21,1,'79asus-rog.jpg');
67/*!40000 ALTER TABLE `produk` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `user`
72--
73
74DROP TABLE IF EXISTS `user`;
75/*!40101 SET @saved_cs_client     = @@character_set_client */;
76/*!40101 SET character_set_client = utf8 */;
77CREATE TABLE `user` (
78  `id` int(11) NOT NULL AUTO_INCREMENT,
79  `username` varchar(50) NOT NULL,
80  `password` text NOT NULL,
81  PRIMARY KEY (`id`),
82  UNIQUE KEY `username_2` (`username`)
83) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Dumping data for table `user`
88--
89
90LOCK TABLES `user` WRITE;
91/*!40000 ALTER TABLE `user` DISABLE KEYS */;
92INSERT INTO `user` VALUES (1,'admin','$2y$10$Cg0KRRvHt/Gz./odmWB3iehdxuRneFCuTJMYpue/g.9P7NjJUIHF2');
93/*!40000 ALTER TABLE `user` ENABLE KEYS */;
94UNLOCK TABLES;
95/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
96
97/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
98/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
99/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
100/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
101/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
102/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
103/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
104
105-- Dump completed on 2019-04-26 10:44:21