--DROP TABLE DocumentEntry.languageCode CASCADE; CREATE TABLE DocumentEntry.languageCode ( DocumentEntry.languageCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (1, 'ar', '2.16.840.1.113883.6.316', 'Arabic'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (2, 'bn', '2.16.840.1.113883.6.316', 'Bengali'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (3, 'cs', '2.16.840.1.113883.6.316', 'Czech'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (4, 'da', '2.16.840.1.113883.6.316', 'Danish'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (5, 'de', '2.16.840.1.113883.6.316', 'German'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (6, 'de-AT', '2.16.840.1.113883.6.316', 'German (Austria)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (7, 'de-CH', '2.16.840.1.113883.6.316', 'German (Switzerland)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (8, 'de-DE', '2.16.840.1.113883.6.316', 'German (Germany)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (9, 'el', '2.16.840.1.113883.6.316', 'Greek'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (10, 'en', '2.16.840.1.113883.6.316', 'English'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (11, 'en-AU', '2.16.840.1.113883.6.316', 'English (Australia)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (12, 'en-CA', '2.16.840.1.113883.6.316', 'English (Canada)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (13, 'en-GB', '2.16.840.1.113883.6.316', 'English (Great Britain)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (14, 'en-IN', '2.16.840.1.113883.6.316', 'English (India)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (15, 'en-NZ', '2.16.840.1.113883.6.316', 'English (New Zealand)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (16, 'en-SG', '2.16.840.1.113883.6.316', 'English (Singapore)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (17, 'en-US', '2.16.840.1.113883.6.316', 'English (United States)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (18, 'es', '2.16.840.1.113883.6.316', 'Spanish'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (19, 'es-AR', '2.16.840.1.113883.6.316', 'Spanish (Argentina)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (20, 'es-ES', '2.16.840.1.113883.6.316', 'Spanish (Spain)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (21, 'es-UY', '2.16.840.1.113883.6.316', 'Spanish (Uruguay)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (22, 'fi', '2.16.840.1.113883.6.316', 'Finnish'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (23, 'fr', '2.16.840.1.113883.6.316', 'French'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (24, 'fr-BE', '2.16.840.1.113883.6.316', 'French (Belgium)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (25, 'fr-CH', '2.16.840.1.113883.6.316', 'French (Switzerland)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (26, 'fr-FR', '2.16.840.1.113883.6.316', 'French (France)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (27, 'fy', '2.16.840.1.113883.6.316', 'Frysian'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (28, 'fy-NL', '2.16.840.1.113883.6.316', 'Frysian (Netherlands)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (29, 'hi', '2.16.840.1.113883.6.316', 'Hindi'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (30, 'hr', '2.16.840.1.113883.6.316', 'Croatian'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (31, 'it', '2.16.840.1.113883.6.316', 'Italian'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (32, 'it-CH', '2.16.840.1.113883.6.316', 'Italian (Switzerland)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (33, 'it-IT', '2.16.840.1.113883.6.316', 'Italian (Italy)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (34, 'ja', '2.16.840.1.113883.6.316', 'Japanese'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (35, 'ko', '2.16.840.1.113883.6.316', 'Korean'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (36, 'nl', '2.16.840.1.113883.6.316', 'Dutch'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (37, 'nl-BE', '2.16.840.1.113883.6.316', 'Dutch (Belgium)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (38, 'nl-NL', '2.16.840.1.113883.6.316', 'Dutch (Netherlands)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (39, 'no', '2.16.840.1.113883.6.316', 'Norwegian'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (40, 'no-NO', '2.16.840.1.113883.6.316', 'Norwegian (Norway)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (41, 'pa', '2.16.840.1.113883.6.316', 'Punjabi'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (42, 'pl', '2.16.840.1.113883.6.316', 'Polish'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (43, 'pt', '2.16.840.1.113883.6.316', 'Portuguese'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (44, 'pt-BR', '2.16.840.1.113883.6.316', 'Portuguese (Brazil)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (45, 'rm', '2.16.840.1.113883.6.316', 'Romansh'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (46, 'ru', '2.16.840.1.113883.6.316', 'Russian'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (47, 'ru-RU', '2.16.840.1.113883.6.316', 'Russian (Russia)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (48, 'sr', '2.16.840.1.113883.6.316', 'Serbian'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (49, 'sr-RS', '2.16.840.1.113883.6.316', 'Serbian (Serbia)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (50, 'sv', '2.16.840.1.113883.6.316', 'Swedish'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (51, 'sv-SE', '2.16.840.1.113883.6.316', 'Swedish (Sweden)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (52, 'te', '2.16.840.1.113883.6.316', 'Telegu'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (53, 'zh', '2.16.840.1.113883.6.316', 'Chinese'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (54, 'zh-CN', '2.16.840.1.113883.6.316', 'Chinese (China)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (55, 'zh-HK', '2.16.840.1.113883.6.316', 'Chinese (Hong Kong)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (56, 'zh-SG', '2.16.840.1.113883.6.316', 'Chinese (Singapore)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (57, 'zh-TW', '2.16.840.1.113883.6.316', 'Chinese (Taiwan)'); INSERT INTO DocumentEntry.languageCode (DocumentEntry.languageCode_id, code, codeSystem, displayName) VALUES (58, 'OTHER', '2.16.756.5.30.1.127.3.10.12', 'Other language');