connect 'jdbc:rmi://localhost:1099/jdbc:cloudscape:emailList;create=true';

drop table Messages;

create table Messages (
	messageID  INT DEFAULT AUTOINCREMENT PRIMARY KEY,
	creationDate DATE DEFAULT CURRENT_DATE,
	creationTime TIME DEFAULT CURRENT_TIME,
	authorName VARCHAR(20),
	authorEmail VARCHAR(20)
);

disconnect;

