/*================================================================  */
/*                 SELAMAT DATANG DI DEANNSETIIA LAND               */
/*                   COPY PASTE SKRIP DIBAWAH INI:                  */
/*================================================================  */


-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 15, 2015 at 03:10 
-- Server version: 5.5.39
-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `rumahtangga`
--

-- --------------------------------------------------------

--
-- Table structure for table `daftarbarang`
--

CREATE TABLE IF NOT EXISTS `daftarbarang` (
`idbarang` int(11) NOT NULL,
  `namabarang` varchar(90) NOT NULL,
  `jumlahbarang` int(11) NOT NULL,
  `kondisibarang` varchar(90) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `daftarbarang`
--

INSERT INTO `daftarbarang` (`idbarang`, `namabarang`, `jumlahbarang`, `kondisibarang`) VALUES
(15, 'Kursi', 1, 'Awet'),
(16, 'Lemari', 0, 'Bagus'),
(17, 'penggaris', 18, 'Baik'),
(18, 'Bulpen', 9909, 'bagus'),
(20, 'Tas', 3, 'Awet');

-- --------------------------------------------------------

--
-- Table structure for table `detiltransaksi`
--

CREATE TABLE IF NOT EXISTS `detiltransaksi` (
`iddetiltransaksi` int(11) NOT NULL,
  `kodetransaksi` int(11) NOT NULL,
  `kodebarang` int(11) NOT NULL,
  `jumlahperbarang` int(11) NOT NULL,
  `filterbarang` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `detiltransaksi`
--

INSERT INTO `detiltransaksi` (`iddetiltransaksi`, `kodetransaksi`, `kodebarang`, `jumlahperbarang`, `filterbarang`) VALUES
(1, 384829, 18, 3, 0),
(2, 384829, 20, 3, 0),
(3, 3306800, 15, 1, 0),
(4, 9588801, 15, 1, 0),
(5, 9909359, 15, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `pengguna`
--

CREATE TABLE IF NOT EXISTS `pengguna` (
`id` int(11) NOT NULL,
  `nama` varchar(90) NOT NULL,
  `username` varchar(90) NOT NULL,
  `katasandi` varchar(90) NOT NULL,
  `kontak` varchar(90) NOT NULL,
  `foto` varchar(90) NOT NULL,
  `status` int(11) NOT NULL,
  `hitungrek` int(11) NOT NULL,
  `pp` varchar(20) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `pengguna`
--

INSERT INTO `pengguna` (`id`, `nama`, `username`, `katasandi`, `kontak`, `foto`, `status`, `hitungrek`, `pp`) VALUES
(1, 'Administrator', '0', '7215ee9c7d9dc229d2921a40e899ec5f', '089694463666', 'undefined.jpg', 0, 0, ''),
(4, 'Lembaga', '[email protected]', '7215ee9c7d9dc229d2921a40e899ec5f', '0899443666', 'undefined.jpg', 3, 0, '4'),
(5, 'x', 'x@x', '7215ee9c7d9dc229d2921a40e899ec5f', '085248968200', '5', 3, 0, 'undefined.jpg'),
(6, 'Administrator2', '02', '7215ee9c7d9dc229d2921a40e899ec5f', '089694463666', 'undefined.jpg', 99, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `transaksi`
--

CREATE TABLE IF NOT EXISTS `transaksi` (
`idtransaksi` int(11) NOT NULL,
  `jmlrequest` int(11) NOT NULL,
  `peminjam` varchar(90) NOT NULL,
  `tglpinjam` date NOT NULL,
  `tglbalikin` date NOT NULL,
  `keperluan` varchar(90) NOT NULL,
  `statustrans` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9909360 ;

--
-- Dumping data for table `transaksi`
--

INSERT INTO `transaksi` (`idtransaksi`, `jmlrequest`, `peminjam`, `tglpinjam`, `tglbalikin`, `keperluan`, `statustrans`) VALUES
(384829, 2, '[email protected]', '2015-01-13', '2015-01-20', 'untuk coba', 4),
(3306800, 1, '[email protected]', '2015-01-20', '2015-01-28', 'l', 2),
(9588801, 1, '[email protected]', '2015-01-21', '2015-01-29', 'd', 1),
(9909359, 1, '[email protected]', '2015-01-28', '2015-01-31', 'fds', 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `daftarbarang`
--
ALTER TABLE `daftarbarang`
 ADD PRIMARY KEY (`idbarang`);

--
-- Indexes for table `detiltransaksi`
--
ALTER TABLE `detiltransaksi`
 ADD PRIMARY KEY (`iddetiltransaksi`);

--
-- Indexes for table `pengguna`
--
ALTER TABLE `pengguna`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transaksi`
--
ALTER TABLE `transaksi`
 ADD PRIMARY KEY (`idtransaksi`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `daftarbarang`
--
ALTER TABLE `daftarbarang`
MODIFY `idbarang` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `detiltransaksi`
--
ALTER TABLE `detiltransaksi`
MODIFY `iddetiltransaksi` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `pengguna`
--
ALTER TABLE `pengguna`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `transaksi`
--
ALTER TABLE `transaksi`
MODIFY `idtransaksi` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9909360;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*================================================================  */
/*       PENEMU DAN PEMILIK DEANNSETIIA LAND FANNIL ABROR           */
/*================================================================  */