Author: heiko.braun(a)jboss.com Date: 2010-09-28 06:27:45 -0400 (Tue, 28 Sep 2010) New Revision: 991 Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql Log: Update DDL for BPAF tables. Add missing SQL dialects Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql 2010-09-27 09:10:08 UTC (rev 990) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql 2010-09-28 10:27:45 UTC (rev 991) @@ -242,4 +242,32 @@ ID bigint generated by default as identity, VERSION bigint, primary key (ID) -); \ No newline at end of file +); + +create table BPAF_EVENT ( + EID bigint generated by default as identity, + ACTIVITY_DEFINITION_ID varchar(255), + ACTIVITY_INSTANCE_ID varchar(255), + ACTIVITY_NAME varchar(255), + CURRENT_STATE varchar(255), + PREVIOUS_STATE varchar(255), + PROCESS_DEFINITION_ID varchar(255), + PROCESS_INSTANCE_ID varchar(255), + PROCESS_NAME varchar(255), + SERVER_ID varchar(255), + TIMESTAMP bigint, + primary key (EID) + ); + + create table BPAF_EVENT_DATA ( + TID bigint generated by default as identity, + NAME varchar(255), + VALUE varchar(255), + EVENT_ID bigint, + primary key (TID) + ); + + alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-09-27 09:10:08 UTC (rev 990) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-09-28 10:27:45 UTC (rev 991) @@ -242,4 +242,33 @@ ID bigint generated by default as identity, VERSION bigint, primary key (ID) -); \ No newline at end of file +); + + + create table BPAF_EVENT ( + EID bigint generated by default as identity (start with 1), + ACTIVITY_DEFINITION_ID varchar(255), + ACTIVITY_INSTANCE_ID varchar(255), + ACTIVITY_NAME varchar(255), + CURRENT_STATE varchar(255), + PREVIOUS_STATE varchar(255), + PROCESS_DEFINITION_ID varchar(255), + PROCESS_INSTANCE_ID varchar(255), + PROCESS_NAME varchar(255), + SERVER_ID varchar(255), + TIMESTAMP bigint, + primary key (EID) + ); + + create table BPAF_EVENT_DATA ( + TID bigint generated by default as identity (start with 1), + NAME varchar(255), + VALUE varchar(255), + EVENT_ID bigint, + primary key (TID) + ); + + alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-09-27 09:10:08 UTC (rev 990) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-09-28 10:27:45 UTC (rev 991) @@ -247,4 +247,34 @@ ID bigint not null auto_increment, VERSION bigint, primary key (ID) -) type=InnoDB; \ No newline at end of file +) type=InnoDB; + + create table BPAF_EVENT ( + EID bigint not null auto_increment, + ACTIVITY_DEFINITION_ID varchar(255), + ACTIVITY_INSTANCE_ID varchar(255), + ACTIVITY_NAME varchar(255), + CURRENT_STATE varchar(255), + PREVIOUS_STATE varchar(255), + PROCESS_DEFINITION_ID varchar(255), + PROCESS_INSTANCE_ID varchar(255), + PROCESS_NAME varchar(255), + SERVER_ID varchar(255), + TIMESTAMP bigint, + primary key (EID) + ); + + create table BPAF_EVENT_DATA ( + TID bigint not null auto_increment, + NAME varchar(255), + VALUE varchar(255), + EVENT_ID bigint, + primary key (TID) + ); + + alter table BPAF_EVENT_DATA + add index FK3E83D1BCDA848C8 (EVENT_ID), + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT (EID); + Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-09-27 09:10:08 UTC (rev 990) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-09-28 10:27:45 UTC (rev 991) @@ -245,3 +245,33 @@ ); create sequence bpel_sequence; + + create table BPAF_EVENT ( + EID number(19,0) not null, + ACTIVITY_DEFINITION_ID varchar2(255 char), + ACTIVITY_INSTANCE_ID varchar2(255 char), + ACTIVITY_NAME varchar2(255 char), + CURRENT_STATE varchar2(255 char), + PREVIOUS_STATE varchar2(255 char), + PROCESS_DEFINITION_ID varchar2(255 char), + PROCESS_INSTANCE_ID varchar2(255 char), + PROCESS_NAME varchar2(255 char), + SERVER_ID varchar2(255 char), + TIMESTAMP number(19,0), + primary key (EID) + ); + + create table BPAF_EVENT_DATA ( + TID number(19,0) not null, + NAME varchar2(255 char), + VALUE varchar2(255 char), + EVENT_ID number(19,0), + primary key (TID) + ); + + alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT; + + create sequence hibernate_sequence; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-09-27 09:10:08 UTC (rev 990) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-09-28 10:27:45 UTC (rev 991) @@ -244,4 +244,32 @@ primary key (ID) ); -create sequence bpel_sequence; \ No newline at end of file +create sequence bpel_sequence; + +create table BPAF_EVENT ( + EID bigint generated by default as identity, + ACTIVITY_DEFINITION_ID varchar(255), + ACTIVITY_INSTANCE_ID varchar(255), + ACTIVITY_NAME varchar(255), + CURRENT_STATE varchar(255), + PREVIOUS_STATE varchar(255), + PROCESS_DEFINITION_ID varchar(255), + PROCESS_INSTANCE_ID varchar(255), + PROCESS_NAME varchar(255), + SERVER_ID varchar(255), + TIMESTAMP bigint, + primary key (EID) + ); + + create table BPAF_EVENT_DATA ( + TID bigint generated by default as identity, + NAME varchar(255), + VALUE varchar(255), + EVENT_ID bigint, + primary key (TID) + ); + + alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-09-27 09:10:08 UTC (rev 990) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-09-28 10:27:45 UTC (rev 991) @@ -243,3 +243,32 @@ VERSION numeric(19,0) null, primary key (ID) ); + +create table BPAF_EVENT ( + EID numeric(19,0) identity not null, + ACTIVITY_DEFINITION_ID varchar(255) null, + ACTIVITY_INSTANCE_ID varchar(255) null, + ACTIVITY_NAME varchar(255) null, + CURRENT_STATE varchar(255) null, + PREVIOUS_STATE varchar(255) null, + PROCESS_DEFINITION_ID varchar(255) null, + PROCESS_INSTANCE_ID varchar(255) null, + PROCESS_NAME varchar(255) null, + SERVER_ID varchar(255) null, + TIMESTAMP numeric(19,0) null, + primary key (EID) + ); + + create table BPAF_EVENT_DATA ( + TID numeric(19,0) identity not null, + NAME varchar(255) null, + VALUE varchar(255) null, + EVENT_ID numeric(19,0) null, + primary key (TID) + ); + + alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT; +