INSERT INTO i3s_status (status_code, status_desc, status_desc_bm, is_active) VALUES 
	(1, 'Active', 'Aktif', true),
	(2, 'Not Active', 'Tidak Aktif', false),
	(3, 'Cancelled', 'Dibatal', false);

INSERT INTO i3s_attendance_status (attend_status_code, attend_status_desc, attend_status_desc_bm, is_present, is_half_day, is_late) VALUES 
	(1, 'Present', 'Hadir', true, false, false),
	(2, 'Late In', 'Lewat', true, false, true),
	(3, 'Half Day', 'Setengah Hari', true, true, false)
	(4, 'Absent', 'Tak Hadir', false);

INSERT INTO i3s_absence_reason (absence_code, absence_reason, absence_reason_bm) VALUES 
	(1, 'Security threats', 'Ancaman keselamatan'),
	(2, 'Natural disasters', 'Bencana alam'),
	(3, 'Medical certificate', 'Sijil cuti sakit'),
	(4, 'Suspended from school', 'Berhenti sekolah'),
	(5, 'Other reasons', 'Lain-lain sebab'),
	(6, 'Personal problem', 'Masalah peribadi'),
	(7, 'Student is not enrolled in school', 'Pelajar tidak berdaftar dengan sekolah'),
	(8, 'No reason', 'Tiada sebab'),
	(9, 'Family matters', 'Urusan keluarga'),
	(10, 'School holiday', 'Cuti sekolah'),
	(11, 'Public holiday', 'Cuti umum');

INSERT INTO i3s_bank (bank_code, bank_name, status_code) VALUES
	('MBB', 'Malayan Banking Berhad', 1),
	('CIMB', 'CIMB Bank Berhad', 1),
	('PUB', 'Public Bank Berhad/ Public Finance Berhad', 1),
	('RHB', 'RHB Bank Berhad', 1),
	('HLB', 'Hong Leong Bank Berhad/ Hong Leong Finance', 1),
	('AMBB', 'AmBank Berhad', 1),
	('UOB', 'United Overseas Bank (M) Bhd', 1),
	('BRB', 'Bank Rakyat Berhad', 1),
	('OCBC', 'OCBC Bank Berhad', 1),
	('HSBC', 'HSBC Bank Berhad', 1),
	('BIMB', 'Bank Islam Malaysia Berhad', 1),
	('AFFIN', 'Affin Bank Berhad', 1),
	('ABB', 'Alliance Bank Berhad', 1),
	('SCBB', 'Standard Chartered Bank Berhad', 1),
	('MBSB', 'MBSB', 1),
	('CITI', 'Citibank', 1),
	('BSNB', 'Bank Simpanan Nasional Berhad', 1),
	('BMMB', 'Bank Muamalat Malaysia Berhad', 1),
	('AGRO', 'Agro Bank', 1),
	('ARBICB', 'Al-Rajhi Banking and Investment Corporation (Malaysia) Berhad', 1);

INSERT INTO i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,currency,dt_create,dt_update) VALUES
	 (1867,'MY','MYS',458,'Malaysia','Asia','South-eastern Asia','','+60',142,35,NULL,true,'MY','2025-02-28 16:18:43.96015+08','2025-02-28 16:18:45.739332+08');
