 -- Table structure for table `tb_jadwal`
 --
 
-CREATE TABLE IF NOT EXISTS `tb_jadwal` (
-  `id_jadwal` int(11) NOT NULL AUTO_INCREMENT,
+DROP TABLE IF EXISTS `tb_jadwal`;
+CREATE TABLE `tb_jadwal` (
+  `id_jadwal` int(11) NOT NULL,
   `id_ruangan` int(11) NOT NULL,
   `jam_awal` varchar(10) NOT NULL,
   `jam_akhir` varchar(10) NOT NULL,
   `status` int(11) NOT NULL,
-  `deleted` int(11) NOT NULL,
-  PRIMARY KEY (`id_jadwal`),
-  KEY `fk_id_room` (`id_ruangan`),
-  KEY `fk_id_jam` (`jam_awal`)
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+  `deleted` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 --
 -- Dumping data for table `tb_jadwal`

-- Table structure for table `tb_det_booking`
--

CREATE TABLE IF NOT EXISTS `tb_det_booking` (
  `id_det_booking` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_booking` int(11) NOT NULL,
  KEY `fk_id_booking` (`id_booking`),
  KEY `fk_id_jadwal` (`id_jadwal`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 12, 2017 at 11:12 AM
-- Server version: 10.1.19-MariaDB
-- PHP Version: 5.6.28

