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-sqlserver.sql
Date Tue, 11 Feb 2003 23:49:49 GMT
taylor      2003/02/11 15:49:49

  Modified:    src/sql/external populate-sqlserver.sql
  Log:
  patch from Eric Pugh for bugs 16524 and 15507 -- SQL Server external SQL population
  
  Revision  Changes    Path
  1.4       +0 -3      jakarta-jetspeed/src/sql/external/populate-sqlserver.sql
  
  Index: populate-sqlserver.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-sqlserver.sql,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- populate-sqlserver.sql	23 Jan 2003 07:24:28 -0000	1.3
  +++ populate-sqlserver.sql	11 Feb 2003 23:49:48 -0000	1.4
  @@ -43,13 +43,10 @@
   INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(3,1);
   INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(3,6);
   
  -
  -SET IDENTITY_INSERT TURBINE_USER_GROUP_ROLE  ON
   INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)  VALUES(2,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)  VALUES(1,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)  VALUES(1,1,2);
   INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)  VALUES(3,1,3);
  -SET IDENTITY_INSERT TURBINE_USER_GROUP_ROLE  OFF
   
   SET IDENTITY_INSERT COFFEES  ON
   INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(1,'ColombianGrade',5,7.99E0,1,2)
  
  
  

---------------------------------------------------------------------
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