CREATE TABLE TURBINE_PERMISSION(PERMISSION_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,PERMISSION_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
CREATE TABLE TURBINE_ROLE(ROLE_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ROLE_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
CREATE TABLE TURBINE_GROUP(GROUP_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,GROUP_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
CREATE TABLE TURBINE_USER(USER_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,LOGIN_NAME VARCHAR NOT NULL,PASSWORD_VALUE VARCHAR NOT NULL,FIRST_NAME VARCHAR NOT NULL,LAST_NAME VARCHAR NOT NULL,EMAIL VARCHAR,CONFIRM_VALUE VARCHAR,MODIFIED TIMESTAMP,CREATED TIMESTAMP,LAST_LOGIN TIMESTAMP,DISABLED CHAR,OBJECTDATA BINARY)
CREATE TABLE TURBINE_ROLE_PERMISSION(ROLE_ID INTEGER NOT NULL,PERMISSION_ID INTEGER NOT NULL)
CREATE UNIQUE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION(ROLE_ID,PERMISSION_ID)
CREATE TABLE TURBINE_USER_GROUP_ROLE(USER_ID INTEGER NOT NULL,GROUP_ID INTEGER NOT NULL,ROLE_ID INTEGER NOT NULL)
CREATE UNIQUE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE(USER_ID,GROUP_ID,ROLE_ID)
CREATE TABLE ID_TABLE(ID_TABLE_ID INTEGER NOT NULL PRIMARY KEY,TABLE_NAME VARCHAR NOT NULL,NEXT_ID INTEGER,QUANTITY INTEGER)
CREATE UNIQUE INDEX ID_TABLE_NAME_INDEX ON ID_TABLE(TABLE_NAME)
CREATE TABLE JETSPEED_USER_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,USER_NAME VARCHAR,MEDIA_TYPE VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE BINARY,UNIQUE(PSML_ID),UNIQUE(USER_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
CREATE INDEX JETSPEED_USER_PROFILE_INDEX ON JETSPEED_USER_PROFILE(USER_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
CREATE TABLE JETSPEED_GROUP_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,GROUP_NAME VARCHAR,MEDIA_TYPE VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE BINARY,UNIQUE(PSML_ID),UNIQUE(GROUP_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
CREATE INDEX JETSPEED_GROUP_PROFILE_INDEX ON JETSPEED_GROUP_PROFILE(GROUP_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
CREATE TABLE JETSPEED_ROLE_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,ROLE_NAME VARCHAR,MEDIA_TYPE VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE BINARY,UNIQUE(PSML_ID),UNIQUE(ROLE_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
CREATE INDEX JETSPEED_ROLE_PROFILE_INDEX ON JETSPEED_ROLE_PROFILE(ROLE_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
CREATE TABLE JETSPEED_ANON_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,MEDIA_TYPE VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE BINARY,UNIQUE(PSML_ID),UNIQUE(MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
CREATE INDEX JETSPEED_ANON_PROFILE_INDEX ON JETSPEED_ANON_PROFILE(MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
CREATE TABLE COFFEES(COF_NAME VARCHAR,SUP_ID INTEGER,PRICE FLOAT,SALES INTEGER,TOTAL 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 DAYNAME FOR "org.hsql.Library.dayname"
CREATE ALIAS SPACE FOR "org.hsql.Library.space"
CREATE ALIAS SUBSTRING FOR "org.hsql.Library.substring"
CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
CREATE ALIAS ABS FOR "java.lang.Math.abs"
CREATE ALIAS POWER FOR "java.lang.Math.pow"
CREATE ALIAS CHAR FOR "org.hsql.Library.character"
CREATE ALIAS CONCAT FOR "org.hsql.Library.concat"
CREATE ALIAS PI FOR "org.hsql.Library.pi"
CREATE ALIAS SECOND FOR "org.hsql.Library.second"
CREATE ALIAS TRUNCATE FOR "org.hsql.Library.truncate"
CREATE ALIAS MONTH FOR "org.hsql.Library.month"
CREATE ALIAS LOWER FOR "org.hsql.Library.lcase"
CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
CREATE ALIAS REPEAT FOR "org.hsql.Library.repeat"
CREATE ALIAS DAYOFMONTH FOR "org.hsql.Library.dayofmonth"
CREATE ALIAS TAN FOR "java.lang.Math.tan"
CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
CREATE ALIAS NOW FOR "org.hsql.Library.now"
CREATE ALIAS ACOS FOR "java.lang.Math.acos"
CREATE ALIAS DAYOFWEEK FOR "org.hsql.Library.dayofweek"
CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
CREATE ALIAS DAYOFYEAR FOR "org.hsql.Library.dayofyear"
CREATE ALIAS LCASE FOR "org.hsql.Library.lcase"
CREATE ALIAS WEEK FOR "org.hsql.Library.week"
CREATE ALIAS SOUNDEX FOR "org.hsql.Library.soundex"
CREATE ALIAS ASIN FOR "java.lang.Math.asin"
CREATE ALIAS LOCATE FOR "org.hsql.Library.locate"
CREATE ALIAS EXP FOR "java.lang.Math.exp"
CREATE ALIAS MONTHNAME FOR "org.hsql.Library.monthname"
CREATE ALIAS YEAR FOR "org.hsql.Library.year"
CREATE ALIAS LEFT FOR "org.hsql.Library.left"
CREATE ALIAS ROUNDMAGIC FOR "org.hsql.Library.roundMagic"
CREATE ALIAS BITOR FOR "org.hsql.Library.bitor"
CREATE ALIAS LTRIM FOR "org.hsql.Library.ltrim"
CREATE ALIAS COT FOR "org.hsql.Library.cot"
CREATE ALIAS COS FOR "java.lang.Math.cos"
CREATE ALIAS MOD FOR "org.hsql.Library.mod"
CREATE ALIAS SIGN FOR "org.hsql.Library.sign"
CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
CREATE ALIAS LOG FOR "java.lang.Math.log"
CREATE ALIAS SIN FOR "java.lang.Math.sin"
CREATE ALIAS CURTIME FOR "org.hsql.Library.curtime"
CREATE ALIAS DIFFERENCE FOR "org.hsql.Library.difference"
CREATE ALIAS INSERT FOR "org.hsql.Library.insert"
CREATE ALIAS DATABASE FOR "org.hsql.Library.database"
CREATE ALIAS MINUTE FOR "org.hsql.Library.minute"
CREATE ALIAS HOUR FOR "org.hsql.Library.hour"
CREATE ALIAS IDENTITY FOR "org.hsql.Library.identity"
CREATE ALIAS QUARTER FOR "org.hsql.Library.quarter"
CREATE ALIAS CURDATE FOR "org.hsql.Library.curdate"
CREATE ALIAS BITAND FOR "org.hsql.Library.bitand"
CREATE ALIAS USER FOR "org.hsql.Library.user"
CREATE ALIAS UCASE FOR "org.hsql.Library.ucase"
CREATE ALIAS RTRIM FOR "org.hsql.Library.rtrim"
CREATE ALIAS LOG10 FOR "org.hsql.Library.log10"
CREATE ALIAS RIGHT FOR "org.hsql.Library.right"
CREATE ALIAS ATAN FOR "java.lang.Math.atan"
CREATE ALIAS UPPER FOR "org.hsql.Library.ucase"
CREATE ALIAS ASCII FOR "org.hsql.Library.ascii"
CREATE ALIAS RAND FOR "java.lang.Math.random"
CREATE ALIAS LENGTH FOR "org.hsql.Library.length"
CREATE ALIAS ROUND FOR "org.hsql.Library.round"
CREATE ALIAS REPLACE FOR "org.hsql.Library.replace"
INSERT INTO TURBINE_PERMISSION VALUES(1,'view',NULL)
INSERT INTO TURBINE_PERMISSION VALUES(2,'customize',NULL)
INSERT INTO TURBINE_PERMISSION VALUES(3,'maximize',NULL)
INSERT INTO TURBINE_PERMISSION VALUES(4,'minimize',NULL)
INSERT INTO TURBINE_PERMISSION VALUES(5,'personalize',NULL)
INSERT INTO TURBINE_PERMISSION VALUES(6,'info',NULL)
INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL)
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL)
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL)
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL)
INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL)
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL)
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL)
INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Tommy','Turbine','david@bluesunrise.com','CONFIRMED',NULL,NULL,'2001-11-11 18:45:32.671','F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007678')
INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','david@bluesunrise.com','CONFIRMED',NULL,NULL,'2001-11-11 18:45:41.671','F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a978')
INSERT INTO TURBINE_USER VALUES(2,'anon','anon','Anon','Ymous','sgala@apache.org','CONFIRMED',NULL,NULL,NULL,'F','')
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,4)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,5)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,6)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,1)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,3)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,3,1)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,3,1)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,3,2)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,3,3)
INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',100,10)
INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',120,10)
INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',100,10)
INSERT INTO ID_TABLE VALUES(4,'TURBINE_USER',160,10)
INSERT INTO ID_TABLE VALUES(5,'TURBINE_SCHEDULED_JOB',100,10)
INSERT INTO ID_TABLE VALUES(6,'TURBINE_ROLE_PERMISSION',100,10)
INSERT INTO ID_TABLE VALUES(7,'TURBINE_USER_GROUP_ROLE',100,10)
INSERT INTO ID_TABLE VALUES(8,'JETSPEED_USER_PROFILE',120,10)
INSERT INTO ID_TABLE VALUES(9,'JETSPEED_GROUP_PROFILE',120,10)
INSERT INTO ID_TABLE VALUES(10,'JETSPEED_ROLE_PROFILE',120,10)
INSERT INTO ID_TABLE VALUES(11,'JETSPEED_ANON_PROFILE',120,10)
INSERT INTO COFFEES VALUES('ColombianGrade',5,7.99,1,2)
INSERT INTO COFFEES VALUES('KonaGrade',6,7.99,1,2)
INSERT INTO COFFEES VALUES('FrenchRoastGrade',7,7.99,1,2)
INSERT INTO COFFEES VALUES('HazelNutGrade',8,7.99,1,2)
INSERT INTO COFFEES VALUES('VanillaGrade',9,7.99,1,2)
INSERT INTO COFFEES VALUES('JavaGrade',10,7.99,1,2)
INSERT INTO COFFEES VALUES('IndonesianGrade',11,7.99,1,2)
INSERT INTO COFFEES VALUES('OotyGrade',1,7.99,1,2)
INSERT INTO COFFEES VALUES('KenyanGrade',2,7.99,1,2)
INSERT INTO COFFEES VALUES('JoeGrade',3,7.99,1,2)
INSERT INTO COFFEES VALUES('CantThinkOfAnymoreGrade',4,7.99,1,2)
/*C1*/CONNECT USER sa PASSWORD ""