 --
 
 CREATE TABLE IF NOT EXISTS `jadwal` (
-  `hari` text NOT NULL,
+  `hari` int(1) NOT NULL,
   `jam` time NOT NULL,
   `kode_kelas` varchar(6) NOT NULL,
   `nomor_ruangan` int(2) NOT NULL,
-  PRIMARY KEY (`jam`,`hari`(6)),
+  PRIMARY KEY (`jam`,`hari`),
   KEY `kode_kelas` (`kode_kelas`),
   KEY `nomor_ruangan` (`nomor_ruangan`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 13, 2016 at 04:33 PM
-- Server version: 5.6.16
-- PHP Version: 5.5.11


  `alamat` text NOT NULL,
  `ttl` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

