## Use this file to create the DBAgent test tables when using MySQL.
## Note: a different file is available for use with Oracle or PostgreSQL.

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',   '1991-01-01');
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(2, 'Betty', '1992-02-02');
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(3, 'Cal',   '1993-03-03');
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(4, 'Dot',   '1994-04-04');
insert into simple_table(ID, NAME, ENTRY_DATE) VALUES(5, 'Ed',    '1995-05-05');