bca3.3.2升级日志

bcacc 数据模型变化：


alter table IVR_CHANNEL_PARA
   drop constraint FK_IVR_CHAN_INHERITAN_IVR_CHAN;

drop index IVR_CHANNEL_PARA_PK;

drop index "Inheritance_9_FK";

drop table IVR_CHANNEL_PARA cascade constraints;

/*==============================================================*/
/* Table: IVR_CHANNEL_PARA                                      */
/*==============================================================*/
create table IVR_CHANNEL_PARA  (
   IVR_CHANNEL_ID       INTEGER                         not null,
   PARA_NAME            VARCHAR2(100)                   not null,
   PARA_VALUE           VARCHAR2(1000),
   constraint PK_IVR_CHANNEL_PARA primary key (IVR_CHANNEL_ID, PARA_NAME)
);

comment on table IVR_CHANNEL_PARA is
'3.3.2 加入';

/*==============================================================*/
/* Index: IVR_CHANNEL_PARA_PK                                   */
/*==============================================================*/
create unique index IVR_CHANNEL_PARA_PK on IVR_CHANNEL_PARA (
   IVR_CHANNEL_ID ASC,
   PARA_NAME ASC
);

/*==============================================================*/
/* Index: "Inheritance_9_FK"                                    */
/*==============================================================*/
create index "Inheritance_9_FK" on IVR_CHANNEL_PARA (
   IVR_CHANNEL_ID ASC
);