· 9 years ago · Jan 24, 2017, 01:08 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.2.2
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Jan 24, 2017 at 02:02 PM
7-- Server version: 5.5.27
8-- PHP Version: 5.4.7
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `toko_buku`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `buku`
27--
28
29CREATE TABLE IF NOT EXISTS `buku` (
30 `no` int(10) NOT NULL AUTO_INCREMENT,
31 `id_buku` int(10) NOT NULL,
32 `judul` varchar(30) NOT NULL,
33 `noisbn` int(30) NOT NULL,
34 `penulis` varchar(30) NOT NULL,
35 `penerbit` varchar(30) NOT NULL,
36 `tahun` varchar(10) NOT NULL,
37 `stok` int(10) NOT NULL,
38 `harga_pokok` int(10) NOT NULL,
39 `harga_jual` int(10) NOT NULL,
40 `ppn` int(10) NOT NULL,
41 `diskon` int(3) NOT NULL,
42 PRIMARY KEY (`no`,`id_buku`,`noisbn`),
43 KEY `id_buku` (`id_buku`)
44) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
45
46--
47-- Dumping data for table `buku`
48--
49
50INSERT INTO `buku` (`no`, `id_buku`, `judul`, `noisbn`, `penulis`, `penerbit`, `tahun`, `stok`, `harga_pokok`, `harga_jual`, `ppn`, `diskon`) VALUES
51(2, 12, 'puisi malam', 132132, 'ismail', 'binatang jaya', '2017', 13, 12000, 2000, 10, 10);
52
53-- --------------------------------------------------------
54
55--
56-- Table structure for table `distributor`
57--
58
59CREATE TABLE IF NOT EXISTS `distributor` (
60 `no` int(10) NOT NULL AUTO_INCREMENT,
61 `id_distributor` int(10) NOT NULL,
62 `nama` varchar(30) NOT NULL,
63 `alamat` text NOT NULL,
64 `telepon` varchar(15) NOT NULL,
65 PRIMARY KEY (`no`,`id_distributor`),
66 KEY `id_distributor` (`id_distributor`)
67) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
68
69--
70-- Dumping data for table `distributor`
71--
72
73INSERT INTO `distributor` (`no`, `id_distributor`, `nama`, `alamat`, `telepon`) VALUES
74(2, 4, 'axu', 'fdf', '90986676776');
75
76-- --------------------------------------------------------
77
78--
79-- Table structure for table `kasir`
80--
81
82CREATE TABLE IF NOT EXISTS `kasir` (
83 `no` int(10) NOT NULL AUTO_INCREMENT,
84 `id_kasir` int(10) NOT NULL,
85 `nama` varchar(30) NOT NULL,
86 `alamat` text NOT NULL,
87 `telepon` varchar(15) NOT NULL,
88 `status` varchar(30) NOT NULL,
89 `username` varchar(30) NOT NULL,
90 `password` varchar(30) NOT NULL,
91 `akses` varchar(20) NOT NULL,
92 PRIMARY KEY (`no`,`id_kasir`,`username`),
93 UNIQUE KEY `password` (`password`),
94 KEY `id_kasir` (`id_kasir`)
95) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `pasok`
101--
102
103CREATE TABLE IF NOT EXISTS `pasok` (
104 `no` int(10) NOT NULL AUTO_INCREMENT,
105 `id_pasok` int(10) NOT NULL,
106 `id_distributor` int(10) NOT NULL,
107 `id_buku` int(10) NOT NULL,
108 `jumlah` int(30) NOT NULL,
109 `tanggal` varchar(15) NOT NULL,
110 PRIMARY KEY (`no`,`id_pasok`),
111 UNIQUE KEY `id_distributor` (`id_distributor`),
112 UNIQUE KEY `id_buku` (`id_buku`)
113) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
114
115--
116-- Dumping data for table `pasok`
117--
118
119INSERT INTO `pasok` (`no`, `id_pasok`, `id_distributor`, `id_buku`, `jumlah`, `tanggal`) VALUES
120(1, 2, 4, 12, 23, '1 januari 2017');
121
122-- --------------------------------------------------------
123
124--
125-- Table structure for table `penjualan`
126--
127
128CREATE TABLE IF NOT EXISTS `penjualan` (
129 `no` int(10) NOT NULL AUTO_INCREMENT,
130 `id_penjualan` int(10) NOT NULL,
131 `id_buku` int(10) NOT NULL,
132 `id_kasir` int(10) NOT NULL,
133 `jumlah` int(15) NOT NULL,
134 `total` int(20) NOT NULL,
135 `tanggal` varchar(15) NOT NULL,
136 PRIMARY KEY (`no`,`id_penjualan`),
137 UNIQUE KEY `id_buku` (`id_buku`),
138 UNIQUE KEY `id_kasir` (`id_kasir`)
139) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
140
141--
142-- Constraints for dumped tables
143--
144
145--
146-- Constraints for table `kasir`
147--
148ALTER TABLE `kasir`
149 ADD CONSTRAINT `kasir_ibfk_1` FOREIGN KEY (`id_kasir`) REFERENCES `penjualan` (`id_kasir`);
150
151--
152-- Constraints for table `pasok`
153--
154ALTER TABLE `pasok`
155 ADD CONSTRAINT `pasok_ibfk_1` FOREIGN KEY (`id_distributor`) REFERENCES `distributor` (`id_distributor`),
156 ADD CONSTRAINT `pasok_ibfk_2` FOREIGN KEY (`id_buku`) REFERENCES `buku` (`id_buku`);
157
158--
159-- Constraints for table `penjualan`
160--
161ALTER TABLE `penjualan`
162 ADD CONSTRAINT `penjualan_ibfk_1` FOREIGN KEY (`id_buku`) REFERENCES `buku` (`id_buku`);
163
164/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
165/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
166/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;