#
# SQL-CONTAINER 31.05.2007
#

DROP TABLE IF EXISTS l_industries;
CREATE TABLE l_industries (id text,text_de text,text_en text) TYPE=ISAM;

INSERT INTO l_industries (id,text_de,text_en) VALUES ('001000','DE Life Sciences','Life Sciences');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('001001','DE Diagnostics','Diagnostics');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('001002','DE Biotechnology','Biotechnology');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('001003','DE Medical Devices','Medical Devices');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('001004','DE Bioinformatics','Bioinformatics');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('001005','DE Therapeutics','Therapeutics');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('002000','DE Enterprise & IT Software','Enterprise & IT Software');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('002001','DE Security','Security');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('002002','DE Enterprise Infrastructure','Enterprise Infrastructure');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('002003','DE Enterprise Applications','Enterprise Applications');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('002004','DE Design and Development Tools','Design and Development Tools');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003000','DE Communications','Communications');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003001','DE Optical Networking','Optical Networking');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003002','DE Broadband','Broadband');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003003','DE Telecom Applications','Telecom Applications');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003004','DE Semiconductors','Semiconductors');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003005','DE Wireless Applications','Wireless Applications');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003006','DE Wireless Infrastructure','Wireless Infrastructure');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003007','DE Networking','Networking');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('003008','DE VoIP','VoIP');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('004000','DE Internet','Internet');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('004001','DE e-Commerce','e-Commerce');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('004002','DE Internet Infrastructure','Internet Infrastructure');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('004003','DE Internet Services','Internet Services');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('005000','DE Nanotechnology/New Materials','Nanotechnology/New Materials');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('006000','DE Computer/Hardware','Computer/Hardware');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('007000','DE Media/Entertainment','Media/Entertainment');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('008000','DE Electronic/Microelectronic/Sensors','Electronic/Microelectronic/Sensors');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('009000','DE Renewable Energy/Environmental Engineering','Renewable Energy/Environmental Engineering');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('010000','DE Laser/Photonics','Laser/Photonics');
INSERT INTO l_industries (id,text_de,text_en) VALUES ('999000','Others','');


DROP TABLE IF EXISTS l_investortypes;
CREATE TABLE l_investortypes (id text,text_de text,text_en text) TYPE=ISAM;

INSERT INTO l_investortypes (id,text_de,text_en) VALUES ('I1','VC-Investor','EN VC-Investor');
INSERT INTO l_investortypes (id,text_de,text_en) VALUES ('I2','PE-Investor','EN PE-Investor');
INSERT INTO l_investortypes (id,text_de,text_en) VALUES ('I3','PE-/VC-Investor','EN PE-/VC-Investor');
INSERT INTO l_investortypes (id,text_de,text_en) VALUES ('I4','Investmentbank/Investmentboutique','EN Investmentbank/Investmentboutique');
INSERT INTO l_investortypes (id,text_de,text_en) VALUES ('I5','Unternehmen (z.B. Bayer AG, CCR Logistics AG,...)','EN Unternehmen (z.B. Bayer AG, CCR Logistics AG,...)');