-- Use this file to create the DBAgent test tables when using
-- Oracle or PostgreSQL.
-- Note1: you may need to account for the default way that your
-- particular installation handles SQL dates.
-- Note2: a different file is available for use with MySQL.

drop table empty_table;
drop table simple_table;

create table empty_table(ID INTEGER, NAME VARCHAR(50), ENTRY_DATE DATE);

create table simple_table(ID INTEGER, NAME VARCHAR(50), ENTRY_DATE DATE);
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(1, 'Abe',   '01-Jan-1991');
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(2, 'Betty', '02-Feb-1992');
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(3, 'Cal',   '03-Mar-1993');
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(4, 'Dot',   '04-Apr-1994');
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(5, 'Ed',    '05-May-1995');