BCA3.3.3 数据结构变化登记

* 预备 bca3.3.3 : 将 如下表的 ACTIVITY_ID 字段扩充为 Varchar2(40)
WF_ACT_DESIGNER_INIT_VALUES
WF_ACT_METHOD_REG
WF_ACT_OBJ_REG
WF_ACT_PROP_REG
WF_ACT_REG
WF_ACT_RET_VALUES_REG
WF_NODE
WF_PROP_PLUGIN_INIT_VALUES
WF_PROP_VAL_ENUMS_ON_CHECKBOX
WF_PROP_VAL_ENUMS_ON_COMBOX

alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_METHOD_REG modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_OBJ_REG modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_PROP_REG modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_REG modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_RET_VALUES_REG modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
alter table WF_ACT_DESIGNER_INIT_VALUES modify ACTIVITY_ID VARCHAR2(40);
commit;

评论

6 楼 dfgxpxz 2009-03-04  

BCA:


drop index "Inheritance_100_FK";

drop table WF_SIMPLE_QUEUE_GRP cascade constraints;

/*==============================================================*/
/* Table: WF_SIMPLE_QUEUE_GRP                                   */
/*==============================================================*/
create table WF_SIMPLE_QUEUE_GRP  (
   DOMAIN_ID            INTEGER                         not null,
   QUEUE_GRP_NAME       VARCHAR2(100)                   not null,
   QUEUE_GRP_LABEL      VARCHAR2(100),
   ALLOC_ARITHMETIC     VARCHAR2(100),
   MAX_ACTIVE_SIZE      VARCHAR2(100),
   MAX_QUEUE_SIZE       VARCHAR2(100),
   constraint PK_WF_SIMPLE_QUEUE_GRP primary key (DOMAIN_ID, QUEUE_GRP_NAME)
);

/*==============================================================*/
/* Index: "Inheritance_100_FK"                                  */
/*==============================================================*/
create index "Inheritance_100_FK" on WF_SIMPLE_QUEUE_GRP (
   DOMAIN_ID ASC
);

5 楼 dfgxpxz 2009-03-04  

bcacc:



drop table CMS_CALL_LOG cascade constraints;

/*==============================================================*/
/* Table: CMS_CALL_LOG                                          */
/*==============================================================*/
create table CMS_CALL_LOG  (
   CALL_SERIAL          INTEGER                         not null,
   CALLER_TYPE          INTEGER,
   CALLED_TYPE          INTEGER,
   CALLER_NUMBER        VARCHAR2(40),
   OCALLED              VARCHAR2(40),
   FCALLED              VARCHAR2(40),
   ACD_LOGIN_ID         VARCHAR2(40),
   COMM_RESULT          INTEGER,
   CALL_START_TIME      DATE,
   TALK_START_TIME      DATE,
   CALL_END_TIME        DATE,
   QUEUE_TIME_LEN       INTEGER,
   ANSWER_WAIT_LEN      INTEGER,
   CALLER_CHANNEL       VARCHAR2(40),
   CALLED_CHANNEL       VARCHAR2(40),
   HANGUP_SIDE          INTEGER,
   REC_FILENAME         VARCHAR2(100),
   SERV_SCORE           VARCHAR2(10),
   constraint PK_CMS_CALL_LOG primary key (CALL_SERIAL)
);

comment on table CMS_CALL_LOG is
'通信结果： 1=talked   2=noanswer  3=busy  -1=calledFailure

HANGUP_SIDE : 0=未建立 1=主叫方 2=被叫方';

4 楼 dfgxpxz 2009-01-30  

CDR 结构变化：

drop table CMS_CALL_LOG cascade constraints;

/*==============================================================*/
/* Table: CMS_CALL_LOG                                          */
/*==============================================================*/
create table CMS_CALL_LOG  (
   CALL_SERIAL          INTEGER                         not null,
   CALLER_TYPE          INTEGER,
   CALLED_TYPE          INTEGER,
   CALLER_NUMBER        VARCHAR2(40),
   OCALLED              VARCHAR2(40),
   FCALLED              VARCHAR2(40),
   ACD_LOGIN_ID         VARCHAR2(40),
   COMM_RESULT          INTEGER,
   CALL_START_TIME      DATE,
   TALK_START_TIME      DATE,
   CALL_END_TIME        DATE,
   CALLER_CHANNEL       VARCHAR2(40),
   CALLED_CHANNEL       VARCHAR2(40),
   HANGUP_SIDE          INTEGER,
   REC_FILENAME         VARCHAR2(100),
   SERV_SCORE           VARCHAR2(10),
   constraint PK_CMS_CALL_LOG primary key (CALL_SERIAL)
);

comment on table CMS_CALL_LOG is
'通信结果： 1=talked   2=noanswer  3=busy  -1=calledFailure

HANGUP_SIDE : 0=未建立 1=主叫方 2=被叫方';

3 楼 dfgxpxz 2009-01-20  

bcacc: 扩充字段：

alter table CMS_CALL_LOG modify REC_FILENAME VARCHAR2(100);
alter table ACD_AUSERS add WEICOME_FILE varchar2(100);

2 楼 dfgxpxz 2009-01-18  

* 如下表结构的script字段从 CLOB 换成BLOB: 
WF_ACTIVE_INSTANCE
WF_NODE_METHOD_SAVE
WF_SUBJECT_METHOD_SAVE

1 楼 dfgxpxz 2009-01-14  

建立传真工单表


drop table CMS_FAX_SEND_ORDER cascade constraints;

/*==============================================================*/
/* Table: CMS_FAX_SEND_ORDER                                    */
/*==============================================================*/
create table CMS_FAX_SEND_ORDER  (
   FAX_SEND_SERIAL      INTEGER                         not null,
   CALLED               VARCHAR2(20),
   CALLING              VARCHAR2(20),
   FAX_FILE_NAME        VARCHAR2(200),
   TITLE                VARCHAR2(200),
   BUSINESS_LABEL       VARCHAR2(100),
   FAX_STATE            INTEGER,
   RECV_TIME            DATE,
   ORDERED_SEND_TIME    DATE,
   MAX_TRY_TIMES        INTEGER,
   TRY_TIMES            INTEGER,
   SEND_TIME            DATE,
   SEND_IVR_CHANNEL     VARCHAR2(40),
   FETCHER_SIGN         VARCHAR2(40),
   constraint PK_CMS_FAX_SEND_ORDER primary key (FAX_SEND_SERIAL)
);

drop table CMS_FAX_RECV_ORDER cascade constraints;

/*==============================================================*/
/* Table: CMS_FAX_RECV_ORDER                                    */
/*==============================================================*/
create table CMS_FAX_RECV_ORDER  (
   FAX_RECV_SERIAL      INTEGER                         not null,
   CALLED               VARCHAR2(20),
   CALLING              VARCHAR2(20),
   FAX_FILE_NAME        VARCHAR2(200),
   TITLE                VARCHAR2(200),
   BUSINESS_LABEL       VARCHAR2(100),
   FAX_STATE            INTEGER,
   RECV_TIME            DATE,
   RECV_IVR_CHANNEL     VARCHAR2(40),
   FETCHER_SIGN         VARCHAR2(40),
   FETCH_TIME           DATE,
   constraint PK_CMS_FAX_RECV_ORDER primary key (FAX_RECV_SERIAL)
);