· 6 years ago · Oct 09, 2019, 05:26 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.7.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 09 Okt 2019 pada 07.21
7-- Versi Server: 5.6.20
8-- PHP Version: 5.5.15
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: `buku`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `buku`
27--
28
29CREATE TABLE IF NOT EXISTS `buku` (
30 `buku_isbn` char(13) NOT NULL,
31 `buku_judul` varchar(75) DEFAULT NULL,
32 `penerbit_id` char(4) DEFAULT NULL,
33 `buku_tglterbit` date DEFAULT NULL,
34 `buku_jmlhalaman` int(4) DEFAULT NULL,
35 `buku_deskripsi` text,
36 `buku_harga` decimal(10,0) DEFAULT NULL,
37 `buku_sinopsis` text
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39
40--
41-- Dumping data untuk tabel `buku`
42--
43
44INSERT INTO `buku` (`buku_isbn`, `buku_judul`, `penerbit_id`, `buku_tglterbit`, `buku_jmlhalaman`, `buku_deskripsi`, `buku_harga`, `buku_sinopsis`) VALUES
45('222-34222-1-0', 'mudah belajar photosho', 'PB01', '2003-07-02', 300, '', '4200', NULL),
46('222-34222-1-1', 'panduan praktis menggunakan corel draw', 'PB02', '2004-03-15', 400, '', '55000', NULL),
47('222-34222-2-1', 'implementasi TCP/IP di linux', 'PB08', '2008-11-21', 230, '', '35000', NULL),
48('222-34222-5-1', 'membuat aplikasi web dengan ASP', 'PB07', '2004-08-01', 180, '', '30000', NULL),
49('222-34222-5-2', 'belajar sendiri internet marketing', 'PB07', '2007-01-24', 150, '', '39000', NULL),
50('222-34222-5-3', 'panduan menggunakan yahoo dan google', 'PB07', '2007-01-24', 243, '', '39000', NULL),
51('4686', 'dfgyh', NULL, NULL, NULL, NULL, NULL, NULL),
52('666-96771-2-0', 'panduan membangun jaringan TCP/IP', 'PB08', '2006-08-02', 200, '', '6000', NULL),
53('6u', 'fdg', NULL, NULL, NULL, NULL, NULL, NULL),
54('777-76732-5-0', 'cara belajar cepat php 6', 'PB07', '2010-05-02', 600, '', '95000', NULL);
55
56--
57-- Indexes for dumped tables
58--
59
60--
61-- Indexes for table `buku`
62--
63ALTER TABLE `buku`
64 ADD PRIMARY KEY (`buku_isbn`);
65
66/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
67/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
68/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;