INSERT INTO i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1486,'AX','ALA',248,'Åland Islands','Europe','Northern Europe','',NULL,150,154,NULL,true,'2025-02-28 16:18:42.731157+08','2025-02-28 16:18:42.731157+08'),
	 (1735,'AL','ALB',8,'Albania','Europe','Southern Europe','','+355',150,39,NULL,true,'2025-02-28 16:18:42.734441+08','2025-02-28 16:18:45.318844+08'),
	 (1736,'DZ','DZA',12,'Algeria','Africa','Northern Africa','','+213',2,15,NULL,true,'2025-02-28 16:18:42.744147+08','2025-02-28 16:18:45.326562+08'),
	 (1737,'AS','ASM',16,'American Samoa','Oceania','Polynesia','','+1-684',9,61,NULL,true,'2025-02-28 16:18:42.831875+08','2025-02-28 16:18:45.329298+08'),
	 (1738,'AD','AND',20,'Andorra','Europe','Southern Europe','','+376',150,39,NULL,true,'2025-02-28 16:18:42.841539+08','2025-02-28 16:18:45.331856+08'),
	 (1740,'AI','AIA',660,'Anguilla','Americas','Latin America and the Caribbean','Caribbean','+1-264',19,419,29,true,'2025-02-28 16:18:42.849776+08','2025-02-28 16:18:45.337196+08'),
	 (1741,'AQ','ATA',10,'Antarctica','','','','+672',NULL,NULL,NULL,true,'2025-02-28 16:18:42.853783+08','2025-02-28 16:18:45.339769+08'),
	 (1742,'AG','ATG',28,'Antigua and Barbuda','Americas','Latin America and the Caribbean','Caribbean','+1-268',19,419,29,true,'2025-02-28 16:18:42.856835+08','2025-02-28 16:18:45.342335+08'),
	 (1743,'AR','ARG',32,'Argentina','Americas','Latin America and the Caribbean','South America','+54',19,419,5,true,'2025-02-28 16:18:42.860015+08','2025-02-28 16:18:45.34501+08'),
	 (1744,'AM','ARM',51,'Armenia','Asia','Western Asia','','+374',142,145,NULL,true,'2025-02-28 16:18:42.863396+08','2025-02-28 16:18:45.347672+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1745,'AW','ABW',533,'Aruba','Americas','Latin America and the Caribbean','Caribbean','+297',19,419,29,true,'2025-02-28 16:18:42.866556+08','2025-02-28 16:18:45.350339+08'),
	 (1746,'AU','AUS',36,'Australia','Oceania','Australia and New Zealand','','+61',9,53,NULL,true,'2025-02-28 16:18:42.869291+08','2025-02-28 16:18:45.353008+08'),
	 (1747,'AT','AUT',40,'Austria','Europe','Western Europe','','+43',150,155,NULL,true,'2025-02-28 16:18:42.872083+08','2025-02-28 16:18:45.355583+08'),
	 (1748,'AZ','AZE',31,'Azerbaijan','Asia','Western Asia','','+994',142,145,NULL,true,'2025-02-28 16:18:42.87486+08','2025-02-28 16:18:45.35834+08'),
	 (1749,'BS','BHS',44,'Bahamas','Americas','Latin America and the Caribbean','Caribbean','+1-242',19,419,29,true,'2025-02-28 16:18:42.877745+08','2025-02-28 16:18:45.360914+08'),
	 (1750,'BH','BHR',48,'Bahrain','Asia','Western Asia','','+973',142,145,NULL,true,'2025-02-28 16:18:42.880605+08','2025-02-28 16:18:45.36358+08'),
	 (1751,'BD','BGD',50,'Bangladesh','Asia','Southern Asia','','+880',142,34,NULL,true,'2025-02-28 16:18:42.88338+08','2025-02-28 16:18:45.366251+08'),
	 (1752,'BB','BRB',52,'Barbados','Americas','Latin America and the Caribbean','Caribbean','+1-246',19,419,29,true,'2025-02-28 16:18:42.886154+08','2025-02-28 16:18:45.368814+08'),
	 (1753,'BY','BLR',112,'Belarus','Europe','Eastern Europe','','+375',150,151,NULL,true,'2025-02-28 16:18:42.888822+08','2025-02-28 16:18:45.371493+08'),
	 (1754,'BE','BEL',56,'Belgium','Europe','Western Europe','','+32',150,155,NULL,true,'2025-02-28 16:18:42.891603+08','2025-02-28 16:18:45.374026+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1755,'BZ','BLZ',84,'Belize','Americas','Latin America and the Caribbean','Central America','+501',19,419,13,true,'2025-02-28 16:18:42.894476+08','2025-02-28 16:18:45.376723+08'),
	 (1756,'BJ','BEN',204,'Benin','Africa','Sub-Saharan Africa','Western Africa','+229',2,202,11,true,'2025-02-28 16:18:42.897115+08','2025-02-28 16:18:45.379901+08'),
	 (1757,'BM','BMU',60,'Bermuda','Americas','Northern America','','+1-441',19,21,NULL,true,'2025-02-28 16:18:42.899804+08','2025-02-28 16:18:45.382557+08'),
	 (1758,'BT','BTN',64,'Bhutan','Asia','Southern Asia','','+975',142,34,NULL,true,'2025-02-28 16:18:42.902585+08','2025-02-28 16:18:45.385726+08'),
	 (1760,'BQ','BES',535,'Bonaire, Sint Eustatius and Saba','Americas','Latin America and the Caribbean','Caribbean','+599',19,419,29,true,'2025-02-28 16:18:42.907991+08','2025-02-28 16:18:45.390975+08'),
	 (1761,'BA','BIH',70,'Bosnia and Herzegovina','Europe','Southern Europe','','+387',150,39,NULL,true,'2025-02-28 16:18:42.910666+08','2025-02-28 16:18:45.394057+08'),
	 (1762,'BW','BWA',72,'Botswana','Africa','Sub-Saharan Africa','Southern Africa','+267',2,202,18,true,'2025-02-28 16:18:42.914665+08','2025-02-28 16:18:45.396714+08'),
	 (1763,'BV','BVT',74,'Bouvet Island','Americas','Latin America and the Caribbean','South America','+47',19,419,5,true,'2025-02-28 16:18:42.917343+08','2025-02-28 16:18:45.399292+08'),
	 (1764,'BR','BRA',76,'Brazil','Americas','Latin America and the Caribbean','South America','+55',19,419,5,true,'2025-02-28 16:18:42.920138+08','2025-02-28 16:18:45.402059+08'),
	 (1765,'IO','IOT',86,'British Indian Ocean Territory','Africa','Sub-Saharan Africa','Eastern Africa','+246',2,202,14,true,'2025-02-28 16:18:42.922816+08','2025-02-28 16:18:45.40483+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1766,'BN','BRN',96,'Brunei Darussalam','Asia','South-eastern Asia','','+673',142,35,NULL,true,'2025-02-28 16:18:42.935609+08','2025-02-28 16:18:45.407523+08'),
	 (1767,'BG','BGR',100,'Bulgaria','Europe','Eastern Europe','','+359',150,151,NULL,true,'2025-02-28 16:18:42.939199+08','2025-02-28 16:18:45.410066+08'),
	 (1768,'BF','BFA',854,'Burkina Faso','Africa','Sub-Saharan Africa','Western Africa','+226',2,202,11,true,'2025-02-28 16:18:42.942592+08','2025-02-28 16:18:45.413674+08'),
	 (1769,'BI','BDI',108,'Burundi','Africa','Sub-Saharan Africa','Eastern Africa','+257',2,202,14,true,'2025-02-28 16:18:42.94575+08','2025-02-28 16:18:45.416333+08'),
	 (1770,'KH','KHM',116,'Cambodia','Asia','South-eastern Asia','','+855',142,35,NULL,true,'2025-02-28 16:18:43.038314+08','2025-02-28 16:18:45.418921+08'),
	 (1771,'CM','CMR',120,'Cameroon','Africa','Sub-Saharan Africa','Middle Africa','+237',2,202,17,true,'2025-02-28 16:18:43.043598+08','2025-02-28 16:18:45.421581+08'),
	 (1772,'CA','CAN',124,'Canada','Americas','Northern America','','+1',19,21,NULL,true,'2025-02-28 16:18:43.140539+08','2025-02-28 16:18:45.424327+08'),
	 (1773,'CV','CPV',132,'Cabo Verde','Africa','Sub-Saharan Africa','Western Africa','+238',2,202,11,true,'2025-02-28 16:18:42.948843+08','2025-02-28 16:18:45.426794+08'),
	 (1774,'KY','CYM',136,'Cayman Islands','Americas','Latin America and the Caribbean','Caribbean','+1-345',19,419,29,true,'2025-02-28 16:18:43.144638+08','2025-02-28 16:18:45.429484+08'),
	 (1775,'CF','CAF',140,'Central African Republic','Africa','Sub-Saharan Africa','Middle Africa','+236',2,202,17,true,'2025-02-28 16:18:43.148751+08','2025-02-28 16:18:45.432258+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1776,'TD','TCD',148,'Chad','Africa','Sub-Saharan Africa','Middle Africa','+235',2,202,17,true,'2025-02-28 16:18:43.153264+08','2025-02-28 16:18:45.435334+08'),
	 (1777,'CL','CHL',152,'Chile','Americas','Latin America and the Caribbean','South America','+56',19,419,5,true,'2025-02-28 16:18:43.156949+08','2025-02-28 16:18:45.438007+08'),
	 (1778,'CN','CHN',156,'China','Asia','Eastern Asia','','+86',142,30,NULL,true,'2025-02-28 16:18:43.161145+08','2025-02-28 16:18:45.44079+08'),
	 (1779,'CX','CXR',162,'Christmas Island','Oceania','Australia and New Zealand','','+61',9,53,NULL,true,'2025-02-28 16:18:43.16462+08','2025-02-28 16:18:45.443591+08'),
	 (1780,'CC','CCK',166,'Cocos (Keeling) Islands','Oceania','Australia and New Zealand','','+61',9,53,NULL,true,'2025-02-28 16:18:43.16828+08','2025-02-28 16:18:45.446246+08'),
	 (1781,'CO','COL',170,'Colombia','Americas','Latin America and the Caribbean','South America','+57',19,419,5,true,'2025-02-28 16:18:43.171984+08','2025-02-28 16:18:45.449125+08'),
	 (1782,'KM','COM',174,'Comoros','Africa','Sub-Saharan Africa','Eastern Africa','+269',2,202,14,true,'2025-02-28 16:18:43.175325+08','2025-02-28 16:18:45.452206+08'),
	 (1783,'CG','COG',178,'Congo','Africa','Sub-Saharan Africa','Middle Africa','+242',2,202,17,true,'2025-02-28 16:18:43.179381+08','2025-02-28 16:18:45.454916+08'),
	 (1784,'CD','COD',180,'Congo, Democratic Republic of the','Africa','Sub-Saharan Africa','Middle Africa','+243',2,202,17,true,'2025-02-28 16:18:43.182842+08','2025-02-28 16:18:45.457827+08'),
	 (1785,'CK','COK',184,'Cook Islands','Oceania','Polynesia','','+682',9,61,NULL,true,'2025-02-28 16:18:43.187002+08','2025-02-28 16:18:45.460543+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1786,'CR','CRI',188,'Costa Rica','Americas','Latin America and the Caribbean','Central America','+506',19,419,13,true,'2025-02-28 16:18:43.189871+08','2025-02-28 16:18:45.46311+08'),
	 (1787,'HR','HRV',191,'Croatia','Europe','Southern Europe','','+385',150,39,NULL,true,'2025-02-28 16:18:43.196967+08','2025-02-28 16:18:45.465789+08'),
	 (1792,'CI','CIV',384,'Côte d''Ivoire','Africa','Sub-Saharan Africa','Western Africa','+225',2,202,11,true,'2025-02-28 16:18:43.193909+08','2025-02-28 16:18:45.486592+08'),
	 (1789,'CW','CUW',531,'Curaçao','Americas','Latin America and the Caribbean','Caribbean','+599',19,419,29,true,'2025-02-28 16:18:43.203936+08','2025-02-28 16:18:45.472628+08'),
	 (1790,'CY','CYP',196,'Cyprus','Asia','Western Asia','','+357',142,145,NULL,true,'2025-02-28 16:18:43.206702+08','2025-02-28 16:18:45.476076+08'),
	 (1791,'CZ','CZE',203,'Czechia','Europe','Eastern Europe','','+420',150,151,NULL,true,'2025-02-28 16:18:43.209484+08','2025-02-28 16:18:45.480651+08'),
	 (1793,'DK','DNK',208,'Denmark','Europe','Northern Europe','','+45',150,154,NULL,true,'2025-02-28 16:18:43.212245+08','2025-02-28 16:18:45.490178+08'),
	 (1794,'DJ','DJI',262,'Djibouti','Africa','Sub-Saharan Africa','Eastern Africa','+253',2,202,14,true,'2025-02-28 16:18:43.215124+08','2025-02-28 16:18:45.493298+08'),
	 (1795,'DM','DMA',212,'Dominica','Americas','Latin America and the Caribbean','Caribbean','+1-767',19,419,29,true,'2025-02-28 16:18:43.218751+08','2025-02-28 16:18:45.497141+08'),
	 (1796,'DO','DOM',214,'Dominican Republic','Americas','Latin America and the Caribbean','Caribbean','+1-809,+1-829,+1-849',19,419,29,true,'2025-02-28 16:18:43.221603+08','2025-02-28 16:18:45.500562+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1797,'EC','ECU',218,'Ecuador','Americas','Latin America and the Caribbean','South America','+593',19,419,5,true,'2025-02-28 16:18:43.224475+08','2025-02-28 16:18:45.504455+08'),
	 (1798,'EG','EGY',818,'Egypt','Africa','Northern Africa','','+20',2,15,NULL,true,'2025-02-28 16:18:43.228538+08','2025-02-28 16:18:45.507204+08'),
	 (1799,'SV','SLV',222,'El Salvador','Americas','Latin America and the Caribbean','Central America','+503',19,419,13,true,'2025-02-28 16:18:43.231218+08','2025-02-28 16:18:45.509994+08'),
	 (1800,'GQ','GNQ',226,'Equatorial Guinea','Africa','Sub-Saharan Africa','Middle Africa','+240',2,202,17,true,'2025-02-28 16:18:43.234003+08','2025-02-28 16:18:45.513043+08'),
	 (1801,'ER','ERI',232,'Eritrea','Africa','Sub-Saharan Africa','Eastern Africa','+291',2,202,14,true,'2025-02-28 16:18:43.236774+08','2025-02-28 16:18:45.516325+08'),
	 (1802,'EE','EST',233,'Estonia','Europe','Northern Europe','','+372',150,154,NULL,true,'2025-02-28 16:18:43.239605+08','2025-02-28 16:18:45.519309+08'),
	 (1803,'ET','ETH',231,'Ethiopia','Africa','Sub-Saharan Africa','Eastern Africa','+251',2,202,14,true,'2025-02-28 16:18:43.246531+08','2025-02-28 16:18:45.522088+08'),
	 (1805,'FO','FRO',234,'Faroe Islands','Europe','Northern Europe','','+298',150,154,NULL,true,'2025-02-28 16:18:43.345906+08','2025-02-28 16:18:45.527633+08'),
	 (1806,'FJ','FJI',242,'Fiji','Oceania','Melanesia','','+679',9,54,NULL,true,'2025-02-28 16:18:43.35101+08','2025-02-28 16:18:45.531002+08'),
	 (1807,'FI','FIN',246,'Finland','Europe','Northern Europe','','+358',150,154,NULL,true,'2025-02-28 16:18:43.355343+08','2025-02-28 16:18:45.534196+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1808,'FR','FRA',250,'France','Europe','Western Europe','','+33',150,155,NULL,true,'2025-02-28 16:18:43.35919+08','2025-02-28 16:18:45.536998+08'),
	 (1809,'GF','GUF',254,'French Guiana','Americas','Latin America and the Caribbean','South America','+594',19,419,5,true,'2025-02-28 16:18:43.362084+08','2025-02-28 16:18:45.539907+08'),
	 (1810,'PF','PYF',258,'French Polynesia','Oceania','Polynesia','','+689',9,61,NULL,true,'2025-02-28 16:18:43.365799+08','2025-02-28 16:18:45.542808+08'),
	 (1811,'TF','ATF',260,'French Southern Territories','Africa','Sub-Saharan Africa','Eastern Africa','+262',2,202,14,true,'2025-02-28 16:18:43.369511+08','2025-02-28 16:18:45.545833+08'),
	 (1812,'GA','GAB',266,'Gabon','Africa','Sub-Saharan Africa','Middle Africa','+241',2,202,17,true,'2025-02-28 16:18:43.372666+08','2025-02-28 16:18:45.548703+08'),
	 (1813,'GM','GMB',270,'Gambia','Africa','Sub-Saharan Africa','Western Africa','+220',2,202,11,true,'2025-02-28 16:18:43.3757+08','2025-02-28 16:18:45.551742+08'),
	 (1814,'GE','GEO',268,'Georgia','Asia','Western Asia','','+995',142,145,NULL,true,'2025-02-28 16:18:43.378465+08','2025-02-28 16:18:45.554966+08'),
	 (1815,'DE','DEU',276,'Germany','Europe','Western Europe','','+49',150,155,NULL,true,'2025-02-28 16:18:43.3815+08','2025-02-28 16:18:45.55787+08'),
	 (1816,'GH','GHA',288,'Ghana','Africa','Sub-Saharan Africa','Western Africa','+233',2,202,11,true,'2025-02-28 16:18:43.384376+08','2025-02-28 16:18:45.560725+08'),
	 (1817,'GI','GIB',292,'Gibraltar','Europe','Southern Europe','','+350',150,39,NULL,true,'2025-02-28 16:18:43.387272+08','2025-02-28 16:18:45.563599+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1818,'GR','GRC',300,'Greece','Europe','Southern Europe','','+30',150,39,NULL,true,'2025-02-28 16:18:43.390309+08','2025-02-28 16:18:45.566394+08'),
	 (1819,'GL','GRL',304,'Greenland','Americas','Northern America','','+299',19,21,NULL,true,'2025-02-28 16:18:43.393423+08','2025-02-28 16:18:45.569148+08'),
	 (1820,'GD','GRD',308,'Grenada','Americas','Latin America and the Caribbean','Caribbean','+1-473',19,419,29,true,'2025-02-28 16:18:43.396526+08','2025-02-28 16:18:45.571964+08'),
	 (1821,'GP','GLP',312,'Guadeloupe','Americas','Latin America and the Caribbean','Caribbean','+590',19,419,29,true,'2025-02-28 16:18:43.400102+08','2025-02-28 16:18:45.577823+08'),
	 (1822,'GU','GUM',316,'Guam','Oceania','Micronesia','','+1-671',9,57,NULL,true,'2025-02-28 16:18:43.402948+08','2025-02-28 16:18:45.580589+08'),
	 (1823,'GT','GTM',320,'Guatemala','Americas','Latin America and the Caribbean','Central America','+502',19,419,13,true,'2025-02-28 16:18:43.405821+08','2025-02-28 16:18:45.584179+08'),
	 (1824,'GG','GGY',831,'Guernsey','Europe','Northern Europe','','+44',150,154,NULL,true,'2025-02-28 16:18:43.408643+08','2025-02-28 16:18:45.587369+08'),
	 (1825,'GN','GIN',324,'Guinea','Africa','Sub-Saharan Africa','Western Africa','+224',2,202,11,true,'2025-02-28 16:18:43.411465+08','2025-02-28 16:18:45.590131+08'),
	 (1826,'GW','GNB',624,'Guinea-Bissau','Africa','Sub-Saharan Africa','Western Africa','+245',2,202,11,true,'2025-02-28 16:18:43.414262+08','2025-02-28 16:18:45.593021+08'),
	 (1827,'GY','GUY',328,'Guyana','Americas','Latin America and the Caribbean','South America','+592',19,419,5,true,'2025-02-28 16:18:43.417262+08','2025-02-28 16:18:45.595823+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1828,'HT','HTI',332,'Haiti','Americas','Latin America and the Caribbean','Caribbean','+509',19,419,29,true,'2025-02-28 16:18:43.420343+08','2025-02-28 16:18:45.598978+08'),
	 (1829,'HM','HMD',334,'Heard Island and McDonald Islands','Oceania','Australia and New Zealand','','+672',9,53,NULL,true,'2025-02-28 16:18:43.423242+08','2025-02-28 16:18:45.601931+08'),
	 (1830,'VA','VAT',336,'Holy See','Europe','Southern Europe','','+379',150,39,NULL,true,'2025-02-28 16:18:43.426166+08','2025-02-28 16:18:45.604613+08'),
	 (1831,'HN','HND',340,'Honduras','Americas','Latin America and the Caribbean','Central America','+504',19,419,13,true,'2025-02-28 16:18:43.429114+08','2025-02-28 16:18:45.607268+08'),
	 (1832,'HK','HKG',344,'Hong Kong','Asia','Eastern Asia','','+852',142,30,NULL,true,'2025-02-28 16:18:43.433395+08','2025-02-28 16:18:45.609673+08'),
	 (1833,'HU','HUN',348,'Hungary','Europe','Eastern Europe','','+36',150,151,NULL,true,'2025-02-28 16:18:43.437459+08','2025-02-28 16:18:45.612208+08'),
	 (1834,'IS','ISL',352,'Iceland','Europe','Northern Europe','','+354',150,154,NULL,true,'2025-02-28 16:18:43.440326+08','2025-02-28 16:18:45.614682+08'),
	 (1835,'IN','IND',356,'India','Asia','Southern Asia','','+91',142,34,NULL,true,'2025-02-28 16:18:43.443249+08','2025-02-28 16:18:45.618145+08'),
	 (1836,'ID','IDN',360,'Indonesia','Asia','South-eastern Asia','','+62',142,35,NULL,true,'2025-02-28 16:18:43.44613+08','2025-02-28 16:18:45.620731+08'),
	 (1837,'IR','IRN',364,'Iran, Islamic Republic of','Asia','Southern Asia','','+98',142,34,NULL,true,'2025-02-28 16:18:43.449987+08','2025-02-28 16:18:45.62328+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1838,'IQ','IRQ',368,'Iraq','Asia','Western Asia','','+964',142,145,NULL,true,'2025-02-28 16:18:43.453153+08','2025-02-28 16:18:45.625846+08'),
	 (1839,'IE','IRL',372,'Ireland','Europe','Northern Europe','','+353',150,154,NULL,true,'2025-02-28 16:18:43.456163+08','2025-02-28 16:18:45.628515+08'),
	 (1840,'IM','IMN',833,'Isle of Man','Europe','Northern Europe','','+44',150,154,NULL,true,'2025-02-28 16:18:43.459205+08','2025-02-28 16:18:45.631091+08'),
	 (1841,'IL','ISR',376,'Israel','Asia','Western Asia','','+972',142,145,NULL,true,'2025-02-28 16:18:43.462232+08','2025-02-28 16:18:45.634162+08'),
	 (1842,'IT','ITA',380,'Italy','Europe','Southern Europe','','+39',150,39,NULL,true,'2025-02-28 16:18:43.465477+08','2025-02-28 16:18:45.636725+08'),
	 (1844,'JP','JPN',392,'Japan','Asia','Eastern Asia','','+81',142,30,NULL,true,'2025-02-28 16:18:43.474262+08','2025-02-28 16:18:45.641583+08'),
	 (1946,'SZ','SWZ',748,'Eswatini','Africa','Sub-Saharan Africa','Southern Africa','+268',2,202,18,true,'2025-02-28 16:18:43.243242+08','2025-02-28 16:18:45.95238+08'),
	 (1846,'JO','JOR',400,'Jordan','Asia','Western Asia','','+962',142,145,NULL,true,'2025-02-28 16:18:43.479697+08','2025-02-28 16:18:45.646577+08'),
	 (1847,'KZ','KAZ',398,'Kazakhstan','Asia','Central Asia','','+7',142,143,NULL,true,'2025-02-28 16:18:43.482283+08','2025-02-28 16:18:45.649212+08'),
	 (1848,'KE','KEN',404,'Kenya','Africa','Sub-Saharan Africa','Eastern Africa','+254',2,202,14,true,'2025-02-28 16:18:43.486517+08','2025-02-28 16:18:45.652033+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1849,'KI','KIR',296,'Kiribati','Oceania','Micronesia','','+686',9,57,NULL,true,'2025-02-28 16:18:43.489249+08','2025-02-28 16:18:45.654805+08'),
	 (1850,'KP','PRK',408,'Korea, Democratic People''s Republic of','Asia','Eastern Asia','','+850',142,30,NULL,true,'2025-02-28 16:18:43.491934+08','2025-02-28 16:18:45.657486+08'),
	 (1851,'KR','KOR',410,'Korea, Republic of','Asia','Eastern Asia','','+82',142,30,NULL,true,'2025-02-28 16:18:43.550478+08','2025-02-28 16:18:45.660059+08'),
	 (1852,'KW','KWT',414,'Kuwait','Asia','Western Asia','','+965',142,145,NULL,true,'2025-02-28 16:18:43.553694+08','2025-02-28 16:18:45.662744+08'),
	 (1853,'KG','KGZ',417,'Kyrgyzstan','Asia','Central Asia','','+996',142,143,NULL,true,'2025-02-28 16:18:43.556568+08','2025-02-28 16:18:45.665513+08'),
	 (1855,'LV','LVA',428,'Latvia','Europe','Northern Europe','','+371',150,154,NULL,true,'2025-02-28 16:18:43.562151+08','2025-02-28 16:18:45.671053+08'),
	 (1856,'LB','LBN',422,'Lebanon','Asia','Western Asia','','+961',142,145,NULL,true,'2025-02-28 16:18:43.565095+08','2025-02-28 16:18:45.673828+08'),
	 (1857,'LS','LSO',426,'Lesotho','Africa','Sub-Saharan Africa','Southern Africa','+266',2,202,18,true,'2025-02-28 16:18:43.570084+08','2025-02-28 16:18:45.689974+08'),
	 (1858,'LR','LBR',430,'Liberia','Africa','Sub-Saharan Africa','Western Africa','+231',2,202,11,true,'2025-02-28 16:18:43.573078+08','2025-02-28 16:18:45.693662+08'),
	 (1859,'LY','LBY',434,'Libya','Africa','Northern Africa','','+218',2,15,NULL,true,'2025-02-28 16:18:43.576279+08','2025-02-28 16:18:45.700823+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1860,'LI','LIE',438,'Liechtenstein','Europe','Western Europe','','+423',150,155,NULL,true,'2025-02-28 16:18:43.652879+08','2025-02-28 16:18:45.704231+08'),
	 (1861,'LT','LTU',440,'Lithuania','Europe','Northern Europe','','+370',150,154,NULL,true,'2025-02-28 16:18:43.755069+08','2025-02-28 16:18:45.706905+08'),
	 (1862,'LU','LUX',442,'Luxembourg','Europe','Western Europe','','+352',150,155,NULL,true,'2025-02-28 16:18:43.857803+08','2025-02-28 16:18:45.709673+08'),
	 (1863,'MO','MAC',446,'Macao','Asia','Eastern Asia','','+853',142,30,NULL,true,'2025-02-28 16:18:43.865113+08','2025-02-28 16:18:45.712341+08'),
	 (1864,'MK','MKD',807,'North Macedonia','Europe','Southern Europe','','+389',150,39,NULL,true,'2025-02-28 16:18:44.413239+08','2025-02-28 16:18:45.71511+08'),
	 (1865,'MG','MDG',450,'Madagascar','Africa','Sub-Saharan Africa','Eastern Africa','+261',2,202,14,true,'2025-02-28 16:18:43.869004+08','2025-02-28 16:18:45.717776+08'),
	 (1866,'MW','MWI',454,'Malawi','Africa','Sub-Saharan Africa','Eastern Africa','+265',2,202,14,true,'2025-02-28 16:18:43.872353+08','2025-02-28 16:18:45.736491+08'),
	 (1868,'MV','MDV',462,'Maldives','Asia','Southern Asia','','+960',142,34,NULL,true,'2025-02-28 16:18:43.964216+08','2025-02-28 16:18:45.741894+08'),
	 (1869,'ML','MLI',466,'Mali','Africa','Sub-Saharan Africa','Western Africa','+223',2,202,11,true,'2025-02-28 16:18:43.967374+08','2025-02-28 16:18:45.744483+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1870,'MT','MLT',470,'Malta','Europe','Southern Europe','','+356',150,39,NULL,true,'2025-02-28 16:18:43.970398+08','2025-02-28 16:18:45.747118+08'),
	 (1871,'MH','MHL',584,'Marshall Islands','Oceania','Micronesia','','+692',9,57,NULL,true,'2025-02-28 16:18:44.04212+08','2025-02-28 16:18:45.749797+08'),
	 (1872,'MQ','MTQ',474,'Martinique','Americas','Latin America and the Caribbean','Caribbean','+596',19,419,29,true,'2025-02-28 16:18:44.050935+08','2025-02-28 16:18:45.752495+08'),
	 (1873,'MR','MRT',478,'Mauritania','Africa','Sub-Saharan Africa','Western Africa','+222',2,202,11,true,'2025-02-28 16:18:44.054745+08','2025-02-28 16:18:45.75523+08'),
	 (1874,'MU','MUS',480,'Mauritius','Africa','Sub-Saharan Africa','Eastern Africa','+230',2,202,14,true,'2025-02-28 16:18:44.060086+08','2025-02-28 16:18:45.758007+08'),
	 (1875,'YT','MYT',175,'Mayotte','Africa','Sub-Saharan Africa','Eastern Africa','+262',2,202,14,true,'2025-02-28 16:18:44.063785+08','2025-02-28 16:18:45.760783+08'),
	 (1876,'MX','MEX',484,'Mexico','Americas','Latin America and the Caribbean','Central America','+52',19,419,13,true,'2025-02-28 16:18:44.067193+08','2025-02-28 16:18:45.76347+08'),
	 (1877,'FM','FSM',583,'Micronesia, Federated States of','Oceania','Micronesia','','+691',9,57,NULL,true,'2025-02-28 16:18:44.070348+08','2025-02-28 16:18:45.766208+08'),
	 (1878,'MD','MDA',498,'Moldova, Republic of','Europe','Eastern Europe','','+373',150,151,NULL,true,'2025-02-28 16:18:44.164947+08','2025-02-28 16:18:45.768775+08'),
	 (1879,'MC','MCO',492,'Monaco','Europe','Western Europe','','+377',150,155,NULL,true,'2025-02-28 16:18:44.170051+08','2025-02-28 16:18:45.771473+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1880,'MN','MNG',496,'Mongolia','Asia','Eastern Asia','','+976',142,30,NULL,true,'2025-02-28 16:18:44.173339+08','2025-02-28 16:18:45.774004+08'),
	 (1881,'ME','MNE',499,'Montenegro','Europe','Southern Europe','','+382',150,39,NULL,true,'2025-02-28 16:18:44.258612+08','2025-02-28 16:18:45.776576+08'),
	 (1883,'MA','MAR',504,'Morocco','Africa','Northern Africa','','+212',2,15,NULL,true,'2025-02-28 16:18:44.265574+08','2025-02-28 16:18:45.782111+08'),
	 (1884,'MZ','MOZ',508,'Mozambique','Africa','Sub-Saharan Africa','Eastern Africa','+258',2,202,14,true,'2025-02-28 16:18:44.268688+08','2025-02-28 16:18:45.784889+08'),
	 (1885,'MM','MMR',104,'Myanmar','Asia','South-eastern Asia','','+95',142,35,NULL,true,'2025-02-28 16:18:44.369852+08','2025-02-28 16:18:45.787558+08'),
	 (1886,'NA','NAM',516,'Namibia','Africa','Sub-Saharan Africa','Southern Africa','+264',2,202,18,true,'2025-02-28 16:18:44.373915+08','2025-02-28 16:18:45.79023+08'),
	 (1887,'NR','NRU',520,'Nauru','Oceania','Micronesia','','+674',9,57,NULL,true,'2025-02-28 16:18:44.377393+08','2025-02-28 16:18:45.793002+08'),
	 (1888,'NP','NPL',524,'Nepal','Asia','Southern Asia','','+977',142,34,NULL,true,'2025-02-28 16:18:44.380651+08','2025-02-28 16:18:45.795664+08'),
	 (1889,'NL','NLD',528,'Netherlands, Kingdom of the','Europe','Western Europe','','+31',150,155,NULL,true,'2025-02-28 16:18:44.383779+08','2025-02-28 16:18:45.798233+08'),
	 (1890,'NC','NCL',540,'New Caledonia','Oceania','Melanesia','','+687',9,54,NULL,true,'2025-02-28 16:18:44.387275+08','2025-02-28 16:18:45.801017+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1891,'NZ','NZL',554,'New Zealand','Oceania','Australia and New Zealand','','+64',9,53,NULL,true,'2025-02-28 16:18:44.390923+08','2025-02-28 16:18:45.80388+08'),
	 (1892,'NI','NIC',558,'Nicaragua','Americas','Latin America and the Caribbean','Central America','+505',19,419,13,true,'2025-02-28 16:18:44.394452+08','2025-02-28 16:18:45.80666+08'),
	 (1893,'NE','NER',562,'Niger','Africa','Sub-Saharan Africa','Western Africa','+227',2,202,11,true,'2025-02-28 16:18:44.39823+08','2025-02-28 16:18:45.809211+08'),
	 (1894,'NG','NGA',566,'Nigeria','Africa','Sub-Saharan Africa','Western Africa','+234',2,202,11,true,'2025-02-28 16:18:44.401701+08','2025-02-28 16:18:45.811882+08'),
	 (1895,'NU','NIU',570,'Niue','Oceania','Polynesia','','+683',9,61,NULL,true,'2025-02-28 16:18:44.405939+08','2025-02-28 16:18:45.814554+08'),
	 (1896,'NF','NFK',574,'Norfolk Island','Oceania','Australia and New Zealand','','+672',9,53,NULL,true,'2025-02-28 16:18:44.409572+08','2025-02-28 16:18:45.817117+08'),
	 (1897,'MP','MNP',580,'Northern Mariana Islands','Oceania','Micronesia','','+1-670',9,57,NULL,true,'2025-02-28 16:18:44.416803+08','2025-02-28 16:18:45.819993+08'),
	 (1898,'NO','NOR',578,'Norway','Europe','Northern Europe','','+47',150,154,NULL,true,'2025-02-28 16:18:44.41969+08','2025-02-28 16:18:45.823229+08'),
	 (1899,'OM','OMN',512,'Oman','Asia','Western Asia','','+968',142,145,NULL,true,'2025-02-28 16:18:44.422972+08','2025-02-28 16:18:45.825841+08'),
	 (1900,'PK','PAK',586,'Pakistan','Asia','Southern Asia','','+92',142,34,NULL,true,'2025-02-28 16:18:44.425968+08','2025-02-28 16:18:45.828391+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1901,'PW','PLW',585,'Palau','Oceania','Micronesia','','+680',9,57,NULL,true,'2025-02-28 16:18:44.428767+08','2025-02-28 16:18:45.830968+08'),
	 (1902,'PS','PSE',275,'Palestine, State of','Asia','Western Asia','','+970',142,145,NULL,true,'2025-02-28 16:18:44.443306+08','2025-02-28 16:18:45.833532+08'),
	 (1905,'PY','PRY',600,'Paraguay','Americas','Latin America and the Caribbean','South America','+595',19,419,5,true,'2025-02-28 16:18:44.474695+08','2025-02-28 16:18:45.841743+08'),
	 (1906,'PE','PER',604,'Peru','Americas','Latin America and the Caribbean','South America','+51',19,419,5,true,'2025-02-28 16:18:44.477572+08','2025-02-28 16:18:45.844143+08'),
	 (1907,'PH','PHL',608,'Philippines','Asia','South-eastern Asia','','+63',142,35,NULL,true,'2025-02-28 16:18:44.574559+08','2025-02-28 16:18:45.846871+08'),
	 (1908,'PN','PCN',612,'Pitcairn','Oceania','Polynesia','','+870',9,61,NULL,true,'2025-02-28 16:18:44.578247+08','2025-02-28 16:18:45.849536+08'),
	 (1909,'PL','POL',616,'Poland','Europe','Eastern Europe','','+48',150,151,NULL,true,'2025-02-28 16:18:44.581541+08','2025-02-28 16:18:45.851972+08'),
	 (1910,'PT','PRT',620,'Portugal','Europe','Southern Europe','','+351',150,39,NULL,true,'2025-02-28 16:18:44.676915+08','2025-02-28 16:18:45.854502+08'),
	 (1911,'PR','PRI',630,'Puerto Rico','Americas','Latin America and the Caribbean','Caribbean','+1',19,419,29,true,'2025-02-28 16:18:44.681057+08','2025-02-28 16:18:45.85701+08'),
	 (1912,'QA','QAT',634,'Qatar','Asia','Western Asia','','+974',142,145,NULL,true,'2025-02-28 16:18:44.684354+08','2025-02-28 16:18:45.859512+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1913,'RO','ROU',642,'Romania','Europe','Eastern Europe','','+40',150,151,NULL,true,'2025-02-28 16:18:44.692152+08','2025-02-28 16:18:45.862054+08'),
	 (1914,'RU','RUS',643,'Russian Federation','Europe','Eastern Europe','','+7',150,151,NULL,true,'2025-02-28 16:18:44.69705+08','2025-02-28 16:18:45.864745+08'),
	 (1915,'RW','RWA',646,'Rwanda','Africa','Sub-Saharan Africa','Eastern Africa','+250',2,202,14,true,'2025-02-28 16:18:44.70057+08','2025-02-28 16:18:45.867387+08'),
	 (1916,'RE','REU',638,'Réunion','Africa','Sub-Saharan Africa','Eastern Africa','+262',2,202,14,true,'2025-02-28 16:18:44.688352+08','2025-02-28 16:18:45.869953+08'),
	 (1917,'BL','BLM',652,'Saint Barthélemy','Americas','Latin America and the Caribbean','Caribbean','+590',19,419,29,true,'2025-02-28 16:18:44.70409+08','2025-02-28 16:18:45.872522+08'),
	 (1918,'SH','SHN',654,'Saint Helena, Ascension and Tristan da Cunha','Africa','Sub-Saharan Africa','Western Africa','+290',2,202,11,true,'2025-02-28 16:18:44.707457+08','2025-02-28 16:18:45.874934+08'),
	 (1919,'KN','KNA',659,'Saint Kitts and Nevis','Americas','Latin America and the Caribbean','Caribbean','+1-869',19,419,29,true,'2025-02-28 16:18:44.710931+08','2025-02-28 16:18:45.877549+08'),
	 (1920,'LC','LCA',662,'Saint Lucia','Americas','Latin America and the Caribbean','Caribbean','+1-758',19,419,29,true,'2025-02-28 16:18:44.715899+08','2025-02-28 16:18:45.880121+08'),
	 (1921,'MF','MAF',663,'Saint Martin (French part)','Americas','Latin America and the Caribbean','Caribbean','+590',19,419,29,true,'2025-02-28 16:18:44.719558+08','2025-02-28 16:18:45.883613+08'),
	 (1922,'PM','SPM',666,'Saint Pierre and Miquelon','Americas','Northern America','','+508',19,21,NULL,true,'2025-02-28 16:18:44.722612+08','2025-02-28 16:18:45.886171+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1924,'WS','WSM',882,'Samoa','Oceania','Polynesia','','+685',9,61,NULL,true,'2025-02-28 16:18:44.729261+08','2025-02-28 16:18:45.891512+08'),
	 (1925,'SM','SMR',674,'San Marino','Europe','Southern Europe','','+378',150,39,NULL,true,'2025-02-28 16:18:44.732308+08','2025-02-28 16:18:45.894073+08'),
	 (1926,'ST','STP',678,'Sao Tome and Principe','Africa','Sub-Saharan Africa','Middle Africa','+239',2,202,17,true,'2025-02-28 16:18:44.735576+08','2025-02-28 16:18:45.896846+08'),
	 (1927,'SA','SAU',682,'Saudi Arabia','Asia','Western Asia','','+966',142,145,NULL,true,'2025-02-28 16:18:44.738348+08','2025-02-28 16:18:45.89951+08'),
	 (1928,'SN','SEN',686,'Senegal','Africa','Sub-Saharan Africa','Western Africa','+221',2,202,11,true,'2025-02-28 16:18:44.741225+08','2025-02-28 16:18:45.902073+08'),
	 (1929,'RS','SRB',688,'Serbia','Europe','Southern Europe','','+381',150,39,NULL,true,'2025-02-28 16:18:44.743792+08','2025-02-28 16:18:45.904926+08'),
	 (1930,'SC','SYC',690,'Seychelles','Africa','Sub-Saharan Africa','Eastern Africa','+248',2,202,14,true,'2025-02-28 16:18:44.74659+08','2025-02-28 16:18:45.907841+08'),
	 (1931,'SL','SLE',694,'Sierra Leone','Africa','Sub-Saharan Africa','Western Africa','+232',2,202,11,true,'2025-02-28 16:18:44.749199+08','2025-02-28 16:18:45.910383+08'),
	 (1932,'SG','SGP',702,'Singapore','Asia','South-eastern Asia','','+65',142,35,NULL,true,'2025-02-28 16:18:44.779218+08','2025-02-28 16:18:45.912965+08'),
	 (1933,'SX','SXM',534,'Sint Maarten (Dutch part)','Americas','Latin America and the Caribbean','Caribbean','+1-721',19,419,29,true,'2025-02-28 16:18:44.782503+08','2025-02-28 16:18:45.915534+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1934,'SK','SVK',703,'Slovakia','Europe','Eastern Europe','','+421',150,151,NULL,true,'2025-02-28 16:18:44.786157+08','2025-02-28 16:18:45.917992+08'),
	 (1935,'SI','SVN',705,'Slovenia','Europe','Southern Europe','','+386',150,39,NULL,true,'2025-02-28 16:18:44.798798+08','2025-02-28 16:18:45.920559+08'),
	 (1936,'SB','SLB',90,'Solomon Islands','Oceania','Melanesia','','+677',9,54,NULL,true,'2025-02-28 16:18:44.880167+08','2025-02-28 16:18:45.922941+08'),
	 (1937,'SO','SOM',706,'Somalia','Africa','Sub-Saharan Africa','Eastern Africa','+252',2,202,14,true,'2025-02-28 16:18:44.88429+08','2025-02-28 16:18:45.925998+08'),
	 (1938,'ZA','ZAF',710,'South Africa','Africa','Sub-Saharan Africa','Southern Africa','+27',2,202,18,true,'2025-02-28 16:18:44.887569+08','2025-02-28 16:18:45.928546+08'),
	 (1939,'GS','SGS',239,'South Georgia and the South Sandwich Islands','Americas','Latin America and the Caribbean','South America','+500',19,419,5,true,'2025-02-28 16:18:44.890636+08','2025-02-28 16:18:45.931124+08'),
	 (1940,'SS','SSD',728,'South Sudan','Africa','Sub-Saharan Africa','Eastern Africa','+211',2,202,14,true,'2025-02-28 16:18:44.893559+08','2025-02-28 16:18:45.933666+08'),
	 (1941,'ES','ESP',724,'Spain','Europe','Southern Europe','','+34',150,39,NULL,true,'2025-02-28 16:18:44.89656+08','2025-02-28 16:18:45.936873+08'),
	 (1942,'LK','LKA',144,'Sri Lanka','Asia','Southern Asia','','+94',142,34,NULL,true,'2025-02-28 16:18:44.899235+08','2025-02-28 16:18:45.940058+08'),
	 (1943,'SD','SDN',729,'Sudan','Africa','Northern Africa','','+249',2,15,NULL,true,'2025-02-28 16:18:44.902314+08','2025-02-28 16:18:45.943342+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1944,'SR','SUR',740,'Suriname','Americas','Latin America and the Caribbean','South America','+597',19,419,5,true,'2025-02-28 16:18:44.905377+08','2025-02-28 16:18:45.946445+08'),
	 (1945,'SJ','SJM',744,'Svalbard and Jan Mayen','Europe','Northern Europe','','+47',150,154,NULL,true,'2025-02-28 16:18:44.908264+08','2025-02-28 16:18:45.948956+08'),
	 (1947,'SE','SWE',752,'Sweden','Europe','Northern Europe','','+46',150,154,NULL,true,'2025-02-28 16:18:44.911032+08','2025-02-28 16:18:45.955138+08'),
	 (1948,'CH','CHE',756,'Switzerland','Europe','Western Europe','','+41',150,155,NULL,true,'2025-02-28 16:18:44.937225+08','2025-02-28 16:18:45.95771+08'),
	 (1949,'SY','SYR',760,'Syrian Arab Republic','Asia','Western Asia','','+963',142,145,NULL,true,'2025-02-28 16:18:44.983964+08','2025-02-28 16:18:45.960511+08'),
	 (1950,'TW','TWN',158,'Taiwan, Province of China','','','','+886',NULL,NULL,NULL,true,'2025-02-28 16:18:44.987503+08','2025-02-28 16:18:45.963157+08'),
	 (1951,'TJ','TJK',762,'Tajikistan','Asia','Central Asia','','+992',142,143,NULL,true,'2025-02-28 16:18:44.990308+08','2025-02-28 16:18:45.965717+08'),
	 (1952,'TZ','TZA',834,'Tanzania, United Republic of','Africa','Sub-Saharan Africa','Eastern Africa','+255',2,202,14,true,'2025-02-28 16:18:44.99301+08','2025-02-28 16:18:45.968787+08'),
	 (1953,'TH','THA',764,'Thailand','Asia','South-eastern Asia','','+66',142,35,NULL,true,'2025-02-28 16:18:45.015194+08','2025-02-28 16:18:45.971588+08'),
	 (1954,'TL','TLS',626,'Timor-Leste','Asia','South-eastern Asia','','+670',142,35,NULL,true,'2025-02-28 16:18:45.086595+08','2025-02-28 16:18:45.974958+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1955,'TG','TGO',768,'Togo','Africa','Sub-Saharan Africa','Western Africa','+228',2,202,11,true,'2025-02-28 16:18:45.090303+08','2025-02-28 16:18:45.977613+08'),
	 (1956,'TK','TKL',772,'Tokelau','Oceania','Polynesia','','+690',9,61,NULL,true,'2025-02-28 16:18:45.093677+08','2025-02-28 16:18:45.980274+08'),
	 (1957,'TO','TON',776,'Tonga','Oceania','Polynesia','','+676',9,61,NULL,true,'2025-02-28 16:18:45.096833+08','2025-02-28 16:18:45.982877+08'),
	 (1958,'TT','TTO',780,'Trinidad and Tobago','Americas','Latin America and the Caribbean','Caribbean','+1-868',19,419,29,true,'2025-02-28 16:18:45.099715+08','2025-02-28 16:18:45.985925+08'),
	 (1959,'TN','TUN',788,'Tunisia','Africa','Northern Africa','','+216',2,15,NULL,true,'2025-02-28 16:18:45.103442+08','2025-02-28 16:18:45.988501+08'),
	 (1960,'TR','TUR',792,'Türkiye','Asia','Western Asia','','+90',142,145,NULL,true,'2025-02-28 16:18:45.108314+08','2025-02-28 16:18:45.991151+08'),
	 (1734,'AF','AFG',4,'Afghanistan','Asia','Southern Asia','','+93',142,34,NULL,true,'2025-02-28 16:18:42.67268+08','2025-02-28 16:18:45.313816+08'),
	 (1739,'AO','AGO',24,'Angola','Africa','Sub-Saharan Africa','Middle Africa','+244',2,202,17,true,'2025-02-28 16:18:42.845867+08','2025-02-28 16:18:45.334649+08'),
	 (1759,'BO','BOL',68,'Bolivia, Plurinational State of','Americas','Latin America and the Caribbean','South America','+591',19,419,5,true,'2025-02-28 16:18:42.90533+08','2025-02-28 16:18:45.388308+08'),
	 (1788,'CU','CUB',192,'Cuba','Americas','Latin America and the Caribbean','Caribbean','+53',19,419,29,true,'2025-02-28 16:18:43.200043+08','2025-02-28 16:18:45.469234+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1804,'FK','FLK',238,'Falkland Islands (Malvinas)','Americas','Latin America and the Caribbean','South America','+500',19,419,5,true,'2025-02-28 16:18:43.250609+08','2025-02-28 16:18:45.524847+08'),
	 (1843,'JM','JAM',388,'Jamaica','Americas','Latin America and the Caribbean','Caribbean','+1-876',19,419,29,true,'2025-02-28 16:18:43.471444+08','2025-02-28 16:18:45.639195+08'),
	 (1845,'JE','JEY',832,'Jersey','Europe','Northern Europe','','+44',150,154,NULL,true,'2025-02-28 16:18:43.476863+08','2025-02-28 16:18:45.644014+08'),
	 (1854,'LA','LAO',418,'Lao People''s Democratic Republic','Asia','South-eastern Asia','','+856',142,35,NULL,true,'2025-02-28 16:18:43.559333+08','2025-02-28 16:18:45.66817+08'),
	 (1882,'MS','MSR',500,'Montserrat','Americas','Latin America and the Caribbean','Caribbean','+1-664',19,419,29,true,'2025-02-28 16:18:44.262347+08','2025-02-28 16:18:45.779284+08'),
	 (1903,'PA','PAN',591,'Panama','Americas','Latin America and the Caribbean','Central America','+507',19,419,13,true,'2025-02-28 16:18:44.446376+08','2025-02-28 16:18:45.836096+08'),
	 (1904,'PG','PNG',598,'Papua New Guinea','Oceania','Melanesia','','+675',9,54,NULL,true,'2025-02-28 16:18:44.471627+08','2025-02-28 16:18:45.839073+08'),
	 (1923,'VC','VCT',670,'Saint Vincent and the Grenadines','Americas','Latin America and the Caribbean','Caribbean','+1-784',19,419,29,true,'2025-02-28 16:18:44.725996+08','2025-02-28 16:18:45.888834+08'),
	 (1961,'TM','TKM',795,'Turkmenistan','Asia','Central Asia','','+993',142,143,NULL,true,'2025-02-28 16:18:45.125478+08','2025-02-28 16:18:45.993928+08'),
	 (1962,'TC','TCA',796,'Turks and Caicos Islands','Americas','Latin America and the Caribbean','Caribbean','+1-649',19,419,29,true,'2025-02-28 16:18:45.129353+08','2025-02-28 16:18:45.996513+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1963,'TV','TUV',798,'Tuvalu','Oceania','Polynesia','','+688',9,61,NULL,true,'2025-02-28 16:18:45.132843+08','2025-02-28 16:18:45.99905+08'),
	 (1964,'UG','UGA',800,'Uganda','Africa','Sub-Saharan Africa','Eastern Africa','+256',2,202,14,true,'2025-02-28 16:18:45.136334+08','2025-02-28 16:18:46.002031+08'),
	 (1965,'UA','UKR',804,'Ukraine','Europe','Eastern Europe','','+380',150,151,NULL,true,'2025-02-28 16:18:45.139822+08','2025-02-28 16:18:46.004717+08'),
	 (1966,'AE','ARE',784,'United Arab Emirates','Asia','Western Asia','','+971',142,145,NULL,true,'2025-02-28 16:18:45.188501+08','2025-02-28 16:18:46.007275+08'),
	 (1967,'GB','GBR',826,'United Kingdom of Great Britain and Northern Ireland','Europe','Northern Europe','','+44',150,154,NULL,true,'2025-02-28 16:18:45.192241+08','2025-02-28 16:18:46.009829+08'),
	 (1968,'US','USA',840,'United States of America','Americas','Northern America','','+1',19,21,NULL,true,'2025-02-28 16:18:45.194907+08','2025-02-28 16:18:46.012398+08'),
	 (1969,'UM','UMI',581,'United States Minor Outlying Islands','Oceania','Micronesia','','+1',9,57,NULL,true,'2025-02-28 16:18:45.197579+08','2025-02-28 16:18:46.015087+08'),
	 (1970,'UY','URY',858,'Uruguay','Americas','Latin America and the Caribbean','South America','+598',19,419,5,true,'2025-02-28 16:18:45.20032+08','2025-02-28 16:18:46.017693+08'),
	 (1971,'UZ','UZB',860,'Uzbekistan','Asia','Central Asia','','+998',142,143,NULL,true,'2025-02-28 16:18:45.203026+08','2025-02-28 16:18:46.020391+08'),
	 (1972,'VU','VUT',548,'Vanuatu','Oceania','Melanesia','','+678',9,54,NULL,true,'2025-02-28 16:18:45.205686+08','2025-02-28 16:18:46.023052+08');
INSERT INTO public.i3s_country (ver,country_code_alpha_2,country_code_alpha_3,country_code,country_name,region,sub_region,inter_region,dial_country_code,region_code,sub_region_code,inter_region_code,is_active,dt_create,dt_update) VALUES
	 (1973,'VE','VEN',862,'Venezuela, Bolivarian Republic of','Americas','Latin America and the Caribbean','South America','+58',19,419,5,true,'2025-02-28 16:18:45.209063+08','2025-02-28 16:18:46.025738+08'),
	 (1974,'VN','VNM',704,'Viet Nam','Asia','South-eastern Asia','','+84',142,35,NULL,true,'2025-02-28 16:18:45.232863+08','2025-02-28 16:18:46.028528+08'),
	 (1975,'VG','VGB',92,'Virgin Islands (British)','Americas','Latin America and the Caribbean','Caribbean','+1-284',19,419,29,true,'2025-02-28 16:18:45.235949+08','2025-02-28 16:18:46.031264+08'),
	 (1976,'VI','VIR',850,'Virgin Islands (U.S.)','Americas','Latin America and the Caribbean','Caribbean','+1-340',19,419,29,true,'2025-02-28 16:18:45.23901+08','2025-02-28 16:18:46.033842+08'),
	 (1977,'WF','WLF',876,'Wallis and Futuna','Oceania','Polynesia','','+681',9,61,NULL,true,'2025-02-28 16:18:45.291249+08','2025-02-28 16:18:46.036611+08'),
	 (1978,'EH','ESH',732,'Western Sahara','Africa','Northern Africa','','+212',2,15,NULL,true,'2025-02-28 16:18:45.29526+08','2025-02-28 16:18:46.039173+08'),
	 (1979,'YE','YEM',887,'Yemen','Asia','Western Asia','','+967',142,145,NULL,true,'2025-02-28 16:18:45.298228+08','2025-02-28 16:18:46.041844+08'),
	 (1980,'ZM','ZMB',894,'Zambia','Africa','Sub-Saharan Africa','Eastern Africa','+260',2,202,14,true,'2025-02-28 16:18:45.303824+08','2025-02-28 16:18:46.044443+08'),
	 (1981,'ZW','ZWE',716,'Zimbabwe','Africa','Sub-Saharan Africa','Eastern Africa','+263',2,202,14,true,'2025-02-28 16:18:45.310946+08','2025-02-28 16:18:46.047197+08');

INSERT INTO i3s_state_group (state_group, weekend) VALUES 
    ('A', '5,6'),
    ('B', '6,7');

-- https://sdk.myinvois.hasil.gov.my/codes/state-codes/
INSERT INTO i3s_state (country_code_alpha_2, state_code, state_group, state_name) VALUES 
    ('MY', 1, 'A', 'Johor'),
    ('MY', 2, 'A', 'Kedah'),
    ('MY', 3, 'A', 'Kelantan'),
    ('MY', 4, 'B', 'Melaka'),
    ('MY', 5, 'B', 'Negeri Sembilan'),
    ('MY', 6, 'B', 'Pahang'),
    ('MY', 7, 'B', 'Pulau Pinang'),
    ('MY', 8, 'B', 'Perak'),
    ('MY', 9, 'B', 'Perlis'),
    ('MY', 10, 'B', 'Selangor'),
    ('MY', 11, 'A', 'Terengganu'),
    ('MY', 12, 'B', 'Sabah'),
    ('MY', 13, 'B', 'Sarawak'),
    ('MY', 14, 'B', 'Wilayah Persekutuan Kuala Lumpur'),
    ('MY', 15, 'B', 'Wilayah Persekutuan Labuan'),
    ('MY', 16, 'B', 'Wilayah Persekutuan Putrajaya');
INSERT INTO i3s_state (country_code_alpha_2, state_code, state_name) VALUES ('MY', 17, 'Not Applicable');

INSERT INTO i3s_city (country_code_alpha_2, city_name, state_code) VALUES
    ('MY', 'Muar', 1),
    ('MY', 'Kluang', 1),
    ('MY', 'Pontian', 1),
    ('MY', 'Kota Tinggi', 1),
    ('MY', 'Segamat', 1),
    ('MY', 'Mersing', 1),
    ('MY', 'Batu Pahat', 1),
    ('MY', 'Johor Bharu', 1),
    ('MY', 'Ulu Tiram', 1),
    ('MY', 'Kulai', 1),
    ('MY', 'Masai', 1),
    ('MY', 'Pasir Gudang', 1),
    ('MY', 'Tangkak', 1),
    ('MY', 'Yong Peng', 1),
    ('MY', 'Simpang Renggam', 1),
    ('MY', 'Pagoh', 1),
    ('MY', 'Air Hitam', 1),
    ('MY', 'Ayer Hitam', 1),
    ('MY', 'Kulim', 2),
    ('MY', 'Alor Setar', 2),
    ('MY', 'Kubang Pasu', 2),
    ('MY', 'Yan', 2),
    ('MY', 'Gurun', 2),
    ('MY', 'Baling', 2),
    ('MY', 'Sik', 2),
    ('MY', 'Sungai Petani', 2),
    ('MY', 'Langkawi', 2),
    ('MY', 'Pendang', 2),
    ('MY', 'Jitra', 2),
    ('MY', 'Kuala Kedah', 2),
    ('MY', 'Air Hitam', 2),
    ('MY', 'Kota Bharu', 3),
    ('MY', 'Kuala Krai', 3),
    ('MY', 'Pasir Puteh', 3),
    ('MY', 'Tanah Merah', 3),
    ('MY', 'Tumpat', 3),
    ('MY', 'Bachok', 3),
    ('MY', 'Pasir Mas', 3),
    ('MY', 'Machang', 3),
    ('MY', 'Gua Musang', 3),
    ('MY', 'Kuala Lumpur', '14'),
    ('MY', 'Kepong', '14'),
    ('MY', 'Wangsa Maju', '14'),
    ('MY', 'Titiwangsa', '14'),
    ('MY', 'Segambut', '14'),
    ('MY', 'Cheras', '14'),
    ('MY', 'Seputeh', '14'),
    ('MY', 'Setiawangsa', '14'),
    ('MY', 'Labuan', '15'),
    ('MY', 'Ayer Keroh', 4),
    ('MY', 'Alor Gajah', 4),
    ('MY', 'Jasin', 4),
    ('MY', 'Melaka Tengah', 4),
    ('MY', 'Masjid Tanah', 4),
    ('MY', 'Merlimau', 4),
    ('MY', 'Jelebu', 5),
    ('MY', 'Kuala Pilah', 5),
    ('MY', 'Tampin', 5),
    ('MY', 'Rembau', 5),
    ('MY', 'Pedas', 5),
    ('MY', 'Seremban', 5),
    ('MY', 'Jempol', 5),
    ('MY', 'Port Dickson', 5),
    ('MY', 'Gemas', 5),
    ('MY', 'Nilai', 5),
    ('MY', 'Mentakab', 6),
    ('MY', 'Pekan', 6),
    ('MY', 'Bentong', 6),
    ('MY', 'Maran', 6),
    ('MY', 'Lipis', 6),
    ('MY', 'Jerantut', 6),
    ('MY', 'Kuantan', 6),
    ('MY', 'Rompin', 6),
    ('MY', 'Bera', 6),
    ('MY', 'Temerloh', 6),
    ('MY', 'Raub', 6),
    ('MY', 'Karak', 6),
    ('MY', 'Betong', 6),
    ('MY', 'Ipoh', 8),
    ('MY', 'Manjung', 8),
    ('MY', 'Taiping', 8),
    ('MY', 'Selama', 8),
    ('MY', 'Kuala Kangsar', 8),
    ('MY', 'Sungai Siput', 8),
    ('MY', 'Gopeng', 8),
    ('MY', 'Kampar', 8),
    ('MY', 'Teluk Intan', 8),
    ('MY', 'Lenggong', 8),
    ('MY', 'Kerian', 8),
    ('MY', 'Kemunting', 8),
    ('MY', 'Menglembu', 8),
    ('MY', 'Lumut', 8),
    ('MY', 'Sg. Siput (U)', 8),
    ('MY', 'Tapah', 8),
    ('MY', 'Kangar', '09'),
    ('MY', 'Ayer Itam', 7),
    ('MY', 'Butterworth', 7),
    ('MY', 'GeorgeTown', 7),
    ('MY', 'Bukit Mertajam', 7),
    ('MY', 'Jelutong', 7),
    ('MY', 'Seberang Perai', 7),
    ('MY', 'Bayan Lepas', 7),
    ('MY', 'Tanjong Bungah', 7),
    ('MY', 'Kepala Batas', 7),
    ('MY', 'Putrajaya', 16),
    ('MY', 'Kota Kinabalu', 12),
    ('MY', 'Kota Belud', 12),
    ('MY', 'Tambunan', 12),
    ('MY', 'Kudat', 12),
    ('MY', 'Sandakan', 12),
    ('MY', 'Ranau', 12),
    ('MY', 'Tawau', 12),
    ('MY', 'Keningau', 12),
    ('MY', 'Lahat Datu', 12),
    ('MY', 'Penampang', 12),
    ('MY', 'Kota Kinabatangan', 12),
    ('MY', 'Miri', 13),
    ('MY', 'Samarahan', 13),
    ('MY', 'Mukah', 13),
    ('MY', 'Sibu', 13),
    ('MY', 'Bintulu', 13),
    ('MY', 'Kuching', 13),
    ('MY', 'Kapit', 13),
    ('MY', 'Kota Samarahan', 13),
    ('MY', 'Sarikei', 13),
    ('MY', 'Asajaya', 13),
    ('MY', 'Subang', 10),
    ('MY', 'Petaling Jaya', 10),
    ('MY', 'Banting', 10),
    ('MY', 'Shah Alam', 10),
    ('MY', 'Klang', 10),
    ('MY', 'Sepang', 10),
    ('MY', 'Ampang', 10),
    ('MY', 'Puchong', 10),
    ('MY', 'Kuala Selangor', 10),
    ('MY', 'Gombak', 10),
    ('MY', 'Hulu Langat', 10),
    ('MY', 'Sabak Bernam', 10),
    ('MY', 'Batu Caves', 10),
    ('MY', 'Dengkil', 10),
    ('MY', 'Jenjarom', 10),
    ('MY', 'Seri Kembangan', 10),
    ('MY', 'Rawang', 10),
    ('MY', 'Kajang', 10),
    ('MY', 'Sungai Besar', 10),
    ('MY', 'Sungai Buloh', 10),
    ('MY', 'Bandar Baru Bangi', 10),
    ('MY', 'Pelabuhan Klang', 10),
    ('MY', 'Semenyih', 10),
    ('MY', 'Telok Panglima Garang', 10),
    ('MY', 'Cheras', 10),
    ('MY', 'Kuala Terengganu', 11),
    ('MY', 'Setiu', 11),
    ('MY', 'Marang', 11),
    ('MY', 'Dungun', 11),
    ('MY', 'Kemaman', 11),
    ('MY', 'Besut', 11);

-- https://publicholidays.com.my/2025-dates/

-- Malaysia national holidays
INSERT INTO i3s_public_holiday (country_code_alpha_2, state_code, holi_date, descript) VALUES
	('MY', NULL, '2025-01-29', 'Chinese New Year'),
	('MY', NULL, '2025-01-30', 'Chinese New Year'),
	('MY', NULL, '2025-03-31', 'Hari Raya Aidilfitri'),
	('MY', NULL, '2025-04-01', 'Hari Raya Aidilfitri'),
	('MY', NULL, '2025-05-01', 'Labour Day'),
	('MY', NULL, '2025-05-12', 'Wesak Day'),
	('MY', NULL, '2025-06-02', 'Agong''s Birthday'),
	('MY', NULL, '2025-06-07', 'Hari Raya Haji'),
	('MY', NULL, '2025-06-27', 'Awal Muharram'),
	('MY', NULL, '2025-08-31', 'Merdeka Day'),
	('MY', NULL, '2025-09-05', 'Prophet Muhammad''s Birthday'),
	('MY', NULL, '2025-09-16', 'Malaysia Day'),
	('MY', NULL, '2025-12-25', 'Christmas Day');

-- Malaysia state holidays
INSERT INTO i3s_public_holiday (country_code_alpha_2, state_code, holi_date, descript) VALUES
	('MY', 4, '2025-01-01', 'New Year''s Day'),							-- Melaka
	('MY', 5, '2025-01-01', 'New Year''s Day'),							-- Negeri Sembilan
	('MY', 6, '2025-01-01', 'New Year''s Day'),							-- Pahang
	('MY', 7, '2025-01-01', 'New Year''s Day'),							-- Pulau Pinang
	('MY', 8, '2025-01-01', 'New Year''s Day'),							-- Perak
	('MY', 10, '2025-01-01', 'New Year''s Day'),						-- Selangor
	('MY', 12, '2025-01-01', 'New Year''s Day'),						-- Sabah
	('MY', 13, '2025-01-01', 'New Year''s Day'),						-- Sarawak
	('MY', 14, '2025-01-01', 'New Year''s Day'),						-- Wilayah Persekutuan Kuala Lumpur
	('MY', 15, '2025-01-01', 'New Year''s Day'),						-- Wilayah Persekutuan Labuan
	('MY', 16, '2025-01-01', 'New Year''s Day'),						-- Wilayah Persekutuan Putrajaya
	('MY', 5, '2025-01-14', 'YDPB Negeri Sembilan''s Birthday'),		-- Negeri Sembilan
	('MY', 2, '2025-01-27', 'Israk and Mikraj'),						-- Kedah
	('MY', 5, '2025-01-27', 'Israk and Mikraj'),						-- Negeri Sembilan
	('MY', 9, '2025-01-27', 'Israk and Mikraj'),						-- Perlis
	('MY', 11, '2025-01-27', 'Israk and Mikraj'),						-- Terengganu
	('MY', 14, '2025-02-01', 'Federal Territory Day'),					-- Wilayah Persekutuan Kuala Lumpur
	('MY', 15, '2025-02-01', 'Federal Territory Day'),					-- Wilayah Persekutuan Labuan
	('MY', 16, '2025-02-01', 'Federal Territory Day'),					-- Wilayah Persekutuan Putrajaya
	('MY', 1, '2025-02-11', 'Thaipusam'),								-- Johor
	('MY', 2, '2025-02-11', 'Thaipusam'),								-- Kedah
	('MY', 5, '2025-02-11', 'Thaipusam'),								-- Negeri Sembilan
	('MY', 7, '2025-02-11', 'Thaipusam'),								-- Pulau Pinang
	('MY', 8, '2025-02-11', 'Thaipusam'),								-- Perak
	('MY', 14, '2025-02-11', 'Thaipusam'),								-- Wilayah Persekutuan Kuala Lumpur
	('MY', 16, '2025-02-11', 'Thaipusam'),								-- Wilayah Persekutuan Putrajaya
	('MY', 10, '2025-02-11', 'Thaipusam'),								-- Selangor
	('MY', 4, '2025-02-20', 'Independence Declaration Day'),			-- Melaka
	('MY', 1, '2025-03-02', 'Awal Ramadan'),							-- Johor
	('MY', 2, '2025-03-02', 'Awal Ramadan'),							-- Kedah
	('MY', 1, '2025-03-03', 'Awal Ramadan'),							-- Johor
	('MY', 11, '2025-03-04', 'Installation of Sultan Terengganu'),		-- Terengganu
	('MY', 3, '2025-03-18', 'Nuzul Al-Quran'),							-- Kelantan
	('MY', 6, '2025-03-18', 'Nuzul Al-Quran'),							-- Pahang
	('MY', 7, '2025-03-18', 'Nuzul Al-Quran'),							-- Pulau Pinang
	('MY', 8, '2025-03-18', 'Nuzul Al-Quran'),							-- Perak
	('MY', 9, '2025-03-18', 'Nuzul Al-Quran'),							-- Perlis
	('MY', 10, '2025-03-18', 'Nuzul Al-Quran'),							-- Selangor
	('MY', 11, '2025-03-18', 'Nuzul Al-Quran'),							-- Terengganu
	('MY', 14, '2025-03-18', 'Nuzul Al-Quran'),							-- Wilayah Persekutuan Kuala Lumpur
	('MY', 15, '2025-03-18', 'Nuzul Al-Quran'),							-- Wilayah Persekutuan Labuan
	('MY', 16, '2025-03-18', 'Nuzul Al-Quran'),							-- Wilayah Persekutuan Putrajaya
	('MY', 1, '2025-03-23', 'Sultan of Johor''s Birthday'),				-- Johor
	('MY', 1, '2025-03-24', 'Sultan of Johor''s Birthday'),				-- Johor
	('MY', 4, '2025-04-02', 'Hari Raya Aidilfitri'),					-- Melaka
	('MY', 12, '2025-04-18', 'Good Friday'),							-- Sabah
	('MY', 13, '2025-04-18', 'Good Friday'),							-- Sarawak
	('MY', 11, '2025-04-26', 'Sultan of Terengganu''s Birthday'),		-- Terengganu
	('MY', 11, '2025-04-27', 'Sultan of Terengganu''s Birthday'),		-- Terengganu
	('MY', 9, '2025-05-17', 'Raja Perlis''s Birthday'),					-- Perlis
	('MY', 6, '2025-05-22', 'Hari Hol Pahang'),							-- Pahang
	('MY', 15, '2025-05-30', 'Harvest Festival'),						-- Wilayah Persekutuan Labuan
	('MY', 12, '2025-05-30', 'Harvest Festival'),						-- Sabah
	('MY', 15, '2025-05-31', 'Harvest Festival'),						-- Wilayah Persekutuan Labuan
	('MY', 12, '2025-05-31', 'Harvest Festival'),						-- Sabah
	('MY', 13, '2025-06-01', 'Hari Gawai'),								-- Sarawak
	('MY', 13, '2025-06-02', 'Hari Gawai'),								-- Sarawak
	('MY', 13, '2025-06-03', 'Agong''s Birthday'),						-- Sarawak
	('MY', 3, '2025-06-06', 'Arafat Day'),								-- Kelantan
	('MY', 11, '2025-06-06', 'Arafat Day'),								-- Terengganu
	('MY', 2, '2025-06-08', 'Hari Raya Haji'),							-- Kedah
	('MY', 3, '2025-06-08', 'Hari Raya Haji'),							-- Kelantan
	('MY', 9, '2025-06-08', 'Hari Raya Haji'),							-- Perlis
	('MY', 11, '2025-06-08', 'Hari Raya Haji'),							-- Terengganu
	('MY', 2, '2025-06-09', 'Hari Raya Haji'),							-- Kedah
	('MY', 3, '2025-06-09', 'Hari Raya Haji'),							-- Kelantan
	('MY', 9, '2025-06-09', 'Hari Raya Haji'),							-- Perlis
	('MY', 11, '2025-06-09', 'Hari Raya Haji'),							-- Terengganu
	('MY', 2, '2025-06-22', 'Sultan of Kedah''s Birthday'),				-- Kedah
	('MY', 2, '2025-06-27', 'Awal Muharram'),							-- Kedah
	('MY', 7, '2025-07-07', 'Georgetown World Heritage City Day'),		-- Pulau Pinang
	('MY', 7, '2025-07-12', 'Penang Governor''s Birthday'),				-- Pulau Pinang
	('MY', 13, '2025-07-22', 'Sarawak Day'),							-- Sarawak
	('MY', 6, '2025-03-30', 'Sultan of Pahang''s Birthday'),			-- Pahang
	('MY', 1, '2025-07-31', 'Hari Hol Almarhum Sultan Iskandar'),		-- Johor
	('MY', 4, '2025-08-24', 'Melaka Governor''s Birthday'),				-- Melaka
	('MY', 4, '2025-08-25', 'Melaka Governor''s Birthday'),				-- Melaka
	('MY', 1, '2025-09-01', 'Merdeka Day'),								-- Johor
	('MY', 4, '2025-09-01', 'Merdeka Day'),								-- Melaka
	('MY', 5, '2025-09-01', 'Merdeka Day'),								-- Negeri Sembilan
	('MY', 6, '2025-09-01', 'Merdeka Day'),								-- Pahang
	('MY', 7, '2025-09-01', 'Merdeka Day'),								-- Pulau Pinang
	('MY', 8, '2025-09-01', 'Merdeka Day'),								-- Perak
	('MY', 9, '2025-09-01', 'Merdeka Day'),								-- Perlis
	('MY', 10, '2025-09-01', 'Merdeka Day'),							-- Selangor
	('MY', 12, '2025-09-01', 'Merdeka Day'),							-- Sabah
	('MY', 13, '2025-09-01', 'Merdeka Day'),							-- Sarawak
	('MY', 14, '2025-09-01', 'Merdeka Day'),							-- Wilayah Persekutuan Kuala Lumpur
	('MY', 15, '2025-09-01', 'Merdeka Day'),							-- Wilayah Persekutuan Labuan
	('MY', 16, '2025-09-01', 'Merdeka Day'),							-- Wilayah Persekutuan Putrajaya
	('MY', 2, '2025-09-07', 'Prophet Muhammad''s Birthday Holiday'),	-- Kedah
	('MY', 3, '2025-09-29', 'Sultan of Kelantan''s Birthday'),			-- Kelantan
	('MY', 3, '2025-09-30', 'Sultan of Kelantan''s Birthday'),			-- Kelantan
	('MY', 12, '2025-10-04', 'Sabah Governor''s Birthday'),				-- Sabah
	('MY', 13, '2025-10-11', 'Sarawak Governor''s Birthday'),			-- Sarawak
	('MY', 1, '2025-10-20', 'Deepavali'),								-- Johor
	('MY', 2, '2025-10-20', 'Deepavali'),								-- Kedah
	('MY', 3, '2025-10-20', 'Deepavali'),								-- Kelantan
	('MY', 4, '2025-10-20', 'Deepavali'),								-- Melaka
	('MY', 5, '2025-10-20', 'Deepavali'),								-- Negeri Sembilan
	('MY', 6, '2025-10-20', 'Deepavali'),								-- Pahang
	('MY', 7, '2025-10-20', 'Deepavali'),								-- Pulau Pinang
	('MY', 8, '2025-10-20', 'Deepavali'),								-- Perak
	('MY', 9, '2025-10-20', 'Deepavali'),								-- Perlis
	('MY', 10, '2025-10-20', 'Deepavali'),								-- Selangor
	('MY', 11, '2025-10-20', 'Deepavali'),								-- Terengganu
	('MY', 12, '2025-10-20', 'Deepavali'),								-- Sabah
	('MY', 14, '2025-10-20', 'Deepavali'),								-- Wilayah Persekutuan Kuala Lumpur
	('MY', 15, '2025-10-20', 'Deepavali'),								-- Wilayah Persekutuan Labuan
	('MY', 16, '2025-10-20', 'Deepavali'),								-- Wilayah Persekutuan Putrajaya
	('MY', 8, '2025-11-07', 'Sultan of Perak''s Birthday'),				-- Perak
	('MY', 10, '2025-12-1', 'Sultan of Selangor''s Birthday'),			-- Selangor
	('MY', 12, '2025-12-24', 'Christman Eve');							-- Sabah

INSERT INTO i3s_school_type (school_type_code, school_type) VALUES (1, 'Sekolah Jenis Kebangsaan');
INSERT INTO i3s_school_type (school_type_code, school_type) VALUES (2, 'Maktab Rendah Sains Mara (MRSM)');

-- Test schools
INSERT INTO i3s_school (school_id,status_code,school_type_code,school_name,principal_name,phone_number,fax_number,email,website_url,result_url,ver,addr_1,addr_2,addr_city,addr_post,addr_state_code,addr_country_code_alpha_2,coordinates,register_date,pic_1_url,pic_2_url,created_by,updated_by,dt_create,dt_update) VALUES
	 ('BBA4049',1,2,'MRSM Bagan Datuk','Juhranar Binti Yang','+60387339008','+60387339008','bba4049@moe.com.my','http://sksi2kajang.blogspot.com/','https://program.i-3s.com.my/Maintenance.aspx',2369,'Persiaran Impian Perdana',NULL,'KAJANG','43200',10,'MY','3.0207628125767934,101.7922266603092',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BBA8250',1,1,'SK SEKSYEN 6','Ooi Ban Aik @ Muhd Umar','+60122058011','+60122058011','BBA8250@moe.edu.my','https://www.facebook.com/skseskyen6kotadamansara/','https://sapsnkra.moe.gov.my/ibubapa2/',2370,'Jalan Cecawi 6/26',NULL,'KOTA DAMANSARA','47810',10,'MY','3.1563679739365584,101.57578172228185',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BBA8105',2,1,'SK SEKSYEN 24','Azman B. Mohd Aris','+60355418623','+60355418623','BBA8105@moe.edu.my','http://portalsksekyen24.blogspot.com','https://sapsnkra.moe.gov.my/ibubapa2/',2371,'Jalan Petola 24/8',NULL,'SHAH ALAM','40300',10,'MY','3.0407507063060937,101.51857151448797',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BBA8284',1,1,'SK TAMAN DESAMINIUM','A.Rahim Bin Mohd Mislani','+60389413905','+60389413905','BBA8284@moe.edu.my','https://www.facebook.com/PIBGSKTamanDesaminium/','https://sapsnkra.moe.gov.my/ibubapa2/',2372,'Persiaran Desaminium 1, Lestari Perdana',NULL,'SERI KEMBANGAN','43300',10,'MY','3.0055688488180765,101.66089497058663',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BEA8608',1,1,'SMK DAMANSARA JAYA','Ahmad Ezzat bin Ismail','+60377296018','+60377296018','BEA8608@moe.edu.my','https://www.smkdj.edu.my/','https://program.i-3s.com.my/Maintenance.aspx',2373,'Jalan SS22A/1, Damansara Jaya',NULL,'PETALING JAYA','47400',10,'MY','3.1304040535931787,101.6158364433421',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BEA8639',2,1,'SMK SEKSYEN 1 BANDAR KINRARA','Puan Normah binti Hashim','+60380704075','+60380704075','bea8639@moe.edu.my','http://www.ict_smkslbk.simplesite','https://program.i-3s.com.my/Maintenance.aspx',2374,'Jalan Kinrara 3, Bandar Kinrara,',NULL,'PUCHONG','47180',10,'MY','3.0511623241387413,101.64321292970229',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BEA8617',1,1,'SMK SEKSYEN 18','HAFIZAH BINTI ABDUL SAMAD','+60355421403','+60355421403','bea8617@moe.edu.my','https://m.facebook.com/smks18/','https://program.i-3s.com.my/Maintenance.aspx',2375,'Jalan Kelapa Bali 18/43, Seksyen 18',NULL,'SHAH ALAM','40200',10,'MY','3.0510034293695076,101.52318869615144',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BBA4050',2,1,'SK CHERAS JAYA','MUHAMMAD THANI BIN ABDULLAH','+0390754929','+0390754929','BBA4050@moe.edu.my','http://skcherasjayaskcj.blogspot.com/','https://sapsnkra.moe.gov.my/ibubapa2/',2376,'Jalan Cj 15, Taman Cheras Jaya, Balakong,',NULL,'CHERAS','43200',10,'MY','3.020319092754677,101.76320082699037',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('WBA2002',1,1,'SK PUTRAJAYA PRESINT 8(1)','SALIZA BINTI SALUDIN','+60388880120','+60388880120','wba2002@moe.edu.my','www.skpp81.edu.my','https://sapsnkra.moe.gov.my/ibubapa2/',2377,'No 4 Jalan P8, Presint 8',NULL,'PUTRAJAYA','62249',16,'MY','2.939558552508965,101.68533355852679',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('WEA2001',2,1,'SMK PUTRAJAYA PRESINT 8(1)','ADEEBAH BINTI ALI','+60388880200','+60388880200','p.smkpp81@gmail.com','www.smkpp8.edu.my','https://program.i-3s.com.my/Maintenance.aspx',2378,'No 4 Jalan P8, presint 8',NULL,'PUTRAJAYA','62250',16,'MY','2.940177472262169,101.68488770851977',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('WBA2004',2,1,'SK PUTRAJAYA PRESINT 11(1)','ROHANA BINTI ABD MANAF','+60388884220','+60388884220','gb.skpp11@gmail.com','http://skputrajayapresint111.blogspot.com','https://sapsnkra.moe.gov.my/ibubapa2/',2379,'Jalan P11/1, Presint 11',NULL,'PUTRAJAYA','62300',16,'MY','2.950708219186395,101.67755339100673',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('WBA2001',2,1,'SK PUTRAJAYA PRESINT 9(1)','NORZAH BINTI MOHD KASSIM','+60388885200','+60388885200','wba2001@moe.edu.my','https://skpp91.edu.my','https://sapsnkra.moe.gov.my/ibubapa2/',2380,'Jalan P9f, Presint 9',NULL,'PUTRAJAYA','62250',16,'MY','2.942346375207574,101.67795908304733',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('WBA2012',1,1,'SK PUTRAJAYA PRESINT 18(2)','HAJAH ROHANA BT JUSOH','+60388610479','+60388613542','wba2012@moe.edu.my','https://skpp182.edu.my','https://sapsnkra.moe.gov.my/ibubapa2/',2381,'No 3 Jalan P18G, presint 18',NULL,'PUTRAJAYA','62100',16,'MY','2.915375438913829,101.69050142276645',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BEA0093',1,1,'SMK TENGKU AMPUAN RAHIMAH','ENCIK SAHRUDIN BIN KASMAN','+60333718582','+60333718582','BEA0093@moe.edu.my','https://m.facebook.com/AktivitiSTAR.Official/','https://program.i-3s.com.my/Maintenance.aspx',2382,'Persiaran Raja Muda Musa, Klang',NULL,'KLANG','41200',10,'MY','3.0323143765690177,101.43959708708361',NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('NBA6030',2,1,'SK TUNKU MUDA SERTING','PN Hjh Halijah','+6064543786','+6064543786','nba6030@moe.edu.my','sktms.com','https://sapsnkra.moe.gov.my/ibubapa2/',2383,'Kampung Bukit Laka',NULL,'BAHAU','72100',5,'MY',NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BEA0114',1,1,'SMK BUKIT KAPAR','Hj Maswi B Saion','+60163500114','+60163500114','BEA0114@moe.edu.my','https://www.facebook.com/SMK-BUKIT-KAPAR-352064872283050/','https://program.i-3s.com.my/Maintenance.aspx',2384,'Jalan Abdul Wahid, Kg Bukit Kapar',NULL,'KAPAR','42200',10,'MY',NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BBA0017',1,1,'SK PANDAMARAN JAYA','MAHAT BIN ABD HAMID','+60331673389',NULL,'BBA0017@moe.edu.my','https://','https://program.i-3s.com.my/Maintenance.aspx',2385,'Pelabuhan Klang',NULL,'P.KLANG','42000',10,'MY',NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('AGA7702',1,2,'MRSM Lenggong','EN Sulaiman B Yusof','+6057676004','+6057676300','info MRSM_lenggong@mara.gov.my','http://llac.mrsm.edu.my/cms/index.jsp','https://',2386,'Changkat Berangan',NULL,'LENGGONG','33400',8,'MY',NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('BEA0105',1,1,'SMK JALAN KEBUN','RUBI''AH BT HAYAT','+60351613964','+60351613964','bea0105@moe.edu my','https://','https://program.i-3s.com.my/Maintenance.aspx',2387,'Batu 7, Jalan Kebun Seksyen 32',NULL,'KLANG','40460',10,'MY',NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('WBB0058',1,1,'SK JALAN GURNEY (1)','PUTRA BIN AHMAD','+60326988475','+60326988475','wbb0058@moe.edu.my','https://','https://program.i-3s.com.my/Maintenance.aspx',2388,'Jalan Gurney 1, Kampung Datuk Keramat',NULL,'KERAMAT','54000',14,'MY',NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('WBB0083',1,1,'SK ST JOHN 1','BASCARAN A/L ARUMUGAM','+60320737648',NULL,'wbb0083@moe.edu.my','https://','https://program.i-3s.com.my/Maintenance.aspx',2389,'7-5 Jalan Bukit Nenas',NULL,'KUALA LUMPUR','50250',14,'MY',NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08'),
	 ('WEA2002',1,1,'SMK PUTRAJAYA PRESINT 9 (1)','AI''IRI B.ABU BAKAR','+60388885150','+60388895150','p.smkpp91@gmail.com','https://','https://program.i-3s.com.my/Maintenance.aspx',2390,'No 2, Jalan P9',NULL,'PUTRAJAYA','62250',16,'MY',NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-28 16:50:31.078611+08','2025-02-28 16:50:31.078611+08');

-- School classes
INSERT INTO i3s_school_class (school_id,class_id,class_name,status_code) VALUES
	 ('BBA8250','1 LESTARI','1 Lestari',1),
	 ('BBA8250','1 BITARA','1 Bitara',1),
	 ('BBA8250','1 HOLISTIK','1 Holistik',1),
	 ('BBA8250','1 INOVASI','1 Inovasi',1),
	 ('BBA8250','1 OBLIGASI','1 Obligasi',1),
	 ('BBA8250','1 SINERGI','1 Sinergi',1),
	 ('BBA8250','2 BITARA','2 Bitara',1),
	 ('BBA8250','2 HOLISTIK','2 Holistik',1),
	 ('BBA8250','2 INOVASI','2 Inovasi',1),
	 ('BBA8250','2 LESTARI','2 Lestari',1),
	 ('BBA8250','2 OBLIGASI','2 Obligasi',1),
	 ('BBA8250','2 SINERGI','2 Sinergi',1),
	 ('BBA8250','3 BITARA','3 Bitara',1),
	 ('BBA8250','3 HOLISTIK','3 Holistik',1),
	 ('BBA8250','3 INOVASI','3 Inovasi',1),
	 ('BBA8250','3 LESTARI','3 Lestari',1),
	 ('BBA8250','3 OBLIGASI','3 Obligasi',1),
	 ('BBA8250','3 SINERGI','3 Sinergi',1),
	 ('BBA4049','1 LESTARI','1 Lestari',1),
	 ('BBA4049','1 BITARA','1 Bitara',1),
	 ('BBA4049','1 HOLISTIK','1 Holistik',1),
	 ('BBA4049','1 INOVASI','1 Inovasi',1),
	 ('BBA4049','1 OBLIGASI','1 Obligasi',1),
	 ('BBA4049','1 SINERGI','1 Sinergi',1),
	 ('BBA4049','2 BITARA','2 Bitara',1),
	 ('BBA4049','2 HOLISTIK','2 Holistik',1),
	 ('BBA4049','2 INOVASI','2 Inovasi',1),
	 ('BBA4049','2 LESTARI','2 Lestari',1),
	 ('BBA4049','2 OBLIGASI','2 Obligasi',1),
	 ('BBA4049','2 SINERGI','2 Sinergi',1),
	 ('BBA4049','3 BITARA','3 Bitara',1),
	 ('BBA4049','3 HOLISTIK','3 Holistik',1),
	 ('BBA4049','3 INOVASI','3 Inovasi',1),
	 ('BBA4049','3 LESTARI','3 Lestari',1),
	 ('BBA4049','3 OBLIGASI','3 Obligasi',1),
	 ('BBA4049','3 SINERGI','3 Sinergi',1),
	 ('BBA4049','4 BITARA','4 Bitara',1),
	 ('BBA4049','4 HOLISTIK','4 Holistik',1),
	 ('BBA4049','4 INOVASI','4 Inovasi',1),
	 ('BBA4049','4 LESTARI','4 Lestari',1),
	 ('BBA4049','4 OBLIGASI','4 Obligasi',1),
	 ('BBA4049','4 SINERGI','4 Sinergi',1),
	 ('BBA4049','5 BITARA','5 Bitara',1),
	 ('BBA4049','5 HOLISTIK','5 Holistik',1),
	 ('BBA4049','5 INOVASI','5 Inovasi',1),
	 ('BBA4049','5 LESTARI','5 Lestari',1),
	 ('BBA4049','5 OBLIGASI','5 Obligasi',1),
	 ('BBA4049','5 SINERGI','5 Sinergi',1),
	 ('BBA0017','1 LESTARI','1 Lestari',1),
	 ('BBA0017','1 BITARA','1 Bitara',1),
	 ('BBA0017','1 HOLISTIK','1 Holistik',1),
	 ('BBA0017','1 INOVASI','1 Inovasi',1),
	 ('BBA0017','1 OBLIGASI','1 Obligasi',1),
	 ('BBA0017','1 SINERGI','1 Sinergi',1),
	 ('BBA0017','2 BITARA','2 Bitara',1),
	 ('BBA0017','2 HOLISTIK','2 Holistik',1),
	 ('BBA0017','2 INOVASI','2 Inovasi',1),
	 ('BBA0017','2 LESTARI','2 Lestari',1),
	 ('BBA0017','2 OBLIGASI','2 Obligasi',1),
	 ('BBA0017','2 SINERGI','2 Sinergi',1),
	 ('BBA0017','3 BITARA','3 Bitara',1),
	 ('BBA0017','3 HOLISTIK','3 Holistik',1),
	 ('BBA0017','3 INOVASI','3 Inovasi',1),
	 ('BBA0017','3 LESTARI','3 Lestari',1),
	 ('BBA0017','3 OBLIGASI','3 Obligasi',1),
	 ('BBA0017','3 SINERGI','3 Sinergi',1),
	 ('BBA0017','4 BITARA','4 Bitara',1),
	 ('BBA0017','4 HOLISTIK','4 Holistik',1),
	 ('BBA0017','4 INOVASI','4 Inovasi',1),
	 ('BBA0017','4 LESTARI','4 Lestari',1),
	 ('BBA0017','4 OBLIGASI','4 Obligasi',1),
	 ('BBA0017','4 SINERGI','4 Sinergi',1),
	 ('BBA0017','5 BITARA','5 Bitara',1),
	 ('BBA0017','5 HOLISTIK','5 Holistik',1),
	 ('BBA0017','5 INOVASI','5 Inovasi',1),
	 ('BBA0017','5 LESTARI','5 Lestari',1),
	 ('BBA0017','5 OBLIGASI','5 Obligasi',1),
	 ('BBA0017','5 SINERGI','5 Sinergi',1),
	 ('BBA0017','2 BESTARI','2 Bestari',1),
	 ('BBA0017','6 BITARA','6 Bitara',1),
	 ('BBA0017','6 HOLISTIK','6 Holistik',1),
	 ('BBA0017','6 BESTARI','6 Bestari',1),
	 ('BBA0017','6 INOVASI','6 Inovasi',1),
	 ('BBA0017','6 LESTARI','6 Lestari',1),
	 ('BBA0017','6 OBLIGASI','6 Obligasi',1),
	 ('BBA0017','6 SINERGI','6 Sinergi',1),
	 ('BBA4049','6 BITARA','6 Bitara',1),
	 ('BBA4049','6 HOLISTIK','6 Holistik',1),
	 ('BBA4049','6 BESTARI','6 Bestari',1),
	 ('BBA4049','6 INOVASI','6 Inovasi',1),
	 ('BBA4049','6 LESTARI','6 Lestari',1),
	 ('BBA4049','6 OBLIGASI','6 Obligasi',1),
	 ('BBA4049','6 SINERGI','6 Sinergi',1),
	 ('AGA7702','3 AMANAH','3 AMANAH',1),
	 ('BBA0017','1 BESTARI','1 BESTARI',1),
	 ('BBA0017','1 EFISIEN','1 EFISIEN',1),
	 ('BBA0017','1 INTEGRITI','1 INTEGRITI',1),
	 ('BBA0017','1 TOLERANSI','1 TOLERANSI',1),
	 ('BBA0017','2 DEDIKASI','2 DEDIKASI',1),
	 ('BBA0017','2 EFISIEN','2 EFISIEN',1),
	 ('BBA0017','2 INTEGRITI','2 INTEGRITI',1),
	 ('BBA0017','2 TOLERANSI','2 TOLERANSI',1),
	 ('BBA0017','3 BESTARI','3 BESTARI',1),
	 ('BBA0017','3 DEDIKASI','3 DEDIKASI',1),
	 ('BBA0017','3 EFISIEN','3 EFISIEN',1),
	 ('BBA0017','3 INTEGRITI','3 INTEGRITI',1),
	 ('BBA0017','3 TOLERANSI','3 TOLERANSI',1),
	 ('BBA0017','4 BESTARI','4 BESTARI',1),
	 ('BBA0017','4 DEDIKASI','4 DEDIKASI',1),
	 ('BBA0017','4 EFISIEN','4 EFISIEN',1),
	 ('BBA0017','4 INTEGRITI','4 INTEGRITI',1),
	 ('BBA0017','4 TOLERANSI','4 TOLERANSI',1),
	 ('BBA0017','5 BESTARI','5 BESTARI',1),
	 ('BBA0017','5 DEDIKASI','5 DEDIKASI',1),
	 ('BBA0017','5 EFISIEN','5 EFISIEN',1),
	 ('BBA0017','5 INTEGRITI','5 INTEGRITI',1),
	 ('BBA0017','5 TOLERANSI','5 TOLERANSI',1),
	 ('BBA0017','6 DEDIKASI','6 DEDIKASI',1),
	 ('BBA0017','6 EFISIEN','6 EFISIEN',1),
	 ('BBA0017','6 INTEGRITI','6 INTEGRITI',1),
	 ('BBA0017','6 TOLERANSI','6 TOLERANSI',1),
	 ('BBA0017','1 DEDIKASI','1 DEDIKASI',1),
	 ('BBA4049','5 EMERGING','5 Emerging',1),
	 ('BBA4050','1 AL BIRUNI','1 AL BIRUNI',1),
	 ('BBA4050','1 AL FARABI','1 AL FARABI',1),
	 ('BBA4050','1 AL GHAZALI','1 AL GHAZALI',1),
	 ('BBA4050','1 AL HAITHAMI','1 AL HAITHAMI',1),
	 ('BBA4050','1 AL JAZARI','1 AL JAZARI',1),
	 ('BBA4050','1 AL KINDI','1 AL KINDI',1),
	 ('BBA4050','2 AL BIRUNI','2 AL BIRUNI',1),
	 ('BBA4050','2 AL FARABI','2 AL FARABI',1),
	 ('BBA4050','2 AL GHAZALI','2 AL GHAZALI',1),
	 ('BBA4050','2 AL HAITHAMI','2 AL HAITHAMI',1),
	 ('BBA4050','2 AL JAZARI','2 AL JAZARI',1),
	 ('BBA4050','2 AL KINDI','2 AL KINDI',1),
	 ('BBA4050','3 AL BIRUNI','3 AL BIRUNI',1),
	 ('BBA4050','3 AL FARABI','3 AL FARABI',1),
	 ('BBA4050','3 AL GHAZALI','3 AL GHAZALI',1),
	 ('BBA4050','3 AL HAITHAMI','3 AL HAITHAMI',1),
	 ('BBA4050','3 AL JAZARI','3 AL JAZARI',1),
	 ('BBA4050','3 AL KINDI','3 AL KINDI',1),
	 ('BBA4050','4 AL BIRUNI','4 AL BIRUNI',1),
	 ('BBA4050','4 AL FARABI','4 AL FARABI',1),
	 ('BBA4050','4 AL GHAZALI','4 AL GHAZALI',1),
	 ('BBA4050','4 AL HAITHAMI','4 AL HAITHAMI',1),
	 ('BBA4050','4 AL JAZARI','4 AL JAZARI',1),
	 ('BBA4050','4 AL KINDI','4 AL KINDI',1),
	 ('BBA4050','5 AL BIRUNI','5 AL BIRUNI',1),
	 ('BBA4050','5 AL FARABI','5 AL FARABI',1),
	 ('BBA4050','5 AL GHAZALI','5 AL GHAZALI',1),
	 ('BBA4050','5 AL HAITHAMI','5 AL HAITHAMI',1),
	 ('BBA4050','5 AL JAZARI','5 AL JAZARI',1),
	 ('BBA4050','5 AL KINDI','5 AL KINDI',1),
	 ('BBA4050','6 AL BIRUNI','6 AL BIRUNI',1),
	 ('BBA4050','6 AL FARABI','6 AL FARABI',1),
	 ('BBA4050','6 AL GHAZALI','6 AL GHAZALI',1),
	 ('BBA4050','6 AL HAITHAMI','6 AL HAITHAMI',1),
	 ('BBA4050','6 AL JAZARI','6 AL JAZARI',1),
	 ('BBA4050','6 AL KINDI','6 AL KINDI',1),
	 ('BBA4050','1 IBNU ABBAS','1 IBNU ABBAS',1),
	 ('BBA4050','2 IBNU QAYYIM','2 IBNU QAYYIM',1),
	 ('BBA4050','3 IBNU SINA','3 IBNU SINA',1),
	 ('BBA4050','4 IBNU KHALDUN','4 IBNU KHALDUN',1),
	 ('BBA8105','1 AMANAH','1 AMANAH',1),
	 ('BBA8105','1 BERSIH','1 BERSIH',1),
	 ('BBA8105','1 CERGAS','1 CERGAS',1),
	 ('BBA8105','1 DEDIKASI','1 DEDIKASI',1),
	 ('BBA8105','1 EFEKTIF','1 EFEKTIF',1),
	 ('BBA8105','1 FITRAH','1 FITRAH',1),
	 ('BBA8105','1 GIGIH','1 GIGIH',1),
	 ('BBA8105','1 HORMAT','1 HORMAT',1),
	 ('BBA8105','1 IKHLAS','1 IKHLAS',1),
	 ('BBA8105','1 JUJUR','1 JUJUR',1),
	 ('BBA8105','2 AMANAH','2 AMANAH',1),
	 ('BBA8105','2 BERSIH','2 BERSIH',1),
	 ('BBA8105','2 CERGAS','2 CERGAS',1),
	 ('BBA8105','2 DEDIKASI','2 DEDIKASI',1),
	 ('BBA8105','2 EFEKTIF','2 EFEKTIF',1),
	 ('BBA8105','2 FITRAH','2 FITRAH',1),
	 ('BBA8105','2 GIGIH','2 GIGIH',1),
	 ('BBA8105','2 HORMAT','2 HORMAT',1),
	 ('BBA8105','2 IKHLAS','2 IKHLAS',1),
	 ('BBA8105','3 AMANAH','3 AMANAH',1),
	 ('BBA8105','3 BERSIH','3 BERSIH',1),
	 ('BBA8105','3 CERGAS','3 CERGAS',1),
	 ('BBA8105','3 HORMAT','3 HORMAT',1),
	 ('BBA8105','3 IKHLAS','3 IKHLAS',1),
	 ('BBA8105','3 JUJUR','3 JUJUR',1),
	 ('BBA8105','3 PINTAR','3 PINTAR',1),
	 ('BBA8105','3 TEKUN','3 TEKUN',1),
	 ('BBA8105','4 AMANAH','4 AMANAH',1),
	 ('BBA8105','4 BERSIH','4 BERSIH',1),
	 ('BBA8105','4 CERGAS','4 CERGAS',1),
	 ('BBA8105','4 HORMAT','4 HORMAT',1),
	 ('BBA8105','4 IKHLAS','4 IKHLAS',1),
	 ('BBA8105','4 JUJUR','4 JUJUR',1),
	 ('BBA8105','4 PINTAR','4 PINTAR',1),
	 ('BBA8105','4 RASIONAL','4 RASIONAL',1),
	 ('BBA8105','4 TEKUN','4 TEKUN',1),
	 ('BBA8105','5 AMANAH','5 AMANAH',1),
	 ('BBA8105','5 BERSIH','5 BERSIH',1),
	 ('BBA8105','5 CERGAS','5 CERGAS',1),
	 ('BBA8105','5 HORMAT','5 HORMAT',1),
	 ('BBA8105','5 IKHLAS','5 IKHLAS',1),
	 ('BBA8105','5 JUJUR','5 JUJUR',1),
	 ('BBA8105','5 PINTAR','5 PINTAR',1),
	 ('BBA8105','6 AMANAH','6 AMANAH',1),
	 ('BBA8105','6 BERSIH','6 BERSIH',1),
	 ('BBA8105','6 CERGAS','6 CERGAS',1),
	 ('BBA8105','6 HORMAT','6 HORMAT',1),
	 ('BBA8105','6 IKHLAS','6 IKHLAS',1),
	 ('BBA8105','6 JUJUR','6 JUJUR',1),
	 ('BBA8105','6 TEKUN','6 TEKUN',1),
	 ('BBA8105','5 TEKUN','5 TEKUN',1),
	 ('BBA8105','3 FITRAH','3 FITRAH',1),
	 ('BBA8250','1 BIDARA','1 BIDARA',1),
	 ('BBA8250','1 CAMAR','1 CAMAR',1),
	 ('BBA8250','1 CECAWI','1 CECAWI',1),
	 ('BBA8250','1 KENYALANG','1 KENYALANG',1),
	 ('BBA8250','1 MERBAH','1 MERBAH',1),
	 ('BBA8250','1 NURI','1 NURI',1),
	 ('BBA8250','1 PEKAKA','1 PEKAKA',1),
	 ('BBA8250','2 BIDARA','2 BIDARA',1),
	 ('BBA8250','2 CAMAR','2 CAMAR',1),
	 ('BBA8250','2 CECAWI','2 CECAWI',1),
	 ('BBA8250','2 KENYALANG','2 KENYALANG',1),
	 ('BBA8250','2 MERBAH','2 MERBAH',1),
	 ('BBA8250','2 NURI','2 NURI',1),
	 ('BBA8250','2 PEKAKA','2 PEKAKA',1),
	 ('BBA8250','3 BIDARA','3 BIDARA',1),
	 ('BBA8250','3 CAMAR','3 CAMAR',1),
	 ('BBA8250','3 CECAWI','3 CECAWI',1),
	 ('BBA8250','3 KENYALANG','3 KENYALANG',1),
	 ('BBA8250','3 MERBAH','3 MERBAH',1),
	 ('BBA8250','3 NURI','3 NURI',1),
	 ('BBA8250','3 PEKAKA','3 PEKAKA',1),
	 ('BBA8250','3 TEKNOLOGI','3 TEKNOLOGI',1),
	 ('BBA8250','4 BIDARA','4 BIDARA',1),
	 ('BBA8250','4 CAMAR','4 CAMAR',1),
	 ('BBA8250','4 CECAWI','4 CECAWI',1),
	 ('BBA8250','4 KENYALANG','4 KENYALANG',1),
	 ('BBA8250','4 MERBAH','4 MERBAH',1),
	 ('BBA8250','4 NURI','4 NURI',1),
	 ('BBA8250','4 PEKAKA','4 PEKAKA',1),
	 ('BBA8250','5 BIDARA','5 BIDARA',1),
	 ('BBA8250','5 CAMAR','5 CAMAR',1),
	 ('BBA8250','5 CECAWI','5 CECAWI',1),
	 ('BBA8250','5 KENYALANG','5 KENYALANG',1),
	 ('BBA8250','5 MERBAH','5 MERBAH',1),
	 ('BBA8250','5 NURI','5 NURI',1),
	 ('BBA8250','5 PEKAKA','5 PEKAKA',1),
	 ('BBA8250','6 BIDARA','6 BIDARA',1),
	 ('BBA8250','6 CAMAR','6 CAMAR',1),
	 ('BBA8250','6 CECAWI','6 CECAWI',1),
	 ('BBA8250','6 KENYALANG','6 KENYALANG',1),
	 ('BBA8250','6 MERBAH','6 MERBAH',1),
	 ('BBA8250','6 NURI','6 NURI',1),
	 ('BBA8284','1 AMANAH','1 AMANAH',1),
	 ('BBA8284','1 DEDIKASI','1 DEDIKASI',1),
	 ('BBA8284','1 EFEKTIF','1 EFEKTIF',1),
	 ('BBA8284','1 INOVATIF','1 INOVATIF',1),
	 ('BBA8284','1 INTELEK','1 INTELEK',1),
	 ('BBA8284','1 MATRIKS','1 MATRIKS',1),
	 ('BBA8284','1 NILAM','1 NILAM',1),
	 ('BBA8284','1 SUKSES','1 SUKSES',1),
	 ('BBA8284','1 USAHA','1 USAHA',1),
	 ('BBA8284','2 AMANAH','2 AMANAH',1),
	 ('BBA8284','2 DEDIKASI','2 DEDIKASI',1),
	 ('BBA8284','2 EFEKTIF','2 EFEKTIF',1),
	 ('BBA8284','2 INOVATIF','2 INOVATIF',1),
	 ('BBA8284','2 INTELEK','2 INTELEK',1),
	 ('BBA8284','2 MAJU','2 MAJU',1),
	 ('BBA8284','2 MATRIKS','2 MATRIKS',1),
	 ('BBA8284','2 NILAM','2 NILAM',1),
	 ('BBA8284','2 SUKSES','2 SUKSES',1),
	 ('BBA8284','2 USAHA','2 USAHA',1),
	 ('BBA8284','3 AMANAH','3 AMANAH',1),
	 ('BBA8284','3 DEDIKASI','3 DEDIKASI',1),
	 ('BBA8284','3 EFEKTIF','3 EFEKTIF',1),
	 ('BBA8284','3 INOVATIF','3 INOVATIF',1),
	 ('BBA8284','3 INTELEK','3 INTELEK',1),
	 ('BBA8284','3 MAJU','3 MAJU',1),
	 ('BBA8284','3 MATRIKS','3 MATRIKS',1),
	 ('BBA8284','3 NILAM','3 NILAM',1),
	 ('BBA8284','3 SUKSES','3 SUKSES',1),
	 ('BBA8284','3 USAHA','3 USAHA',1),
	 ('BBA8284','4 AMANAH','4 AMANAH',1),
	 ('BBA8284','4 DEDIKASI','4 DEDIKASI',1),
	 ('BBA8284','4 EFEKTIF','4 EFEKTIF',1),
	 ('BBA8284','4 INOVATIF','4 INOVATIF',1),
	 ('BBA8284','4 INTELEK','4 INTELEK',1),
	 ('BBA8284','4 MAJU','4 MAJU',1),
	 ('BBA8284','4 MATRIKS','4 MATRIKS',1),
	 ('BBA8284','4 NILAM','4 NILAM',1),
	 ('BBA8284','4 SUKSES','4 SUKSES',1),
	 ('BBA8284','4 USAHA','4 USAHA',1),
	 ('BBA8284','5 AMANAH','5 AMANAH',1),
	 ('BBA8284','5 DEDIKASI','5 DEDIKASI',1),
	 ('BBA8284','5 EFEKTIF','5 EFEKTIF',1),
	 ('BBA8284','5 INOVATIF','5 INOVATIF',1),
	 ('BBA8284','5 INTELEK','5 INTELEK',1),
	 ('BBA8284','5 MAJU','5 MAJU',1),
	 ('BBA8284','5 MATRIKS','5 MATRIKS',1),
	 ('BBA8284','5 NILAM','5 NILAM',1),
	 ('BBA8284','5 SUKSES','5 SUKSES',1),
	 ('BBA8284','5 USAHA','5 USAHA',1),
	 ('BBA8284','6 DEDIKASI','6 DEDIKASI',1),
	 ('BBA8284','6 MAJU','6 MAJU',1),
	 ('BBA8284','6 SUKSES','6 SUKSES',1),
	 ('BBA8284','6 NILAM','6 NILAM',1),
	 ('BBA8284','6 USAHA','6 USAHA',1),
	 ('BBA8284','1 MAJU','1 MAJU',1),
	 ('BBA8284','1 SUNFLOWER','1 SUNFLOWER',1),
	 ('BBA8284','2 IRIS','2 IRIS',1),
	 ('BBA8284','3 ORCHID','3 ORCHID',1),
	 ('BBA8284','4 TULIP','4 TULIP',1),
	 ('BBA8284','5 ROSE','5 ROSE',1),
	 ('BBA8284','6 DAISY','6 DAISY',1),
	 ('BBA8284','6 INOVATIF','6 INOVATIF',1),
	 ('BBA8284','6 INTELEK','6 INTELEK',1),
	 ('BBA8284','6 EFEKTIF','6 EFEKTIF',1),
	 ('BBA8284','6 PKB TULIP','6 PKB TULIP',1),
	 ('BBA8284','4 PKB DAISY','4 PKB DAISY',1),
	 ('BBA8284','2 PKB JASMINE','2 PKB JASMINE',1),
	 ('BBA8284','5 PKB ROSE','5 PKB ROSE',1),
	 ('BBA8284','2 PKB LILY','2 PKB LILY',1),
	 ('BBA8284','6 AMANAH','6 AMANAH',1),
	 ('BBA8284','3 PKB IRIS','3 PKB IRIS',1),
	 ('BBA8284','3 PKB ORCHID','3 PKB ORCHID',1),
	 ('BBA8284','6 MATRIKS','6 MATRIKS',1),
	 ('BEA0093','1 AMAL','1 AMAL',1),
	 ('BEA0093','1 BUDI','1 BUDI',1),
	 ('BEA0093','1 GIGIH','1 GIGIH',1),
	 ('BEA0093','1 ILMU','1 ILMU',1),
	 ('BEA0093','1 MAJU','1 MAJU',1),
	 ('BEA0093','1 SETIA','1 SETIA',1),
	 ('BEA0093','1 USAHA','1 USAHA',1),
	 ('BEA0093','1 YAKIN','1 YAKIN',1),
	 ('BEA0093','2 AMAL','2 AMAL',1),
	 ('BEA0093','2 BUDI','2 BUDI',1),
	 ('BEA0093','2 GIGIH','2 GIGIH',1),
	 ('BEA0093','2 ILMU','2 ILMU',1),
	 ('BEA0093','2 MAJU','2 MAJU',1),
	 ('BEA0093','2 SETIA','2 SETIA',1),
	 ('BEA0093','2 USAHA','2 USAHA',1),
	 ('BEA0093','2 YAKIN','2 YAKIN',1),
	 ('BEA0093','3 AMAL','3 AMAL',1),
	 ('BEA0093','3 YAKIN','3 YAKIN',1),
	 ('BEA0093','3 USAHA','3 USAHA',1),
	 ('BEA0093','3 MAJU','3 MAJU',1),
	 ('BEA0093','3 SETIA','3 SETIA',1),
	 ('BEA0093','3 GIGIH','3 GIGIH',1),
	 ('BEA0093','3 ILMU','3 ILMU',1),
	 ('BEA0093','3 BUDI','3 BUDI',1),
	 ('BEA0093','4S4','4S4',1),
	 ('BEA0093','4AS','4AS',1),
	 ('BEA0093','4S1','4S1',1),
	 ('BEA0093','4S2','4S2',1),
	 ('BEA0093','4S3','4S3',1),
	 ('BEA0093','4AK1','4AK1',1),
	 ('BEA0093','4AK2','4AK2',1),
	 ('BEA0093','4BZ','4BZ',1),
	 ('BEA0093','4PSV1','4PSV1',1),
	 ('BEA0093','4PSV2','4PSV2',1),
	 ('BEA0093','5AS1','5AS1',1),
	 ('BEA0093','5S1','5S1',1),
	 ('BEA0093','5S2','5S2',1),
	 ('BEA0093','5S3','5S3',1),
	 ('BEA0093','5S4','5S4',1),
	 ('BEA0093','5AK1','5AK1',1),
	 ('BEA0093','5AK2','5AK2',1),
	 ('BEA0093','5BZ','5BZ',1),
	 ('BEA0093','5BZ2','5BZ2',1),
	 ('BEA0093','5PSV1','5PSV1',1),
	 ('BEA0093','5PSV2','5PSV2',1),
	 ('BEA0105','4 IBNU RUSHD','4 IBNU RUSHD',1),
	 ('BEA0105','4 SAINS','4 SAINS',1),
	 ('BEA0105','4 PRINSIP AKAUN','4 PRINSIP AKAUN',1),
	 ('BEA0105','4 PERTANIAN 1','4 PERTANIAN 1',1),
	 ('BEA0105','4 PERTANIAN 2','4 PERTANIAN 2',1),
	 ('BEA0105','4 SRT1','4 SRT1',1),
	 ('BEA0105','4 SRT2','4 SRT2',1),
	 ('BEA0105','4 EKONOMI','4 EKONOMI',1),
	 ('BEA0105','4 IBNU NAFIS','4 IBNU NAFIS',1),
	 ('BEA0105','4 SASTERA','4 SASTERA',1),
	 ('BEA0105','4 PERNIAGAAN 1','4 PERNIAGAAN 1',1),
	 ('BEA0105','4 PERNIAGAAN 2','4 PERNIAGAAN 2',1),
	 ('BEA0105','4 PERNIAGAAN 3','4 PERNIAGAAN 3',1),
	 ('BEA0105','4 SV1','4 SV1',1),
	 ('BEA0105','4 SV2','4 SV2',1),
	 ('BEA0105','4 SV3','4 SV3',1),
	 ('BEA0105','4 SV4','4 SV4',1),
	 ('BEA0105','4 AKUAKULTUR','4 AKUAKULTUR',1),
	 ('BEA0105','5 IBNU RUSHD','5 IBNU RUSHD',1),
	 ('BEA0105','5 SAINS','5 SAINS',1),
	 ('BEA0105','5 PRINSIP AKAUN','5 PRINSIP AKAUN',1),
	 ('BEA0105','5 PERTANIAN 1','5 PERTANIAN 1',1),
	 ('BEA0105','5 PERTANIAN 2','5 PERTANIAN 2',1),
	 ('BEA0105','5 SRT1','5 SRT1',1),
	 ('BEA0105','5 SRT2','5 SRT2',1),
	 ('BEA0105','5 EKONOMI','5 EKONOMI',1),
	 ('BEA0105','5 IBNU NAFIS','5 IBNU NAFIS',1),
	 ('BEA0105','5 SASTERA','5 SASTERA',1),
	 ('BEA0105','5 PERNIAGAAN 1','5 PERNIAGAAN 1',1),
	 ('BEA0105','5 PERNIAGAAN 2','5 PERNIAGAAN 2',1),
	 ('BEA0105','5 PERNIAGAAN 3','5 PERNIAGAAN 3',1),
	 ('BEA0105','5 SV1','5 SV1',1),
	 ('BEA0105','5 SV2','5 SV2',1),
	 ('BEA0105','5 SV3','5 SV3',1),
	 ('BEA0105','5 SV4','5 SV4',1),
	 ('BEA0105','5 AKUAKULTUR','5 AKUAKULTUR',1),
	 ('BEA0105','1 AL FARABI','1 AL FARABI',1),
	 ('BEA0105','1 AL KINDI','1 AL KINDI',1),
	 ('BEA0105','1 AL RAZI','1 AL RAZI',1),
	 ('BEA0105','1 ARIF','1 ARIF',1),
	 ('BEA0105','1 BESTARI','1 BESTARI',1),
	 ('BEA0105','1 CERDAS','1 CERDAS',1),
	 ('BEA0105','1 DEDIKASI','1 DEDIKASI',1),
	 ('BEA0105','1 EFISIEN','1 EFISIEN',1),
	 ('BEA0105','1 FOKUS','1 FOKUS',1),
	 ('BEA0105','1 GIGIH','1 GIGIH',1),
	 ('BEA0105','1 HARMONI','1 HARMONI',1),
	 ('BEA0105','1 ILTIZAM','1 ILTIZAM',1),
	 ('BEA0105','1 JUJUR','1 JUJUR',1),
	 ('BEA0105','1 KARISMA','1 KARISMA',1),
	 ('BEA0105','1 LUHUR','1 LUHUR',1),
	 ('BEA0105','1 MURNI','1 MURNI',1),
	 ('BEA0105','1 NUR','1 NUR',1),
	 ('BEA0105','2 AL FARABI','2 AL FARABI',1),
	 ('BEA0105','2 AL KINDI','2 AL KINDI',1),
	 ('BEA0105','2 AL RAZI','2 AL RAZI',1),
	 ('BEA0105','2 ARIF','2 ARIF',1),
	 ('BEA0105','2 BESTARI','2 BESTARI',1),
	 ('BEA0105','2 CERDAS','2 CERDAS',1),
	 ('BEA0105','2 DEDIKASI','2 DEDIKASI',1),
	 ('BEA0105','2 EFISIEN','2 EFISIEN',1),
	 ('BEA0105','2 FOKUS','2 FOKUS',1),
	 ('BEA0105','2 GIGIH','2 GIGIH',1),
	 ('BEA0105','2 HARMONI','2 HARMONI',1),
	 ('BEA0105','2 ILTIZAM','2 ILTIZAM',1),
	 ('BEA0105','2 JUJUR','2 JUJUR',1),
	 ('BEA0105','2 KARISMA','2 KARISMA',1),
	 ('BEA0105','2 LUHUR','2 LUHUR',1),
	 ('BEA0105','2 MURNI','2 MURNI',1),
	 ('BEA0105','2 NUR','2 NUR',1),
	 ('BEA0105','3 AL FARABI','3 AL FARABI',1),
	 ('BEA0105','3 AL KINDI','3 AL KINDI',1),
	 ('BEA0105','3 AL RAZI','3 AL RAZI',1),
	 ('BEA0105','3 ARIF','3 ARIF',1),
	 ('BEA0105','3 BESTARI','3 BESTARI',1),
	 ('BEA0105','3 CERDAS','3 CERDAS',1),
	 ('BEA0105','3 DEDIKASI','3 DEDIKASI',1),
	 ('BEA0105','3 EFISIEN','3 EFISIEN',1),
	 ('BEA0105','3 FOKUS','3 FOKUS',1),
	 ('BEA0105','3 GIGIH','3 GIGIH',1),
	 ('BEA0105','3 HARMONI','3 HARMONI',1),
	 ('BEA0105','3 ILTIZAM','3 ILTIZAM',1),
	 ('BEA0105','3 JUJUR','3 JUJUR',1),
	 ('BEA0105','3 KARISMA','3 KARISMA',1),
	 ('BEA0105','3 LUHUR','3 LUHUR',1),
	 ('BEA0105','3 MURNI','3 MURNI',1),
	 ('BEA0105','3 NUR','3 NUR',1),
	 ('BEA0114','1 A','1 A',1),
	 ('BEA0114','1 B','1 B',1),
	 ('BEA0114','1 C','1 C',1),
	 ('BEA0114','1 D','1 D',1),
	 ('BEA0114','1 E','1 E',1),
	 ('BEA0114','1 F','1 F',1),
	 ('BEA0114','1 G','1 G',1),
	 ('BEA0114','2 A','2 A',1),
	 ('BEA0114','2 B','2 B',1),
	 ('BEA0114','2 C','2 C',1),
	 ('BEA0114','2 D','2 D',1),
	 ('BEA0114','2 E','2 E',1),
	 ('BEA0114','2 F','2 F',1),
	 ('BEA0114','2 G','2 G',1),
	 ('BEA0114','3 A','3 A',1),
	 ('BEA0114','3 B','3 B',1),
	 ('BEA0114','3 C','3 C',1),
	 ('BEA0114','3 D','3 D',1),
	 ('BEA0114','3 E','3 E',1),
	 ('BEA0114','3 F','3 F',1),
	 ('BEA0114','3 G','3 G',1),
	 ('BEA0114','4 A','4 A',1),
	 ('BEA0114','4 B','4 B',1),
	 ('BEA0114','4 C','4 C',1),
	 ('BEA0114','4 D','4 D',1),
	 ('BEA0114','4 E','4 E',1),
	 ('BEA0114','4 F','4 F',1),
	 ('BEA0114','4 G','4 G',1),
	 ('BEA0114','5 A','5 A',1),
	 ('BEA0114','5 B','5 B',1),
	 ('BEA0114','5 C','5 C',1),
	 ('BEA0114','5 D','5 D',1),
	 ('BEA0114','5 E','5 E',1),
	 ('BEA0114','5 F','5 F',1),
	 ('BEA0114','2 KS(AU) LESTARI','2 KS(AU) Lestari',1),
	 ('BEA0114','3 KS(AU) LESTARI','3 KS(AU) Lestari',1),
	 ('BEA0114','5 G','5 G',1),
	 ('BEA0114','KR (PPK) LESTARI','KR (PPK) Lestari',1),
	 ('BEA8608','1 ANGSANA','1 ANGSANA',1),
	 ('BEA8608','1 BALAU','1 BALAU',1),
	 ('BEA8608','1 BATAI','1 BATAI',1),
	 ('BEA8608','1 BELIAN','1 BELIAN',1),
	 ('BEA8608','1 CENGAL','1 CENGAL',1),
	 ('BEA8608','1 JATI','1 JATI',1),
	 ('BEA8608','2 ANGSANA','2 ANGSANA',1),
	 ('BEA8608','2 BALAU','2 BALAU',1),
	 ('BEA8608','2 BATAI','2 BATAI',1),
	 ('BEA8608','2 BELIAN','2 BELIAN',1),
	 ('BEA8608','2 CENGAL','2 CENGAL',1),
	 ('BEA8608','2 JATI','2 JATI',1),
	 ('BEA8608','3 ANGSANA','3 ANGSANA',1),
	 ('BEA8608','3 BALAU','3 BALAU',1),
	 ('BEA8608','3 BATAI','3 BATAI',1),
	 ('BEA8608','3 BELIAN','3 BELIAN',1),
	 ('BEA8608','3 CENGAL','3 CENGAL',1),
	 ('BEA8608','3 JATI','3 JATI',1),
	 ('BEA8608','4 ANGSANA','4 ANGSANA',1),
	 ('BEA8608','4 BALAU','4 BALAU',1),
	 ('BEA8608','4 BATAI','4 BATAI',1),
	 ('BEA8608','4 BELIAN','4 BELIAN',1),
	 ('BEA8608','4 CENGAL','4 CENGAL',1),
	 ('BEA8608','4 JATI','4 JATI',1),
	 ('BEA8608','5 ANGSANA','5 ANGSANA',1),
	 ('BEA8608','5 BALAU','5 BALAU',1),
	 ('BEA8608','5 BATAI','5 BATAI',1),
	 ('BEA8608','5 BELIAN','5 BELIAN',1),
	 ('BEA8608','5 CENGAL','5 CENGAL',1),
	 ('BEA8608','5 JATI','5 JATI',1),
	 ('BEA8608','1 KERUING','1 KERUING',1),
	 ('BEA8608','2 KERUING','2 KERUING',1),
	 ('BEA8617','1 ABU BAKAR AS-SIDDIQ','1 ABU BAKAR AS-SIDDIQ',1),
	 ('BEA8617','1 ALI B. ABI TALIB','1 ALI B. ABI TALIB',1),
	 ('BEA8617','1 ANAS B.MALIK','1 ANAS B.MALIK',1),
	 ('BEA8617','1 BILAL B.RABAH','1 BILAL B.RABAH',1),
	 ('BEA8617','1 HAMZAH B.ABD.MUTALLIB','1 HAMZAH B.ABD.MUTALLIB',1),
	 ('BEA8617','1 UMAR AL-KHATTAB','1 UMAR AL-KHATTAB',1),
	 ('BEA8617','1 UTHMAN B.AFFAN','1 UTHMAN B.AFFAN',1),
	 ('BEA8617','2 ABU BAKAR AS-SIDDIQ','2 ABU BAKAR AS-SIDDIQ',1),
	 ('BEA8617','2 ALI B. ABI TALIB','2 ALI B. ABI TALIB',1),
	 ('BEA8617','2 ANAS B.MALIK','2 ANAS B.MALIK',1),
	 ('BEA8617','2 BILAL B.RABAH','2 BILAL B.RABAH',1),
	 ('BEA8617','2 HAMZAH B.ABD.MUTALLIB','2 HAMZAH B.ABD.MUTALLIB',1),
	 ('BEA8617','2 UMAR AL-KHATTAB','2 UMAR AL-KHATTAB',1),
	 ('BEA8617','2 UTHMAN B.AFFAN','2 UTHMAN B.AFFAN',1),
	 ('BEA8617','3 ABU BAKAR AS-SIDDIQ','3 ABU BAKAR AS-SIDDIQ',1),
	 ('BEA8617','3 ALI B. ABI TALIB','3 ALI B. ABI TALIB',1),
	 ('BEA8617','3 ANAS B.MALIK','3 ANAS B.MALIK',1),
	 ('BEA8617','3 BILAL B.RABAH','3 BILAL B.RABAH',1),
	 ('BEA8617','3 HAMZAH B.ABD.MUTALLIB','3 HAMZAH B.ABD.MUTALLIB',1),
	 ('BEA8617','3 UMAR AL-KHATTAB','3 UMAR AL-KHATTAB',1),
	 ('BEA8617','3 UTHMAN B.AFFAN','3 UTHMAN B.AFFAN',1),
	 ('BEA8617','4 ABU BAKAR AS-SIDDIQ','4 ABU BAKAR AS-SIDDIQ',1),
	 ('BEA8617','4 ALI B. ABI TALIB','4 ALI B. ABI TALIB',1),
	 ('BEA8617','4 ANAS B.MALIK','4 ANAS B.MALIK',1),
	 ('BEA8617','4 BILAL B.RABAH','4 BILAL B.RABAH',1),
	 ('BEA8617','4 HAMZAH B.ABD.MUTALLIB','4 HAMZAH B.ABD.MUTALLIB',1),
	 ('BEA8617','4 SALMAN_AL-FARISI','4 SALMAN_AL-FARISI',1),
	 ('BEA8617','4 UMAR AL-KHATTAB','4 UMAR AL-KHATTAB',1),
	 ('BEA8617','4 UTHMAN B.AFFAN','4 UTHMAN B.AFFAN',1),
	 ('BEA8617','5 ABU BAKAR AS-SIDDIQ','5 ABU BAKAR AS-SIDDIQ',1),
	 ('BEA8617','5 ALI B. ABI TALIB','5 ALI B. ABI TALIB',1),
	 ('BEA8617','5 ANAS B.MALIK','5 ANAS B.MALIK',1),
	 ('BEA8617','5 BILAL B.RABAH','5 BILAL B.RABAH',1),
	 ('BEA8617','5 HAMZAH B.ABD.MUTALLIB','5 HAMZAH B.ABD.MUTALLIB',1),
	 ('BEA8617','5 SAAD B.ABI_WAQAS','5 SAAD B.ABI_WAQAS',1),
	 ('BEA8617','5 SALMAN AL-FARISI','5 SALMAN AL-FARISI',1),
	 ('BEA8617','5 UMAR AL-KHATTAB','5 UMAR AL-KHATTAB',1),
	 ('BEA8617','5 UTHMAN B.AFFAN','5 UTHMAN B.AFFAN',1),
	 ('BEA8639','1 ALFA','1 ALFA',1),
	 ('BEA8639','1 BETA','1 BETA',1),
	 ('BEA8639','1 DELTA','1 DELTA',1),
	 ('BEA8639','1 EPSILON','1 EPSILON',1),
	 ('BEA8639','1 GAMMA','1 GAMMA',1),
	 ('BEA8639','1 LAMBDA','1 LAMBDA',1),
	 ('BEA8639','2 ALFA','2 ALFA',1),
	 ('BEA8639','2 BETA','2 BETA',1),
	 ('BEA8639','2 DELTA','2 DELTA',1),
	 ('BEA8639','2 EPSILON','2 EPSILON',1),
	 ('BEA8639','2 GAMMA','2 GAMMA',1),
	 ('BEA8639','2 LAMBDA','2 LAMBDA',1),
	 ('BEA8639','3 ALFA','3 ALFA',1),
	 ('BEA8639','3 BETA','3 BETA',1),
	 ('BEA8639','3 DELTA','3 DELTA',1),
	 ('BEA8639','3 EPSILON','3 EPSILON',1),
	 ('BEA8639','3 GAMMA','3 GAMMA',1),
	 ('BEA8639','3 LAMBDA','3 LAMBDA',1),
	 ('BEA8639','4 ALFA','4 ALFA',1),
	 ('BEA8639','4 BETA','4 BETA',1),
	 ('BEA8639','4 DELTA','4 DELTA',1),
	 ('BEA8639','4 EPSILON','4 EPSILON',1),
	 ('BEA8639','4 GAMMA','4 GAMMA',1),
	 ('BEA8639','4 KAPPA','4 KAPPA',1),
	 ('BEA8639','5 ALFA','5 ALFA',1),
	 ('BEA8639','5 BETA','5 BETA',1),
	 ('BEA8639','5 DELTA','5 DELTA',1),
	 ('BEA8639','5 EPSILON','5 EPSILON',1),
	 ('BEA8639','5 GAMMA','5 GAMMA',1),
	 ('BEA8639','5 KAPPA','5 KAPPA',1),
	 ('WBA2001','1 ADIL','1 ADIL',1),
	 ('WBA2001','1 BESTARI','1 BESTARI',1),
	 ('WBA2001','1 CEKAL','1 CEKAL',1),
	 ('WBA2001','1 DEDIKASI','1 DEDIKASI',1),
	 ('WBA2001','1 INTELEK','1 INTELEK',1),
	 ('WBA2001','2 ADIL','2 ADIL',1),
	 ('WBA2001','2 BESTARI','2 BESTARI',1),
	 ('WBA2001','2 CEKAL','2 CEKAL',1),
	 ('WBA2001','2 DEDIKASI','2 DEDIKASI',1),
	 ('WBA2001','2 INTELEK','2 INTELEK',1),
	 ('WBA2001','3 ADIL','3 ADIL',1),
	 ('WBA2001','3 BESTARI','3 BESTARI',1),
	 ('WBA2001','3 CEKAL','3 CEKAL',1),
	 ('WBA2001','3 DEDIKASI','3 DEDIKASI',1),
	 ('WBA2001','3 INTELEK','3 INTELEK',1),
	 ('WBA2001','3 PINTAR','3 PINTAR',1),
	 ('WBA2001','3 RAJIN','3 RAJIN',1),
	 ('WBA2001','4 ADIL','4 ADIL',1),
	 ('WBA2001','4 BESTARI','4 BESTARI',1),
	 ('WBA2001','4 CEKAL','4 CEKAL',1),
	 ('WBA2001','4 DEDIKASI','4 DEDIKASI',1),
	 ('WBA2001','4 INTELEK','4 INTELEK',1),
	 ('WBA2001','4 PINTAR','4 PINTAR',1),
	 ('WBA2001','4 RAJIN','4 RAJIN',1),
	 ('WBA2001','5 ADIL','5 ADIL',1),
	 ('WBA2001','5 BESTARI','5 BESTARI',1),
	 ('WBA2001','5 CEKAL','5 CEKAL',1),
	 ('WBA2001','5 DEDIKASI','5 DEDIKASI',1),
	 ('WBA2001','5 INTELEK','5 INTELEK',1),
	 ('WBA2001','5 PINTAR','5 PINTAR',1),
	 ('WBA2001','5 RAJIN','5 RAJIN',1),
	 ('WBA2001','6 BESTARI','6 BESTARI',1),
	 ('WBA2001','6 CEKAL','6 CEKAL',1),
	 ('WBA2001','6 PINTAR','6 PINTAR',1),
	 ('WBA2001','6 RAJIN','6 RAJIN',1),
	 ('WBA2001','6 DEDIKASI','6 DEDIKASI',1),
	 ('WBA2001','6 INTELEK','6 INTELEK',1),
	 ('WBA2001','6 ADIL','6 ADIL',1),
	 ('WBA2002','1 EARTH','1 EARTH',1),
	 ('WBA2002','1 NEPTUNE','1 NEPTUNE',1),
	 ('WBA2002','1 MERCURY','1 MERCURY',1),
	 ('WBA2002','1 JUPITER','1 JUPITER',1),
	 ('WBA2002','1 MARS','1 MARS',1),
	 ('WBA2002','2 EARTH','2 EARTH',1),
	 ('WBA2002','2 NEPTUNE','2 NEPTUNE',1),
	 ('WBA2002','2 MERCURY','2 MERCURY',1),
	 ('WBA2002','2 JUPITER','2 JUPITER',1),
	 ('WBA2002','2 MARS','2 MARS',1),
	 ('WBA2002','3 EARTH','3 EARTH',1),
	 ('WBA2002','3 NEPTUNE','3 NEPTUNE',1),
	 ('WBA2002','3 MERCURY','3 MERCURY',1),
	 ('WBA2002','3 JUPITER','3 JUPITER',1),
	 ('WBA2002','3 MARS','3 MARS',1),
	 ('WBA2002','3 VENUS','3 VENUS',1),
	 ('WBA2002','4 EARTH','4 EARTH',1),
	 ('WBA2002','4 NEPTUNE','4 NEPTUNE',1),
	 ('WBA2002','4 MERCURY','4 MERCURY',1),
	 ('WBA2002','4 JUPITER','4 JUPITER',1),
	 ('WBA2002','4 MARS','4 MARS',1),
	 ('WBA2002','5 EARTH','5 EARTH',1),
	 ('WBA2002','5 NEPTUNE','5 NEPTUNE',1),
	 ('WBA2002','5 MERCURY','5 MERCURY',1),
	 ('WBA2002','5 JUPITER','5 JUPITER',1),
	 ('WBA2002','5 MARS','5 MARS',1),
	 ('WBA2002','5 VENUS','5 VENUS',1),
	 ('WBA2002','6 EARTH','6 EARTH',1),
	 ('WBA2002','6 NEPTUNE','6 NEPTUNE',1),
	 ('WBA2002','6 MERCURY','6 MERCURY',1),
	 ('WBA2002','6 JUPITER','6 JUPITER',1),
	 ('WBA2002','6 MARS','6 MARS',1),
	 ('WBA2002','6 VENUS','6 VENUS',1),
	 ('WBA2004','1 SIRIUS','1 SIRIUS',1),
	 ('WBA2004','1 RIGEL','1 RIGEL',1),
	 ('WBA2004','1 DENEB','1 DENEB',1),
	 ('WBA2004','1 VEGA','1 VEGA',1),
	 ('WBA2004','1 ANTARES','1 ANTARES',1),
	 ('WBA2004','2 SERI PERDANA','2 SERI PERDANA',1),
	 ('WBA2004','2 SERI BAKTI','2 SERI BAKTI',1),
	 ('WBA2004','2 SERI GEMILANG','2 SERI GEMILANG',1),
	 ('WBA2004','2 SERI WAWASAN','2 SERI WAWASAN',1),
	 ('WBA2004','2 SERI SAUJANA','2 SERI SAUJANA',1),
	 ('WBA2004','3 DAISY','3 DAISY',1),
	 ('WBA2004','3 ALAMANDA','3 ALAMANDA',1),
	 ('WBA2004','3 ORKID','3 ORKID',1),
	 ('WBA2004','3 CANNA','3 CANNA',1),
	 ('WBA2004','3 TULIP','3 TULIP',1),
	 ('WBA2004','3 IXORA','3 IXORA',1),
	 ('WBA2004','3 LAVENDER','3 LAVENDER',1),
	 ('WBA2004','4 DEBIAN','4 DEBIAN',1),
	 ('WBA2004','4 FEDORA','4 FEDORA',1),
	 ('WBA2004','4 CENTOS','4 CENTOS',1),
	 ('WBA2004','4 AMIGA','4 AMIGA',1),
	 ('WBA2004','4 LINUX','4 LINUX',1),
	 ('WBA2004','4 UNIX','4 UNIX',1),
	 ('WBA2004','4 SOLARIS','4 SOLARIS',1),
	 ('WBA2004','5 KINABALU','5 KINABALU',1),
	 ('WBA2004','5 BAYU','5 BAYU',1),
	 ('WBA2004','5 JERAI','5 JERAI',1),
	 ('WBA2004','5 RAYA','5 RAYA',1),
	 ('WBA2004','5 MULU','5 MULU',1),
	 ('WBA2004','5 LEDANG','5 LEDANG',1),
	 ('WBA2004','6 DELIMA','6 DELIMA',1),
	 ('WBA2004','6 KRISTAL','6 KRISTAL',1),
	 ('WBA2004','6 OPAL','6 OPAL',1),
	 ('WBA2004','6 ZAMRUD','6 ZAMRUD',1),
	 ('WBA2004','6 TOPAZ','6 TOPAZ',1),
	 ('WBA2012','1 UKM','1 UKM',1),
	 ('WBA2012','1 UIA','1 UIA',1),
	 ('WBA2012','1 UPM','1 UPM',1),
	 ('WBA2012','1 AZAM','1 AZAM',1),
	 ('WBA2012','2 UIA','2 UIA',1),
	 ('WBA2012','2 UKM','2 UKM',1),
	 ('WBA2012','2 USM','2 USM',1),
	 ('WBA2012','2 UPM','2 UPM',1),
	 ('WBA2012','3 BRILLIANT','3 BRILLIANT',1),
	 ('WBA2012','3 CREATIVE','3 CREATIVE',1),
	 ('WBA2012','3 DYNAMIC','3 DYNAMIC',1),
	 ('WBA2012','3 EXCELLENT','3 EXCELLENT',1),
	 ('WBA2012','4 UPM','4 UPM',1),
	 ('WBA2012','4 UKM','4 UKM',1),
	 ('WBA2012','4 UIA','4 UIA',1),
	 ('WBA2012','4 DYNAMIC','4 DYNAMIC',1),
	 ('WBA2012','5 UPM','5 UPM',1),
	 ('WBA2012','5 UKM','5 UKM',1),
	 ('WBA2012','5 USM','5 USM',1),
	 ('WBA2012','6 UKM','6 UKM',1),
	 ('WBA2012','6 UPM','6 UPM',1),
	 ('WBA2012','6 USM','6 USM',1),
	 ('WBA2012','6 UIA','6 UIA',1),
	 ('WBA2012','3 UKM','3 UKM',1),
	 ('WBA2012','3 USM','3 USM',1),
	 ('WBA2012','3 UPM','3 UPM',1),
	 ('WBA2012','3 UIA','3 UIA',1),
	 ('WBA2012','5 UTM','5 UTM',1),
	 ('WBA2012','5 UIA','5 UIA',1),
	 ('WBA2012','4 USM','4 USM',1),
	 ('WBA2012','1 USM','1 USM',1),
	 ('WBB0058','1 AMBER','1 AMBER',1),
	 ('WBB0058','1 OPAL','1 OPAL',1),
	 ('WBB0058','1 RUBY','1 RUBY',1),
	 ('WBB0058','1 TOPAZ','1 TOPAZ',1),
	 ('WBB0058','2 AMBER','2 AMBER',1),
	 ('WBB0058','2 OPAL','2 OPAL',1),
	 ('WBB0058','2 RUBY','2 RUBY',1),
	 ('WBB0058','2 TOPAZ','2 TOPAZ',1),
	 ('WBB0058','3 AMBER','3 AMBER',1),
	 ('WBB0058','3 OPAL','3 OPAL',1),
	 ('WBB0058','3 RUBY','3 RUBY',1),
	 ('WBB0058','3 TOPAZ','3 TOPAZ',1),
	 ('WBB0058','4 OPAL','4 OPAL',1),
	 ('WBB0058','4 RUBY','4 RUBY',1),
	 ('WBB0058','4 TOPAZ','4 TOPAZ',1),
	 ('WBB0058','5 OPAL','5 OPAL',1),
	 ('WBB0058','5 RUBY','5 RUBY',1),
	 ('WBB0058','5 TOPAZ','5 TOPAZ',1),
	 ('WBB0058','6 OPAL','6 OPAL',1),
	 ('WBB0058','6 TOPAZ','6 TOPAZ',1),
	 ('WBB0058','4 AMBER','4 AMBER',1),
	 ('WBB0083','SATU MARTIAL','SATU MARTIAL',1),
	 ('WBB0083','SATU HARPY','SATU HARPY',1),
	 ('WBB0083','SATU CROWNED','SATU CROWNED',1),
	 ('WBB0083','SATU TAWNY','SATU TAWNY',1),
	 ('WBB0083','DUA MARTIAL','DUA MARTIAL',1),
	 ('WBB0083','DUA HARPY','DUA HARPY',1),
	 ('WBB0083','DUA CROWNED','DUA CROWNED',1),
	 ('WBB0083','DUA TAWNY','DUA TAWNY',1),
	 ('WBB0083','TIGA MARTIAL','TIGA MARTIAL',1),
	 ('WBB0083','TIGA HARPY','TIGA HARPY',1),
	 ('WBB0083','TIGA CROWNED','TIGA CROWNED',1),
	 ('WBB0083','TIGA TAWNY','TIGA TAWNY',1),
	 ('WBB0083','EMPAT MARTIAL','EMPAT MARTIAL',1),
	 ('WBB0083','EMPAT HARPY','EMPAT HARPY',1),
	 ('WBB0083','EMPAT CROWNED','EMPAT CROWNED',1),
	 ('WBB0083','EMPAT TAWNY','EMPAT TAWNY',1),
	 ('WBB0083','LIMA MARTIAL','LIMA MARTIAL',1),
	 ('WBB0083','LIMA HARPY','LIMA HARPY',1),
	 ('WBB0083','LIMA CROWNED','LIMA CROWNED',1),
	 ('WBB0083','LIMA TAWNY','LIMA TAWNY',1),
	 ('WBB0083','ENAM MARTIAL','ENAM MARTIAL',1),
	 ('WBB0083','ENAM HARPY','ENAM HARPY',1),
	 ('WBB0083','ENAM CROWNED','ENAM CROWNED',1),
	 ('WBB0083','ENAM TAWNY','ENAM TAWNY',1),
	 ('WEA2001','1 PUTRA','1 PUTRA',1),
	 ('WEA2001','1 SIBER','1 SIBER',1),
	 ('WEA2001','1 INOVATIF','1 INOVATIF',1),
	 ('WEA2001','1 WIRA','1 WIRA',1),
	 ('WEA2001','1 BESTARI','1 BESTARI',1),
	 ('WEA2001','1 LESTARI','1 LESTARI',1),
	 ('WEA2001','1 DINAMIK','1 DINAMIK',1),
	 ('WEA2001','1 SATRIA','1 SATRIA',1),
	 ('WEA2001','1 PERDANA','1 PERDANA',1),
	 ('WEA2001','2 SIBER','2 SIBER',1),
	 ('WEA2001','2 PERDANA','2 PERDANA',1),
	 ('WEA2001','2 PUTRA','2 PUTRA',1),
	 ('WEA2001','2 SATRIA','2 SATRIA',1),
	 ('WEA2001','2 WIRA','2 WIRA',1),
	 ('WEA2001','2 BESTARI','2 BESTARI',1),
	 ('WEA2001','2 LESTARI','2 LESTARI',1),
	 ('WEA2001','3 SATRIA','3 SATRIA',1),
	 ('WEA2001','3 BESTARI','3 BESTARI',1),
	 ('WEA2001','3 WIRA','3 WIRA',1),
	 ('WEA2001','3 PERDANA','3 PERDANA',1),
	 ('WEA2001','3 PUTRA','3 PUTRA',1),
	 ('WEA2001','3 SIBER','3 SIBER',1),
	 ('WEA2001','3 LESTARI','3 LESTARI',1),
	 ('WEA2001','4 LESTARI','4 LESTARI',1),
	 ('WEA2001','4 PERDANA','4 PERDANA',1),
	 ('WEA2001','4 SATRIA','4 SATRIA',1),
	 ('WEA2001','4 PUTRA','4 PUTRA',1),
	 ('WEA2001','4 WIRA','4 WIRA',1),
	 ('WEA2001','4 BESTARI','4 BESTARI',1),
	 ('WEA2001','4 SIBER','4 SIBER',1),
	 ('WEA2001','5 BESTARI','5 BESTARI',1),
	 ('WEA2001','5 SATRIA','5 SATRIA',1),
	 ('WEA2001','5 LESTARI','5 LESTARI',1),
	 ('WEA2001','5 PERDANA','5 PERDANA',1),
	 ('WEA2001','5 PUTRA','5 PUTRA',1),
	 ('WEA2001','5 SIBER','5 SIBER',1),
	 ('WEA2001','5 WIRA','5 WIRA',1),
	 ('WEA2002','1 PUTRA ASPIRASI','1 PUTRA ASPIRASI',1),
	 ('WEA2002','1 PUTRA BESTARI','1 PUTRA BESTARI',1),
	 ('WEA2002','1 PUTRA CERGAS','1 PUTRA CERGAS',1),
	 ('WEA2002','1 PUTRA DEDIKASI','1 PUTRA DEDIKASI',1),
	 ('WEA2002','1 PUTRA EHSAN','1 PUTRA EHSAN',1),
	 ('WEA2002','1 PUTRA GEMILANG','1 PUTRA GEMILANG',1),
	 ('WEA2002','1 PUTRA HARAPAN','1 PUTRA HARAPAN',1),
	 ('WEA2002','1 PUTRA INTELEK','1 PUTRA INTELEK',1),
	 ('WEA2002','1 PUTRA KREATIF','1 PUTRA KREATIF',1),
	 ('WEA2002','1 PUTRA PERDANA','1 PUTRA PERDANA',1),
	 ('WEA2002','1 PUTRA SATRIA','1 PUTRA SATRIA',1),
	 ('WEA2002','1 PUTRA WAWASAN','1 PUTRA WAWASAN',1),
	 ('WEA2002','2 PUTRA ASPIRASI','2 PUTRA ASPIRASI',1),
	 ('WEA2002','2 PUTRA BESTARI','2 PUTRA BESTARI',1),
	 ('WEA2002','2 PUTRA DEDIKASI','2 PUTRA DEDIKASI',1),
	 ('WEA2002','2 PUTRA GEMILANG','2 PUTRA GEMILANG',1),
	 ('WEA2002','2 PUTRA INTELEK','2 PUTRA INTELEK',1),
	 ('WEA2002','2 PUTRA PERDANA','2 PUTRA PERDANA',1),
	 ('WEA2002','2 PUTRA SATRIA','2 PUTRA SATRIA',1),
	 ('WEA2002','2 PUTRA WAWASAN','2 PUTRA WAWASAN',1),
	 ('WEA2002','3 PUTRA BESTARI','3 PUTRA BESTARI',1),
	 ('WEA2002','3 PUTRA DEDIKASI','3 PUTRA DEDIKASI',1),
	 ('WEA2002','3 PUTRA GEMILANG','3 PUTRA GEMILANG',1),
	 ('WEA2002','3 PUTRA INTELEK','3 PUTRA INTELEK',1),
	 ('WEA2002','3 PUTRA PERDANA','3 PUTRA PERDANA',1),
	 ('WEA2002','3 PUTRA SATRIA','3 PUTRA SATRIA',1),
	 ('WEA2002','3 PUTRA WAWASAN','3 PUTRA WAWASAN',1),
	 ('WEA2002','4 PUTRA BESTARI','4 PUTRA BESTARI',1),
	 ('WEA2002','4 PUTRA GEMILANG','4 PUTRA GEMILANG',1),
	 ('WEA2002','4 PUTRA INTELEK','4 PUTRA INTELEK',1),
	 ('WEA2002','4 PUTRA PERDANA','4 PUTRA PERDANA',1),
	 ('WEA2002','4 PUTRA SATRIA','4 PUTRA SATRIA',1),
	 ('WEA2002','4 PUTRA WAWASAN','4 PUTRA WAWASAN',1),
	 ('WEA2002','5 PUTRA BESTARI','5 PUTRA BESTARI',1),
	 ('WEA2002','5 PUTRA GEMILANG','5 PUTRA GEMILANG',1),
	 ('WEA2002','5 PUTRA INTELEK','5 PUTRA INTELEK',1),
	 ('WEA2002','5 PUTRA PERDANA','5 PUTRA PERDANA',1),
	 ('WEA2002','5 PUTRA SATRIA','5 PUTRA SATRIA',1),
	 ('WEA2002','5 PUTRA WAWASAN','5 PUTRA WAWASAN',1);

-- Some data for relationship
INSERT INTO i3s_relationship (rel_code, descript, descript_bm) VALUES 
	('FATHER', 'Father', 'Bapa'),
	('MOTHER', 'Mother', 'Emak'),
	('CHILD', 'Child', 'Anak'),
	('Ward', 'Ward', 'Tanggungjawab'),
	('GUARDIAN', 'Guardian', 'Penjaga'),
	('SIBLING', 'Sibling', 'Adik beradik'),
	('SPOUSE', 'Spouse', 'Pasangan'),
	('GRANDFATHER', 'Grandfather', 'Datuk'),
	('GRANDMOTHER', 'Grandmother', 'Nenek'),
	('UNCLE', 'Uncle', 'Pakcik'),
	('AUNT', 'Aunt', 'Makcik');

-- POS terminal lookup status
INSERT INTO i3s_pos_term_status (term_status_code, term_status, term_status_bm, is_active, is_usable) VALUES
	(1, 'In Stock', 'Dalam Stok', false, true),
	(2, 'Active', 'Aktif', true, true),
	(3, 'Lost', 'Hilang', false, false),
	(4, 'Faulty', 'Rosak', false, false),
	(5, 'Repair', 'Dibaiki', false, false),
	(6, 'Disposed', 'Dilupus', false, false);

-- POS terminals
INSERT INTO i3s_pos_term (term_status_code,term_model,term_serial_no,tag_no,merch_id,descript) VALUES
	 (1,'PT7003','201709100101767','SKSI2/2021/POS/20.20',NULL,NULL),
	 (1,'PT7003','201708010100052','SKSI2/2021/POS/20.21',NULL,NULL),
	 (1,'N910 Pro','NA8900170741','LOAN-10L001244-3',NULL,'For testing SAT with Mpay PoS Terminal'),
	 (1,'WizarPoS Q2','WP17451Q20007349','Mpay/2022/test',NULL,'Test PoS'),
	 (1,'PT7003','202209090100001','2022/04/i3s/0001',NULL,'PT7003 tousei terminal v7'),
	 (1,'PT7003','202209090100003','2022/04/i3s/0002',NULL,'PT7003 tousei terminal v7'),
	 (1,'N910 Pro','NA8900170962','1700-81-6729',NULL,'For testing SAT with Mpay PoS Terminal'),
	 (1,'PT7003_m_i3s','202306170100031','SKSI2/2023/POS/20.10',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100023','SMKS18/2023/POS/20.10',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100027','STAR/2023/POS/20.10',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100028','STAR/2023/POS/20.11',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100021','STAR/2023/POS/20.12',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100025','STAR/2023/POS/20.13',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100032','STAR/2023/POS/20.14',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100026','SKPJ/2023/POS/20.11',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100019','SKPJ/2023/POS/20.12',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100029','SMKS18/2023/POS/20.11',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100030','SMKS18/2023/POS/20.12',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100006','SKPJ/2023/POS/20.13',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100002','SMKBK/2023/POS/20.10',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100008','SMKBK/2023/POS/20.11',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100020','SMKBK/2023/POS/20.12',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100024','SMKBK/2023/POS/20.13',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100018','SMKBK/2023/POS/20.14',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100022','SKPP18(2)/2023/POS/20.10',NULL,'192.168.20.32'),
	 (1,'PT7003_m_i3s','202306170100017','SKPP18(2)/2023/POS/20.11',NULL,'192.168.20.33'),
	 (1,'PT7003_m_i3s','202306170100004','SKPP18(2)/2023/POS/20.12',NULL,'192.168.20.34'),
	 (1,'PT7003_m_i3s','202306170100003','SKPP9(1)/2023/POS/20.10',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100001','SKPP9(1)/2023/POS/20.11',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100005','SKPP9(1)/2023/POS/20.12',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100007','SKPP9(1)/2023/POS/20.13',NULL,NULL),
	 (1,'PT7003_m_i3s','202306170100037','STAR/2024/POS/20.15',NULL,'IPwifi 192.168.20.34'),
	 (1,'PT7003_m_i3s','202306170100034','SKSTJOHN1/2024/POS/20.11',NULL,'IPwifi 192.168.20.33'),
	 (1,'PT7003_m_i3s','202306170100033','SKSTJOHN1/2024/POS/20.12',NULL,'IPwifi 192.168.20.32'),
	 (1,'PT7003_m_i3s','202306170100036','SMKJK/2024/POS/20.10',NULL,'IPwifi 192.168.20.32'),
	 (1,'PT7003_m_i3s','202306170100040','SMKJK/2024/POS/20.11',NULL,'IPwifi 192.168.20.34'),
	 (1,'PT7003_m_i3s','202306170100038','SMKJK/2024/POS/20.12',NULL,'IPwifi 192.168.20.33'),
	 (1,'PT7003_m_i3s','202306170100039','SMKPP9(1)/2024/POS/20.10',NULL,'IPwifi 192.168.20.31'),
	 (1,'PT7003_m_i3s','202306170100041','SKJG1/2024/POS/20.10',NULL,'IPwifi 192.168.20.31'),
	 (1,'PT7003_m_i3s','202306170100042','SKJG1/2024/POS/20.11',NULL,'IPwifi 192.168.20.32'),
	 (1,'PT7003_m_i3s','202306170100043','SKJG1/2024/POS/20.12',NULL,'IPwifi 192.168.20.33'),
	 (1,'PT7003_m_i3s','202306170100044','SMKPP9(1)/2024/POS/20.11',NULL,'IPwifi 192.168.20.32'),
	 (1,'PT7003_m_i3s','202306170100047','SMKJK/2024/POS/20.14',NULL,'IPwifi 192.168.20.31'),
	 (1,'PT7003_m_i3s','202306170100045','SMKJK/2024/POS/20.15',NULL,'IPwifi 192.168.20.36'),
	 (1,'PT7003_m_i3s','202306170100046','SMKPP9(1)/2024/POS/20.12',NULL,'IPwifi 192.168.20.33'),
	 (1,'PT7003_m_i3s','202306170100048','SMKPP9(1)/2024/POS/20.13',NULL,'IPwifi 192.168.20.34'),
	 (1,'PT7003_m_i3s','202306170100049','SMKPP9(1)/2024/POS/20.14',NULL,'IPwifi 192.168.20.35'),
	 (1,'PT7003_m_i3s','202306170100050','SMKDJ/062024/POS/20.10',NULL,'IPwifi 192.168.20.31'),
	 (1,'PT7003_m_i3s','202306170100051','SMKDJ/062024/POS/20.11',NULL,'IPwifi 192.168.20.32'),
	 (1,'PT7003_m_i3s','202306170100052','SMKDJ/062024/POS/20.12',NULL,'IPwifi 192.168.20.33'),
	 (1,'PT7003_m_i3s','202306170100053','SMKDJ/062024/POS/20.13',NULL,'IPwifi 192.168.20.34'),
	 (1,'PT7003_m_i3s','202306170100055','SMKDJ/062024/POS/20.14',NULL,'IPwifi 192.168.20.35'),
	 (1,'PT7003_m_i3s','202306170100054','SKJG1/2024/POS/20.13',NULL,'IPwifi 192.168.20.34'),
	 (1,'PT7003_m_i3s','202306170100058','SKSTJOHN1/2024/POS/20.13',NULL,'IPwifi 192.168.20.34');

-- Merchant type
INSERT INTO i3s_merchant_type (merch_type_code, merch_type, merch_type_bm) VALUES
	(1, 'Canteen', 'Kantin'),
	(2, 'Cooperative', 'Koperasi'),
	(3, 'Bookstore', 'Kedai Buku'),
	(4, 'School', 'Sekolah');

-- Merchants
INSERT INTO i3s_merchant (merch_type_code,status_code,merch_name,merch_reg_no,bank_code,bank_account_no,bank_account_name,addr_1,addr_2,addr_city,addr_post,addr_state_code,addr_country_code_alpha_2,person_in_charge,phone_number,fax_number,email,website_url,pic_1_url,pic_2_url,mdr_rate,sc_rate) VALUES
	 (1,2,'R & Z RAZIMAN ENTERPRISE','SA0030843D','MBB','114011717259',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MD RAZI BIN MAN','+60133240649',NULL,NULL,NULL,NULL,NULL,5.00,0.00),
	 (2,1,'KOPERASI MRSM BAGAN DATUK','002572144V','MBB','162021451127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOHD FAREEZ BIN ABDUL RAHMAN','+60129197821',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SK Seksyen 6','SA0380564W','CIMB','8603264387',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SRI MURNI BINTI ABDULLAH','+60133339109',NULL,NULL,NULL,NULL,NULL,10.00,0.00),
	 (1,2,'TUNAS JAYA RESOURCES','001559521X','CIMB','8600431749',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HIRMAN BIN HAMDAN','+60106305533',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (3,2,'KANGTING SDN BHD','210639V','MBB','014196208044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'GAN KANG TING','+60189888351',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,2,'Kantin SMK Seksyen 1, BK (Q CATERERS)','000989143M','MBB','512491103378',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOHD AZHARUDIN BIN BIDIN','+60122323886',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,2,'KEMBARA DESA RESOURCES','SA0095789P','BIMB','12038010087076',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FOZIAH BINTI ABD GHANI','+60123949434',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,2,'Kantin SK Cheras Jaya','001346893W','MBB','514356704044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'RUSNAH BIN RASHID','+60126240784',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SKPP 9(1)','JR0050628V','BIMB','12065010046084',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ROZIATY RASHID','+60175392747',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,2,'Kantin SKPP 18(2)','002131315B','MBB','162982008948',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KHAIRUL ZANZABIL B.ABDUL RAZAK','+601164604698',NULL,NULL,NULL,NULL,NULL,0.00,5.66),
	 (1,1,'MAHAT HASHIM ENTERPRISE','001106686P','BIMB','04024010028395',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAHAT BIN HASHIM','+60133923803',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SMK Seksyen 18','SA0309649H','MBB','8881020261405',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ABDUL AZIZ AL IKRAM BIN HJ YAAKUB','+60136773711',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,2,'Kantin SMK Damansara Jaya','SA0303191X','MBB','152077305062',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ZURIATY BINTI MAT ISA @ HASHIM','+60194444123',NULL,NULL,NULL,NULL,NULL,0.00,5.66),
	 (1,1,'Kantin SMK Ampuan Rahimah','SA0237380A','CIMB','8003690861',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ZUZANA BINTI RAHMAN','+601155594349',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (2,1,'KEDAI i3s','414477T','CIMB','70556534',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Maisarah','+60199305900',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'AZZAQ LAVENDER TRADING (SKS1 2)','001362897W','HLB','18700004676',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Azman','+60182119313',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SMK Bukit Kapar','001504469W','RHB','26229600010700',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suraya Binti Jaafar','+60193671512',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SK Pandamaran Jaya','AS0444131M','CIMB','8605213195',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NORYUSLAIHIS BINTI MOHD ZAIN','+60172852957',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SMK Jalan Kebun','001983218K','MBB','564212106767',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHIHABUDDIN BIN ABDULLAH','+601136940873',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SMK Seksyen 18','RA0100581M','MBB','562861153150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAWARNI BINTI AZALI','+60178384283',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (3,1,'Bookstore SK Jln Gurney 1','937857K','RHB','21213400069120',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SITI','+60198927030',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,2,'Kantin SK Jln Gurney 1','001274334X','RHB','26419700002275',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yahaya hashim','+60173207023',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SKPP 18(2)','SA014381V','CIMB','8602019298',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NOR PARALIZA BINTI A KAHAR','+60148381866',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SK ST John 1','002688927U','BIMB','14153023306317',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ZAIDAH BINTI ZAINAL ABIDIN','+60166470320',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SMK PP9(1)','002823236T','MBB','562058080781',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TUMINAH BINTI MARKOM','+601135191559',NULL,NULL,NULL,NULL,NULL,6.00,5.66),
	 (1,1,'Kantin SMK Damansara Jaya','1409479H','MBB','562759706933',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MUHAMMAD SYAZWAN BIN MOHAMAD ZAKI','+60126455773',NULL,NULL,NULL,NULL,NULL,6.00,5.66);

-------------------------------
-- Add users from pguser.sql --
---------------------------- --

-- Add account / wallet for users
INSERT INTO i3s_account (account_id, user_id, status_code, descript, balance) VALUES
	(i3s_unique_id(), 'TESTUSER1', 1, 'Test Parent 1', 0),
	(i3s_unique_id(), 'TESTCHILD11', 1, 'Test Parent 1', 0),
	(i3s_unique_id(), 'TESTCHILD12', 1, 'Test Parent 1', 0),
	(i3s_unique_id(), 'TESTCHILD13', 1, 'Test Parent 1', 0);

-- Set children as students
INSERT INTO i3s_link_user_school (user_id, school_id, status_code, student_no, is_student) VALUES
	('testchild11', 'BBA8250', 1, 'S0000001', true),
	('testchild12', 'BBA8250', 1, 'S0000002', true),
	('testchild13', 'BBA8250', 1, 'S0000003', true);

-- Add students
INSERT INTO i3s_school_class_student (school_id,class_id,user_id,status_code) VALUES
	 ('BBA8250','1 LESTARI','TESTCHILD11',1),
	 ('BBA4049','2 BITARA','141004140262',1),
	 ('BBA4049','2 BITARA','140816100173',1),
	 ('BBA4049','2 BITARA','141110140637',1),
	 ('BBA4049','2 BITARA','140429101088',1),
	 ('BBA4049','2 BITARA','140219140628',1),
	 ('BBA4049','2 BITARA','140906100919',1),
	 ('BBA4049','2 BITARA','141012101802',1),
	 ('BBA4049','2 BITARA','140724141306',1),
	 ('BBA4049','2 HOLISTIK','140906100257',1),
	 ('BBA4049','2 BITARA','140217140341',1),
	 ('BBA4049','2 BITARA','140908140615',1),
	 ('BBA4049','2 BITARA','140822101594',1),
	 ('BBA4049','2 BITARA','141013100182',1),
	 ('BBA4049','2 BITARA','140616100101',1),
	 ('BBA4049','2 BITARA','140818103685',1),
	 ('BBA4049','2 BITARA','140103102531',1),
	 ('BBA4049','2 BITARA','141210103075',1),
	 ('BBA4049','2 BITARA','140926141291',1),
	 ('BBA4049','2 BITARA','140925080861',1),
	 ('BBA4049','2 BITARA','140904100499',1),
	 ('BBA4049','2 BITARA','140531100639',1),
	 ('BBA4049','2 BITARA','140204100383',1),
	 ('BBA4049','2 BITARA','140923141069',1),
	 ('BBA4049','2 BITARA','141119100332',1),
	 ('BBA4049','2 BITARA','141026100210',1),
	 ('BBA4049','2 BITARA','140310100192',1),
	 ('BBA4049','2 BITARA','140501140234',1),
	 ('BBA4049','2 BITARA','140331101004',1),
	 ('BBA4049','2 BITARA','140409102382',1),
	 ('BBA4049','2 BITARA','140401140528',1),
	 ('BBA4049','2 BITARA','140417102550',1),
	 ('BBA4049','2 HOLISTIK','140501140023',1),
	 ('BBA4049','2 INOVASI','140604100024',1),
	 ('BBA4049','2 SINERGI','140304030474',1),
	 ('BBA4049','2 HOLISTIK','140526100204',1),
	 ('BBA4049','2 HOLISTIK','141028100353',1),
	 ('BBA4049','2 HOLISTIK','140405102182',1),
	 ('BBA4049','2 HOLISTIK','141023102608',1),
	 ('BBA4049','2 HOLISTIK','140329140792',1),
	 ('BBA4049','2 HOLISTIK','140905141575',1),
	 ('BBA4049','2 HOLISTIK','141127102557',1),
	 ('BBA4049','2 HOLISTIK','140823100219',1),
	 ('BBA4049','2 HOLISTIK','141010101331',1),
	 ('BBA4049','2 HOLISTIK','140825101493',1),
	 ('BBA4049','2 HOLISTIK','140202101745',1),
	 ('BBA4049','2 HOLISTIK','141219040277',1),
	 ('BBA4049','2 BITARA','140801141167',1),
	 ('BBA4049','2 HOLISTIK','141216140213',1),
	 ('BBA4049','2 HOLISTIK','140611102925',1),
	 ('BBA4049','2 HOLISTIK','141007102042',1),
	 ('BBA4049','2 HOLISTIK','140623102738',1),
	 ('BBA4049','2 INOVASI','141210102996',1),
	 ('BBA4049','2 HOLISTIK','140517100720',1),
	 ('BBA4049','2 HOLISTIK','141202101520',1),
	 ('BBA4049','2 HOLISTIK','140327101837',1),
	 ('BBA4049','2 HOLISTIK','141216060280',1),
	 ('BBA4049','2 HOLISTIK','140610050334',1),
	 ('BBA4049','2 HOLISTIK','140821101277',1),
	 ('BBA4049','2 HOLISTIK','140515102925',1),
	 ('BBA4049','1 INOVASI','140125011286',1),
	 ('BBA4049','1 INOVASI','140520100182',1),
	 ('BBA4049','1 INOVASI','140828101712',1),
	 ('BBA4049','2 INOVASI','140302100301',1),
	 ('BBA4049','2 INOVASI','140125141195',1),
	 ('BBA4049','2 OBLIGASI','140826100118',1),
	 ('BBA4049','2 INOVASI','140906010761',1),
	 ('BBA4049','2 INOVASI','140909160175',1),
	 ('BBA4049','2 INOVASI','140220101845',1),
	 ('BBA4049','2 INOVASI','140906140099',1),
	 ('BBA4049','2 INOVASI','140209160035',1),
	 ('BBA4049','2 INOVASI','141112030116',1),
	 ('BBA4049','2 INOVASI','140514103053',1),
	 ('BBA4049','2 INOVASI','141110101048',1),
	 ('BBA4049','2 INOVASI','141201100112',1),
	 ('BBA4049','2 INOVASI','140304140622',1),
	 ('BBA4049','2 INOVASI','140704102078',1),
	 ('BBA4049','2 INOVASI','140104101055',1),
	 ('BBA4049','2 INOVASI','141023160082',1),
	 ('BBA4049','2 LESTARI','140615101583',1),
	 ('BBA4049','2 SINERGI','140328103121',1),
	 ('BBA4049','2 LESTARI','140612140528',1),
	 ('BBA4049','2 LESTARI','140924101122',1),
	 ('BBA4049','2 LESTARI','140216100794',1),
	 ('BBA4049','2 LESTARI','141024080316',1),
	 ('BBA4049','2 LESTARI','140807160027',1),
	 ('BBA4049','2 LESTARI','140311100151',1),
	 ('BBA4049','2 LESTARI','140603100372',1),
	 ('BBA4049','2 LESTARI','140523101308',1),
	 ('BBA4049','2 OBLIGASI','140413140162',1),
	 ('BBA4049','2 BITARA','140925030071',1),
	 ('BBA4049','2 OBLIGASI','140722103269',1),
	 ('BBA4049','2 OBLIGASI','140527140427',1),
	 ('BBA4049','2 OBLIGASI','141229102347',1),
	 ('BBA4049','1 OBLIGASI','140910160105',1),
	 ('BBA4049','2 SINERGI','141207030266',1),
	 ('BBA4049','2 INOVASI','141225100184',1),
	 ('BBA4049','1 OBLIGASI','140920102734',1),
	 ('BBA4049','2 SINERGI','140906101989',1),
	 ('BBA4049','2 SINERGI','140903140771',1),
	 ('BBA4049','2 SINERGI','140125100115',1),
	 ('BBA4049','2 SINERGI','141129101347',1),
	 ('BBA4049','2 SINERGI','140722101589',1),
	 ('BBA4049','2 SINERGI','140418102050',1),
	 ('BBA4049','2 SINERGI','141020140828',1),
	 ('BBA4049','2 SINERGI','140928100514',1),
	 ('BBA4049','2 SINERGI','141005102225',1),
	 ('BBA4049','2 SINERGI','141005102217',1),
	 ('BBA4049','2 SINERGI','141107101637',1),
	 ('BBA4049','2 SINERGI','140805140911',1),
	 ('BBA4049','2 SINERGI','141017102847',1),
	 ('BBA4049','2 SINERGI','141110100133',1),
	 ('BBA4049','2 SINERGI','140930102180',1),
	 ('BBA4049','2 SINERGI','140517101256',1),
	 ('BBA4049','2 SINERGI','140306100472',1),
	 ('BBA4049','2 SINERGI','141030103094',1),
	 ('BBA4049','2 SINERGI','140415102776',1),
	 ('BBA4049','2 SINERGI','140415102653',1),
	 ('BBA4049','2 SINERGI','141219102319',1),
	 ('BBA4049','2 SINERGI','140210101497',1),
	 ('BBA4049','2 SINERGI','140808103390',1),
	 ('BBA4049','3 BITARA','131012101010',1),
	 ('BBA4049','3 BITARA','130808030735',1),
	 ('BBA4049','3 BITARA','130811070156',1),
	 ('BBA4049','3 BITARA','130228102632',1),
	 ('BBA4049','3 BITARA','131220100290',1),
	 ('BBA4049','3 BITARA','131129100046',1),
	 ('BBA4049','3 BITARA','130108141469',1),
	 ('BBA4049','3 BITARA','131111100646',1),
	 ('BBA4049','3 BITARA','130428100957',1),
	 ('BBA4049','3 BITARA','130505102287',1),
	 ('BBA4049','3 BITARA','130530100515',1),
	 ('BBA4049','3 BITARA','130124101993',1),
	 ('BBA4049','3 BITARA','130828100403',1),
	 ('BBA4049','3 BITARA','130215101649',1),
	 ('BBA4049','3 BITARA','130312140746',1),
	 ('BBA4049','3 BITARA','140101060550',1),
	 ('BBA4049','3 BITARA','130618101280',1),
	 ('BBA4049','3 BITARA','130418030027',1),
	 ('BBA4049','3 BITARA','130925100392',1),
	 ('BBA4049','3 BITARA','131005102306',1),
	 ('BBA4049','3 BITARA','130108100026',1),
	 ('BBA4049','3 BITARA','130221102234',1),
	 ('BBA4049','3 BITARA','130519101314',1),
	 ('BBA4049','3 BITARA','131015100902',1),
	 ('BBA4049','3 BITARA','130206050034',1),
	 ('BBA4049','3 BITARA','130416101506',1),
	 ('BBA4049','3 BITARA','130907101818',1),
	 ('BBA4049','3 BITARA','130528100428',1),
	 ('BBA4049','3 BITARA','130708140494',1),
	 ('BBA4049','3 HOLISTIK','130811100335',1),
	 ('BBA4049','3 HOLISTIK','130803102090',1),
	 ('BBA4049','3 HOLISTIK','130310160217',1),
	 ('BBA4049','3 HOLISTIK','130618101125',1),
	 ('BBA4049','3 HOLISTIK','130214101065',1),
	 ('BBA4049','3 HOLISTIK','120314102269',1),
	 ('BBA4049','3 HOLISTIK','130511100501',1),
	 ('BBA4049','3 HOLISTIK','130122140235',1),
	 ('BBA4049','3 HOLISTIK','130707100407',1),
	 ('BBA4049','3 HOLISTIK','130530102086',1),
	 ('BBA4049','3 HOLISTIK','131222101764',1),
	 ('BBA4049','3 HOLISTIK','130331140864',1),
	 ('BBA4049','3 HOLISTIK','130301102170',1),
	 ('BBA4049','3 HOLISTIK','130530102094',1),
	 ('BBA4049','3 HOLISTIK','130112050658',1),
	 ('BBA4049','3 HOLISTIK','130501101586',1),
	 ('BBA4049','3 HOLISTIK','130319100819',1),
	 ('BBA4049','3 HOLISTIK','130222100310',1),
	 ('BBA4049','3 HOLISTIK','130924102273',1),
	 ('BBA4049','3 HOLISTIK','130628110383',1),
	 ('BBA4049','3 HOLISTIK','130617140878',1),
	 ('BBA4049','1 OBLIGASI','131113100199',1),
	 ('BBA4049','3 INOVASI','130404100469',1),
	 ('BBA4049','3 INOVASI','130107101561',1),
	 ('BBA4049','3 INOVASI','130905140434',1),
	 ('BBA4049','3 INOVASI','130605100975',1),
	 ('BBA4049','3 INOVASI','131031140461',1),
	 ('BBA4049','3 INOVASI','130725100291',1),
	 ('BBA4049','3 INOVASI','131126102425',1),
	 ('BBA4049','3 INOVASI','131127100309',1),
	 ('BBA4049','3 INOVASI','130415100296',1),
	 ('BBA4049','3 INOVASI','131108070474',1),
	 ('BBA4049','3 INOVASI','130703140356',1),
	 ('BBA4049','3 INOVASI','131223101432',1),
	 ('BBA4049','3 INOVASI','130715140038',1),
	 ('BBA4049','3 INOVASI','131122140432',1),
	 ('BBA4049','3 INOVASI','130503101846',1),
	 ('BBA4049','3 INOVASI','130827102669',1),
	 ('BBA4049','3 INOVASI','130111100799',1),
	 ('BBA4049','3 INOVASI','130113100434',1),
	 ('BBA4049','3 LESTARI','130302100425',1),
	 ('BBA4049','3 LESTARI','130814100656',1),
	 ('BBA4049','3 LESTARI','130918100175',1),
	 ('BBA4049','4 LESTARI','130413102335',1),
	 ('BBA4049','3 LESTARI','130830100234',1),
	 ('BBA4049','3 LESTARI','130209140414',1),
	 ('BBA4049','3 LESTARI','130909140116',1),
	 ('BBA4049','3 LESTARI','131025040245',1),
	 ('BBA4049','3 LESTARI','130930100741',1),
	 ('BBA4049','3 LESTARI','130430140253',1);

-- Setup testuser1 as father of testchild11, testchild12 and testchild13
INSERT INTO i3s_link_users (user_id_from, user_id_to, rel_code, is_guardian, status_code) VALUES
	('testuser1', 'testchild11', 'FATHER', TRUE, 1),
	('testuser1', 'testchild12', 'FATHER', TRUE, 1),
	('testuser1', 'testchild13', 'FATHER', TRUE, 1);

-- RFID lookup status
INSERT INTO i3s_rfid_status (rfid_status_code, rfid_status, rfid_status_bm, is_active, is_usable) VALUES
	(1, 'In Stock', 'Dalam Stok', false, true),
	(2, 'Active', 'Aktif', true, true),
	(3, 'Lost', 'Hilang', false, false),
	(4, 'Faulty', 'Rosak', false, false),
	(5, 'Blacklisted', 'Senarai Hitam', false, false),
	(6, 'Inactive', 'Tidak Aktif', false, false);

-- Insert a lost RFID card for testchild11's account
INSERT INTO i3s_rfid (
    rfid_status_code,
    rfid_tag,
    rfid_card_no,
    account_id,
    card_standard,
    card_type,
    card_implement,
    issue_date,
    valid_start_date,
    valid_end_date,
    is_replaced,
    replace_reason,
    replace_date)
VALUES (
        3,
        'test-rfid-tag-1',
        'test-rfid-card-no-1',
        '01959DC5-7C52-713F-AAD2-03BF5257DE18',
        'ISO 14443',
        'Non-contact',
        'MIFARE',
        '2024-06-01',
        '2024-01-01',
        '2035-12-31',
        't',
        'Stolen',
        '2025-02-01'
);

-- Insert a replacement card for testchild11's account
INSERT INTO i3s_rfid (
    rfid_status_code,
    rfid_tag,
    rfid_card_no,
    account_id,
    card_standard,
    card_type,
    card_implement,
    issue_date,
    valid_start_date,
    valid_end_date)
VALUES (
        2,
        'test-rfid-tag-2',
        'test-rfid-card-no-2',
        '01959DC5-7C52-713F-AAD2-03BF5257DE18',
        'ISO 14443',
        'Non-contact',
        'MIFARE',
        '2025-02-01',
        '2024-01-01',
        '2035-12-31'
);

-- Insert some test bulletins
INSERT INTO i3s_bulletin(
	bulletin_type, 
	school_id,
    bulletin_title,
    bulletin_content,
    status_code
) VALUES (
	1,
	'BBA4049',
	'Test school bulletin for BBA4049',
	'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
	1
);

INSERT INTO i3s_bulletin(
	bulletin_type, 
	school_id,
    bulletin_title,
    bulletin_content,
    status_code
) VALUES (
	1,
	'BBA8250',
	'Test school bulletin for BBA8250',
	'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
	1
);

INSERT INTO i3s_bulletin(
	bulletin_type, 
	school_id,
	class_id,
    bulletin_title,
    bulletin_content,
    status_code
) VALUES (
	2,
	'BBA4049',
	'1 LESTARI',
	'Test school bulletin for BBA4049 (class=1 LESTARI)',
	'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
	1
);

INSERT INTO i3s_bulletin(
	bulletin_type, 
	school_id,
	class_id,
    bulletin_title,
    bulletin_content,
    status_code
) VALUES (
	2,
	'BBA8250',
	'1 LESTARI',
	'Test school bulletin for BBA8250 (class=1 LESTARI)',
	'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
	1
);
