/* 
SQLyog v3.03
Host - localhost : Database - toko
**************************************************************
Server version 3.23.47-max-debug
*/

create database if not exists `toko`;

use `toko`;

/*
Table struture for admin
*/

drop table if exists `admin`;
CREATE TABLE `admin` (
  `id_admin` int(10) unsigned NOT NULL auto_increment,
  `nama` varchar(20) NOT NULL default '',
  `passwd` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id_admin`)
) TYPE=MyISAM;

/*
Table data for toko.admin
*/

INSERT INTO `admin` VALUES (123,'muchib','1234');

/*
Table struture for daftar_buku
*/

drop table if exists `daftar_buku`;
CREATE TABLE `daftar_buku` (
  `id_buku` int(10) unsigned NOT NULL auto_increment,
  `nama_buku` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id_buku`)
) TYPE=MyISAM;

/*
Table data for toko.daftar_buku
*/

INSERT INTO `daftar_buku` VALUES (11112,'pc');
INSERT INTO `daftar_buku` VALUES (11113,'abc');
INSERT INTO `daftar_buku` VALUES (11114,'buah');
INSERT INTO `daftar_buku` VALUES (11115,'kakau');
INSERT INTO `daftar_buku` VALUES (11116,'besi');
INSERT INTO `daftar_buku` VALUES (11117,'pembuatan kertas');
INSERT INTO `daftar_buku` VALUES (11118,'jamu tradisional');
INSERT INTO `daftar_buku` VALUES (11119,'sulap');
INSERT INTO `daftar_buku` VALUES (111110,'pengenalan hewan');
INSERT INTO `daftar_buku` VALUES (111111,'panduan belajar komp');
INSERT INTO `daftar_buku` VALUES (111112,'rantai makanan');
INSERT INTO `daftar_buku` VALUES (111113,'ipa 3');
INSERT INTO `daftar_buku` VALUES (111114,'ips 3');
INSERT INTO `daftar_buku` VALUES (111115,'tehnik mengambar');
INSERT INTO `daftar_buku` VALUES (111116,'kimia');
INSERT INTO `daftar_buku` VALUES (111117,'pkn');
INSERT INTO `daftar_buku` VALUES (111118,'sejarah indo');
INSERT INTO `daftar_buku` VALUES (111119,'georgafi');
INSERT INTO `daftar_buku` VALUES (111120,'ekonomi');
INSERT INTO `daftar_buku` VALUES (111121,'ti');
INSERT INTO `daftar_buku` VALUES (111122,'seni lukis');
INSERT INTO `daftar_buku` VALUES (111123,'teknik menulis berit');
INSERT INTO `daftar_buku` VALUES (111124,'teknik menulis 10 ja');
INSERT INTO `daftar_buku` VALUES (111125,'pengenalan organ tub');
INSERT INTO `daftar_buku` VALUES (111126,'tutorial ppt');
INSERT INTO `daftar_buku` VALUES (111127,'tutorial potoshop');
INSERT INTO `daftar_buku` VALUES (111128,'tutorial vb');
INSERT INTO `daftar_buku` VALUES (111129,'pengenalan struktur');
INSERT INTO `daftar_buku` VALUES (111130,'dunia air');

/*
Table struture for nama_karyawan
*/

drop table if exists `nama_karyawan`;
CREATE TABLE `nama_karyawan` (
  `id_karyawan` int(10) unsigned NOT NULL auto_increment,
  `nama_karyawan` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id_karyawan`)
) TYPE=MyISAM;

/*
Table data for toko.nama_karyawan
*/

INSERT INTO `nama_karyawan` VALUES (101,'bejo');
INSERT INTO `nama_karyawan` VALUES (102,'joko');
INSERT INTO `nama_karyawan` VALUES (103,'mamat');
INSERT INTO `nama_karyawan` VALUES (104,'wawan');
INSERT INTO `nama_karyawan` VALUES (105,'didik');

/*
Table struture for nama_member
*/

drop table if exists `nama_member`;
CREATE TABLE `nama_member` (
  `id_member` int(10) unsigned NOT NULL auto_increment,
  `nama_member` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id_member`)
) TYPE=MyISAM;

/*
Table data for toko.nama_member
*/

INSERT INTO `nama_member` VALUES (1001,'ratna');
INSERT INTO `nama_member` VALUES (1002,'dina');
INSERT INTO `nama_member` VALUES (1003,'manis');
INSERT INTO `nama_member` VALUES (1004,'wawan');
INSERT INTO `nama_member` VALUES (1005,'rina');
INSERT INTO `nama_member` VALUES (1006,'samson');
INSERT INTO `nama_member` VALUES (1007,'sasa');
INSERT INTO `nama_member` VALUES (1008,'rani');
INSERT INTO `nama_member` VALUES (1009,'rere');
INSERT INTO `nama_member` VALUES (1010,'gangsar');
INSERT INTO `nama_member` VALUES (1011,'dana');
INSERT INTO `nama_member` VALUES (1012,'dini');
INSERT INTO `nama_member` VALUES (1013,'dodik');
INSERT INTO `nama_member` VALUES (1014,'fara');
INSERT INTO `nama_member` VALUES (1015,'fatus');
INSERT INTO `nama_member` VALUES (1016,'vina');
INSERT INTO `nama_member` VALUES (1017,'vivi');
INSERT INTO `nama_member` VALUES (1018,'fatus');
INSERT INTO `nama_member` VALUES (1019,'saleh');
INSERT INTO `nama_member` VALUES (1020,'soleh');
INSERT INTO `nama_member` VALUES (1021,'rini');
INSERT INTO `nama_member` VALUES (1022,'unyil');
INSERT INTO `nama_member` VALUES (1023,'usrok');
INSERT INTO `nama_member` VALUES (1024,'lala');
INSERT INTO `nama_member` VALUES (1025,'lila');
INSERT INTO `nama_member` VALUES (1026,'lani');
INSERT INTO `nama_member` VALUES (1027,'lia');
INSERT INTO `nama_member` VALUES (1028,'luluk');
INSERT INTO `nama_member` VALUES (1029,'likah');
INSERT INTO `nama_member` VALUES (1030,'lina');