· 6 years ago · Sep 04, 2019, 02:04 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 04, 2019 at 04:00 AM
7-- Server version: 5.6.21
8-- PHP Version: 5.6.3
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: `bukudb`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `buku`
27--
28
29CREATE TABLE IF NOT EXISTS `buku` (
30 `buku_isbn` char(13) NOT NULL DEFAULT '',
31 `buku_judul` varchar(75) DEFAULT NULL,
32 `penerbit_id` char(4) DEFAULT NULL,
33 `buku_tglterbit` date DEFAULT NULL,
34 `buku_jmlhalaman` int(11) DEFAULT NULL,
35 `buku_deskripsi` text,
36 `buku_harga` decimal(10,0) DEFAULT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
39--
40-- Dumping data for table `buku`
41--
42
43INSERT INTO `buku` (`buku_isbn`, `buku_judul`, `penerbit_id`, `buku_tglterbit`, `buku_jmlhalaman`, `buku_deskripsi`, `buku_harga`) VALUES
44('halo kamoeh', 'aqqqu yank selaloe tersaqiti', 'mars', '2019-09-03', 8000, 'Cinta', '28'),
45('html', 'malas ngoding', 'nopi', '2019-01-23', 1001, 'wkwk', '6000');
46
47-- --------------------------------------------------------
48
49--
50-- Table structure for table `kategori`
51--
52
53CREATE TABLE IF NOT EXISTS `kategori` (
54 `kategori_id` int(11) NOT NULL DEFAULT '0',
55 `kategori_nama` varchar(25) DEFAULT NULL
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58-- --------------------------------------------------------
59
60--
61-- Table structure for table `penerbit`
62--
63
64CREATE TABLE IF NOT EXISTS `penerbit` (
65 `penerbit_id` char(4) NOT NULL DEFAULT '',
66 `penerbit_nama` varchar(50) DEFAULT NULL
67) ENGINE=InnoDB DEFAULT CHARSET=latin1;
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `pengarang`
73--
74
75CREATE TABLE IF NOT EXISTS `pengarang` (
76 `pengarang_id` char(3) NOT NULL DEFAULT '',
77 `pengarang_nama` varchar(30) DEFAULT NULL
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80--
81-- Indexes for dumped tables
82--
83
84--
85-- Indexes for table `buku`
86--
87ALTER TABLE `buku`
88 ADD PRIMARY KEY (`buku_isbn`);
89
90--
91-- Indexes for table `kategori`
92--
93ALTER TABLE `kategori`
94 ADD PRIMARY KEY (`kategori_id`);
95
96--
97-- Indexes for table `penerbit`
98--
99ALTER TABLE `penerbit`
100 ADD PRIMARY KEY (`penerbit_id`);
101
102--
103-- Indexes for table `pengarang`
104--
105ALTER TABLE `pengarang`
106 ADD PRIMARY KEY (`pengarang_id`);
107
108/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
109/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
110/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;