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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
