You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2003/02/12 00:49:49 UTC
cvs commit: jakarta-jetspeed/src/sql/external populate-sqlserver.sql
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