CREATE TABLE IF NOT EXISTS `rumah_full_mark` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `dt` datetime DEFAULT NULL,
  `sch_id` tinyint(4) DEFAULT '0',
  `stu_uid` varchar(12) DEFAULT NULL,
  `cls_code` varchar(16) DEFAULT NULL,
  `cls_level` tinyint(4) DEFAULT NULL,
  `cls_name` varchar(32) DEFAULT NULL,
  `examcode` varchar(8) DEFAULT NULL,
  `examname` varchar(12) DEFAULT NULL,
  `year` varchar(5) DEFAULT NULL,
  `rumah_akademik` varchar(4) DEFAULT NULL,
  `rumah_3k` varchar(4) DEFAULT NULL,
  `rumah_hafazan` varchar(4) DEFAULT NULL,
  `rumah_sahsiah` varchar(4) DEFAULT NULL,
  `rumah_koku` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `year` (`year`),
  KEY `sch_id` (`sch_id`),
  KEY `stu_uid` (`stu_uid`),
  KEY `cls_code` (`cls_code`),
  KEY `examcode` (`examcode`),
  KEY `examname` (`examname`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;