portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed/webapp/WEB-INF/db jetspeed.properties jetspeed.script
Date Thu, 07 Jun 2001 06:28:02 GMT
taylor      01/06/06 23:28:02

  Modified:    webapp/WEB-INF/db jetspeed.properties jetspeed.script
  Log:
  added admin role, and role-permissions for the admin
  made the role-permission index on turbine-role-permission unique
  
  Revision  Changes    Path
  1.4       +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.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- jetspeed.properties	2001/06/04 07:53:20	1.3
  +++ jetspeed.properties	2001/06/07 06:27:59	1.4
  @@ -1,4 +1,4 @@
   #Hypersonic SQL database
  -#Mon Jun 04 00:42:52 PDT 2001
  +#Wed Jun 06 23:22:17 PDT 2001
   version=1.4
   modified=no
  
  
  
  1.4       +15 -5     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.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- jetspeed.script	2001/06/04 07:53:20	1.3
  +++ jetspeed.script	2001/06/07 06:28:00	1.4
  @@ -1,12 +1,12 @@
   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_ROLE_PERMISSION(ROLE_ID INTEGER NOT NULL,PERMISSION_ID INTEGER NOT
NULL)
  -CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION(ROLE_ID,PERMISSION_ID)
   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,LASTLOGIN TIMESTAMP,OBJECTDATA
BINARY)
   CREATE TABLE TURBINE_USER_GROUP_ROLE(USER_ID INTEGER NOT NULL,GROUP_ID INTEGER NOT NULL,ROLE_ID
INTEGER NOT NULL)
   CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE(USER_ID,GROUP_ID,ROLE_ID)
   CREATE TABLE TURBINE_SCHEDULED_JOB(JOB_ID INTEGER NOT NULL,SECOND INTEGER NOT NULL,MINUTE
INTEGER NOT NULL,HOUR INTEGER NOT NULL,WEEK_DAY INTEGER NOT NULL,DAY_OF_MONTH INTEGER NOT
NULL,TASK VARCHAR NOT NULL,EMAIL VARCHAR)
  +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)
   GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
   GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC
   CREATE USER SA PASSWORD "" ADMIN
  @@ -83,13 +83,23 @@
   INSERT INTO TURBINE_PERMISSION VALUES(6,'detach',NULL)
   INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL)
   INSERT INTO TURBINE_ROLE VALUES(1,'authenticated_user',NULL)
  +INSERT INTO TURBINE_ROLE VALUES(2,'administrator',NULL)
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL)
  +INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Turbine','Turbine Tester','david@bluesunrise.com','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_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_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_USER VALUES(0,'turbine','turbine','Turbine','Turbine 2','david@bluesunrise.com','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000000e6e1b60d247874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000004478')
  -INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin',NULL,'CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000000e6c291f20f7874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000a78')
  -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1)
  +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)
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message