/*
SQLyog Community v12.5.1 (64 bit)
MySQL - 5.7.21-log : Database - penjualan
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`penjualan` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `penjualan`;

/*Data for the table `barang` */

insert  into `barang`(`id_barang`,`nama`,`stok`,`harga`,`persen_laba`,`diskon`,`id_jenis_brg`,`id_suplier`) values 
('B001','Wafer Tango',104,318,5,3,'1','S001'),
('B002','Wafer Nissin',54,2760,6,3,'1','S002'),
('B003','Ember',150,1747,5,0,'2','S001'),
('B004','Payung',59,11644,6,0,'2','S002'),
('B005','Mangkok',45,3432430,8,0,'2','S003'),
('B006','Payung',56,765,8,0,'2','S001'),
('B007','Chiki',34,1500,5,3,'2',NULL),
('B008','Pulpen',50,2000,1,1,'3',NULL);

/*Data for the table `detail_transaksi` */

insert  into `detail_transaksi`(`kode_transaksi`,`id_barang`,`jumlah`) values 
('T001','B001',2),
('T001','B002',3),
('T001','B003',4),
('T002','B002',7),
('T002','B003',4),
('T003','B001',3),
('T003','B004',4),
('T004','B001',4),
('T004','B004',5);

/*Data for the table `jenis_barang` */

insert  into `jenis_barang`(`id_jenis_brg`,`nama_jenis_brg`) values 
('1','Makanan'),
('2','Peralatan'),
('3','Alat Tulis'),
('6','Bola');

/*Data for the table `karyawan` */

insert  into `karyawan`(`id_karyawan`,`nama`,`alamat`,`telepon`,`tgl_lahir`,`gaji`) values 
('K001','Anton','Jl. Borobudur No.97','0897654321','1987-04-08',2000000),
('K002','Rudi','Jl. Prambanan No.78','08123456789','1984-08-06',3000000),
('K003','Rina','Jl. Nusa Indah','08976543323','1985-09-12',1000000),
('K004','Joko','Jl. Lely','08654388022','1986-07-12',900000),
('K005','Raditya','Jl. Lingkar','08573639485','1984-06-16',6000000);

/*Data for the table `pelanggan` */

insert  into `pelanggan`(`id_pelanggan`,`nama`,`jenis_kelamin`,`alamat`,`telepon`,`tgl_lahir`,`jenis_pelanggan`) values 
('P001','Tyas','P','Jl. Resimuka Barat III No. 8','08574292929','1987-02-01','S'),
('P002','Riyanto','P','Jl. Denpasar','08123456789','1987-06-04','S'),
('P003','apa','P','Jl. Sulawesi','08132123456','1986-05-04','S'),
('P009','Andi Ikhsan','P','Jl. Makasar 13','08164228112','1969-07-19','G'),
('P011','Debimpri','P','Jl. Balikpapan No.8','0858732620','1975-03-11','G'),
('P012','Hardiansyah','P','Jl. Bondowoso No.95','0817465011','1970-12-08','G'),
('P013','Ibrahim','P','Jl. Kacer 2 No.19','0818909846','1974-06-05','S'),
('P014','Gatot','W','Jl. Bukit Menoreh No.66',NULL,'1984-10-02','S'),
('P015','Adita Putri','W','Jl. Giri Loka 3 No.28','08164622383','1988-02-02','S');

/*Data for the table `suplier` */

insert  into `suplier`(`id_suplier`,`nama`,`alamat`,`telepon`) values 
('S001','Pungkas Mandiri','Jl. Nusa Indah No. 288','08987654321'),
('S002','Dapur Ngepul','Jl. Dapurmu No. 666','08123456789'),
('S003','Patmo','Jl. Raya No. 23','09876543211'),
('S004','Sumber Makmur','Jl. Kedamaian No. 17','08765432246');

/*Data for the table `transaksi` */

insert  into `transaksi`(`kode_transaksi`,`tgl_transaksi`,`id_pelanggan`,`id_karyawan`) values 
('T001','2014-06-07','P001','K001'),
('T002','2014-09-08','P002','K001'),
('T003','2014-06-23','P015','K002'),
('T004','2014-06-09','P001','K002'),
('T005','2014-09-07',NULL,'K001');

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