--DROP TABLE ELGA_URLScheme CASCADE; CREATE TABLE ELGA_URLScheme ( ELGA_URLScheme_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (1, 'fax', '2.16.840.1.113883.5.143', 'Fax'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (2, 'file', '2.16.840.1.113883.5.143', 'File'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (3, 'ftp', '2.16.840.1.113883.5.143', 'FTP'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (4, 'mllp', '2.16.840.1.113883.5.143', 'HL7 Minimal Lower Layer Protocol'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (5, 'http', '2.16.840.1.113883.5.143', 'HTTP'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (6, 'mailto', '2.16.840.1.113883.5.143', 'Mailto'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (7, 'me', '1.2.40.0.34.5.55', 'ME-Nummer'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (8, 'modem', '2.16.840.1.113883.5.143', 'Modem'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (9, 'nfs', '2.16.840.1.113883.5.143', 'NFS'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (10, 'tel', '2.16.840.1.113883.5.143', 'Telephone'); INSERT INTO ELGA_URLScheme (ELGA_URLScheme_id, code, codeSystem, displayName) VALUES (11, 'telnet', '2.16.840.1.113883.5.143', 'Telnet');