 -- 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_gedung`
--

CREATE TABLE IF NOT EXISTS `tb_gedung` (
  `id_gedung` int(11) NOT NULL AUTO_INCREMENT,
  `nama_gedung` varchar(255) NOT NULL,
  `deleted` int(11) NOT NULL,
  PRIMARY KEY (`id_gedung`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tb_gedung`

(11, 'sky eye', 1),
(12, 'sky eyes', 1),
(13, 'Lalalangsat Tower', 1),
(14, '', 1),
(15, '', 1),
(16, '', 1);

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

