· 8 years ago · Mar 16, 2018, 12:38 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Mar 04, 2018 at 12:32 AM
7-- Server version: 5.7.19
8-- PHP Version: 5.6.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `db_perpustakaan`
23--
24CREATE DATABASE IF NOT EXISTS `db_perpustakaan` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `db_perpustakaan`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `mst_anggota`
31--
32
33DROP TABLE IF EXISTS `mst_anggota`;
34CREATE TABLE IF NOT EXISTS `mst_anggota` (
35 `id_anggota` int(6) UNSIGNED NOT NULL AUTO_INCREMENT,
36 `id_jeniskelamin` int(1) NOT NULL,
37 `id_jurusan` int(2) NOT NULL,
38 `nama` varchar(50) NOT NULL,
39 `alamat` varchar(100) NOT NULL,
40 `hp` varchar(15) NOT NULL,
41 `isused` char(1) NOT NULL,
42 `isactivated` char(1) NOT NULL,
43 `createdby` int(6) NOT NULL,
44 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
45 `updatedby` int(6) DEFAULT NULL,
46 `updateddate` timestamp NULL DEFAULT '0000-00-00 00:00:00',
47 PRIMARY KEY (`id_anggota`)
48) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `mst_buku`
54--
55
56DROP TABLE IF EXISTS `mst_buku`;
57CREATE TABLE IF NOT EXISTS `mst_buku` (
58 `id_buku` int(5) NOT NULL AUTO_INCREMENT,
59 `id_penerbit` int(3) NOT NULL,
60 `id_jenisbuku` int(3) NOT NULL,
61 `id_rak` int(3) NOT NULL,
62 `nama` varchar(10) NOT NULL,
63 `tahunterbit` int(4) NOT NULL,
64 `jumlahhalaman` int(4) NOT NULL,
65 `isused` char(1) NOT NULL,
66 `isactivated` char(1) NOT NULL,
67 `createdby` int(6) NOT NULL,
68 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
69 `updatedby` int(6) DEFAULT NULL,
70 `updateddate` timestamp NULL DEFAULT NULL,
71 PRIMARY KEY (`id_buku`)
72) ENGINE=InnoDB DEFAULT CHARSET=latin1;
73
74-- --------------------------------------------------------
75
76--
77-- Table structure for table `mst_jenisbuku`
78--
79
80DROP TABLE IF EXISTS `mst_jenisbuku`;
81CREATE TABLE IF NOT EXISTS `mst_jenisbuku` (
82 `id_jenisbuku` int(3) NOT NULL AUTO_INCREMENT,
83 `nama` varchar(10) NOT NULL,
84 `isused` char(1) NOT NULL,
85 `isactivated` char(1) NOT NULL,
86 `createdby` int(6) NOT NULL,
87 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
88 `updatedby` int(6) DEFAULT NULL,
89 `updateddate` timestamp NULL DEFAULT NULL,
90 PRIMARY KEY (`id_jenisbuku`)
91) ENGINE=InnoDB DEFAULT CHARSET=latin1;
92
93-- --------------------------------------------------------
94
95--
96-- Table structure for table `mst_jeniskelamin`
97--
98
99DROP TABLE IF EXISTS `mst_jeniskelamin`;
100CREATE TABLE IF NOT EXISTS `mst_jeniskelamin` (
101 `id_jeniskelamin` int(1) NOT NULL AUTO_INCREMENT,
102 `nama` varchar(10) NOT NULL,
103 `isused` char(1) NOT NULL,
104 `isactivated` char(1) NOT NULL,
105 `createdby` int(6) NOT NULL,
106 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
107 `updatedby` int(6) DEFAULT NULL,
108 `updateddate` timestamp NULL DEFAULT NULL,
109 PRIMARY KEY (`id_jeniskelamin`)
110) ENGINE=InnoDB DEFAULT CHARSET=latin1;
111
112-- --------------------------------------------------------
113
114--
115-- Table structure for table `mst_jurusan`
116--
117
118DROP TABLE IF EXISTS `mst_jurusan`;
119CREATE TABLE IF NOT EXISTS `mst_jurusan` (
120 `id_jurusan` int(2) NOT NULL AUTO_INCREMENT,
121 `nama` varchar(10) NOT NULL,
122 `isused` char(1) NOT NULL,
123 `isactivated` char(1) NOT NULL,
124 `createdby` int(6) NOT NULL,
125 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
126 `updatedby` int(6) DEFAULT NULL,
127 `updateddate` timestamp NULL DEFAULT NULL,
128 PRIMARY KEY (`id_jurusan`)
129) ENGINE=InnoDB DEFAULT CHARSET=latin1;
130
131-- --------------------------------------------------------
132
133--
134-- Table structure for table `mst_penerbit`
135--
136
137DROP TABLE IF EXISTS `mst_penerbit`;
138CREATE TABLE IF NOT EXISTS `mst_penerbit` (
139 `id_penerbit` int(3) NOT NULL AUTO_INCREMENT,
140 `nama` varchar(10) NOT NULL,
141 `isused` char(1) NOT NULL,
142 `isactivated` char(1) NOT NULL,
143 `createdby` int(6) NOT NULL,
144 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
145 `updatedby` int(6) DEFAULT NULL,
146 `updateddate` timestamp NULL DEFAULT NULL,
147 PRIMARY KEY (`id_penerbit`)
148) ENGINE=InnoDB DEFAULT CHARSET=latin1;
149
150-- --------------------------------------------------------
151
152--
153-- Table structure for table `mst_rak`
154--
155
156DROP TABLE IF EXISTS `mst_rak`;
157CREATE TABLE IF NOT EXISTS `mst_rak` (
158 `id_rak` int(3) NOT NULL AUTO_INCREMENT,
159 `nama` varchar(10) NOT NULL,
160 `isused` char(1) NOT NULL,
161 `isactivated` char(1) NOT NULL,
162 `createdby` int(6) NOT NULL,
163 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
164 `updatedby` int(6) DEFAULT NULL,
165 `updateddate` timestamp NULL DEFAULT NULL,
166 PRIMARY KEY (`id_rak`)
167) ENGINE=InnoDB DEFAULT CHARSET=latin1;
168
169-- --------------------------------------------------------
170
171--
172-- Table structure for table `sys_user`
173--
174
175DROP TABLE IF EXISTS `sys_user`;
176CREATE TABLE IF NOT EXISTS `sys_user` (
177 `id_user` int(4) NOT NULL AUTO_INCREMENT,
178 `id_member` int(4) NOT NULL,
179 `username` varchar(15) NOT NULL,
180 `password` varchar(15) NOT NULL,
181 `isused` char(1) NOT NULL,
182 `isactivated` char(1) NOT NULL,
183 `createdby` int(6) NOT NULL,
184 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
185 `updatedby` int(6) DEFAULT NULL,
186 `updateddate` timestamp NULL DEFAULT NULL,
187 PRIMARY KEY (`id_user`)
188) ENGINE=InnoDB DEFAULT CHARSET=latin1;
189
190-- --------------------------------------------------------
191
192--
193-- Table structure for table `trx_peminjaman`
194--
195
196DROP TABLE IF EXISTS `trx_peminjaman`;
197CREATE TABLE IF NOT EXISTS `trx_peminjaman` (
198 `id_peminjaman` int(6) NOT NULL AUTO_INCREMENT,
199 `id_anggota` int(6) NOT NULL,
200 `id_buku` int(5) NOT NULL,
201 `tanggalpinjam` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
202 `tanggalkembali` timestamp NOT NULL,
203 `keterlambatan` int(3) NOT NULL,
204 `denda` int(6) NOT NULL,
205 `isused` char(1) NOT NULL,
206 `isactivated` char(1) NOT NULL,
207 `createdby` int(6) NOT NULL,
208 `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
209 `updatedby` int(6) DEFAULT NULL,
210 `updateddate` timestamp NULL DEFAULT NULL,
211 PRIMARY KEY (`id_peminjaman`)
212) ENGINE=InnoDB DEFAULT CHARSET=latin1;
213COMMIT;
214
215/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
216/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
217/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;