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/src/sql/external populate-mysql.sql populate-oracle.sql turbine-mysql.sql turbine-oracle.sql
Date Mon, 25 Jun 2001 05:34:21 GMT
taylor      01/06/24 22:34:21

  Modified:    src/sql/external turbine-mysql.sql turbine-oracle.sql
  Added:       src/sql/external populate-mysql.sql populate-oracle.sql
  Log:
  - turbine-mysql.sql and turbine-oracle.sql are updated to match the latest turbine schema.
  - populate-mysql.sql and populate-oracle.sql are new files, that should be used to populate
your databases.
  
  Sometime soon, we can dump all these scripts and use torque...
  
  Revision  Changes    Path
  1.2       +20 -4     jakarta-jetspeed/src/sql/external/turbine-mysql.sql
  
  Index: turbine-mysql.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-mysql.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- turbine-mysql.sql	2000/12/05 13:26:15	1.1
  +++ turbine-mysql.sql	2001/06/25 05:34:21	1.2
  @@ -55,8 +55,7 @@
       PERMISSION_ID INTEGER NOT NULL,
       PRIMARY KEY(ROLE_ID,PERMISSION_ID),
       FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
  -    FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID),
  -    INDEX ROLE_PERMISSION_INDEX (ROLE_ID, PERMISSION_ID)
  +    FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
   );
   
       
  @@ -96,8 +95,7 @@
       PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID),
       FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
       FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID),
  -    FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_USER_ROLE (ROLE_ID),
  -    INDEX USER_GROUP_ROLE_INDEX (USER_ID, GROUP_ID, ROLE_ID)
  +    FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_USER_ROLE (ROLE_ID)
   );
   
       
  @@ -118,4 +116,22 @@
       EMAIL VARCHAR (99),
       PRIMARY KEY(JOB_ID)
   );
  +
  +
  +-----------------------------------------------------------------------------
  +-- ID_TABLE
  +-----------------------------------------------------------------------------
  +
  +drop table if exists ID_TABLE;
  +
  +CREATE TABLE ID_TABLE
  +(
  +    ID_TABLE_ID INT NOT NULL,
  +    TABLE_NAME VARCHAR (255) NOT NULL,
  +    NEXT_ID INT,
  +    QUANTITY INT,
  +    PRIMARY KEY(ID_TABLE_ID),
  +    UNIQUE (TABLE_NAME)
  +);
  +
   
  
  
  
  1.3       +21 -4     jakarta-jetspeed/src/sql/external/turbine-oracle.sql
  
  Index: turbine-oracle.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-oracle.sql,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- turbine-oracle.sql	2000/12/07 04:46:17	1.2
  +++ turbine-oracle.sql	2001/06/25 05:34:21	1.3
  @@ -153,12 +153,12 @@
       ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_2 FOREIGN KEY (GROUP_ID)
       REFERENCES TURBINE_GROUP (GROUP_ID);
   
  --- ALTER TABLE TURBINE_USER_GROUP_ROLE
  ---    ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLE_ID)
  ---    REFERENCES TURBINE_USER_ROLE (ROLE_ID);
  +ALTER TABLE TURBINE_USER_GROUP_ROLE
  +    ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLE_ID)
  +    REFERENCES TURBINE_ROLE (ROLE_ID);
   
   
  --- CREATE  INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID);
  +-- CREATE UNIQUE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID,
ROLE_ID);
   
   
       
  @@ -183,6 +183,23 @@
       ADD CONSTRAINT TURBINE_SCHEDULED_JOB_PK 
   PRIMARY KEY (JOB_ID);
   
  +-----------------------------------------------------------------------------
  +-- ID_TABLE
  +-----------------------------------------------------------------------------
  +
  +drop table ID_TABLE cascade constraints;
  +-- drop sequence ID_TABLE_SEQ;
   
  +CREATE TABLE ID_TABLE
  +(
  +    ID_TABLE_ID INT NOT NULL,
  +    TABLE_NAME VARCHAR2 (255) NOT NULL,
  +    NEXT_ID INT,
  +    QUANTITY INT,
  +    UNIQUE (TABLE_NAME)
  +);
   
  +ALTER TABLE ID_TABLE
  +    ADD CONSTRAINT ID_TABLE_PK 
  +PRIMARY KEY (ID_TABLE_ID);
   
  
  
  
  1.1                  jakarta-jetspeed/src/sql/external/populate-mysql.sql
  
  Index: populate-mysql.sql
  ===================================================================
  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_GROUP VALUES(1,'Jetspeed',NULL);
  INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
  INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478');
  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(1,1,1);
  INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
  INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,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);
  
  
  
  
  
  1.1                  jakarta-jetspeed/src/sql/external/populate-oracle.sql
  
  Index: populate-oracle.sql
  ===================================================================
  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_GROUP VALUES(1,'Jetspeed',NULL);
  INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478');
  INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','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);
  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 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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message