[overlord-commits] Overlord SVN: r418 - cdl/trunk/runtime/jbossesb-assembly/src/main/resources/cdl-sql.

Author: jeff.yuchang Date: 2008-10-31 06:40:23 -0400 (Fri, 31 Oct 2008) New Revision: 418 Added: cdl/trunk/runtime/jbossesb-assembly/src/main/resources/cdl-sql/cdl.mysqldb.sql Log: *[SOAG-71] Add mysql specific sql. Added: cdl/trunk/runtime/jbossesb-assembly/src/main/resources/cdl-sql/cdl.mysqldb.sql =================================================================== --- cdl/trunk/runtime/jbossesb-assembly/src/main/resources/cdl-sql/cdl.mysqldb.sql (rev 0) +++ cdl/trunk/runtime/jbossesb-assembly/src/main/resources/cdl-sql/cdl.mysqldb.sql 2008-10-31 10:40:23 UTC (rev 418) @@ -0,0 +1,23 @@ + create table CDL_EPRS (ID bigint not null auto_increment,name varchar(255),EPR text, SESSION_ID bigint, primary key (ID)); + + create table CDL_IDENTITY (ID bigint not null auto_increment,TYPE varchar(255),PROPERTY_VALUE varchar(255),SERVICE_NAME varchar(255),SESSION_ID bigint not null,primary key (ID)); + + create table CDL_JOIN_STATES (ID bigint not null auto_increment,CATEGORY varchar(255) not null,NAME varchar(255) not null,ITEM_COUNT integer,SESSION_ID bigint,primary key (ID)); + + create table CDL_SCHEDULE_ITEM (ID bigint not null auto_increment,CATEGORY varchar(255) not null,NAME varchar(255) not null,SESSION_ID bigint,primary key (ID)); + + create table CDL_SESSION (SESSION_ID bigint not null auto_increment,STATUS varchar(255),POJO_CLASS varchar(255),SERVICE_NAME varchar(255),CONVERSATION_TYPE varchar(255),Business_OBJECT blob,PARENT_ID bigint,primary key (SESSION_ID)); + + create table CDL_SESSION_PROPERTY (SESSION_ID bigint not null,property_value varchar(255),property_key varchar(255),primary key (SESSION_ID, property_key)); + + alter table CDL_EPRS add index FKC42217E04BA6EBA4 (SESSION_ID), add constraint FKC42217E04BA6EBA4 foreign key (SESSION_ID) references CDL_SESSION (SESSION_ID); + + alter table CDL_IDENTITY add index FK41FEEA724BA6EBA4 (SESSION_ID),add constraint FK41FEEA724BA6EBA4 foreign key (SESSION_ID) references CDL_SESSION (SESSION_ID); + + alter table CDL_JOIN_STATES add index FKBBDE50834BA6EBA4 (SESSION_ID), add constraint FKBBDE50834BA6EBA4 foreign key (SESSION_ID) references CDL_SESSION (SESSION_ID); + + alter table CDL_SCHEDULE_ITEM add index FKA52316874BA6EBA4 (SESSION_ID), add constraint FKA52316874BA6EBA4 foreign key (SESSION_ID) references CDL_SESSION (SESSION_ID); + + alter table CDL_SESSION add index FKD597E4263FFBD10 (PARENT_ID), add constraint FKD597E4263FFBD10 foreign key (PARENT_ID) references CDL_SESSION (SESSION_ID); + + alter table CDL_SESSION_PROPERTY add index FK3C6B324BA6EBA4 (SESSION_ID), add constraint FK3C6B324BA6EBA4 foreign key (SESSION_ID) references CDL_SESSION (SESSION_ID);