-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jan 19, 2024 at 03:41 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `punchsys_yuhhuadb`
-- 

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

-- 
-- Table structure for table `punchsys_announce`
-- 

CREATE TABLE `punchsys_announce` (
  `id` int(2) NOT NULL auto_increment,
  `dateFrom` date NOT NULL,
  `dateEnd` date NOT NULL,
  `descr` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `punchsys_announce`
-- 


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

-- 
-- Table structure for table `punchsys_exsttg`
-- 

CREATE TABLE `punchsys_exsttg` (
  `name` varchar(30) NOT NULL,
  `val` text NOT NULL,
  `descr` text NOT NULL,
  `tb_order` int(3) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `punchsys_exsttg`
-- 

INSERT INTO `punchsys_exsttg` VALUES ('attd_teachergroup', '1', 'teacher attd group [group id]', 3);
INSERT INTO `punchsys_exsttg` VALUES ('attd_pejabatgroup', '3,2,5', 'pejabat attd group [group id]', 4);
INSERT INTO `punchsys_exsttg` VALUES ('scanid', '0', '<span style=''color: #000000''>face recognation [scanned id]</span>', 2);
INSERT INTO `punchsys_exsttg` VALUES ('face_mc', '0', '<span style=''color: #000000''>with [face recognation device]</span>', 1);
INSERT INTO `punchsys_exsttg` VALUES ('enable_pjbt_staff', '1', 'pejabat boleh add/edit staff', 5);
INSERT INTO `punchsys_exsttg` VALUES ('enable_pjbt_remark', '1', 'pejabat boleh buat remark', 6);
INSERT INTO `punchsys_exsttg` VALUES ('enable_pjbt_punchrecord', '0', 'pejabat boleh edit masak punch-in', 7);
INSERT INTO `punchsys_exsttg` VALUES ('enable_pjbt_report', '1', 'pejabat boleh tengok report', 8);
INSERT INTO `punchsys_exsttg` VALUES ('enable_pjbt_setting', '0', 'pejabat boleh buat setting', 9);
INSERT INTO `punchsys_exsttg` VALUES ('enable_pjbt_rpt5late', '0', 'pejabat boleh edit masak datang/keluar dgn guna [ REPORT 5 ]', 10);
INSERT INTO `punchsys_exsttg` VALUES ('announce', '0', 'Enable function [announcement]<br>1: enable, 0: disable', 11);

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

-- 
-- Table structure for table `punchsys_holiday`
-- 

CREATE TABLE `punchsys_holiday` (
  `id` int(2) NOT NULL auto_increment,
  `holDateFm` date NOT NULL,
  `holDateTo` date NOT NULL,
  `holDesc` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;

-- 
-- Dumping data for table `punchsys_holiday`
-- 

INSERT INTO `punchsys_holiday` VALUES (48, '2024-12-25', '2024-12-25', 'Hari Krismas');
INSERT INTO `punchsys_holiday` VALUES (47, '2024-11-01', '2024-11-01', 'Hari Keputeraan Sultan Perak');
INSERT INTO `punchsys_holiday` VALUES (46, '2024-10-31', '2024-10-31', 'Hari Deepavali');
INSERT INTO `punchsys_holiday` VALUES (45, '2024-09-16', '2024-09-16', 'Hari Malaysia');
INSERT INTO `punchsys_holiday` VALUES (44, '2024-08-31', '2024-08-31', 'Hari Kebangsaan');
INSERT INTO `punchsys_holiday` VALUES (43, '2024-07-07', '2024-07-07', 'Awal Muharram');
INSERT INTO `punchsys_holiday` VALUES (42, '2024-06-17', '2024-06-17', 'Hari Aidil Adha');
INSERT INTO `punchsys_holiday` VALUES (41, '2024-06-03', '2024-06-03', 'Hari Keputeraan YDP Agong');
INSERT INTO `punchsys_holiday` VALUES (40, '2024-05-22', '2024-05-22', 'Hari Wesak');
INSERT INTO `punchsys_holiday` VALUES (39, '2024-05-01', '2024-05-01', 'Hari Pekerja');
INSERT INTO `punchsys_holiday` VALUES (38, '2024-04-10', '2024-04-11', 'Hari Raya Aidilfitri');
INSERT INTO `punchsys_holiday` VALUES (37, '2024-03-28', '2024-03-28', 'Nuzul Al-Quran');
INSERT INTO `punchsys_holiday` VALUES (36, '2024-02-10', '2024-02-12', 'Tahun Baru Cina');
INSERT INTO `punchsys_holiday` VALUES (35, '2024-01-25', '2024-01-25', 'Hari Thaipusam');
INSERT INTO `punchsys_holiday` VALUES (34, '2024-01-01', '2024-01-01', 'Tahun Baru');

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

-- 
-- Table structure for table `punchsys_punchrecord`
-- 

CREATE TABLE `punchsys_punchrecord` (
  `punch_Id` int(3) NOT NULL auto_increment,
  `staffId` varchar(15) NOT NULL default '',
  `punchDate` date NOT NULL default '0000-00-00',
  `punchIn` time NOT NULL default '00:00:00',
  `punchOutDate` date NOT NULL,
  `punchOut` time default '00:00:00',
  `message` varchar(100) default NULL,
  `comLate` time default '00:00:00',
  `levEarly` time default '00:00:00',
  PRIMARY KEY  (`punch_Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `punchsys_punchrecord`
-- 


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

-- 
-- Table structure for table `punchsys_remarkevent`
-- 

CREATE TABLE `punchsys_remarkevent` (
  `id` int(11) NOT NULL auto_increment,
  `event` varchar(20) NOT NULL default '',
  `tb_ord` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

-- 
-- Dumping data for table `punchsys_remarkevent`
-- 

INSERT INTO `punchsys_remarkevent` VALUES (1, 'Kursus', 0);
INSERT INTO `punchsys_remarkevent` VALUES (8, 'Hal Peribadi', 0);
INSERT INTO `punchsys_remarkevent` VALUES (3, 'Cuti Sakit', 0);
INSERT INTO `punchsys_remarkevent` VALUES (4, 'Cuti Rehat Khas', 0);
INSERT INTO `punchsys_remarkevent` VALUES (5, 'Mesyuarat', 0);
INSERT INTO `punchsys_remarkevent` VALUES (6, 'Taklimat', 0);
INSERT INTO `punchsys_remarkevent` VALUES (7, 'Bengkel', 0);
INSERT INTO `punchsys_remarkevent` VALUES (9, 'Cuti Bersalin', 0);
INSERT INTO `punchsys_remarkevent` VALUES (10, 'Cuti Sakit Bpanjanga', 0);
INSERT INTO `punchsys_remarkevent` VALUES (11, 'Cuti Rehat', 0);
INSERT INTO `punchsys_remarkevent` VALUES (12, 'Urusan Rasmi', 0);
INSERT INTO `punchsys_remarkevent` VALUES (13, 'Bersembahyang', 0);
INSERT INTO `punchsys_remarkevent` VALUES (14, 'Konvensyen', 0);
INSERT INTO `punchsys_remarkevent` VALUES (15, 'Seminar', 0);
INSERT INTO `punchsys_remarkevent` VALUES (16, 'Anugerah', 0);
INSERT INTO `punchsys_remarkevent` VALUES (17, 'Pemeriksaan Doktor', 0);
INSERT INTO `punchsys_remarkevent` VALUES (18, 'Cuti Tahunan', 0);
INSERT INTO `punchsys_remarkevent` VALUES (19, 'Cuti Tanpa Rekod', 0);
INSERT INTO `punchsys_remarkevent` VALUES (20, 'Datang lewat', 0);
INSERT INTO `punchsys_remarkevent` VALUES (21, 'Balik awal', 0);
INSERT INTO `punchsys_remarkevent` VALUES (22, 'Cuti Tanpa Gaji', 0);
INSERT INTO `punchsys_remarkevent` VALUES (23, 'Cuti Ganti', 0);

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

-- 
-- Table structure for table `punchsys_remarkrecord`
-- 

CREATE TABLE `punchsys_remarkrecord` (
  `id` int(11) NOT NULL auto_increment,
  `staffId` varchar(15) NOT NULL default '',
  `remarkDate` date NOT NULL default '0000-00-00',
  `remarkDatetil` date NOT NULL,
  `eventId` int(11) NOT NULL default '0',
  `notice` varchar(50) NOT NULL default '',
  `status` int(1) NOT NULL,
  `apvby` varchar(15) NOT NULL,
  `apvdate` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `punchsys_remarkrecord`
-- 


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

-- 
-- Table structure for table `punchsys_section`
-- 

CREATE TABLE `punchsys_section` (
  `id` varchar(2) NOT NULL,
  `name` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `punchsys_section`
-- 

INSERT INTO `punchsys_section` VALUES ('0', 'UNDEFINED');
INSERT INTO `punchsys_section` VALUES ('1', 'GURU');
INSERT INTO `punchsys_section` VALUES ('2', '8:00 ~ 17:00');
INSERT INTO `punchsys_section` VALUES ('3', 'NO-LIMIT');
INSERT INTO `punchsys_section` VALUES ('4', 'HELPER');
INSERT INTO `punchsys_section` VALUES ('5', 'GURU M');
INSERT INTO `punchsys_section` VALUES ('6', 'PEJABAT');
INSERT INTO `punchsys_section` VALUES ('7', 'UNDEFINED');
INSERT INTO `punchsys_section` VALUES ('8', 'UNDEFINED');
INSERT INTO `punchsys_section` VALUES ('9', 'UNDEFINED');

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

-- 
-- Table structure for table `punchsys_setting`
-- 

CREATE TABLE `punchsys_setting` (
  `passverify` int(1) NOT NULL,
  `maxpunchtime` int(2) NOT NULL default '1',
  `stype` int(1) NOT NULL,
  `lateId` int(3) NOT NULL,
  `autolate` varchar(1) NOT NULL,
  `gbname` varchar(15) NOT NULL,
  `gtname` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `punchsys_setting`
-- 

INSERT INTO `punchsys_setting` VALUES (0, 1, 0, 0, '0', 'GURU BESAR', 'GURU BERTUGAS');

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

-- 
-- Table structure for table `punchsys_staff`
-- 

CREATE TABLE `punchsys_staff` (
  `id` varchar(15) NOT NULL default '',
  `eName` varchar(50) NOT NULL default '',
  `pfx` varchar(5) NOT NULL,
  `cName` varchar(20) default NULL,
  `gender` char(3) NOT NULL default '',
  `IC` varchar(14) default NULL,
  `userID` varchar(15) NOT NULL default '',
  `password` varchar(10) NOT NULL default '',
  `qualification` varchar(20) default NULL,
  `address1` varchar(50) default NULL,
  `address2` varchar(50) NOT NULL default '',
  `postcode` varchar(5) NOT NULL default '',
  `city` varchar(30) NOT NULL default '',
  `state` varchar(30) NOT NULL default '',
  `phone` varchar(15) default NULL,
  `DOB` date NOT NULL default '0000-00-00',
  `race` varchar(20) NOT NULL default '',
  `religion` varchar(20) NOT NULL default '',
  `nation` text NOT NULL,
  `regDae` date NOT NULL default '0000-00-00',
  `position` varchar(50) default NULL,
  `section` char(1) NOT NULL default '',
  `administrator` int(1) NOT NULL default '0',
  `type` char(1) NOT NULL default '',
  `repPrint` char(3) NOT NULL default '',
  `session` char(1) NOT NULL default '',
  `fprint01` text NOT NULL,
  `fprint02` text NOT NULL,
  `fprint03` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `punchsys_staff`
-- 

INSERT INTO `punchsys_staff` VALUES ('admin', 'ADMINISTRATOR', '', NULL, '', NULL, '0', 'admin', NULL, NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', NULL, '', 9, '', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('pejabat', 'PEJABAT', '', NULL, '', NULL, '0', 'pejabat', NULL, NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', 'pejabat', '', 0, '', '99', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('18', 'Pn Kiang Yoke Mung', '', '½­ÓñÃô', '', NULL, '0', '', '1705632698', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('17', 'Pn Ng Weng Ley', '', 'ÎâÓ±Àþ', '', NULL, '0', '', '1705632672', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('16', 'Pn Loh Lei Tang', '', 'Â¬ÀöÌÁ', '', NULL, '0', '', '1705632649', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('15', 'Pn Woo Jing Wen', '', 'ºúÝ¼ÎÆ', '', NULL, '0', '', '1705632627', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('14', 'Cik Chung Yee Ling', '', 'Ö£ÒÀÁå', '', NULL, '0', '', '1705632591', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('13', 'Pn Ng Yen Lai', '', 'ÎâÑàÀö', '', NULL, '0', '', '1705632565', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('12', 'Pn Chow Wan Khee', '', 'ÖÜÔËç÷', '', NULL, '0', '', '1705632533', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('11', 'Pn Chan Mei Yoke', '', '³ÂÃÀÓñ', '', NULL, '0', '', '1705632505', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('10', 'Pn Leong Pooi San', '', 'Áº«˜Éº', '', NULL, '0', '', '1705632483', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('9', 'Pn Fang Lai Sun', '', '·½ÀöÉº', '', NULL, '0', '', '1705632443', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('8', 'Pn Lau See Wan', '', 'ÁõÊ«ÔÏ', '', NULL, '0', '', '1705632404', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('7', 'Pn Ang Huey Shan', '', '°²»ÛÉº', '', NULL, '0', '', '1705632319', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('6', 'Cik Gan Hui Fang', '', 'ÑÕÓýå¸', '', NULL, '0', '', '1705632304', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('5', 'Cik Lee Pei Chee', '', 'ÀîÅåÖ¥', '', NULL, '0', '', '1705632284', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('4', 'En Fong Kok Fei', '', '·ë¹ú»Ô', '', NULL, '0', '', '1705632263', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('3', 'Pn Chin Wan Soo', '', '³ÂÔ·Êæ', '', NULL, '0', '', '1705632250', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('2', 'Pn Lip Chooi Peng', '', 'Äô´äÆ¼', '', NULL, '0', '', '1705632214', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('1', 'Pn Kwa Pooi Meng', '', '¿ÂŠ³ÃûÐ£³¤', '', NULL, '0', '', '1705632119', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', 'Guru Besar', '3', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('19', 'En Ong Choon Kit', '', 'ÍõÕñ½Ü', '', NULL, '0', '', '1705632882', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('20', 'Cik Cheong Oi San', '', 'ÕÅ¿­Éº', '', NULL, '0', '', '1705632902', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('21', 'Pn Chung Wai Mun', '', 'Ö£»ÛÃô', '', NULL, '0', '', '1705632928', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('22', 'Pn Lam See Yin', '', 'ÁÖÊ«ÔÏ', '', NULL, '0', '', '1705632955', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('23', 'Pn Lee Wen Kit', '', 'ÀîÎÄ½à', '', NULL, '0', '', '1705632998', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('24', 'Pn Ng So So', '', '»ÆÑ©Ñ©', '', NULL, '0', '', '1705633023', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('25', 'Pn Thong Chow Sim', '', 'ÌÆÀÖÍ¥', '', NULL, '0', '', '1705633056', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('26', 'Cik Yuen Sook Ching', '', 'Ô¬ÊçÕê', '', NULL, '0', '', '1705633077', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('27', 'Pn Khor Siew Kheng', '', 'ÐíÐãÇÙ', '', NULL, '0', '', '1705633099', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('28', 'Cik Chai Sook Jin', '', '²ÌÊç¾§', '', NULL, '0', '', '1705633119', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('29', 'Pn Tan Sook Han', '', '³ÂËØæµ', '', NULL, '0', '', '1705633139', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('30', 'Pn Cheong Yit Chew', '', 'ÕÅÔÂÐ¤', '', NULL, '0', '', '1705633159', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 0, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('31', 'En Mohamad Syamer ', '', '', '', NULL, '0', '', '1705566686', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 8, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('32', 'En Rabinder Singh A/L Jagir Si', '', '', '', NULL, '0', '', '1705566691', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 8, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('33', 'Pn Arena Wati Bt AB Gani', '', '', '', NULL, '0', '', '1705566698', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 8, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('34', 'Pn Rabiatul-A''dawiah Bt Mohtha', '', '', '', NULL, '0', '', '1705566705', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 8, '1', '', '', '', '', '');
INSERT INTO `punchsys_staff` VALUES ('35', 'Pn Jayanti A/P Rajah Gobal', '', '', '', NULL, '0', '', '1705566718', NULL, '', '', '', '', NULL, '0000-00-00', '', '', '', '0000-00-00', '', '1', 8, '1', '', '', '', '', '');

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

-- 
-- Table structure for table `punchsys_timetable`
-- 

CREATE TABLE `punchsys_timetable` (
  `id` int(11) NOT NULL auto_increment,
  `secid` int(1) NOT NULL,
  `wkDay` varchar(10) NOT NULL default '',
  `pcInTime` time default '00:00:00',
  `pcOutTime` time default '00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;

-- 
-- Dumping data for table `punchsys_timetable`
-- 

INSERT INTO `punchsys_timetable` VALUES (45, 1, '5', '07:00:00', '13:20:00');
INSERT INTO `punchsys_timetable` VALUES (44, 1, '4', '07:00:00', '13:20:00');
INSERT INTO `punchsys_timetable` VALUES (43, 1, '3', '07:00:00', '13:20:00');
INSERT INTO `punchsys_timetable` VALUES (42, 1, '2', '07:00:00', '13:20:00');
INSERT INTO `punchsys_timetable` VALUES (41, 1, '1', '07:00:00', '13:20:00');
INSERT INTO `punchsys_timetable` VALUES (40, 1, '0', '00:00:00', '00:00:00');
INSERT INTO `punchsys_timetable` VALUES (8, 2, '1', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (9, 2, '2', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (10, 2, '3', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (11, 2, '4', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (12, 2, '5', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (13, 2, '6', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (14, 3, '1', '23:59:00', '00:01:00');
INSERT INTO `punchsys_timetable` VALUES (15, 3, '2', '23:59:00', '00:01:00');
INSERT INTO `punchsys_timetable` VALUES (16, 3, '3', '23:59:00', '00:01:00');
INSERT INTO `punchsys_timetable` VALUES (17, 3, '4', '23:59:00', '00:01:00');
INSERT INTO `punchsys_timetable` VALUES (18, 3, '5', '23:59:00', '00:01:00');
INSERT INTO `punchsys_timetable` VALUES (19, 3, '6', '23:59:00', '00:01:00');
INSERT INTO `punchsys_timetable` VALUES (20, 4, '1', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (21, 4, '2', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (22, 4, '3', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (23, 4, '4', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (24, 4, '5', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (25, 4, '6', '08:00:00', '17:00:00');
INSERT INTO `punchsys_timetable` VALUES (26, 5, '1', '07:30:00', '13:15:00');
INSERT INTO `punchsys_timetable` VALUES (27, 5, '2', '07:30:00', '13:15:00');
INSERT INTO `punchsys_timetable` VALUES (28, 5, '3', '07:30:00', '13:15:00');
INSERT INTO `punchsys_timetable` VALUES (29, 5, '4', '07:30:00', '13:15:00');
INSERT INTO `punchsys_timetable` VALUES (30, 5, '5', '07:30:00', '12:10:00');
INSERT INTO `punchsys_timetable` VALUES (31, 5, '6', '07:30:00', '13:15:00');
INSERT INTO `punchsys_timetable` VALUES (32, 6, '1', '08:00:00', '16:00:00');
INSERT INTO `punchsys_timetable` VALUES (35, 7, '1', '07:00:00', '16:00:00');
INSERT INTO `punchsys_timetable` VALUES (36, 7, '2', '07:00:00', '16:00:00');
INSERT INTO `punchsys_timetable` VALUES (37, 7, '3', '07:00:00', '16:00:00');
INSERT INTO `punchsys_timetable` VALUES (38, 7, '4', '07:00:00', '16:00:00');
INSERT INTO `punchsys_timetable` VALUES (39, 7, '5', '07:00:00', '16:00:00');
INSERT INTO `punchsys_timetable` VALUES (46, 1, '6', '07:15:00', '13:15:00');
