# MySQL-Front 5.1  (Build 4.13)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


# Host: localhost    Database: distroku
# ------------------------------------------------------
# Server version 5.6.21

#
# Source for table admin
#

DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id_admin` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `nama_lengkap` varchar(100) NOT NULL,
  PRIMARY KEY (`id_admin`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

#
# Dumping data for table admin
#

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,'distroku.com','jinkujin123','adiantinofajaradzani');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table ongkir
#

DROP TABLE IF EXISTS `ongkir`;
CREATE TABLE `ongkir` (
  `id_ongkir` int(5) NOT NULL AUTO_INCREMENT,
  `nama_kota` varchar(100) NOT NULL,
  `tarif` int(11) NOT NULL,
  PRIMARY KEY (`id_ongkir`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

#
# Dumping data for table ongkir
#

LOCK TABLES `ongkir` WRITE;
/*!40000 ALTER TABLE `ongkir` DISABLE KEYS */;
INSERT INTO `ongkir` VALUES (1,'Regular',10000);
INSERT INTO `ongkir` VALUES (2,'Expres',25000);
/*!40000 ALTER TABLE `ongkir` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table pelanggan
#

DROP TABLE IF EXISTS `pelanggan`;
CREATE TABLE `pelanggan` (
  `id_pelanggan` int(11) NOT NULL AUTO_INCREMENT,
  `email_pelanggan` varchar(100) NOT NULL,
  `password_pelanggan` varchar(50) NOT NULL,
  `nama_pelanggan` varchar(100) NOT NULL,
  `telepon_pelanggan` varchar(25) NOT NULL,
  `alamat_pelanggan` text NOT NULL,
  PRIMARY KEY (`id_pelanggan`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

#
# Dumping data for table pelanggan
#

LOCK TABLES `pelanggan` WRITE;
/*!40000 ALTER TABLE `pelanggan` DISABLE KEYS */;
INSERT INTO `pelanggan` VALUES (1,'tino@gmail.com','tino123','Adiantino','089123876812','');
INSERT INTO `pelanggan` VALUES (2,'edokarnadi@gmail.com','edo123','Edokarnadi','081234890345','');
INSERT INTO `pelanggan` VALUES (3,'said@gmail.com','said123','Said','@telepon','Babatan kulon progo');
INSERT INTO `pelanggan` VALUES (4,'bagus@gmail.com','bagus123','Bagus','08512181721','gunung pati ');
/*!40000 ALTER TABLE `pelanggan` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table pembelian
#

DROP TABLE IF EXISTS `pembelian`;
CREATE TABLE `pembelian` (
  `id_pembelian` int(11) NOT NULL AUTO_INCREMENT,
  `id_pelanggan` int(11) NOT NULL,
  `id_ongkir` int(11) NOT NULL,
  `tanggal_pembelian` date NOT NULL,
  `total_pembelian` int(11) NOT NULL,
  `nama_kota` varchar(100) NOT NULL,
  `tarif` int(11) NOT NULL,
  `alamat_pengiriman` text NOT NULL,
  PRIMARY KEY (`id_pembelian`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

#
# Dumping data for table pembelian
#

LOCK TABLES `pembelian` WRITE;
/*!40000 ALTER TABLE `pembelian` DISABLE KEYS */;
INSERT INTO `pembelian` VALUES (33,3,2,'2018-07-23',250000,'Jakarta',10000,'Jln Gendruwo 1 semarang Utara kodepos 12121');
INSERT INTO `pembelian` VALUES (34,1,2,'2018-07-24',255000,'Jakarta',10000,'Jln Diponegoro No. 1 Jakarta utara kodepos 12311');
INSERT INTO `pembelian` VALUES (35,1,3,'2018-07-24',134000,'Bandung',14000,'Jln Majapahit no 1 Bandung kodepos 1112');
INSERT INTO `pembelian` VALUES (36,4,1,'2018-07-24',135000,'Samarang',15000,'jalan gatot Subroto 01 semarang barat kodepo 11221');
INSERT INTO `pembelian` VALUES (37,4,5,'2018-07-24',255000,'Surabaya',15000,'jalan serondol 3 semarang utara kodepos 01');
INSERT INTO `pembelian` VALUES (38,1,2,'2018-07-24',130000,'Jakarta',10000,'jln lembayung 3 semarang kota kodepos 119912');
INSERT INTO `pembelian` VALUES (39,1,2,'2018-07-25',145000,'Expres',25000,'jlan pendrikan kidul no 1 semarang kota kodepos 551234');
INSERT INTO `pembelian` VALUES (40,1,2,'2018-07-25',145000,'Expres',25000,'');
INSERT INTO `pembelian` VALUES (41,1,0,'2018-07-25',120000,'',0,'ungaran');
INSERT INTO `pembelian` VALUES (42,1,2,'2018-07-25',145000,'Expres',25000,'jln serondol 3 ');
INSERT INTO `pembelian` VALUES (43,1,1,'2018-07-25',575000,'Regular',10000,'jln serondol 1 semarang barat kodepo 551121 ');
/*!40000 ALTER TABLE `pembelian` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table pembelian_produk
#

DROP TABLE IF EXISTS `pembelian_produk`;
CREATE TABLE `pembelian_produk` (
  `id_pembelian_produk` int(11) NOT NULL AUTO_INCREMENT,
  `id_pembelian` int(11) NOT NULL,
  `id_produk` int(11) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `harga` int(11) NOT NULL,
  `jenis` varchar(50) NOT NULL,
  `brand` varchar(50) NOT NULL,
  `subharga` int(11) NOT NULL,
  PRIMARY KEY (`id_pembelian_produk`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

#
# Dumping data for table pembelian_produk
#

LOCK TABLES `pembelian_produk` WRITE;
/*!40000 ALTER TABLE `pembelian_produk` DISABLE KEYS */;
INSERT INTO `pembelian_produk` VALUES (42,33,7,2,'WILLMILL',120000,'T-shirt','Rown',240000);
INSERT INTO `pembelian_produk` VALUES (43,34,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
INSERT INTO `pembelian_produk` VALUES (44,34,24,1,'BL PACKO 02',125000,'Girdle','Bloods',125000);
INSERT INTO `pembelian_produk` VALUES (45,35,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
INSERT INTO `pembelian_produk` VALUES (46,36,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
INSERT INTO `pembelian_produk` VALUES (47,37,7,2,'WILLMILL',120000,'T-shirt','Rown',240000);
INSERT INTO `pembelian_produk` VALUES (48,38,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
INSERT INTO `pembelian_produk` VALUES (49,39,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
INSERT INTO `pembelian_produk` VALUES (50,40,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
INSERT INTO `pembelian_produk` VALUES (51,41,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
INSERT INTO `pembelian_produk` VALUES (52,42,7,1,'WILLMILL',120000,'T-shirt','Rown',120000);
INSERT INTO `pembelian_produk` VALUES (53,43,7,2,'WILLMILL',120000,'T-shirt','Rown',240000);
INSERT INTO `pembelian_produk` VALUES (54,43,16,1,'GORJI BLUE NAVY',325000,'Hoodei','Throox',325000);
/*!40000 ALTER TABLE `pembelian_produk` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table produk
#

DROP TABLE IF EXISTS `produk`;
CREATE TABLE `produk` (
  `id_produk` int(11) NOT NULL AUTO_INCREMENT,
  `alamat_distro` text NOT NULL,
  `nama_produk` varchar(100) NOT NULL,
  `harga_produk` int(11) NOT NULL,
  `jenis` varchar(100) NOT NULL,
  `brand` varchar(50) NOT NULL,
  `foto_produk` varchar(50) NOT NULL,
  `deskripsi_produk` text NOT NULL,
  PRIMARY KEY (`id_produk`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

#
# Dumping data for table produk
#

LOCK TABLES `produk` WRITE;
/*!40000 ALTER TABLE `produk` DISABLE KEYS */;
INSERT 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 ');
INSERT 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 ');
INSERT 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');
INSERT 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');
INSERT 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');
INSERT 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');
INSERT 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');
INSERT 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 ');
INSERT INTO `produk` VALUES (20,'','PIRHO',240000,'Basic Flanel','Argh','PIRHO.jpg','Colour : Gold\r\nAvailable size : S,M,L,XL\r\n');
INSERT INTO `produk` VALUES (21,'','LATITUDE',240000,'Bagpack','Argh','LATITUDE.jpg','Color : Navy\r\nInclude Notebook Slot up to 16 inch.');
INSERT INTO `produk` VALUES (22,'','SPOTTING',280000,'Hoodei','Argh','SPOTTING.jpg','Color : black\r\nAvailable size : M,L,XL');
INSERT INTO `produk` VALUES (23,'','INFINITY',240000,'Bagpack','Argh','INFINITY.jpg','Color : Red Black\r\nInclude Notebook Slot up to 16 inch.');
INSERT INTO `produk` VALUES (24,'','BL PACKO 02',125000,'Girdle','Bloods','BL PACKO 02.jpg','warna : coklat\r\npanjang : 130 cm');
INSERT INTO `produk` VALUES (25,'','HT CERIBE',105000,'Topi','Bloods','HT CERIBE.jpg','-');
INSERT INTO `produk` VALUES (26,'','Roses Field Pouch',95000,'Roses','Prigel','Roses Field Pouch.jpg','-');
INSERT INTO `produk` VALUES (27,'','Baju Baru KU',105000,'T-shirt','Bloods','lala.jpg','baju baguus');
/*!40000 ALTER TABLE `produk` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;