-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 13, 2016 at 06:34 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 7.0.6

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 utf8mb4 */;

--
-- Database: `db_adminfinance`
--

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

--
-- Table structure for table `bbm`
--

CREATE TABLE `bbm` (
  `id_bbm` char(5) NOT NULL,
  `jenis_bbm` varchar(30) NOT NULL,
  `harga` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bbm`
--

INSERT INTO `bbm` (`id_bbm`, `jenis_bbm`, `harga`) VALUES
('SOL01', 'Solar', 5150);

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

--
-- Table structure for table `karyawan`
--

CREATE TABLE `karyawan` (
  `nip` varchar(20) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `tgl_lhir` varchar(15) NOT NULL,
  `jenkel` varchar(10) NOT NULL,
  `alamat` varchar(70) NOT NULL,
  `no_tlp` varchar(13) NOT NULL,
  `jabatan` varchar(50) NOT NULL,
  `stts` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karyawan`
--

INSERT INTO `karyawan` (`nip`, `nama`, `tgl_lhir`, `jenkel`, `alamat`, `no_tlp`, `jabatan`, `stts`) VALUES
('880OMI', 'I Ketut Rastika', '1964-06-08', 'Laki-laki', 'Malawe', '00', 'SDM', 'Aktif'),
('MZ0N', 'Mirzon', '2016-07-13', 'Laki-laki', '-', '0', 'Manager Spare Part', 'Aktif');

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `userid` varchar(20) NOT NULL,
  `pass` varchar(30) NOT NULL,
  `cabang` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`userid`, `pass`, `cabang`) VALUES
('bu5et', '4llahuak', 'pusat'),
('kridamataram', 'krida2016', 'mataram'),
('kridaselong', 'krida2016', 'selong');

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

--
-- Table structure for table `supir`
--

CREATE TABLE `supir` (
  `kode` int(11) NOT NULL,
  `nip` varchar(20) NOT NULL,
  `nopol` char(10) NOT NULL,
  `cabang` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supir`
--

INSERT INTO `supir` (`kode`, `nip`, `nopol`, `cabang`) VALUES
(3, 'MZ0N', 'DR888KT', 'Pusat'),
(4, '880OMI', 'DR1200AC', 'Pusat');

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

--
-- Table structure for table `trasportasi`
--

CREATE TABLE `trasportasi` (
  `nopol` char(10) NOT NULL,
  `jenis` char(10) NOT NULL,
  `tipe` varchar(30) NOT NULL,
  `ket` varchar(20) NOT NULL,
  `coa` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trasportasi`
--

INSERT INTO `trasportasi` (`nopol`, `jenis`, `tipe`, `ket`, `coa`) VALUES
('DR1200AC', 'Mobil', 'Avanza', 'Operasional', '511.02.06'),
('DR888KT', 'Mobil', 'Avanza', 'Operasional', '511.02.06');

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

--
-- Table structure for table `voucher`
--

CREATE TABLE `voucher` (
  `no_voucher` int(11) NOT NULL,
  `tgl_voucher` varchar(13) NOT NULL,
  `jam` varchar(13) NOT NULL,
  `nip` varchar(20) NOT NULL,
  `nopol` char(10) NOT NULL,
  `km_akhir` varchar(30) NOT NULL,
  `id_bbm` char(5) NOT NULL,
  `liter` varchar(12) NOT NULL,
  `total` decimal(10,0) DEFAULT NULL,
  `userid` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bbm`
--
ALTER TABLE `bbm`
  ADD PRIMARY KEY (`id_bbm`);

--
-- Indexes for table `karyawan`
--
ALTER TABLE `karyawan`
  ADD PRIMARY KEY (`nip`);

--
-- Indexes for table `login`
--
ALTER TABLE `login`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `supir`
--
ALTER TABLE `supir`
  ADD PRIMARY KEY (`kode`),
  ADD KEY `nip` (`nip`),
  ADD KEY `nopol` (`nopol`);

--
-- Indexes for table `trasportasi`
--
ALTER TABLE `trasportasi`
  ADD PRIMARY KEY (`nopol`);

--
-- Indexes for table `voucher`
--
ALTER TABLE `voucher`
  ADD PRIMARY KEY (`no_voucher`),
  ADD KEY `nip` (`nip`),
  ADD KEY `nopol` (`nopol`),
  ADD KEY `id_bbm` (`id_bbm`),
  ADD KEY `userid` (`userid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `supir`
--
ALTER TABLE `supir`
  MODIFY `kode` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `voucher`
--
ALTER TABLE `voucher`
  MODIFY `no_voucher` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `supir`
--
ALTER TABLE `supir`
  ADD CONSTRAINT `supir_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `karyawan` (`nip`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `supir_ibfk_2` FOREIGN KEY (`nopol`) REFERENCES `trasportasi` (`nopol`) ON DELETE NO ACTION ON UPDATE CASCADE;

--
-- Constraints for table `voucher`
--
ALTER TABLE `voucher`
  ADD CONSTRAINT `voucher_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `karyawan` (`nip`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `voucher_ibfk_2` FOREIGN KEY (`nopol`) REFERENCES `trasportasi` (`nopol`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `voucher_ibfk_3` FOREIGN KEY (`id_bbm`) REFERENCES `bbm` (`id_bbm`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `voucher_ibfk_4` FOREIGN KEY (`userid`) REFERENCES `login` (`userid`) ON DELETE NO ACTION ON UPDATE CASCADE;

/*!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 */;