CREATE TABLE `stu` (
  `id` bigint(20) NOT NULL,
  `cdate` datetime DEFAULT '0000-00-00 00:00:00',
  `rdate` date DEFAULT NULL,
  `edate` date DEFAULT NULL,
  `sch_id` int(11) DEFAULT '0',
  `clslevel` int(11) DEFAULT '0',
  `clscode` varchar(8) DEFAULT NULL,
  `ses` int(11) DEFAULT '0',
  `ses_cls_id` int(11) DEFAULT '0',
  `uid` varchar(40) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `ic` varchar(32) DEFAULT NULL,
  `intake` varchar(8) NOT NULL,
  `sex` varchar(16) DEFAULT NULL,
  `race` varchar(16) DEFAULT NULL,
  `religion` varchar(16) DEFAULT NULL,
  `plogin` datetime NOT NULL,
  `p1name` varchar(64) DEFAULT NULL,
  `p1imgProfile` text,
  `p1_firebase_id` text,
  `p1ic` varchar(16) DEFAULT NULL,
  `p1rel` varchar(16) DEFAULT NULL,
  `p1hp` varchar(12) DEFAULT NULL,
  `p2name` varchar(64) DEFAULT NULL,
  `p2imgProfile` text,
  `p2_firebase_id` text,
  `p2ic` varchar(16) DEFAULT NULL,
  `p2rel` varchar(16) DEFAULT NULL,
  `isislah` tinyint(4) DEFAULT '0',
  `ishostel` tinyint(4) DEFAULT '0',
  `isstaff` tinyint(4) DEFAULT '0',
  `isyatim` tinyint(4) DEFAULT '0',
  `isyatimpiatu` tinyint(4) DEFAULT '0',
  `isanakangkat` tinyint(4) DEFAULT '0',
  `isothers` tinyint(4) DEFAULT '0',
  `iskawasan` tinyint(4) DEFAULT '0',
  `isfeefree` tinyint(4) DEFAULT '0',
  `isfeeonanak` tinyint(4) DEFAULT '0',
  `isfeenew` tinyint(4) DEFAULT '0',
  `isfakir` tinyint(4) DEFAULT '0',
  `isspecial` tinyint(4) DEFAULT '0',
  `isinter` tinyint(4) DEFAULT '0',
  `isblock` tinyint(4) DEFAULT '0',
  `ismurabbi` tinyint(4) DEFAULT '0',
  `status` tinyint(4) DEFAULT '0',
  `file` varchar(16) DEFAULT NULL,
  `tmp` varchar(10) DEFAULT NULL,
  `adm` varchar(12) DEFAULT NULL,
  `ts` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `stu` ADD PRIMARY KEY (`id`);

ALTER TABLE `stu` ADD UNIQUE KEY `uid` (`uid`);

ALTER TABLE `stu` ADD KEY `ic` (`ic`);

ALTER TABLE `stu` ADD KEY `p1ic` (`p1ic`);

ALTER TABLE `stu` ADD KEY `p2ic` (`p2ic`);

ALTER TABLE `stu` ADD KEY `sch_id` (`sch_id`);

ALTER TABLE `stu` ADD KEY `name` (`name`);

ALTER TABLE `stu` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

ALTER TABLE `stu` ADD `isblockcomm` TEXT NOT NULL AFTER `isblock`;

ALTER TABLE `stu` ADD `isblockdt` TEXT NOT NULL  AFTER `isblockcomm`;

ALTER TABLE `stu` ADD `att_isstatus` tinyint(4) NOT NULL DEFAULT '0' AFTER `att_finger`;

ALTER TABLE `stu` ADD `att_in_ts` datetime NOT NULL AFTER `att_isstatus`;

ALTER TABLE `stu` ADD `att_out_ts` datetime NOT NULL AFTER `att_in_ts`;

SELECT rdate,sch_id,ses,uid,name,ic,hp,mel,addr,bandar,poskod,state,p1name,p1ic,p1mel,p1hp,p2name,p2ic,p2mel,p2hp,p3name,p3ic,p3mel,p3hp FROM `stu`