drop table HAPI_user\g
create table HAPI_user (
	login char(250),
	pswd char(250),
	fname char(250),
	lname char(250),
	email char(250)
)\g

drop table HAPI_permission\g
create table HAPI_permission (
	login char(250),
	application char(250),
	accessLevel int
)\g

drop table HAPI_session\g
create table HAPI_session (
	sessionID char(250),
	login char(250),
	creationTime timestamp
)\g

drop table HAPI_registration\g
create table HAPI_registration (
	application char(250),
	functionName char(250),
	description longtext,
	URL char(250),
	accessLevel int
)\g

insert into HAPI_user (login, pswd) values ('tester','tester')\g

insert into HAPI_permission (login,	application,accessLevel) values ('tester','HAPItest_test1',9)\g

insert into HAPI_permission (login,	application,accessLevel) values ('tester','HAPItest_test2',8)\g