; First load the JDBC driver and open a database.
d com.lutris.instantdb.jdbc.idbDriver;
o jdbc:idb=sample.prp;

; Create the table and its index
e DROP TABLE EMPLOYEE;
e CREATE Table EMPLOYEE ( 	UserName varchar2(50) PRIMARY KEY, 
				Password varchar2(50), 
				FirstName varchar2(50),
				LastName varchar2(50),
				Dept varchar2(50),
				EmpDate date,
				EmailAddr varchar2(50),
				ModDate date );

e DROP TABLE EMPLOYEEPROJECTS;
e CREATE Table EMPLOYEEPROJECTS ( UserName varchar2(50), 
				  ProjectName varchar2(50));

e DROP TABLE INPUTTEST;
e CREATE Table INPUTTEST ( MyDate date, 
			   MyNumber double);


c close;