-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `wkconsult_db`
--

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dp_code` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `country` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `dp_code`, `country`) VALUES
(1, 'Singapore Citizen', 'SGP', 'Singapore'),
(2, 'Singapore Permanent Resident', 'SGP', 'Singapore Permanent Resident'),
(3, 'Afghan', 'AFG', 'Afghanistan'),
(4, 'Albanian', 'ALB', 'Albania'),
(5, 'Algerian', 'DZA', 'Algeria'),
(6, 'American', 'USA', 'United States'),
(7, 'American Samoa', 'ASM', 'American SAMOA'),
(8, 'Andorran', 'AND', 'Andorra'),
(9, 'Angolan', 'AGO', 'Angola'),
(10, 'Antigua', 'ATG', 'Antigua And Barbuda'),
(11, 'Argentinian', 'ARG', 'Argentina'),
(12, 'Armenian', 'ARM', 'Armenia'),
(13, 'Australian', 'AUS', 'Australia'),
(14, 'Austrian', 'AUT', 'Austria'),
(15, 'Azerbaijani', 'AZE', 'Azerbaijan'),
(16, 'Bahamas', 'BHS', 'Bahamas'),
(17, 'Bahraini', 'BHR', 'Bahrain'),
(18, 'Bangladeshi', 'BGD', 'Bangladesh'),
(19, 'Barbados', 'BRB', 'Barbados'),
(20, 'Belarussian', 'BLR', 'Belarus'),
(21, 'Belgian', 'BEL', 'Belgium'),
(22, 'Belize', 'BLZ', 'Belize'),
(23, 'Benin', 'BEN', 'Benin'),
(24, 'Bhutan', 'BTN', 'Bhutan'),
(25, 'Bolivian', 'BOL', 'Bolivia'),
(26, 'Bosnian', 'BIH', 'Bosnia And Herzegowina'),
(27, 'Br Dep Ter Citizen', 'GBR', ''),
(28, 'Br Nat. Overseas', 'GBR', ''),
(29, 'Br Overseas Cit.', 'GBR', ''),
(30, 'Br Protected Pers.', 'GBR', ''),
(31, 'Brazilian', 'BRA', 'Brazil'),
(32, 'British', 'GBR', 'United Kingdom'),
(33, 'British Subject', 'GBR', ''),
(34, 'Bruneian', 'BRN', 'Brunei Darussalam'),
(35, 'Bulgarian', 'BGR', 'Bulgaria'),
(36, 'Burkina Faso', 'BFA', 'Burkina Faso'),
(37, 'Burundi', 'BDI', 'Burundi'),
(38, 'Cambodian', 'KHM', 'Cambodia'),
(39, 'Cameroon', 'CMR', 'Cameroon'),
(40, 'Canadian', 'CAN', 'Canada'),
(41, 'Cape Verde', 'CPV', 'Cape Verde'),
(42, 'Chadian', 'TCD', 'Chad'),
(43, 'Chilean', 'CHL', 'Chile'),
(44, 'Chinese', 'CHN', 'China'),
(45, 'Colombian', 'COL', 'Colombia'),
(46, 'Comoros', 'COM', 'Comoros'),
(47, 'Congo', 'COG', 'Congo'),
(48, 'Cook Islands', 'COK', 'Cook Islands'),
(49, 'Costa Rican', 'CRI', 'Costa Rica'),
(50, 'Croatian', 'HRV', 'Croatia (Local Name: Hrvatska)'),
(51, 'C\'tral African Rep', 'CAF', 'Central African Republic'),
(52, 'Cuban', 'CUB', 'Cuba'),
(53, 'Cypriot', 'CYP', 'Cyprus'),
(54, 'Czech', 'CZE', 'Czech Republic'),
(55, 'Czechoslovak', 'CZE', ''),
(56, 'Danish', 'DNK', 'Denmark'),
(57, 'Djibouti', 'DJI', 'Djibouti'),
(58, 'Dominica', 'DMA', 'Dominica'),
(59, 'Dominican Republic', 'DOM', 'Dominican Republic'),
(60, 'Dutch', 'BEL', ''),
(61, 'East Timorese', 'TLS', 'East Timor'),
(62, 'Ecuadorian', 'ECU', 'Ecuador'),
(63, 'Egyptian', 'EGY', 'Egypt'),
(64, 'Equatorial Guinea', 'GNQ', 'Equatorial Guinea'),
(65, 'Eritrean', 'ERI', 'ERITREA'),
(66, 'Estonian', 'EST', 'Estonia'),
(67, 'Ethiopian', 'ETH', 'Ethiopia'),
(68, 'Fijian', 'FJI', 'Fiji'),
(69, 'Filipino', 'PHL', 'Philippines'),
(70, 'Finnish', 'FIN', 'Finland'),
(71, 'French', 'FRA', 'France'),
(72, 'French Guiana', 'GUF', 'French Guiana'),
(73, 'French Polynesia', 'PYF', 'French Polynesia'),
(74, 'Gabon', 'GAB', 'Gabon'),
(75, 'Gambian', 'GMB', 'Gambia'),
(76, 'Georgian', 'GEO', 'Georgia'),
(77, 'German', 'DEU', 'Germany'),
(78, 'German East', 'DEU', ''),
(79, 'German West', 'DEU', ''),
(80, 'Ghanaian', 'GHA', 'Ghana'),
(81, 'Greek', 'GRC', 'Greece'),
(82, 'Grenadian', 'GRD', 'Grenada'),
(83, 'Guadeloupe', 'GLP', 'Guadeloupe'),
(84, 'Guam', 'GUM', 'GUAM (Usa)'),
(85, 'Guatemala', 'GTM', 'Guatemala'),
(86, 'Guinea', 'GIN', 'Guinea'),
(87, 'Guinea-Bissau', 'GNB', 'Guinea-Bissau'),
(88, 'Guyana', 'GUY', 'Guyana'),
(89, 'Haitian', 'HTI', 'Haiti'),
(90, 'Honduran', 'HND', 'Honduras'),
(91, 'Hong Kong', 'HKG', 'Hong Kong'),
(92, 'Hungarian', 'HUN', 'Hungary'),
(93, 'Iceland', 'ISL', 'Iceland'),
(94, 'Indian', 'IND', 'India'),
(95, 'Indonesian', 'IDN', 'Indonesia'),
(96, 'Iranian', 'IRN', 'Iran (Islamic Republic Of)'),
(97, 'Iraqi', 'IRQ', 'Iraq'),
(98, 'Irish', 'IRL', 'Ireland'),
(99, 'Israeli', 'ISR', 'Israel'),
(100, 'Italian', 'ITA', 'Italy'),
(101, 'Ivory Coast', 'CIV', ''),
(102, 'Jamaican', 'JAM', 'Jamaica'),
(103, 'Japanese', 'JPN', 'Japan'),
(104, 'Jordanian', 'JOR', 'Jordan'),
(105, 'Kampuchean', 'KHM', ''),
(106, 'Kazakh', 'KAZ', 'Kazakhstan'),
(107, 'Kenyan', 'KEN', 'Kenya'),
(108, 'Kiribati', 'KIR', 'Kiribati'),
(109, 'Korea North', 'PRK', 'Democratic People\'s Republic Of Korea (North Korea)'),
(110, 'Korea South', 'KOR', 'Republic Of Korea'),
(111, 'Kuwaiti', 'KWT', 'Kuwait'),
(112, 'Kyrghis', 'KGZ', 'Kyrgyzstan'),
(113, 'Kyrgyzstan', 'KGZ', ''),
(114, 'Laotian', 'LAO', 'Lao People\'s Democratic Republic'),
(115, 'Latvian', 'LVA', 'Latvia'),
(116, 'Lebanese', 'LBN', 'Lebanon'),
(117, 'Lesotho', 'LSO', 'Lesotho'),
(118, 'Liberian', 'LBR', 'Liberia'),
(119, 'Libyan', 'LBY', 'Libyan Arab Jamahiriya'),
(120, 'Liechtensteiner', 'LIE', 'Liechtenstein'),
(121, 'Lithuanian', 'LTU', 'Lithuania'),
(122, 'Luxembourg', 'LUX', 'Luxembourg'),
(123, 'Macao', 'MAC', 'Macau'),
(124, 'Macedonia', 'MKD', 'Macedonia'),
(125, 'Madagascar', 'MDG', 'Madagascar'),
(126, 'Malawi', 'MWI', 'Malawi'),
(127, 'Malaysian', 'MYS', 'Malaysia'),
(128, 'Maldivian', 'MDV', 'Maldives'),
(129, 'Mali', 'MLI', 'Mali'),
(130, 'Maltese', 'MLT', 'Malta'),
(131, 'Marshallese', 'MHL', 'Marshall Islands'),
(132, 'Martinique', 'MTQ', 'Martinique (French)'),
(133, 'Mauritanean', 'MRT', 'Mauritania'),
(134, 'Mauritian', 'MUS', 'Mauritius'),
(135, 'Mexican', 'MEX', 'Mexico'),
(136, 'Micronesian', 'FSM', 'Micronesia'),
(137, 'Moldavian', 'MDA', 'Moldova'),
(138, 'Monaco', 'MCO', 'Monaco'),
(139, 'Mongolian', 'MNG', 'Mongolia'),
(140, 'Moroccan', 'MAR', 'Morocco'),
(141, 'Mozambique', 'MOZ', 'Mozambique'),
(142, 'Myanmar', 'MMR', 'Myanmar'),
(143, 'Namibia', 'NAM', ''),
(144, 'Nauruan', 'NRU', 'Nauru'),
(145, 'Nepalese', 'NPL', 'Nepal'),
(146, 'Netherlands', 'NLD', 'Netherlands'),
(147, 'Netherlands Antil.', 'ANT', 'Netherlands Antilles'),
(148, 'New Caledonia', 'NCL', 'New Caledonia (French)'),
(149, 'New Zealander', 'NZL', 'New Zealand'),
(150, 'Nicaraguan', 'NIC', 'Nicaragua'),
(151, 'Niger', 'NER', 'Niger'),
(152, 'Nigerian', 'NGA', 'Nigeria'),
(153, 'Niue Island', 'NIU', 'Niue'),
(154, 'Norwegian', 'NOR', 'Norway'),
(155, 'Omani', 'OMN', 'Oman'),
(156, 'Pacific Is Trust T', 'FSM', ''),
(157, 'Pakistani', 'PAK', 'Pakistan'),
(158, 'Palauan', 'PLW', 'Palau'),
(159, 'Palestinian', 'PSE', 'Palestinian Territory, Occupied'),
(160, 'Panamanian', 'PAN', 'Panama'),
(161, 'Papua New Guinea', 'PNG', 'Papua New Guinea'),
(162, 'Paraguay', 'PRY', 'Paraguay'),
(163, 'Peruvian', 'PER', 'Peru'),
(164, 'Pitcairn', 'PCN', 'Pitcairn Island'),
(165, 'Polish', 'POL', 'Poland'),
(166, 'Portuguese', 'PRT', 'Portugal'),
(167, 'Puerto Rican', 'PRI', 'Puerto Rico'),
(168, 'Qatar', 'QAT', 'Qatar'),
(169, 'Reunion', 'REU', 'Reunion (French)'),
(170, 'Romanian', 'ROU', 'Romania'),
(171, 'Russian', 'RUS', 'Russian Federation'),
(172, 'Rwandan', 'RWA', 'Rwanda'),
(173, 'Salvadoran', 'SLV', 'El Salvador'),
(174, 'Samoan', 'WSM', 'Samoa'),
(175, 'Sao Tome', 'STP', 'Sao Tome AND Principe'),
(176, 'Saudi Arabian', 'SAU', 'Saudi Arabia'),
(177, 'Senegalese', 'SEN', 'Senegal'),
(178, 'Seychelles', 'SYC', 'Seychelles'),
(179, 'Sierra Leone', 'SLE', 'Sierra Leone'),
(180, 'Slovak', 'SVK', 'Slovakia (Slovak Republic)'),
(181, 'Slovenian', 'SVN', 'Slovenia'),
(182, 'Solomon Islands', 'SLB', 'Solomon Islands'),
(183, 'Somali', 'SOM', 'Somalia'),
(184, 'South African', 'ZAF', 'South Africa'),
(185, 'South Yemen', 'YEM', ''),
(186, '(Soviet) Russian', 'RUS', ''),
(187, 'Spanish', 'ESP', 'Spain'),
(188, 'Sri Lankan', 'LKA', 'Sri Lanka'),
(189, 'St Kitts', 'KNA', 'Saint Kitts And Nevis'),
(190, 'St. Lucia', 'LCA', 'Saint Lucia'),
(191, 'St. Vincent', 'VCT', 'Saint Vincent And The Grenadines'),
(193, 'Sudanese', 'SDN', 'Sudan'),
(194, 'Suriname', 'SUR', 'Suriname'),
(195, 'Swazi', 'SWZ', 'Swaziland'),
(196, 'Swedish', 'SWE', 'Sweden'),
(197, 'Swiss', 'CHE', 'Switzerland'),
(198, 'Syrian', 'SYR', 'Syrian Arab Republic'),
(199, 'Tadzhik', 'TJK', ''),
(200, 'Taiwanese', 'TWN', 'Taiwan'),
(201, 'Tajikistani', 'TJK', 'Tajikistan'),
(202, 'Tanzanian', 'TZA', 'Tanzania'),
(203, 'Thai', 'THA', 'Thailand'),
(204, 'Timorese', 'TLS', ''),
(205, 'Togo', 'TGO', 'Togo'),
(206, 'Tokelau Islands', 'TKL', 'Tokelau'),
(207, 'Tonga', 'TON', 'Tonga'),
(208, 'Trinidad', 'TTO', 'Trinidad And Tobago'),
(209, 'Tunisia', 'TUN', 'Tunisia'),
(210, 'Turk', 'TUR', 'Turkey'),
(211, 'Turkmen', 'TKM', 'Turkmenistan'),
(212, 'Tuvalu', 'TUV', 'Tuvalu'),
(213, 'Ugandan', 'UGA', 'Uganda'),
(214, 'Ukrainian', 'UKR', 'Ukraine'),
(215, 'United Arab Em.', 'ARE', 'United Arab Emirates'),
(216, 'Unknown', 'OTH', 'Unknown'),
(217, 'Upper Volta', 'BFA', ''),
(218, 'Uruguay', 'URY', 'Uruguay'),
(219, 'Uzbek', 'UZB', 'Uzbekistan'),
(220, 'Vanuatu', 'VUT', 'Vanuatu'),
(221, 'Venezuelan', 'VEN', 'Venezuela'),
(222, 'Vietnamese', 'VNM', 'Vietnam'),
(223, 'Wallis And Futuna', 'WLF', 'Wallis And Futuna Islands'),
(224, 'Western Sahara', 'ESH', 'Western Sahara'),
(225, 'Yemen Arab Rep', 'YEM', ''),
(226, 'Yemeni', 'YEM', 'Yemen'),
(227, 'Yugoslav', 'YUG', 'Yugoslavia'),
(228, 'Zairean', 'COG', ''),
(229, 'Zambian', 'ZMB', 'Zambia'),
(230, 'Zimbabwean', 'ZWE', 'Zimbabwe'),
(231, 'Non-S\'pore Citizen', '', ''),
(232, '', 'AIA', 'Anguilla'),
(233, '', 'ATA', 'Antarctica'),
(234, '', 'ABW', 'Aruba'),
(235, '', 'BMU', 'Bermuda'),
(236, '', 'BWA', 'Botswana'),
(237, '', 'BVT', 'Bouvet Island'),
(238, '', 'IOT', 'British Indian Ocean Territory'),
(239, '', 'CYM', 'Cayman Islands'),
(240, '', 'CXR', 'Christmas Island'),
(241, '', 'CCK', 'Cocos (Keeling) Islands'),
(242, '', 'CIV', 'Cote D\'Ivoire'),
(243, '', 'FLK', 'Falkland Islands (Malvinas)'),
(244, '', 'FRO', 'Faroe Islands'),
(245, '', 'ATF', 'French Southern Territories'),
(246, '', 'GIB', 'Gibraltar'),
(247, '', 'GRL', 'Greenland'),
(248, '', 'GGY', 'Guernsey'),
(249, '', 'HMD', 'Heard And McDonald Islands'),
(250, '', 'IMN', 'Isle Of Man'),
(251, '', 'JEY', 'Jersey'),
(252, '', 'MYT', 'Mayotte'),
(253, '', 'MNE', 'Montenegro'),
(254, '', 'MSR', 'Montserrat'),
(255, '', 'NFK', 'Norfolk Island'),
(256, '', 'MNP', 'Northern Mariana Islands'),
(257, '', 'SHN', 'Saint Helena'),
(258, '', 'SPM', 'Saint Pierre And Miquelon'),
(259, '', 'BLM', 'Saint-Barthélemy'),
(260, '', 'SMR', 'San Marino'),
(261, 'Serbian', 'SRB', 'Serbia'),
(262, '', 'SGS', 'South Georgia And The South Sandwich Islands'),
(263, '', 'SJM', 'Svalbard AND Jan Mayen Islands'),
(264, '', 'TCA', 'Turks And Caicos Islands'),
(265, '', 'UMI', 'United States Minor Outlying Islands'),
(266, '', 'VAT', 'Vatican City State (Holy See)'),
(267, '', 'VGB', 'Virgin Islands (British)'),
(268, '', 'VIR', 'Virgin Islands (Usa)'),
(295, 'Stateless', 'OTH', 'Stateless');

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

--
-- Table structure for table `identification_types`
--

CREATE TABLE `identification_types` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `identification_types`
--

INSERT INTO `identification_types` (`id`, `name`) VALUES
(1, 'Singapore NRIC No'),
(2, 'Singapore PR No'),
(3, 'Foreign Identification Number'),
(4, 'Passport No.'),
(5, 'Others'),
(6, 'VISIT PASS'),
(10, 'Unique Entity No');

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

--
-- Table structure for table `positions`
--

CREATE TABLE `positions` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `code` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `positions`
--

INSERT INTO `positions` (`id`, `name`, `code`) VALUES
(1, 'Director / GM', 'DIRGM'),
(2, 'Senior Manager', 'SNRMG'),
(3, 'Manager/Assistant Manager', 'MGASSMG'),
(4, 'Supervisor', 'SUPERVIS'),
(5, 'Senior Executive', 'SNREXEC'),
(6, 'Junior Executive', 'JNREXEC'),
(7, 'Non-Executive', 'NONEXEC'),
(8, 'Professional', 'PROF'),
(10, 'Others', 'OTHERS');

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

--
-- Table structure for table `race`
--

CREATE TABLE `race` (
  `CODE` text,
  `DESCRIPTION` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `race`
--

INSERT INTO `race` (`CODE`, `DESCRIPTION`) VALUES
('AB', 'ANGLO BURMESE'),
('AC', 'ANGLO CHINESE'),
('AD', 'AMERINDIAN'),
('AF', 'AFRICAN'),
('AG', 'AFGHAN'),
('AH', 'ANGLO THAI'),
('AI', 'ANGLO INDIAN'),
('AJ', 'ACHEHNESE'),
('AL', 'ALBANIAN'),
('AM', 'ARMENIAN'),
('AN', 'ANNAMITE'),
('AO', 'AMBONESE'),
('AP', 'ANGLO FILIPINO'),
('AR', 'ARAB'),
('AS', 'ASSAMI'),
('AT', 'AUSTRIAN'),
('AU', 'AUSTRALIAN'),
('AX', 'ANGLO SAXON'),
('AY', 'ARYAN'),
('AZ', 'AZERI'),
('BA', 'BATAK'),
('BB', 'BULGARIAN'),
('BC', 'BUTONESE'),
('BD', 'BANGLADESHI'),
('BE', 'BELGIAN'),
('BF', 'BAJAU'),
('BG', 'BUGIS'),
('BH', 'BURGHER'),
('BI', 'BENGALI'),
('BJ', 'BANJARESE'),
('BK', 'BAMAR'),
('BL', 'BANGALA'),
('BM', 'BALINESE'),
('BN', 'BHUTANESE'),
('BO', 'BANTEN'),
('BQ', 'BASQUE'),
('BR', 'BRAHMIN'),
('BS', 'BISAYA'),
('BT', 'BRITISH'),
('BU', 'BURMESE'),
('BV', 'BOSNIAK'),
('BW', 'BETAWI'),
('BY', 'BOYANESE'),
('BZ', 'BRAZILIAN'),
('CA', 'CAUCASIAN'),
('CB', 'CANADIAN'),
('CC', 'CAPE COLOURED'),
('CD', 'CAMBODIAN'),
('CE', 'CEYLONESE'),
('CF', 'CORNISH'),
('CG', 'CREOLE'),
('CH', 'SWISS'),
('CI', 'CROAT'),
('CJ', 'CHAMORRO'),
('CM', 'CEYLON MOOR'),
('CN', 'CHINESE'),
('CO', 'COCOS'),
('CR', 'CARIBBEAN'),
('CS', 'CZECHOSLOVAK'),
('CZ', 'CZECH'),
('DA', 'DANE'),
('DB', 'DUTCH BURGHER'),
('DH', 'BIDAYUH'),
('DS', 'DUSUN'),
('DU', 'DUTCH'),
('DY', 'DAYAK'),
('EL', 'ENGLISH'),
('ER', 'EUROPEAN'),
('ES', 'SPANISH'),
('ET', 'ETHIOPIAN'),
('EU', 'EURASIAN'),
('EY', 'EGYPTIAN'),
('FI', 'FINN'),
('FJ', 'FIJIAN'),
('FM', 'FLEMISH'),
('FR', 'FRENCH'),
('GA', 'GOAN'),
('GE', 'GUJARATI'),
('GH', 'GHANAIAN'),
('GK', 'GURKHA'),
('GM', 'GERMAN'),
('GO', 'GOANESE'),
('GR', 'GREEK'),
('HA', 'HAITIAN'),
('HI', 'HISPANIC'),
('HO', 'HOLLANDER'),
('HT', 'HINDUSTANI'),
('HU', 'HUNGARIAN'),
('HW', 'HAWAIIAN'),
('IA', 'IRANIAN'),
('IB', 'IBAN'),
('ID', 'INDONESIAN'),
('IK', 'ISOKO'),
('IL', 'ISRAELI'),
('IN', 'INDIAN'),
('IQ', 'IRAQI'),
('IR', 'IRISH'),
('IS', 'ICELANDER'),
('IT', 'ITALIAN'),
('IU', 'INUIT'),
('JA', 'JAVANESE'),
('JK', 'JAKUN'),
('JM', 'JAMAICAN'),
('JO', 'JORDANIAN'),
('JP', 'JAPANESE'),
('JW', 'JEW'),
('KA', 'KACHIN'),
('KB', 'KHASI'),
('KC', 'KAYAH'),
('KD', 'KAYIN'),
('KE', 'KENYAN'),
('KF', 'KINH'),
('KG', 'KYRGYZ'),
('KH', 'KHMER'),
('KI', 'KENYAH'),
('KK', 'KAZAKH'),
('KL', 'KELABIT'),
('KM', 'KAMPUCHEAN'),
('KN', 'KAREN'),
('KR', 'KOREAN'),
('KY', 'KAYAN'),
('KZ', 'KADAZAN'),
('LA', 'LAO'),
('LB', 'LEBANESE'),
('LI', 'LITHUANIAN'),
('LK', 'SRI LANKAN'),
('LT', 'LATIN'),
('LV', 'LATVIAN'),
('LX', 'LUXEMBOURGER'),
('LY', 'LIBYAN'),
('MA', 'MADURESE'),
('MB', 'MALABARI'),
('MC', 'MAGYARS'),
('MD', 'MOLDAVIAN'),
('ME', 'MINANGKABAU'),
('MF', 'MANX'),
('MG', 'MALAGASY'),
('MH', 'MAHRATTA'),
('MI', 'MAORI'),
('MJ', 'MURUT'),
('MK', 'MAKASARESE'),
('ML', 'MALDIVIAN'),
('MM', 'MALAYALEE'),
('MN', 'MELANESIAN'),
('MO', 'MONGOLIAN'),
('MP', 'MANIPURI'),
('MQ', 'MESTIZO'),
('MR', 'MARATHI'),
('MS', 'METIS'),
('MT', 'MALTESE'),
('MU', 'MAURITIAN'),
('MV', 'MON'),
('MW', 'MOROCCAN'),
('MX', 'MEXICAN'),
('MY', 'MALAY'),
('MZ', 'MELANAU'),
('NA', 'NAGA'),
('NG', 'NEGRO'),
('NI', 'NIGERIAN'),
('NL', 'NETHERLANDER'),
('NO', 'NORWEGIAN'),
('NP', 'NEPALESE'),
('NR', 'NAURUAN'),
('NW', 'NEWAR'),
('NZ', 'NEW ZEALANDER'),
('PA', 'PENAN'),
('PB', 'PALESTINE'),
('PC', 'POLISH'),
('PE', 'PERSIAN'),
('PH', 'FILIPINO'),
('PJ', 'PUNJABI'),
('PK', 'PAKISTANI'),
('PL', 'POLE'),
('PN', 'PATHAN'),
('PO', 'PORTUGUESE'),
('PR', 'PERUVIAN'),
('PS', 'PARSEE'),
('PY', 'POLYNESIAN'),
('RJ', 'RAJPUT'),
('RK', 'RAKHINE'),
('RO', 'ROMANIAN'),
('RU', 'RUSSIAN'),
('SA', 'SINO KADAZAN'),
('SB', 'SAMMARINESE'),
('SC', 'SCOT'),
('SD', 'SINDHI'),
('SE', 'SWEDE'),
('SF', 'SERBIA/MONTENGERIN'),
('SG', 'SAMOAN'),
('SH', 'SHAN'),
('SI', 'SINHALESE'),
('SJ', 'SINO JAPANESE'),
('SK', 'SIKH'),
('SL', 'SLOVAK'),
('SM', 'SUMATRAN'),
('SN', 'SINO INDIAN'),
('SO', 'SOMALI'),
('SQ', 'SLAVIC'),
('SR', 'SERANI'),
('SS', 'SUNDANESE'),
('SU', 'SUDANESE'),
('SW', 'SWEDISH'),
('SY', 'SEYCHELLOIS'),
('TE', 'TELUGU'),
('TH', 'THAI'),
('TI', 'TIBETAN'),
('TJ', 'TAJIK'),
('TM', 'TAMIL'),
('TN', 'TURKMEN'),
('TO', 'TONGAN'),
('TP', 'TIMOR'),
('TR', 'TURK'),
('UN', 'UNKNOWN'),
('UR', 'UKRAINIAN'),
('US', 'AMERICAN'),
('UY', 'UYGHUR'),
('UZ', 'UZBEK'),
('VE', 'VENEZUELAN'),
('VN', 'VIETNAMESE'),
('WE', 'WELSH'),
('XD', 'OTHER INDONESIAN'),
('XE', 'OTHER EURASIAN'),
('XI', 'OTHER INDIAN'),
('XX', 'OTHERS'),
('YU', 'YUGOSLAV'),
('ZW', 'ZIMBABWEAN');

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

--
-- Stand-in structure for view `repayments_bdr_view`
-- (See below for the actual view)
--
CREATE TABLE `repayments_bdr_view` (
);

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

--
-- Table structure for table `specialisations`
--

CREATE TABLE `specialisations` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `code` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `specialisations`
--

INSERT INTO `specialisations` (`id`, `name`, `code`) VALUES
(1, 'Agriculture and Fishing', 'AAF'),
(2, 'Mining and Quarrying', 'MAQ'),
(3, 'Manufacturing', 'MANUFACT'),
(4, 'Electricity, Gas, Steam and Air-Conditioning Supply', 'EGSACP'),
(5, 'Water Supply; Sewerage, Waste Management and Remediation Activities', 'WSWMRA'),
(6, 'Construction', 'CONS'),
(7, 'Wholesale and Retail Trade', 'WRT'),
(8, 'Transportation and Storage', 'TAS'),
(9, 'Accommodation and Food Service Activities', 'AFSA'),
(10, 'Information and Communications', 'ITCOM'),
(11, 'Financial and Insurance Activities', 'FININS'),
(12, 'Real Estate Activities', 'REA'),
(13, 'Professional, Scientific and Technical Activities', 'PSTA'),
(14, 'Administrative and Support Service Activities', 'ASSA'),
(15, 'Public Administration and Defence', 'PAD'),
(16, 'Education', 'EDU'),
(17, 'Health and Social Services', 'HSS'),
(18, 'Arts, Entertainment and Recreation', 'AER'),
(19, 'Other Service Activities', 'OTHERS'),
(20, 'Activities of Households as Employers of Domestic Personnel', 'HEDP'),
(21, 'Activities of Extra-Territorial Organisations and Bodies', 'ETOB'),
(22, 'Activities Not Adequately Defined', 'NAD');

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

--
-- Structure for view `repayments_bdr_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `repayments_bdr_view`  AS SELECT `repayments`.`id` AS `id`, `repayments`.`disbursement_id` AS `disbursement_id`, `repayments`.`application_id` AS `application_id`, `repayments`.`account_number` AS `account_number`, `repayments`.`date` AS `date`, `repayments`.`voucher_number` AS `voucher_number`, `repayments`.`payer_type_id` AS `payer_type_id`, `repayments`.`other_payer_name` AS `other_payer_name`, `repayments`.`other_payer_address` AS `other_payer_address`, `repayments`.`other_payer_uid` AS `other_payer_uid`, `repayments`.`amount` AS `amount`, `repayments`.`PaymentMode` AS `PaymentMode`, `repayments`.`PayDetDate` AS `PayDetDate`, `repayments`.`transaction_number` AS `transaction_number`, `repayments`.`PayDetBank` AS `PayDetBank`, `repayments`.`remarks` AS `remarks`, `repayments`.`RegularPay` AS `RegularPay`, `repayments`.`paid_principal` AS `paid_principal`, `repayments`.`paid_interest` AS `paid_interest`, `repayments`.`PrincipalAdj` AS `PrincipalAdj`, `repayments`.`InterestAdj` AS `InterestAdj`, `repayments`.`AmountAdj` AS `AmountAdj`, `repayments`.`permit_fee` AS `permit_fee`, `repayments`.`acceptance_fee` AS `acceptance_fee`, `repayments`.`renewal_fee` AS `renewal_fee`, `repayments`.`late_fee` AS `late_fee`, `repayments`.`contract_variation_fee` AS `contract_variation_fee`, `repayments`.`cheque_dishonoured_fee` AS `cheque_dishonoured_fee`, `repayments`.`termination_fee` AS `termination_fee`, `repayments`.`legal_fee` AS `legal_fee`, `repayments`.`principal` AS `principal`, `repayments`.`interest` AS `interest`, `repayments`.`compound_interest` AS `compound_interest`, `repayments`.`interest_growth` AS `interest_growth`, `repayments`.`LenderID` AS `LenderID`, `repayments`.`RegularPrincipal` AS `RegularPrincipal`, `repayments`.`RegularInterest` AS `RegularInterest`, `repayments`.`AmountPrincipal` AS `AmountPrincipal`, `repayments`.`late_interest` AS `late_interest`, `repayments`.`receipt_number` AS `receipt_number`, `repayments`.`outstanding_principal` AS `outstanding_principal`, `repayments`.`NoofLateDays` AS `NoofLateDays`, `repayments`.`NoofLatePayment` AS `NoofLatePayment`, `repayments`.`cheque_dishonour` AS `cheque_dishonour`, `repayments`.`payment_type_id` AS `payment_type_id`, `repayments`.`book_id` AS `book_id`, `repayments`.`CollectionFees` AS `CollectionFees`, `repayments`.`deleted` AS `deleted`, `repayments`.`mlcb_paystt` AS `mlcb_paystt` FROM `repayments`union all select `repayments_bdr`.`id` AS `id`,`repayments_bdr`.`disbursement_id` AS `disbursement_id`,`repayments_bdr`.`application_id` AS `application_id`,`repayments_bdr`.`account_number` AS `account_number`,`repayments_bdr`.`date` AS `date`,`repayments_bdr`.`voucher_number` AS `voucher_number`,`repayments_bdr`.`payer_type_id` AS `payer_type_id`,`repayments_bdr`.`other_payer_name` AS `other_payer_name`,`repayments_bdr`.`other_payer_address` AS `other_payer_address`,`repayments_bdr`.`other_payer_uid` AS `other_payer_uid`,`repayments_bdr`.`amount` AS `amount`,`repayments_bdr`.`PaymentMode` AS `PaymentMode`,`repayments_bdr`.`PayDetDate` AS `PayDetDate`,`repayments_bdr`.`transaction_number` AS `transaction_number`,`repayments_bdr`.`PayDetBank` AS `PayDetBank`,`repayments_bdr`.`remarks` AS `remarks`,`repayments_bdr`.`RegularPay` AS `RegularPay`,`repayments_bdr`.`paid_principal` AS `paid_principal`,`repayments_bdr`.`paid_interest` AS `paid_interest`,`repayments_bdr`.`PrincipalAdj` AS `PrincipalAdj`,`repayments_bdr`.`InterestAdj` AS `InterestAdj`,`repayments_bdr`.`AmountAdj` AS `AmountAdj`,`repayments_bdr`.`permit_fee` AS `permit_fee`,`repayments_bdr`.`acceptance_fee` AS `acceptance_fee`,`repayments_bdr`.`renewal_fee` AS `renewal_fee`,`repayments_bdr`.`late_fee` AS `late_fee`,`repayments_bdr`.`contract_variation_fee` AS `contract_variation_fee`,`repayments_bdr`.`cheque_dishonoured_fee` AS `cheque_dishonoured_fee`,`repayments_bdr`.`termination_fee` AS `termination_fee`,`repayments_bdr`.`legal_fee` AS `legal_fee`,`repayments_bdr`.`principal` AS `principal`,`repayments_bdr`.`interest` AS `interest`,`repayments_bdr`.`compound_interest` AS `compound_interest`,`repayments_bdr`.`interest_growth` AS `interest_growth`,`repayments_bdr`.`LenderID` AS `LenderID`,`repayments_bdr`.`RegularPrincipal` AS `RegularPrincipal`,`repayments_bdr`.`RegularInterest` AS `RegularInterest`,`repayments_bdr`.`AmountPrincipal` AS `AmountPrincipal`,`repayments_bdr`.`late_interest` AS `late_interest`,`repayments_bdr`.`receipt_number` AS `receipt_number`,`repayments_bdr`.`outstanding_principal` AS `outstanding_principal`,`repayments_bdr`.`NoofLateDays` AS `NoofLateDays`,`repayments_bdr`.`NoofLatePayment` AS `NoofLatePayment`,`repayments_bdr`.`cheque_dishonour` AS `cheque_dishonour`,`repayments_bdr`.`payment_type_id` AS `payment_type_id`,`repayments_bdr`.`book_id` AS `book_id`,`repayments_bdr`.`CollectionFees` AS `CollectionFees`,`repayments_bdr`.`deleted` AS `deleted`,`repayments_bdr`.`mlcb_paystt` AS `mlcb_paystt` from `repayments_bdr`  ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `identification_types`
--
ALTER TABLE `identification_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `positions`
--
ALTER TABLE `positions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `specialisations`
--
ALTER TABLE `specialisations`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=296;

--
-- AUTO_INCREMENT for table `identification_types`
--
ALTER TABLE `identification_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `positions`
--
ALTER TABLE `positions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `specialisations`
--
ALTER TABLE `specialisations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
COMMIT;

