I had to tweak the sql above a little bit for MS SQLServer. This worked for me.
SET IDENTITY_INSERT JBPM_ID_GROUP ON;
| INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES
(1,'G','sales','organisation',NULL);
| INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES
(2,'G','admin','security-role',NULL);
| INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES
(3,'G','user','security-role',NULL);
| INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES
(4,'G','hr','organisation',NULL);
| INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES
(5,'G','manager','security-role',NULL);
| SET IDENTITY_INSERT JBPM_ID_GROUP OFF;
|
| SET IDENTITY_INSERT JBPM_ID_USER ON;
| INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES
(1,'U','user','user(a)sample.domain','user');
| INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES
(2,'U','manager','manager(a)sample.domain','manager');
| INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES
(3,'U','admin','admin(a)sample.domain','admin');
| INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES
(4,'U','shipper','shipper(a)sample.domain','shipper');
| SET IDENTITY_INSERT JBPM_ID_USER OFF;
|
| SET IDENTITY_INSERT JBPM_ID_MEMBERSHIP ON;
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(1,'M',NULL,NULL,2,4);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(2,'M',NULL,NULL,3,4);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(3,'M',NULL,NULL,4,4);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(4,'M',NULL,NULL,4,3);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(5,'M',NULL,NULL,1,3);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(6,'M',NULL,NULL,2,3);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(7,'M',NULL,NULL,3,3);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(8,'M',NULL,NULL,3,2);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(9,'M',NULL,NULL,2,2);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(10,'M',NULL,NULL,2,5);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(11,'M',NULL,'boss',2,1);
| INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES
(12,'M',NULL,NULL,1,1);
| SET IDENTITY_INSERT JBPM_ID_MEMBERSHIP OFF;
|
Scott
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134849#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...