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-db2.sql populate-mysql.sql populate-oracle.sql populate-postgres.sql populate-sybase.sql turbine-db2.sql turbine-hypersonic.sql turbine-mysql.sql turbine-oracle.sql turbine-postgres.sql turbine-sybase.sql
Date Mon, 25 Feb 2002 04:15:44 GMT
taylor      02/02/24 20:15:44

  Modified:    src/sql/external populate-db2.sql populate-mysql.sql
                        populate-oracle.sql populate-postgres.sql
                        populate-sybase.sql turbine-db2.sql
                        turbine-hypersonic.sql turbine-mysql.sql
                        turbine-oracle.sql turbine-postgres.sql
                        turbine-sybase.sql
  Log:
  - added 'disabled' column to db
  
  Revision  Changes    Path
  1.3       +2 -2      jakarta-jetspeed/src/sql/external/populate-db2.sql
  
  Index: populate-db2.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-db2.sql,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- populate-db2.sql	7 Dec 2001 17:05:04 -0000	1.2
  +++ populate-db2.sql	25 Feb 2002 04:15:43 -0000	1.3
  @@ -10,8 +10,8 @@
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',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_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
  +INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,'F','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);
  
  
  
  1.5       +2 -2      jakarta-jetspeed/src/sql/external/populate-mysql.sql
  
  Index: populate-mysql.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-mysql.sql,v
  retrieving revision 1.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- populate-mysql.sql	7 Dec 2001 17:50:13 -0000	1.4
  +++ populate-mysql.sql	25 Feb 2002 04:15:43 -0000	1.5
  @@ -10,8 +10,8 @@
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',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_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
  +INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,'F','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);
  
  
  
  1.3       +2 -2      jakarta-jetspeed/src/sql/external/populate-oracle.sql
  
  Index: populate-oracle.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-oracle.sql,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- populate-oracle.sql	30 Jul 2001 04:37:38 -0000	1.2
  +++ populate-oracle.sql	25 Feb 2002 04:15:43 -0000	1.3
  @@ -10,8 +10,8 @@
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',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','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_USER VALUES(0,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478');
  +INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F','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);
  
  
  
  1.4       +2 -2      jakarta-jetspeed/src/sql/external/populate-postgres.sql
  
  Index: populate-postgres.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-postgres.sql,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- populate-postgres.sql	7 Dec 2001 17:05:04 -0000	1.3
  +++ populate-postgres.sql	25 Feb 2002 04:15:43 -0000	1.4
  @@ -10,8 +10,8 @@
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
  -INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,NULL);
  -INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,NULL);
  +INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F',NULL);
  +INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,'F',NULL);
   INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1);
   INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2);
   INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3);
  
  
  
  1.3       +2 -2      jakarta-jetspeed/src/sql/external/populate-sybase.sql
  
  Index: populate-sybase.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-sybase.sql,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- populate-sybase.sql	7 Dec 2001 17:05:04 -0000	1.2
  +++ populate-sybase.sql	25 Feb 2002 04:15:43 -0000	1.3
  @@ -10,8 +10,8 @@
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',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_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
  +INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,'F','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);
  
  
  
  1.3       +1 -0      jakarta-jetspeed/src/sql/external/turbine-db2.sql
  
  Index: turbine-db2.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-db2.sql,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- turbine-db2.sql	24 Aug 2001 07:36:16 -0000	1.2
  +++ turbine-db2.sql	25 Feb 2002 04:15:43 -0000	1.3
  @@ -117,6 +117,7 @@
       MODIFIED DATE,
       CREATED DATE,
       LAST_LOGIN DATE,
  +    DISABLED VARCHAR(1),
       OBJECTDATA BLOB (16777215),
       UNIQUE (LOGIN_NAME)
   );
  
  
  
  1.3       +1 -0      jakarta-jetspeed/src/sql/external/turbine-hypersonic.sql
  
  Index: turbine-hypersonic.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-hypersonic.sql,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- turbine-hypersonic.sql	24 Aug 2001 07:36:16 -0000	1.2
  +++ turbine-hypersonic.sql	25 Feb 2002 04:15:43 -0000	1.3
  @@ -68,6 +68,7 @@
       MODIFIED timestamp,
       CREATED timestamp,
       LAST_LOGIN timestamp,
  +    DISABLED CHAR,
       OBJECTDATA BINARY,
       PRIMARY KEY(USER_ID),
       UNIQUE (LOGIN_NAME)
  
  
  
  1.5       +1 -0      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.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- turbine-mysql.sql	24 Aug 2001 07:36:16 -0000	1.4
  +++ turbine-mysql.sql	25 Feb 2002 04:15:43 -0000	1.5
  @@ -76,6 +76,7 @@
       MODIFIED TIMESTAMP,
       CREATED TIMESTAMP,
       LAST_LOGIN TIMESTAMP,
  +    DISABLED VARCHAR(1),
       OBJECTDATA MEDIUMBLOB,
       PRIMARY KEY(USER_ID),
       UNIQUE (LOGIN_NAME)
  
  
  
  1.6       +1 -0      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.5
  retrieving revision 1.6
  diff -u -r1.5 -r1.6
  --- turbine-oracle.sql	24 Aug 2001 07:36:16 -0000	1.5
  +++ turbine-oracle.sql	25 Feb 2002 04:15:43 -0000	1.6
  @@ -116,6 +116,7 @@
       MODIFIED DATE,
       CREATED DATE,
       LAST_LOGIN DATE,
  +    DISABLED CHAR(1),
       OBJECTDATA LONG RAW,
       UNIQUE (LOGIN_NAME)
   );
  
  
  
  1.4       +1 -0      jakarta-jetspeed/src/sql/external/turbine-postgres.sql
  
  Index: turbine-postgres.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-postgres.sql,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- turbine-postgres.sql	24 Aug 2001 07:36:16 -0000	1.3
  +++ turbine-postgres.sql	25 Feb 2002 04:15:43 -0000	1.4
  @@ -80,6 +80,7 @@
       MODIFIED timestamp,
       CREATED timestamp,
       LAST_LOGIN timestamp,
  +    DISABLED VARCHAR(1),
       OBJECTDATA oid,
       PRIMARY KEY(USER_ID),
       UNIQUE (LOGIN_NAME)
  
  
  
  1.3       +1 -0      jakarta-jetspeed/src/sql/external/turbine-sybase.sql
  
  Index: turbine-sybase.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-sybase.sql,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- turbine-sybase.sql	24 Aug 2001 07:36:16 -0000	1.2
  +++ turbine-sybase.sql	25 Feb 2002 04:15:43 -0000	1.3
  @@ -124,6 +124,7 @@
       MODIFIED TIMESTAMP,
       CREATED TIMESTAMP,
       LAST_LOGIN TIMESTAMP,
  +    DISABLED VARCHAR(1),
       OBJECTDATA CHAR(10),
       CONSTRAINT TURBINE_USER_PK PRIMARY KEY(USER_ID),
       UNIQUE (LOGIN_NAME)
  
  
  

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


Mime
View raw message