TRUNCATE TABLE xoops_adm_teacher;
INSERT INTO xoops_adm_teacher VALUES ('admin','ADMINISTRATOR','','','','','','admin','','','','','','','','0000-00-00','','','','0000-00-00','','','9','','','','','','');
INSERT INTO xoops_adm_teacher VALUES ('2','cikgu A','',' 老师甲','','','','','','','','','','','','0000-00-00','','','','0000-00-00','','1','0','0','','','','','');
INSERT INTO xoops_adm_teacher VALUES ('3','Guru B','','老师乙','','','','','','','','','','','','0000-00-00','','','','0000-00-00','','1','0','0','','','','','');
INSERT INTO xoops_adm_teacher VALUES ('1','guru besar','','不知道','','','','111','','','','','','','','0000-00-00','','','','0000-00-00','GB','1','8','0','','','','','');
INSERT INTO xoops_adm_teacher VALUES ('pejabat','PEJABAT','','','','','0','pejabat','','','','','','','','0000-00-00','','','','0000-00-00','pejabat','','0','','','','','','');
TRUNCATE TABLE xoops_pc_holiday;
INSERT INTO xoops_pc_holiday VALUES ('1','2021-05-01','2021-05-01','Hari Pekerja');
INSERT INTO xoops_pc_holiday VALUES ('13','2021-02-10','2021-02-14','Tahun Baru Cina');
INSERT INTO xoops_pc_holiday VALUES ('14','2021-10-19','2021-10-19','Hari Keputeraan Nabi Muhammad SAW');
INSERT INTO xoops_pc_holiday VALUES ('12','2021-04-29','2021-04-29','Hari Nuzul Al-Quran');
INSERT INTO xoops_pc_holiday VALUES ('9','2021-01-01','2021-01-01','Tahun Baru 2021');
INSERT INTO xoops_pc_holiday VALUES ('10','2021-01-28','2021-01-28','Thaipusam');
INSERT INTO xoops_pc_holiday VALUES ('11','2021-11-05','2021-11-05','Hari Keputeraan Sultan Perak');
INSERT INTO xoops_pc_holiday VALUES ('15','2021-05-26','2021-05-26','Hari Wesak');
INSERT INTO xoops_pc_holiday VALUES ('16','2021-06-07','2021-06-07','Hari Keputeraan YDP Agong');
INSERT INTO xoops_pc_holiday VALUES ('17','2021-05-11','2021-05-16','Hari Raya Aidilfitri');
INSERT INTO xoops_pc_holiday VALUES ('18','2021-08-31','2021-08-31','Hari Kebangsaan');
INSERT INTO xoops_pc_holiday VALUES ('19','2021-09-16','2021-09-16','Hari Malaysia');
INSERT INTO xoops_pc_holiday VALUES ('20','2021-07-20','2021-07-20','Hari Raya Haji');
INSERT INTO xoops_pc_holiday VALUES ('21','2021-11-03','2021-11-07','Hari Deepavali');
INSERT INTO xoops_pc_holiday VALUES ('22','2021-08-10','2021-08-10','Awal Muharram');
INSERT INTO xoops_pc_holiday VALUES ('23','2021-12-25','2021-12-25','Hari Krismas');
INSERT INTO xoops_pc_holiday VALUES ('24','2021-01-02','2021-01-19','Cuti Awal Tahun');
INSERT INTO xoops_pc_holiday VALUES ('25','2021-03-27','2021-04-04','Cuti Pertengahan Penggal');
INSERT INTO xoops_pc_holiday VALUES ('27','2021-12-11','2021-12-31','Cuti Akhir Tahun');
INSERT INTO xoops_pc_holiday VALUES ('28','2021-05-29','2021-06-13','Cuti Pertengahan Tahun');
INSERT INTO xoops_pc_holiday VALUES ('29','2021-07-17','2021-07-25','Cuti Pertengahan Penggal');
INSERT INTO xoops_pc_holiday VALUES ('30','2021-09-11','2021-09-19','Cuti Pertengahan Penggal');
TRUNCATE TABLE xoops_pc_punchrecord;
INSERT INTO xoops_pc_punchrecord VALUES ('1','1','2021-01-04','07:10:59','2021-01-04','14:12:12','','00:00:00','00:00:00');
INSERT INTO xoops_pc_punchrecord VALUES ('2','2','2021-01-04','07:11:00','2021-01-04','14:12:14','','00:00:00','00:00:00');
INSERT INTO xoops_pc_punchrecord VALUES ('3','3','2021-01-04','07:11:02','2021-01-04','14:12:16','','00:00:00','00:00:00');
INSERT INTO xoops_pc_punchrecord VALUES ('12','1','2021-01-01','07:14:00','2021-01-01','18:13:00','','00:00:00','00:00:00');
TRUNCATE TABLE xoops_pc_remarkevent;
INSERT INTO xoops_pc_remarkevent VALUES ('1','Kursus','0');
INSERT INTO xoops_pc_remarkevent VALUES ('8','Hal Peribadi','0');
INSERT INTO xoops_pc_remarkevent VALUES ('3','Cuti Sakit','0');
INSERT INTO xoops_pc_remarkevent VALUES ('4','Cuti Rehat Khas','0');
INSERT INTO xoops_pc_remarkevent VALUES ('5','Mesyuarat','0');
INSERT INTO xoops_pc_remarkevent VALUES ('6','Taklimat','0');
INSERT INTO xoops_pc_remarkevent VALUES ('7','Bengkel','0');
INSERT INTO xoops_pc_remarkevent VALUES ('9','Cuti Bersalin','0');
INSERT INTO xoops_pc_remarkevent VALUES ('10','Cuti Sakit Bpanjanga','0');
INSERT INTO xoops_pc_remarkevent VALUES ('11','Cuti Rehat','0');
INSERT INTO xoops_pc_remarkevent VALUES ('12','Urusan Rasmi','0');
INSERT INTO xoops_pc_remarkevent VALUES ('13','Bersembahyang','0');
INSERT INTO xoops_pc_remarkevent VALUES ('14','Konvensyen','0');
INSERT INTO xoops_pc_remarkevent VALUES ('15','Seminar','0');
INSERT INTO xoops_pc_remarkevent VALUES ('16','Anugerah','0');
INSERT INTO xoops_pc_remarkevent VALUES ('17','Pemeriksaan Doktor','0');
TRUNCATE TABLE xoops_pc_remarkrecord;
INSERT INTO xoops_pc_remarkrecord VALUES ('1','1','2021-01-04','2021-01-04','1','','1','admin','2021-01-04');
INSERT INTO xoops_pc_remarkrecord VALUES ('3','1','2021-01-01','2021-01-01','5','','1','admin','2021-01-18');
TRUNCATE TABLE xoops_pc_request;
TRUNCATE TABLE xoops_pc_section;
INSERT INTO xoops_pc_section VALUES ('0','UNDEFINED');
INSERT INTO xoops_pc_section VALUES ('1','GURU');
INSERT INTO xoops_pc_section VALUES ('2','8:00 ~ 17:00');
INSERT INTO xoops_pc_section VALUES ('3','NO-LIMIT');
INSERT INTO xoops_pc_section VALUES ('4','HELPER');
INSERT INTO xoops_pc_section VALUES ('5','GURU M');
INSERT INTO xoops_pc_section VALUES ('6','Pejabat');
INSERT INTO xoops_pc_section VALUES ('7','UNDEFINED');
INSERT INTO xoops_pc_section VALUES ('8','UNDEFINED');
INSERT INTO xoops_pc_section VALUES ('9','UNDEFINED');
TRUNCATE TABLE xoops_pc_setting;
INSERT INTO xoops_pc_setting VALUES ('0','1','0','1','0','GURU BESAR','GURU BERTUGAS');
TRUNCATE TABLE xoops_pc_tempreport;
TRUNCATE TABLE xoops_pc_timetable;
INSERT INTO xoops_pc_timetable VALUES ('1','1','4','07:15:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('3','1','1','07:15:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('4','1','2','07:15:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('5','1','3','07:15:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('6','1','5','07:15:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('7','1','6','07:15:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('8','2','1','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('9','2','2','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('10','2','3','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('11','2','4','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('12','2','5','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('13','2','6','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('14','3','1','23:59:00','00:01:00');
INSERT INTO xoops_pc_timetable VALUES ('15','3','2','23:59:00','00:01:00');
INSERT INTO xoops_pc_timetable VALUES ('16','3','3','23:59:00','00:01:00');
INSERT INTO xoops_pc_timetable VALUES ('17','3','4','23:59:00','00:01:00');
INSERT INTO xoops_pc_timetable VALUES ('18','3','5','23:59:00','00:01:00');
INSERT INTO xoops_pc_timetable VALUES ('19','3','6','23:59:00','00:01:00');
INSERT INTO xoops_pc_timetable VALUES ('20','4','1','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('21','4','2','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('22','4','3','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('23','4','4','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('24','4','5','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('25','4','6','08:00:00','17:00:00');
INSERT INTO xoops_pc_timetable VALUES ('26','5','1','07:30:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('27','5','2','07:30:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('28','5','3','07:30:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('29','5','4','07:30:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('30','5','5','07:30:00','12:10:00');
INSERT INTO xoops_pc_timetable VALUES ('31','5','6','07:30:00','13:15:00');
INSERT INTO xoops_pc_timetable VALUES ('32','6','1','08:00:00','16:00:00');
