Duh - I just saw the DataModel Wiki http://wiki.jboss.org/wiki/Wiki.jsp?page=Jbpm31DataModel , somehow I missed it on the Wiki page.
I have corrected my earlier script, for SQLServer, by adding the rest of the tables from the Execution Model. Note that JBPM_MESSAGE is not part of my 3.0.1 installation, so is omitted here. By way of apology, here is the final script for SQLServer users, note the skirting of a FK. | delete from JBPM_LOG | delete from JBPM_TIMER | delete from JBPM_MODULEINSTANCE | delete from JBPM_TOKENVARIABLEMAP | delete from JBPM_TASKINSTANCE | delete from JBPM_VARIABLEINSTANCE | | -- Must temporarily drop FK from Token -> ProcInstance | if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TOKEN_PROCINST]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) | ALTER TABLE [dbo].[JBPM_TOKEN] DROP CONSTRAINT FK_TOKEN_PROCINST | | -- Clear tables | delete from JBPM_PROCESSINSTANCE | delete from JBPM_TOKEN | | -- Re-add dropped FKs | ALTER TABLE [dbo].[JBPM_TOKEN] ADD | CONSTRAINT [FK_TOKEN_PROCINST] FOREIGN KEY | ( | [PROCESSINSTANCE_] | ) REFERENCES [dbo].[JBPM_PROCESSINSTANCE] ( | [ID_] | ) | | delete from JBPM_SWIMLANEINSTANCE | delete from JBPM_POOLEDACTOR | delete from JBPM_TASKACTORPOOL | delete from JBPM_COMMENT | delete from JBPM_RUNTIMEACTION | delete from JBPM_BYTEBLOCK | delete from JBPM_BYTEARRAY | Comments welcome. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3959928#3959928 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3959928 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user