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);
Show replies by date