DikDB9ss

1# MySQL-Front 5.1  (Build 4.13)
2
3/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
4/*!40101 SET SQL_MODE='NO_ENGINE_SUBSTITUTION' */;
5/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
6/*!40103 SET SQL_NOTES='ON' */;
7/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
8/*!40014 SET UNIQUE_CHECKS=0 */;
9/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
10/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
11
12
13# Host: localhost    Database: distroku
14# ------------------------------------------------------
15# Server version 5.6.21
16
17#
18# Source for table admin
19#
20
21DROP TABLE IF EXISTS `admin`;
22CREATE TABLE `admin` (
23  `id_admin` int(11) NOT NULL AUTO_INCREMENT,
24  `username` varchar(100) NOT NULL,
25  `password` varchar(100) NOT NULL,
26  `nama_lengkap` varchar(100) NOT NULL,
27  PRIMARY KEY (`id_admin`)
28) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
29
30#
31# Dumping data for table admin
32#
33
34LOCK TABLES `admin` WRITE;
35/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
36INSERT INTO `admin` VALUES (1,'distroku.com','jinkujin123','adiantinofajaradzani');
37/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
38UNLOCK TABLES;
39
40#
41# Source for table ongkir
42#
43
44DROP TABLE IF EXISTS `ongkir`;
45CREATE TABLE `ongkir` (
46  `id_ongkir` int(5) NOT NULL AUTO_INCREMENT,
47  `nama_kota` varchar(100) NOT NULL,
48  `tarif` int(11) NOT NULL,
49  PRIMARY KEY (`id_ongkir`)
50) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
51
52#
53# Dumping data for table ongkir
54#
55
56LOCK TABLES `ongkir` WRITE;
57/*!40000 ALTER TABLE `ongkir` DISABLE KEYS */;
58INSERT INTO `ongkir` VALUES (1,'Regular',10000);
59INSERT INTO `ongkir` VALUES (2,'Expres',25000);
60/*!40000 ALTER TABLE `ongkir` ENABLE KEYS */;
61UNLOCK TABLES;
62
63#
64# Source for table pelanggan
65#
66
67DROP TABLE IF EXISTS `pelanggan`;
68CREATE TABLE `pelanggan` (
69  `id_pelanggan` int(11) NOT NULL AUTO_INCREMENT,
70  `email_pelanggan` varchar(100) NOT NULL,
71  `password_pelanggan` varchar(50) NOT NULL,
72  `nama_pelanggan` varchar(100) NOT NULL,
73  `telepon_pelanggan` varchar(25) NOT NULL,
74  `alamat_pelanggan` text NOT NULL,
75  PRIMARY KEY (`id_pelanggan`)
76) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
77
78#
79# Dumping data for table pelanggan
80#
81
82LOCK TABLES `pelanggan` WRITE;
83/*!40000 ALTER TABLE `pelanggan` DISABLE KEYS */;
84INSERT INTO `pelanggan` VALUES (1,'tino@gmail.com','tino123','Adiantino','089123876812','');
85INSERT INTO `pelanggan` VALUES (2,'edokarnadi@gmail.com','edo123','Edokarnadi','081234890345','');
86INSERT INTO `pelanggan` VALUES (3,'said@gmail.com','said123','Said','@telepon','Babatan kulon progo');
87INSERT INTO `pelanggan` VALUES (4,'bagus@gmail.com','bagus123','Bagus','08512181721','gunung pati ');
88/*!40000 ALTER TABLE `pelanggan` ENABLE KEYS */;
89UNLOCK TABLES;
90
91#
92# Source for table pembelian
93#
94
95DROP TABLE IF EXISTS `pembelian`;
96CREATE TABLE `pembelian` (
97  `id_pembelian` int(11) NOT NULL AUTO_INCREMENT,
98  `id_pelanggan` int(11) NOT NULL,
99  `id_ongkir` int(11) NOT NULL,
100  `tanggal_pembelian` date NOT NULL,
101  `total_pembelian` int(11) NOT NULL,
102  `nama_kota` varchar(100) NOT NULL,
103  `tarif` int(11) NOT NULL,
104  `alamat_pengiriman` text NOT NULL,
105  PRIMARY KEY (`id_pembelian`)
106) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
107
108#
109# Dumping data for table pembelian
110#
111
112LOCK TABLES `pembelian` WRITE;
113/*!40000 ALTER TABLE `pembelian` DISABLE KEYS */;
114INSERT INTO `pembelian` VALUES (33,3,2,'2018-07-23',250000,'Jakarta',10000,'Jln Gendruwo 1 semarang Utara kodepos 12121');
115INSERT INTO `pembelian` VALUES (34,1,2,'2018-07-24',255000,'Jakarta',10000,'Jln Diponegoro No. 1 Jakarta utara kodepos 12311');
116INSERT INTO `pembelian` VALUES (35,1,3,'2018-07-24',134000,'Bandung',14000,'Jln Majapahit no 1 Bandung kodepos 1112');
117INSERT INTO `pembelian` VALUES (36,4,1,'2018-07-24',135000,'Samarang',15000,'jalan gatot Subroto 01 semarang barat kodepo 11221');
118INSERT INTO `pembelian` VALUES (37,4,5,'2018-07-24',255000,'Surabaya',15000,'jalan serondol 3 semarang utara kodepos 01');
119INSERT INTO `pembelian` VALUES (38,1,2,'2018-07-24',130000,'Jakarta',10000,'jln lembayung 3 semarang kota kodepos 119912');
120INSERT INTO `pembelian` VALUES (39,1,2,'2018-07-25',145000,'Expres',25000,'jlan pendrikan kidul no 1 semarang kota kodepos 551234');
121INSERT INTO `pembelian` VALUES (40,1,2,'2018-07-25',145000,'Expres',25000,'');
122INSERT INTO `pembelian` VALUES (41,1,0,'2018-07-25',120000,'',0,'ungaran');
123INSERT INTO `pembelian` VALUES (42,1,2,'2018-07-25',145000,'Expres',25000,'jln serondol 3 ');
124INSERT INTO `pembelian` VALUES (43,1,1,'2018-07-25',575000,'Regular',10000,'jln serondol 1 semarang barat kodepo 551121 ');
125/*!40000 ALTER TABLE `pembelian` ENABLE KEYS */;
126UNLOCK TABLES;
127
128#
129# Source for table pembelian_produk
130#
131
132DROP TABLE IF EXISTS `pembelian_produk`;
133CREATE TABLE `pembelian_produk` (
134  `id_pembelian_produk` int(11) NOT NULL AUTO_INCREMENT,
135  `id_pembelian` int(11) NOT NULL,
136  `id_produk` int(11) NOT NULL,
137  `jumlah` int(11) NOT NULL,
138  `nama` varchar(100) NOT NULL,
139  `harga` int(11) NOT NULL,
140  `jenis` varchar(50) NOT NULL,
141  `brand` varchar(50) NOT NULL,
142  `subharga` int(11) NOT NULL,
143  PRIMARY KEY (`id_pembelian_produk`)
144) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;
145
146#
147# Dumping data for table pembelian_produk
148#
149
150LOCK TABLES `pembelian_produk` WRITE;
151/*!40000 ALTER TABLE `pembelian_produk` DISABLE KEYS */;
152INSERT INTO `pembelian_produk` VALUES (42,33,7,2,'WILLMILL',120000,'T-shirt','Rown',240000);
153INSERT INTO `pembelian_produk` VALUES (43,34,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
154INSERT INTO `pembelian_produk` VALUES (44,34,24,1,'BL PACKO 02',125000,'Girdle','Bloods',125000);
155INSERT INTO `pembelian_produk` VALUES (45,35,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
156INSERT INTO `pembelian_produk` VALUES (46,36,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
157INSERT INTO `pembelian_produk` VALUES (47,37,7,2,'WILLMILL',120000,'T-shirt','Rown',240000);
158INSERT INTO `pembelian_produk` VALUES (48,38,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
159INSERT INTO `pembelian_produk` VALUES (49,39,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
160INSERT INTO `pembelian_produk` VALUES (50,40,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
161INSERT INTO `pembelian_produk` VALUES (51,41,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
162INSERT INTO `pembelian_produk` VALUES (52,42,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
163INSERT INTO `pembelian_produk` VALUES (53,43,7,2,'WILLMILL',120000,'T-shirt','Rown',240000);
164INSERT INTO `pembelian_produk` VALUES (54,43,16,1,'GORJI BLUE NAVY',325000,'Hoodei','Throox',325000);
165/*!40000 ALTER TABLE `pembelian_produk` ENABLE KEYS */;
166UNLOCK TABLES;
167
168#
169# Source for table produk
170#
171
172DROP TABLE IF EXISTS `produk`;
173CREATE TABLE `produk` (
174  `id_produk` int(11) NOT NULL AUTO_INCREMENT,
175  `alamat_distro` text NOT NULL,
176  `nama_produk` varchar(100) NOT NULL,
177  `harga_produk` int(11) NOT NULL,
178  `jenis` varchar(100) NOT NULL,
179  `brand` varchar(50) NOT NULL,
180  `foto_produk` varchar(50) NOT NULL,
181  `deskripsi_produk` text NOT NULL,
182  PRIMARY KEY (`id_produk`)
183) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
184
185#
186# Dumping data for table produk
187#
188
189LOCK TABLES `produk` WRITE;
190/*!40000 ALTER TABLE `produk` DISABLE KEYS */;
191INSERT INTO `produk` VALUES (7,'','WILLMILL',120000,'T-shirt','Rown','4.jpg','Size chart \r\nS: Length 70 x Width 50 cm \r\nM: Length 72 x Width 52 cm \r\nL: Length 74 x Width 54 cm \r\nXL: Length 76 x Width 56 cm ');
192INSERT INTO `produk` VALUES (13,'','PICO',140000,'T-shirt','Rown','rown1.jpg','Size chart \r\nS: Length 70 x Width 50 cm \r\nM: Length 72 x Width 52 cm \r\nL: Length 74 x Width 54 cm \r\nXL: Length 76 x Width 56 cm ');
193INSERT INTO `produk` VALUES (14,'','BLAIR MISTY GREEN',160000,'T-shirt','Throox','Throox1.jpg','(Exclude Shipping Cost)\r\nAvailable Size S M L XL\r\n\r\n');
194INSERT INTO `produk` VALUES (15,'','VORSA',265000,'Basic Flanel','Throox','VORSA.jpg','Available Size S M L XL\r\nall info \r\n- Line : @throoxorg\r\n- Wa : 081393444144\r\n- BBM : 5A1A5844\r\n- Fb : throoxoriginal\r\n');
195INSERT INTO `produk` VALUES (16,'','GORJI BLUE NAVY',325000,'Hoodei','Throox','GORJI BLUE NAVY.jpg','Available Size S M L XL\r\nall info \r\n- Line : @throoxorg\r\n- Wa : 081393444144\r\n- BBM : 5A1A5844\r\n- Fb : throoxoriginal');
196INSERT INTO `produk` VALUES (17,'','GORJI OLIVE BLACK',325000,'Hoodei','Throox','GORJI OLIVE BLACK.jpg','Available Size S M L XL\r\nall info \r\n- Line : @throoxorg\r\n- Wa : 081393444144\r\n- BBM : 5A1A5844\r\n- Fb : throoxoriginal\r\n');
197INSERT INTO `produk` VALUES (18,'','SOCHI MAROON',210000,'Bagpack','Rown','SOCHI MAROON.jpg','Bacgpack with zipper pocket and padded laptop\r\nplace inside.\r\n\r\nSize\r\nlength x width x height = 28 x 13 x 45 cm  \r\n');
198INSERT INTO `produk` VALUES (19,'','TOCHIYA GREY',260000,'Bagpack','Rown','TOCHIYA GREY.jpg','Bacgpack with zipper pocket and padded laptop\r\nplace inside.\r\n\r\nSize\r\nlength x width x height = 28 x 13 x 45 cm ');
199INSERT INTO `produk` VALUES (20,'','PIRHO',240000,'Basic Flanel','Argh','PIRHO.jpg','Colour : Gold\r\nAvailable size : S,M,L,XL\r\n');
200INSERT INTO `produk` VALUES (21,'','LATITUDE',240000,'Bagpack','Argh','LATITUDE.jpg','Color : Navy\r\nInclude Notebook Slot up to 16 inch.');
201INSERT INTO `produk` VALUES (22,'','SPOTTING',280000,'Hoodei','Argh','SPOTTING.jpg','Color : black\r\nAvailable size : M,L,XL');
202INSERT INTO `produk` VALUES (23,'','INFINITY',240000,'Bagpack','Argh','INFINITY.jpg','Color : Red Black\r\nInclude Notebook Slot up to 16 inch.');
203INSERT INTO `produk` VALUES (24,'','BL PACKO 02',125000,'Girdle','Bloods','BL PACKO 02.jpg','warna : coklat\r\npanjang : 130 cm');
204INSERT INTO `produk` VALUES (25,'','HT CERIBE',105000,'Topi','Bloods','HT CERIBE.jpg','-');
205INSERT INTO `produk` VALUES (26,'','Roses Field Pouch',95000,'Roses','Prigel','Roses Field Pouch.jpg','-');
206INSERT INTO `produk` VALUES (27,'','Baju Baru KU',105000,'T-shirt','Bloods','lala.jpg','baju baguus');
207/*!40000 ALTER TABLE `produk` ENABLE KEYS */;
208UNLOCK TABLES;
209
210/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
211/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
212/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
213/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;