/*update new nationality*/

DROP TABLE IF EXISTS nationality;

CREATE TABLE nationality (

name VARCHAR(255) DEFAULT NULL,

nationality VARCHAR(2) NOT NULL,

nhso_code VARCHAR(3) DEFAULT NULL,

hos_guid VARCHAR(255) DEFAULT NULL,

zip09_code VARCHAR(255) DEFAULT NULL,

inv_unuse VARCHAR(255) DEFAULT NULL,

PRIMARY KEY ( nationality ),

KEY nation ( nationality , nhso_code ) USING BTREE

) ENGINE=MYISAM DEFAULT CHARSET=tis620;

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไม่ระบุ', '00', '999', '{E95D8B90-34F0-4E88-8CA4-6DBAF5207BD6}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บริติช(อังกฤษ,สก็อตแลนด์)', '01', '126', '{AC8B82F1-BA37-4C5B-B93A-13551E7E30C0}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โปรตุเกส', '02', '002', '{783E4E62-B573-409D-AE6C-50E1087A9E2A}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ดัตช์', '03', '003', '{086E3DC7-0BA8-452F-95EB-874F3AE8D443}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เยอรมัน', '04', '004', '{2A37FFE3-D78C-4D91-B12C-A2DFEB659D0F}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ผรั่งเศส', '05', '005', '{0E574354-8BAB-46DD-A67E-45AA526CD037}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เดนมาร์ก', '06', '006', '{B59B0A27-3750-464F-B594-AB5647973140}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('สวีเดน', '07', '007', '{4E162AEA-8CC5-4244-86EB-1F45075B2AC9}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('สวีสเซอร์แลนด์', '08', '008', '{DA7EDACE-E09B-46BD-BE01-97DFD28F941A}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อิตาลี', '09', '009', '{6D0FBFD2-68D5-4B41-8C87-4DF8C75F5FC0}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('นอร์เวย์', '10', '010', '{F08B023B-1AFB-4C37-A571-23FB573FADE7}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ออสเตรีย', '11', '011', '{1A67748F-0129-45BE-8AB0-390664505803}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไอริช', '12', '012', '{835C908A-BC47-4F83-A1C4-1D5BDB6D1E14}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ฟินแลนด์', '13', '013', '{B32B2DD8-2FEA-42DC-9CCE-78C9FB1E5BA0}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เบลเยี่ยม', '14', '014', '{143FDA8B-EADA-4559-BA56-C7FC95DBC0E4}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('สเปน', '15', '015', '{A6CD7772-265B-4FDA-A875-99CF772FFE52}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('รัสเซีย', '16', '016', '{615AD10F-87BA-4D78-9380-5B2D6FD58CB0}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โปแลนด์', '17', '017', '{8A54B419-FBFB-4C9C-B708-E6E0B8EEDDF2}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เช็ก', '18', '018', '{81F4B0BF-0DBE-4AEE-BA44-4635AC7A42D1}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ฮังการี', '19', '019', '{C10BB291-4F5F-415B-8FD1-12490BBF3DB6}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อัฟกัน', '1A', '100', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บาห์เรน', '1B', '101', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ภูฏาน', '1C', '102', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จอร์แดน', '1D', '103', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เกาหลีเหนือ', '1E', '104', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มัลดีฟ', '1F', '105', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มองโกเลีย', '1G', '106', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โอมาน', '1H', '107', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('กาตาร์', '1J', '108', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เยเมน', '1K', '109', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)เยเมน(ใต้)**', '1L', '110', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('หมู่เกาะฟิจิ', '1M', '111', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คิริบาส', '1N', '112', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('นาอูรู', '1P', '113', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('หมู่เกาะโซโลมอน', '1R', '114', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ตองก้า', '1S', '115', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ตูวาลู', '1T', '116', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('วานูอาตู', '1U', '117', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ซามัว', '1V', '118', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อันดอร์รา', '1W', '120', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)เยอรมนีตะวันออก**', '1X', '121', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไอซ์แลนด์', '1Y', '122', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ลิกเตนสไตน์', '1Z', '123', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('กรีก', '20', '020', '{05616695-F289-4B96-BEEB-530A4E4B33CF}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ยูโกสลาฟ', '21', '021', '{70573FD4-900D-4802-9D97-F0684F709141}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ลักเซมเบอร์ก', '22', '022', '{BC16BA97-EC8C-4A9D-8ABB-05C0F7522A49}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('วาติกัน', '23', '023', '{E6618C19-D83B-49A7-9082-559E74308C68}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มอลต้า', '24', '024', '{A828ED03-1B2A-480C-AB46-3352D8349952}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อัลบาเนีย', '25', '119', '{ADBB3F0B-5495-47F7-8CD7-27D2A4C14C16}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บัลกาเรีย', '26', '026', '{6D4A6D65-7108-4D2F-AB7F-F8ECE9B2C80C}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โรมาเนีย', '27', '027', '{6080E551-1F3C-4B6A-9B1F-9333E228C813}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไซปรัส', '28', '028', '{7F3AA254-ADD7-4768-86A3-FB49EBDFC676}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อเมริกา', '29', '029', '{D322ECB0-DAC7-4ECE-86ED-1B8BE098D03E}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ลีซู', '2A', '025', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โมนาโก', '2B', '124', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ซานมารีโน', '2C', '125', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('แอลจีเรีย', '2D', '127', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('แองโกลา', '2E', '128', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เบนิน', '2F', '129', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บอตสวานา', '2G', '130', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บูร์กินาฟาโซ', '2H', '131', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บุรุนดี', '2J', '132', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('แคเมอรูน', '2K', '133', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เคปเวิร์ด', '2L', '134', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('แอฟริกากลาง', '2M', '135', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ชาด', '2N', '136', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คอโมโรส', '2P', '137', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คองโก', '2R', '138', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไอโวเรี่ยน', '2S', '139', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จิบูตี', '2T', '140', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อิเควทอเรียลกินี', '2U', '141', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('กาบอง', '2V', '142', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('แกมเบีย', '2W', '143', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('กานา', '2X', '144', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('กินีบีสเซา', '2Y', '145', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เลโซโท', '2Z', '146', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คานาดา', '30', '030', '{6C691D06-8AD0-4B19-8788-D45FC627EBFB}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เม็กซิโก', '31', '031', '{2D600145-102E-4D45-8CE1-56C2F72B0BAE}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คิวบา', '32', '032', '{C25599D1-CF89-416F-877F-F014881F2A79}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อาร์เจนตินา', '33', '033', '{8D95FE01-33C0-448F-9C07-00AB00208F0D}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บราซิล', '34', '034', '{9CB72714-A497-4A6A-9068-F134C111108D}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ชิลี', '35', '035', '{C11637ED-96DF-40CF-BA94-1B1D213A7596}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เอกวาดอร์', '36', '191', '{2A91FD87-AF36-4A2C-9964-88302353E97D}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โคลัมเบีย', '37', '037', '{FA92277F-7701-4968-BB4E-74B9465347A4}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บาร์เบโดส', '38', '174', '{9CBEE40D-6952-4AD7-9329-33FB184498D5}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เปรู', '39', '039', '{40566529-9EA4-4AB7-B9DD-5C3333E52B64}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ลั๊ว', '3A', '038', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไลบีเรีย', '3B', '147', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ลิเบีย', '3C', '148', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มาลากาซี', '3D', '149', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มาลาวี', '3E', '150', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มาลี', '3F', '151', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มอริเตเนีย', '3G', '152', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มอริเชียส', '3H', '153', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โมร็อกโก', '3J', '154', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โมซัมบิก', '3K', '155', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไนเจอร์', '3L', '156', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('รวันดา', '3M', '157', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เซาโตเมและปรินซิเป', '3N', '158', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เซเนกัล', '3P', '159', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เซเชลส์', '3R', '160', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เซียร์ราลีโอน', '3S', '161', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โซมาลี', '3T', '162', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('สวาซี', '3U', '164', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('แทนซาเนีย', '3V', '165', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โตโก', '3W', '166', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ยูกันดา', '3X', '168', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ซาอีร์', '3Y', '169', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('แซมเบีย', '3Z', '170', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ปานามา', '40', '040', '{34AB5CEE-E36C-4542-AE8E-4345CB349884}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อุรุกวัย', '41', '041', '{990DABE8-CF6C-4194-8106-85F78B1DF2DD}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เวเนซุเอลา', '42', '042', '{B07DD6F8-FD2F-4A45-A91C-C678650E450D}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เปอร์โตริโก้', '43', '043', '{6A90F987-106F-467A-A21B-D8BF975EA010}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จีน', '44', '044', '{72FCA149-D652-442B-81E0-B15E57BF10DD}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อินเดีย', '45', '045', '{1A5E97C6-2778-4403-BF78-77C9227FDF87}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เวียดนาม', '46', '046', '{CB100BA6-81AA-4A1C-BD63-41DC2AADFA19}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ญี่ปุ่น', '47', '047', '{3B0E604A-B500-41F8-81B0-324EBAFC4A34}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('พม่า', '48', '048', '{84368BDD-BBC1-4083-8E96-2C3DF8B03BEB}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ฟิลิปปินส์', '49', '049', '{8E19738D-EF1D-4F88-98FD-6D422019FEEE}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ซิมบับเว', '4A', '171', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('แอนติกาและบาร์บูดา', '4B', '172', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บาฮามาส', '4C', '173', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เบลิซ', '4D', '175', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คอสตาริกา', '4E', '176', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โดมินิกา', '4F', '177', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โดมินิกัน', '4G', '178', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เอลซัลวาดอร์', '4H', '179', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เกรเนดา', '4J', '180', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('กัวเตมาลา', '4K', '181', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เฮติ', '4L', '182', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ฮอนดูรัส', '4M', '183', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จาเมกา', '4N', '184', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('นิการากัว', '4P', '185', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เซนต์คิตส์และเนวิส', '4R', '186', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เซนต์ลูเซีย', '4S', '187', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เซนต์วินเซนต์และเกรนาดีนส์', '4T', '188', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ตรินิแดดและโตเบโก', '4U', '189', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โบลีเวีย', '4V', '190', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('กายอานา', '4W', '192', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ปารากวัย', '4X', '193', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ซูรินาเม', '4Y', '194', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คะฉิ่น', '4Z', '196', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มาเลเซีย', '50', '050', '{35D72A17-10CE-41A4-BB86-56269CB58EAC}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อินโดนีเซีย', '51', '051', '{F9C811EC-47E0-40FA-8100-FAF59156D2D1}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ปากีสถาน', '52', '052', '{F36AA69A-0342-415A-8E22-10AF79D99EAD}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เกาหลีใต้', '53', '053', '{C18B41BC-E58D-4439-8C99-AE847EB1B208}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('สิงคโปร์', '54', '054', '{3C285D54-7986-42EE-8CE4-CBB16E05A426}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เนปาล', '55', '055', '{EE4809CE-9FF7-4477-BC4B-0DCFE326A301}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ลาว', '56', '056', '{AB3A4BC8-201A-404E-AE4C-075A69D2FEE1}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('กัมพูชา', '57', '057', '{520C6BA9-7181-43A7-BADB-D73D2090564E}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ศรีลังกา', '58', '058', '{95DD4096-332A-4094-BDD7-1BB2CDCB8E17}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ซาอุดิอาระเบีย', '59', '059', '{B71F6FE7-C27D-48CD-82E1-B00ACA0C3407}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ว้า', '5A', '197', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไทยใหญ่', '5B', '198', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไทยลื้อ', '5C', '199', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ขมุ', '5D', '200', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ตองสู', '5E', '201', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)เงี้ยว**', '5F', '202', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ละว้า', '5G', '203', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)แม้ว*', '5H', '204', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ปะหร่อง', '5J', '205', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ถิ่น', '5K', '206', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ปะโอ', '5L', '207', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มอญ', '5M', '208', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มลาบรี', '5N', '209', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)เฮาะ**', '5P', '210', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)สก๊อตแลนด์**', '5R', '211', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จีน(จีนฮ่ออิสระ)', '5S', '212', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)จีนอพยพ**', '5T', '213', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จีน(จีนฮ่ออพยพ)', '5U', '214', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)ไต้หวัน**', '5V', '215', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ยูเครน', '5W', '216', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)อาณานิคมอังกฤษ**', '5X', '217', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)ดูไบ**', '5Y', '218', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จีน(ฮ่องกง)', '5Z', '219', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อิสราเอล', '60', '060', '{2528E431-6566-4F27-86C0-106C606D266F}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เลบานอน', '61', '061', '{8A7C5BF8-5A0D-42D8-8138-B8BC891C59DF}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อิหร่าน', '62', '062', '{173B750D-6804-4AFD-8491-94F357B919C7}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ตุรกี', '63', '063', '{16E35421-6D15-4D95-8C08-E623193754A2}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บังคลาเทศ', '64', '064', '{F5FC95B7-3D07-422E-90C7-696AA88D22FD}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อาหรับ', '65', '195', '{98B66FE6-73DD-4EA3-B10F-2DCA975EEDFF}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ซีเรีย', '66', '066', '{FAB3A256-167C-4458-828F-8D4EF9CB972E}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อิรัค', '67', '067', '{AADA35F3-A442-48F2-9851-C4B2F99A82D2}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คูเวต', '68', '068', '{B8859203-FAD7-4E6D-A3E0-D486F4492D61}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บรูไน', '69', '069', '{AD6B0F0D-D537-4CFD-B830-B6C74F2E40CF}', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ถูกถอนสัญชาติ', '6A', '065', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จีน(ไต้หวัน)', '6B', '220', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('โครเอเชีย', '6C', '221', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('(ยกเลิก)บริทิธ**', '6D', '222', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คาซัค', '6E', '223', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อาร์เมเนีย', '6F', '224', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อาเซอร์ไบจาน', '6G', '225', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('จอร์เจีย', '6H', '226', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('คีร์กีซ', '6J', '227', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ทาจิก', '6K', '228', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อุซเบก', '6L', '229', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('หมู่เกาะมาร์แชลล์', '6M', '230', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ไมโครนีเซีย', '6N', '231', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ปาเลา', '6P', '232', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เบลารุส', '6R', '233', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('บอสเนียและเฮอร์เซโกวีนา', '6S', '234', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เติร์กเมน', '6T', '235', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('เอสโตเนีย', '6U', '236', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ลัตเวีย', '6V', '237', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('ลิทัวเนีย', '6W', '238', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มาซิโดเนีย', '6X', '239', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('มอลโดวา', '6Y', '240', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('สโลวัก', '6Z', '241', '', '', '');

INSERT IGNORE INTO nationality ( name , nationality , nhso_code , hos_guid , zip09_code , inv_unuse ) VALUES ('อาฟริกาใต้', '70', '070', '{EAA7F393-A5E7-4EBF-A337-CB46922FD383}', '', '');

INSERT IGNORE INTO nationality ( name