drop table db..deptemails;

create table db..deptemails(displayorder integer, dname varchar, demail varchar);

insert into db..deptemails (displayorder, dname, demail) values (1, 'Testing', 'thaynes@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (0, 'Product Sales', 'sales@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (1, 'General Information', 'general.information@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (2, 'Product Quote', 'sales@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (3, 'Product Availability', 'product.availability@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (4, 'EMEA Customer Services', 'emea.customer.services@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (5, 'Account Manager', 'sales@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (6, 'Technical Support', 'technical.support@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (7, 'Download Wizard', 'downwiz@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (8, 'License Terms', 'sales@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (9, 'Training and Professional Services', 'training@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (10, 'Human Resources', 'human.resources@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (11, 'Discussion/News administrator', 'discussion@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (12, 'Support phpBB Boards Team', 'boards@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (13, 'OpenLink Webmaster', 'webmaster@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (14, 'iODBC Webmaster', 'webmaster@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (15, 'iODBC Manager', 'iodbc@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (16, 'Virtuoso Open Source Maintainer', 'vos.admin@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (17, 'Virtuoso Documentation Maintainer', 'virtuoso.docs@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (18, 'UDA Documentation Maintainer', 'uda.docs@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (19, 'OpenLink Data-Spaces (ODS)', 'ods@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (20, 'OAT Team', 'oat.admin@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (21, 'JDBCBench Administrator', 'jdbc-bench@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (22, 'ODBC Benchmark Maintainer', 'odbc-bench@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (23, 'OpenLink Data Explorer', 'ode@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (24, 'Ruby on Rails ODBC Adapter', 'odbc-rails@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (25, 'SOAP', 'soap@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (26, 'SPARQL', 'sparql@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (27, 'FOAF', 'foaf@openlinksw.com');
insert into db..deptemails (displayorder, dname, demail) values (28, 'ATOM', 'atom@openlinksw.com');