4dYD1VpG

1CREATE TABLE IF NOT EXISTS produk ( 
2id_produk varchar(5) NOT NULL, 
3nm_produk varchar(30) NOT NULL, 
4satuan varchar(10) NOT NULL, 
5harga decimal(10,0) NOT NULL default '0',
6stock int(3) NOT NULL default '0', 
7PRIMARY KEY (id_produk) 
8) ENGINE=InnoDB DEFAULT CHARSET=latin1;
9
10-- menginput data
11
12-- tabel pelanggan
13INSERT INTO pelanggan VALUES ('P0001', 'Budi Santoso','Jakarta Selatan', '0217327762', 'budi_s@gmail.com');
14INSERT INTO pelanggan VALUES ('P0002', 'Zaskia Putri','Jakarta Selatan', '0217450231', 'z_putri@gmail.com');
15INSERT INTO pelanggan VALUES ('P0003', 'Muhammad Syahranu','Surabaya', '031720000', 'ranu@yahoo.com');
16INSERT INTO pelanggan VALUES ('P0004', 'Putri Cantika Sari','Malang', '0341212700', 'c_putri@gmail.com');
17INSERT INTO pelanggan VALUES ('P0005', 'Siska Shanti','Jakarta Timur', '0217327762', 'siska_sh@yahoo.com');
18INSERT INTO pelanggan VALUES ('P0006', 'Johan Pahing','Surabaya', '03180000', 'jh_top@yahoo.com');
19
20-- tabel produk
21INSERT into produk VALUES('B0001','Buku Tulis','Biji',4500,100);
22INSERT into produk VALUES('B0002','Penghapus','Biji',1500,200);
23INSERT into produk VALUES('B0003','Penggaris','Biji',2500,50);
24INSERT into produk VALUES('B0004','Pensil','Biji',3000,200);
25INSERT into produk VALUES('B0005','Bolpen','Biji',2500,300);
26
27-- tabel pesan
28INSERT into pesan (ID_PELANGGAN,TGL_PESAN) VALUES ('P0001','2015-11-19');
29INSERT into pesan (ID_PELANGGAN,TGL_PESAN) VALUES ('P0002','2015-1-19');
30INSERT into pesan (ID_PELANGGAN,TGL_PESAN) VALUES ('P0003','2015-2-19');
31INSERT into pesan (ID_PELANGGAN,TGL_PESAN) VALUES ('P0001','2015-3-19');
32INSERT into pesan (ID_PELANGGAN,TGL_PESAN) VALUES ('P0002','2015-11-10');
33INSERT into pesan (ID_PELANGGAN,TGL_PESAN) VALUES ('P0005','2015-11-5');
34
35-- tabel detil_pesan
36INSERT into detil_pesan VALUES ('1','B0001',5,4500);
37INSERT into detil_pesan VALUES ('1','B0002',5,1500);
38INSERT into detil_pesan VALUES ('1','B0003',5,2500);
39INSERT into detil_pesan VALUES ('2','B0002',1,1500);
40INSERT into detil_pesan VALUES ('2','B0005',2,2500);
41INSERT into detil_pesan VALUES ('3','B0002',3,1500);
42INSERT into detil_pesan VALUES ('4','B0004',7,3000);
43INSERT into detil_pesan VALUES ('5','B0005',2,2500);
44INSERT into detil_pesan VALUES ('6','B0001',10,4500);