 --
 
 CREATE TABLE IF NOT EXISTS `presensi` (
-  `hari` int(1) NOT NULL,
+  `hari` date NOT NULL,
   `status` text NOT NULL,
   `kode_kelas` varchar(6) NOT NULL,
-  PRIMARY KEY (`hari`),
+  PRIMARY KEY (`hari`,`kode_kelas`),
   KEY `kode_kelas` (`kode_kelas`),
   KEY `kode_kelas_2` (`kode_kelas`)
 ) 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


  `kode_kelas` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kode_kelas` (`kode_kelas`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Constraints for dumped tables
