taylor 01/06/10 23:54:50
Modified: webapp/WEB-INF/db jetspeed.properties jetspeed.script
Log:
added ID_TABLE for generation of unique ids on security tables
Revision Changes Path
1.6 +1 -1 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties
Index: jetspeed.properties
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- jetspeed.properties 2001/06/07 07:26:59 1.5
+++ jetspeed.properties 2001/06/11 06:54:47 1.6
@@ -1,4 +1,4 @@
#Hypersonic SQL database
-#Thu Jun 07 00:26:05 PDT 2001
+#Sun Jun 10 23:54:01 PDT 2001
version=1.4
modified=no
1.6 +11 -2 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script
Index: jetspeed.script
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- jetspeed.script 2001/06/07 07:27:01 1.5
+++ jetspeed.script 2001/06/11 06:54:48 1.6
@@ -7,6 +7,8 @@
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)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
@@ -86,8 +88,8 @@
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL)
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL)
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL)
-INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Turbine','Turbine
Tester','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000000e6f1624d6c7874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000005978')
-INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Jetspeed','Admin',NULL,'CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000000e6f160a1437874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000002078')
+INSERT INTO TURBINE_USER
VALUES(0,'turbine','turbine','Tommy','Turbine','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478')
+INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Jetspeed','Admin','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778')
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3)
@@ -104,3 +106,10 @@
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 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',120,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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
