export db

-- phpMyAdmin SQL Dump
-- version 4.4.15.9
-- https://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 26, 2018 at 08:04 AM
-- Server version: 5.6.37
-- PHP Version: 7.1.8

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

--
-- Database: `fb_ruang`
--

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

--
-- Table structure for table `pemesanan`
--

CREATE TABLE IF NOT EXISTS `pemesanan` (
  `id` int(11) NOT NULL,
  `nama_pemesan` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '4',
  `ruang_id` int(11) NOT NULL,
  `jadwal_id` int(11) NOT NULL,
  `nama_ruangan` varchar(100) NOT NULL,
  `prodi_dosen` varchar(50) NOT NULL,
  `jam_mulai` varchar(20) NOT NULL,
  `sks` varchar(5) NOT NULL,
  `tanggal` date DEFAULT NULL,
  `status` enum('yes','no','other','waiting') NOT NULL DEFAULT 'waiting',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pemesanan`
--

INSERT INTO `pemesanan` (`id`, `nama_pemesan`, `user_id`, `ruang_id`, `jadwal_id`, `nama_ruangan`, `prodi_dosen`, `jam_mulai`, `sks`, `tanggal`, `status`, `updated`) VALUES
(56, 'andi', 4, 6, 1, '', 'pte-yusran', '', '2', '2018-12-17', 'yes', '2018-12-25 13:48:17'),
(57, 'ade', 4, 8, 9, '', 'PTI-Ghufran', '', '2', '2018-12-17', 'yes', '2018-12-25 13:48:31'),
(59, 'akbar', 4, 11, 1, '', 'pte-bustomi', '', '3', '2018-12-17', 'no', '2018-12-25 13:48:31'),
(60, 'ipad', 4, 12, 11, '', 'pte-mira', '', '3', '2018-12-17', 'no', '2018-12-25 13:48:31'),
(61, 'muhajir', 4, 10, 10, '', 'pte-mira', '', '2', '2018-12-17', 'no', '2018-12-25 13:48:31'),
(62, 'andi', 4, 10, 12, '', 'pti-andika', '', '2', '2018-12-17', 'no', '2018-12-25 13:48:31'),
(63, 'dian', 4, 3, 1, '', 'pte-yusran', '', '2', '2018-12-17', 'yes', '2018-12-25 13:48:31'),
(64, 'ipad', 4, 8, 8, '', 'pte-bustomi', '', '1', '2018-12-17', 'no', '2018-12-25 13:48:31'),
(65, 'akbar', 4, 2, 1, '', 'pti-andika', '', '3', '2018-12-21', 'yes', '2018-12-25 13:48:31'),
(66, 'muhajir', 4, 5, 1, '', 'pte-bustomi', '', '1', '2018-12-24', 'no', '2018-12-25 13:48:31'),
(67, 'Khairul', 4, 5, 3, '', 'PTI - Syubhan', '', '3', '2018-12-24', 'yes', '2018-12-25 13:48:31'),
(68, 'Haji', 4, 7, 1, '', 'PTI - Bustomi', '', '2', '2018-12-24', 'waiting', '2018-12-25 13:48:31'),
(69, 'Nanda', 4, 12, 4, '', 'PTI - Basrul', '', '3', '2018-12-24', 'yes', '2018-12-25 13:48:31'),
(70, 'Fauzi', 4, 11, 1, '', 'PTI - Ghufran', '', '2', '2018-12-24', 'yes', '2018-12-25 13:48:31'),
(71, 'Akbar', 4, 2, 5, '', 'PBL - Sri', '', '3', '2018-12-24', 'yes', '2018-12-25 13:48:31');

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL,
  `nip_nim` varchar(20) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `password` varchar(50) NOT NULL,
  `status` varchar(20) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `nip_nim`, `nama`, `password`, `status`) VALUES
(1, '1408107010060', 'putra arifah', '3fc0a7acf087f549ac2b266baf94b8b1', 'mahasiswa'),
(2, '123456789012345', 'OP', '25d55ad283aa400af464c76d713c07ad', 'admin'),
(3, '141414', 'ade', '827ccb0eea8a706c4c34a16891f84e7b', 'admin'),
(4, '121212', 'akbar', '827ccb0eea8a706c4c34a16891f84e7b', 'dosen');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pemesanan`
--
ALTER TABLE `pemesanan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ruang_id` (`ruang_id`),
  ADD KEY `jadwal_id` (`jadwal_id`),
  ADD KEY `user_id` (`user_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pemesanan`
--
ALTER TABLE `pemesanan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=72;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `pemesanan`
--
ALTER TABLE `pemesanan`

  ADD CONSTRAINT `pemesanan_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;