--DROP TABLE ELGA_Medientyp CASCADE; CREATE TABLE ELGA_Medientyp ( ELGA_Medientyp_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_Medientyp (ELGA_Medientyp_id, code, codeSystem, displayName) VALUES (1, 'text/xml', '1.2.840.10003.5.109', 'Mime Type text/xml'); INSERT INTO ELGA_Medientyp (ELGA_Medientyp_id, code, codeSystem, displayName) VALUES (2, 'application/pdf', '1.2.840.10003.5.109', 'Mime Type application/pdf'); INSERT INTO ELGA_Medientyp (ELGA_Medientyp_id, code, codeSystem, displayName) VALUES (3, 'image/png', '1.2.840.10003.5.109', 'Mime Type image/png'); INSERT INTO ELGA_Medientyp (ELGA_Medientyp_id, code, codeSystem, displayName) VALUES (4, 'image/jpeg', '1.2.840.10003.5.109', 'Mime Type image/jpeg'); INSERT INTO ELGA_Medientyp (ELGA_Medientyp_id, code, codeSystem, displayName) VALUES (5, 'image/gif', '1.2.840.10003.5.109', 'Mime Type image/gif'); INSERT INTO ELGA_Medientyp (ELGA_Medientyp_id, code, codeSystem, displayName) VALUES (6, 'video/mpeg', '1.2.840.10003.5.109', 'Mime Type video/mpeg'); INSERT INTO ELGA_Medientyp (ELGA_Medientyp_id, code, codeSystem, displayName) VALUES (7, 'audio/mpeg', '1.2.840.10003.5.109', 'Mime Type audio/mpeg');