CREATE TABLE PERMISSION(PERMISSIONID INTEGER NOT NULL IDENTITY PRIMARY KEY,PERMISSION VARCHAR NOT NULL)
CREATE TABLE USERROLE(ROLEID INTEGER NOT NULL IDENTITY PRIMARY KEY,ROLENAME VARCHAR NOT NULL)
CREATE TABLE ROLEPERMISSION(ROLEID INTEGER NOT NULL,PERMISSIONID INTEGER NOT NULL)
CREATE UNIQUE INDEX SYSTEM_CONSTRAINT0 ON ROLEPERMISSION(ROLEID,PERMISSIONID)
CREATE UNIQUE INDEX ROLEID_PERMISSIONID_INDEX ON ROLEPERMISSION(ROLEID,PERMISSIONID)
CREATE TABLE VISITOR(VISITORID INTEGER NOT NULL IDENTITY PRIMARY KEY,LOGINID VARCHAR NOT NULL,PASSWORD_VALUE VARCHAR NOT NULL,FIRST_NAME VARCHAR NOT NULL,LAST_NAME VARCHAR NOT NULL,ADDRESS1 VARCHAR,ADDRESS2 VARCHAR,CITY VARCHAR,STATE VARCHAR,POSTALCODE VARCHAR,COUNTRY VARCHAR,CITIZENSHIP VARCHAR,PHONE VARCHAR,ALTPHONE VARCHAR,FAX VARCHAR,CELL VARCHAR,PAGER VARCHAR,EMAIL VARCHAR,MODIFIED TIMESTAMP,CREATED DATE,LASTLOGIN TIMESTAMP,OBJECTDATA BINARY,PREFIX_NAME VARCHAR,MIDDLE_NAME VARCHAR,SUFFIX_NAME VARCHAR,COMPANY VARCHAR,CONFIRM_VALUE VARCHAR)
CREATE TABLE VISITORROLE(VISITORID INTEGER NOT NULL,ROLEID INTEGER NOT NULL)
CREATE UNIQUE INDEX SYSTEM_CONSTRAINT0 ON VISITORROLE(VISITORID,ROLEID)
CREATE UNIQUE INDEX VISITORID_ROLEID_INDEX ON VISITORROLE(VISITORID,ROLEID)
CREATE TABLE ID_TABLE(ID_TABLE_ID INTEGER NOT NULL PRIMARY KEY,TABLE_NAME VARCHAR NOT NULL,NEXT_ID INTEGER,QUANTITY INTEGER)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
CREATE ALIAS MONTH FOR "org.hsql.Library.month"
CREATE ALIAS ACOS FOR "java.lang.Math.acos"
CREATE ALIAS TRUNCATE FOR "org.hsql.Library.truncate"
CREATE ALIAS TAN FOR "java.lang.Math.tan"
CREATE ALIAS REPLACE FOR "org.hsql.Library.replace"
CREATE ALIAS RIGHT FOR "org.hsql.Library.right"
CREATE ALIAS SIN FOR "java.lang.Math.sin"
CREATE ALIAS ROUNDMAGIC FOR "org.hsql.Library.roundMagic"
CREATE ALIAS SIGN FOR "org.hsql.Library.sign"
CREATE ALIAS LEFT FOR "org.hsql.Library.left"
CREATE ALIAS RAND FOR "java.lang.Math.random"
CREATE ALIAS DATABASE FOR "org.hsql.Library.database"
CREATE ALIAS IDENTITY FOR "org.hsql.Library.identity"
CREATE ALIAS INSERT FOR "org.hsql.Library.insert"
CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
CREATE ALIAS YEAR FOR "org.hsql.Library.year"
CREATE ALIAS LTRIM FOR "org.hsql.Library.ltrim"
CREATE ALIAS HOUR FOR "org.hsql.Library.hour"
CREATE ALIAS SUBSTRING FOR "org.hsql.Library.substring"
CREATE ALIAS CURDATE FOR "org.hsql.Library.curdate"
CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
CREATE ALIAS LCASE FOR "org.hsql.Library.lcase"
CREATE ALIAS SECOND FOR "org.hsql.Library.second"
CREATE ALIAS UPPER FOR "org.hsql.Library.ucase"
CREATE ALIAS SPACE FOR "org.hsql.Library.space"
CREATE ALIAS DAYOFMONTH FOR "org.hsql.Library.dayofmonth"
CREATE ALIAS LOG10 FOR "org.hsql.Library.log10"
CREATE ALIAS UCASE FOR "org.hsql.Library.ucase"
CREATE ALIAS MINUTE FOR "org.hsql.Library.minute"
CREATE ALIAS DAYNAME FOR "org.hsql.Library.dayname"
CREATE ALIAS ROUND FOR "org.hsql.Library.round"
CREATE ALIAS COT FOR "org.hsql.Library.cot"
CREATE ALIAS MOD FOR "org.hsql.Library.mod"
CREATE ALIAS COS FOR "java.lang.Math.cos"
CREATE ALIAS MONTHNAME FOR "org.hsql.Library.monthname"
CREATE ALIAS ABS FOR "java.lang.Math.abs"
CREATE ALIAS ASCII FOR "org.hsql.Library.ascii"
CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
CREATE ALIAS QUARTER FOR "org.hsql.Library.quarter"
CREATE ALIAS DAYOFWEEK FOR "org.hsql.Library.dayofweek"
CREATE ALIAS LOCATE FOR "org.hsql.Library.locate"
CREATE ALIAS POWER FOR "java.lang.Math.pow"
CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
CREATE ALIAS LENGTH FOR "org.hsql.Library.length"
CREATE ALIAS ATAN FOR "java.lang.Math.atan"
CREATE ALIAS RTRIM FOR "org.hsql.Library.rtrim"
CREATE ALIAS BITOR FOR "org.hsql.Library.bitor"
CREATE ALIAS USER FOR "org.hsql.Library.user"
CREATE ALIAS LOWER FOR "org.hsql.Library.lcase"
CREATE ALIAS ASIN FOR "java.lang.Math.asin"
CREATE ALIAS EXP FOR "java.lang.Math.exp"
CREATE ALIAS SOUNDEX FOR "org.hsql.Library.soundex"
CREATE ALIAS PI FOR "org.hsql.Library.pi"
CREATE ALIAS NOW FOR "org.hsql.Library.now"
CREATE ALIAS DAYOFYEAR FOR "org.hsql.Library.dayofyear"
CREATE ALIAS REPEAT FOR "org.hsql.Library.repeat"
CREATE ALIAS CONCAT FOR "org.hsql.Library.concat"
CREATE ALIAS BITAND FOR "org.hsql.Library.bitand"
CREATE ALIAS DIFFERENCE FOR "org.hsql.Library.difference"
CREATE ALIAS CHAR FOR "org.hsql.Library.character"
CREATE ALIAS LOG FOR "java.lang.Math.log"
CREATE ALIAS CURTIME FOR "org.hsql.Library.curtime"
CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
CREATE ALIAS WEEK FOR "org.hsql.Library.week"
INSERT INTO PERMISSION VALUES(1,'view_user')
INSERT INTO PERMISSION VALUES(2,'add_user')
INSERT INTO PERMISSION VALUES(3,'modify_user')
INSERT INTO PERMISSION VALUES(4,'view_group')
INSERT INTO PERMISSION VALUES(5,'add_group')
INSERT INTO PERMISSION VALUES(6,'modify_group')
INSERT INTO PERMISSION VALUES(7,'view_permission')
INSERT INTO PERMISSION VALUES(8,'add_permission')
INSERT INTO PERMISSION VALUES(9,'modify_permission')
INSERT INTO PERMISSION VALUES(10,'view_role')
INSERT INTO PERMISSION VALUES(11,'add_role')
INSERT INTO PERMISSION VALUES(12,'modify_role')
INSERT INTO USERROLE VALUES(1,'turbine_root')
INSERT INTO ROLEPERMISSION VALUES(1,1)
INSERT INTO ROLEPERMISSION VALUES(1,2)
INSERT INTO ROLEPERMISSION VALUES(1,3)
INSERT INTO ROLEPERMISSION VALUES(1,4)
INSERT INTO ROLEPERMISSION VALUES(1,5)
INSERT INTO ROLEPERMISSION VALUES(1,6)
INSERT INTO ROLEPERMISSION VALUES(1,7)
INSERT INTO ROLEPERMISSION VALUES(1,8)
INSERT INTO ROLEPERMISSION VALUES(1,9)
INSERT INTO ROLEPERMISSION VALUES(1,10)
INSERT INTO ROLEPERMISSION VALUES(1,11)
INSERT INTO ROLEPERMISSION VALUES(1,12)
INSERT INTO VISITOR VALUES(0,'turbine','turbine','turbine','turbine',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
INSERT INTO VISITORROLE VALUES(0,1)
INSERT INTO ID_TABLE VALUES(1,'Permission',20,10)
INSERT INTO ID_TABLE VALUES(2,'UserRole',20,10)
INSERT INTO ID_TABLE VALUES(3,'Visitor',20,10)
INSERT INTO ID_TABLE VALUES(4,'Jobentry',20,10)