- 浏览: 14955 次
- 性别:
- 来自: 北京
最近访客 更多访客>>
文章分类
最新评论
-
dfgxpxz:
2009年11月25日 星期3 郑州
----------- ...
BCA3.3.5工作日志 -
dfgxpxz:
2009年11月24日 星期2 郑州
----------- ...
BCA3.3.5工作日志 -
dfgxpxz:
BCA:
drop index "Inherit ...
BCA3.3.3 数据结构变化登记 -
dfgxpxz:
bcacc:
drop table CMS_CALL_L ...
BCA3.3.3 数据结构变化登记 -
dfgxpxz:
CDR 结构变化:
drop table CMS_CALL ...
BCA3.3.3 数据结构变化登记
建立用户:(system登录)
CREATE USER "BCACC" PROFILE "DEFAULT"
IDENTIFIED BY "4" DEFAULT TABLESPACE "BCA"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "BCACC" WITH ADMIN OPTION;
GRANT "CONNECT" TO "BCACC" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "BCACC" WITH ADMIN OPTION;
建表:(bcacc登录)
/*==============================================================*/
/* DBMS name: ORACLE Version 9i2 */
/* Created on: 2008-6-2 15:34:20 */
/*==============================================================*/
alter table ACD_USER_GRP_MAPS
drop constraint FK_ACD_USER_INH;
alter table ACD_USER_GRP_MAPS
drop constraint FK_ACD_USER_IN2;
alter table ACD_CH_GRP_MAPS
drop constraint FK_ACD_CH_G_INH;
alter table ACD_CH_GRP_MAPS
drop constraint FK_ACD_CH_G_IN2;
alter table IVR_CHANNELS
drop constraint FK_IVR_CHAN_REL;
drop index "Inheritance_6_FK";
drop index "Inheritance_7_FK";
drop index "Relationship_3_FK";
drop index "Inheritance_4_FK";
drop index "Inheritance_5_FK";
drop index "Relationship_2_FK";
drop table ACD_ARITHMETIC cascade constraints;
drop table ACD_AUSERS cascade constraints;
drop table ACD_CH_GRP_MAPS cascade constraints;
drop table ACD_GROUP cascade constraints;
drop table ACD_USER_GRP_MAPS cascade constraints;
drop table IVR_CHANNELS cascade constraints;
drop table IVR_HOSTS cascade constraints;
drop table IVR_REFUSE_CALLED cascade constraints;
drop table IVR_REFUSE_CALL_TIMESPAN cascade constraints;
/*==============================================================*/
/* Table: ACD_ARITHMETIC */
/*==============================================================*/
create table ACD_ARITHMETIC (
ACD_ARITHMETIC_ID INTEGER not null,
ARITHMETIC_NAME VARCHAR2(40),
IMPL_CLASS VARCHAR2(100),
DESIGN_CLASS VARCHAR2(100),
HELP_INFO BLOB,
constraint PK_ACD_ARITHMET primary key (ACD_ARITHMETIC_ID)
);
/*==============================================================*/
/* Table: ACD_AUSERS */
/*==============================================================*/
create table ACD_AUSERS (
ACD_USER_ID INTEGER not null,
ACD_LOGIN_ID VARCHAR2(40),
ACD_USER_NAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
HELP_INFO BLOB,
constraint PK_ACD_AUSERS primary key (ACD_USER_ID)
);
/*==============================================================*/
/* Table: ACD_CH_GRP_MAPS */
/*==============================================================*/
create table ACD_CH_GRP_MAPS (
ACD_GRP_ID INTEGER not null,
IVR_CHANNEL_ID INTEGER not null,
IVR_HOST_ID INTEGER,
CHANNEL_NAME VARCHAR2(100) not null,
CHANNEL_NO INTEGER not null,
THREAD_SLEEP_LEN INTEGER,
SIGNALING_TYPE VARCHAR2(20),
SITUATION_PROPERTIES VARCHAR2(1000),
AHOST_IP VARCHAR2(40),
AHOST_PHONE_NUMBER VARCHAR2(20),
CHANNEL_ACT_TYPE INTEGER,
HELP_INFO BLOB,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
constraint PK_ACD_CH_GRP_M primary key (ACD_GRP_ID, IVR_CHANNEL_ID)
);
/*==============================================================*/
/* Index: "Inheritance_6_FK" */
/*==============================================================*/
create index "Inheritance_6_FK" on ACD_CH_GRP_MAPS (
ACD_GRP_ID ASC
);
/*==============================================================*/
/* Index: "Inheritance_7_FK" */
/*==============================================================*/
create index "Inheritance_7_FK" on ACD_CH_GRP_MAPS (
IVR_CHANNEL_ID ASC
);
/*==============================================================*/
/* Table: ACD_GROUP */
/*==============================================================*/
create table ACD_GROUP (
ACD_GRP_ID INTEGER not null,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
constraint PK_ACD_GROUP primary key (ACD_GRP_ID)
);
/*==============================================================*/
/* Index: "Relationship_3_FK" */
/*==============================================================*/
create index "Relationship_3_FK" on ACD_GROUP (
ACD_ARITHMETIC_ID ASC
);
/*==============================================================*/
/* Table: ACD_USER_GRP_MAPS */
/*==============================================================*/
create table ACD_USER_GRP_MAPS (
ACD_USER_ID INTEGER not null,
ACD_GRP_ID INTEGER not null,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
ACD_LOGIN_ID VARCHAR2(40),
ACD_USER_NAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
HELP_INFO BLOB,
SKILL_WEIGHT NUMBER(5,2),
MONITOR_FLAG INTEGER,
constraint PK_ACD_USER_GRP primary key (ACD_USER_ID, ACD_GRP_ID)
);
/*==============================================================*/
/* Index: "Inheritance_4_FK" */
/*==============================================================*/
create index "Inheritance_4_FK" on ACD_USER_GRP_MAPS (
ACD_USER_ID ASC
);
/*==============================================================*/
/* Index: "Inheritance_5_FK" */
/*==============================================================*/
create index "Inheritance_5_FK" on ACD_USER_GRP_MAPS (
ACD_GRP_ID ASC
);
/*==============================================================*/
/* Table: IVR_CHANNELS */
/*==============================================================*/
create table IVR_CHANNELS (
IVR_CHANNEL_ID INTEGER not null,
IVR_HOST_ID INTEGER,
CHANNEL_NAME VARCHAR2(100) not null,
CHANNEL_NO INTEGER not null,
THREAD_SLEEP_LEN INTEGER,
SIGNALING_TYPE VARCHAR2(20),
SITUATION_PROPERTIES VARCHAR2(1000),
AHOST_IP VARCHAR2(40),
AHOST_PHONE_NUMBER VARCHAR2(20),
CHANNEL_ACT_TYPE INTEGER,
HELP_INFO BLOB,
constraint PK_IVR_CHANNELS primary key (IVR_CHANNEL_ID)
);
comment on table IVR_CHANNELS is
'CHANNEL_ACT_TYPE: 1 CTI 2 录音';
/*==============================================================*/
/* Index: "Relationship_2_FK" */
/*==============================================================*/
create index "Relationship_2_FK" on IVR_CHANNELS (
IVR_HOST_ID ASC
);
/*==============================================================*/
/* Table: IVR_HOSTS */
/*==============================================================*/
create table IVR_HOSTS (
IVR_HOST_ID INTEGER not null,
BCA_AGENT_NAME VARCHAR2(40),
HOST_IP VARCHAR2(20),
HOST_NAME VARCHAR2(100),
FAX_CHANNELS INTEGER,
HELP_INFO BLOB,
constraint PK_IVR_HOSTS primary key (IVR_HOST_ID)
);
/*==============================================================*/
/* Table: IVR_REFUSE_CALLED */
/*==============================================================*/
create table IVR_REFUSE_CALLED (
CALLED_LEADING VARCHAR2(20) not null,
SWITCH_ENABLE INTEGER,
constraint PK_IVR_REFUSE_2 primary key (CALLED_LEADING)
);
/*==============================================================*/
/* Table: IVR_REFUSE_CALL_TIMESPAN */
/*==============================================================*/
create table IVR_REFUSE_CALL_TIMESPAN (
REFUSE_IDX INTEGER not null,
START_TIME VARCHAR2(5),
END_TIME VARCHAR2(5),
SWITCH_ENABLE INTEGER,
constraint PK_IVR_REFUSE_C primary key (REFUSE_IDX)
);
CREATE USER "BCACC" PROFILE "DEFAULT"
IDENTIFIED BY "4" DEFAULT TABLESPACE "BCA"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "BCACC" WITH ADMIN OPTION;
GRANT "CONNECT" TO "BCACC" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "BCACC" WITH ADMIN OPTION;
建表:(bcacc登录)
/*==============================================================*/
/* DBMS name: ORACLE Version 9i2 */
/* Created on: 2008-6-2 15:34:20 */
/*==============================================================*/
alter table ACD_USER_GRP_MAPS
drop constraint FK_ACD_USER_INH;
alter table ACD_USER_GRP_MAPS
drop constraint FK_ACD_USER_IN2;
alter table ACD_CH_GRP_MAPS
drop constraint FK_ACD_CH_G_INH;
alter table ACD_CH_GRP_MAPS
drop constraint FK_ACD_CH_G_IN2;
alter table IVR_CHANNELS
drop constraint FK_IVR_CHAN_REL;
drop index "Inheritance_6_FK";
drop index "Inheritance_7_FK";
drop index "Relationship_3_FK";
drop index "Inheritance_4_FK";
drop index "Inheritance_5_FK";
drop index "Relationship_2_FK";
drop table ACD_ARITHMETIC cascade constraints;
drop table ACD_AUSERS cascade constraints;
drop table ACD_CH_GRP_MAPS cascade constraints;
drop table ACD_GROUP cascade constraints;
drop table ACD_USER_GRP_MAPS cascade constraints;
drop table IVR_CHANNELS cascade constraints;
drop table IVR_HOSTS cascade constraints;
drop table IVR_REFUSE_CALLED cascade constraints;
drop table IVR_REFUSE_CALL_TIMESPAN cascade constraints;
/*==============================================================*/
/* Table: ACD_ARITHMETIC */
/*==============================================================*/
create table ACD_ARITHMETIC (
ACD_ARITHMETIC_ID INTEGER not null,
ARITHMETIC_NAME VARCHAR2(40),
IMPL_CLASS VARCHAR2(100),
DESIGN_CLASS VARCHAR2(100),
HELP_INFO BLOB,
constraint PK_ACD_ARITHMET primary key (ACD_ARITHMETIC_ID)
);
/*==============================================================*/
/* Table: ACD_AUSERS */
/*==============================================================*/
create table ACD_AUSERS (
ACD_USER_ID INTEGER not null,
ACD_LOGIN_ID VARCHAR2(40),
ACD_USER_NAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
HELP_INFO BLOB,
constraint PK_ACD_AUSERS primary key (ACD_USER_ID)
);
/*==============================================================*/
/* Table: ACD_CH_GRP_MAPS */
/*==============================================================*/
create table ACD_CH_GRP_MAPS (
ACD_GRP_ID INTEGER not null,
IVR_CHANNEL_ID INTEGER not null,
IVR_HOST_ID INTEGER,
CHANNEL_NAME VARCHAR2(100) not null,
CHANNEL_NO INTEGER not null,
THREAD_SLEEP_LEN INTEGER,
SIGNALING_TYPE VARCHAR2(20),
SITUATION_PROPERTIES VARCHAR2(1000),
AHOST_IP VARCHAR2(40),
AHOST_PHONE_NUMBER VARCHAR2(20),
CHANNEL_ACT_TYPE INTEGER,
HELP_INFO BLOB,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
constraint PK_ACD_CH_GRP_M primary key (ACD_GRP_ID, IVR_CHANNEL_ID)
);
/*==============================================================*/
/* Index: "Inheritance_6_FK" */
/*==============================================================*/
create index "Inheritance_6_FK" on ACD_CH_GRP_MAPS (
ACD_GRP_ID ASC
);
/*==============================================================*/
/* Index: "Inheritance_7_FK" */
/*==============================================================*/
create index "Inheritance_7_FK" on ACD_CH_GRP_MAPS (
IVR_CHANNEL_ID ASC
);
/*==============================================================*/
/* Table: ACD_GROUP */
/*==============================================================*/
create table ACD_GROUP (
ACD_GRP_ID INTEGER not null,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
constraint PK_ACD_GROUP primary key (ACD_GRP_ID)
);
/*==============================================================*/
/* Index: "Relationship_3_FK" */
/*==============================================================*/
create index "Relationship_3_FK" on ACD_GROUP (
ACD_ARITHMETIC_ID ASC
);
/*==============================================================*/
/* Table: ACD_USER_GRP_MAPS */
/*==============================================================*/
create table ACD_USER_GRP_MAPS (
ACD_USER_ID INTEGER not null,
ACD_GRP_ID INTEGER not null,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
ACD_LOGIN_ID VARCHAR2(40),
ACD_USER_NAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
HELP_INFO BLOB,
SKILL_WEIGHT NUMBER(5,2),
MONITOR_FLAG INTEGER,
constraint PK_ACD_USER_GRP primary key (ACD_USER_ID, ACD_GRP_ID)
);
/*==============================================================*/
/* Index: "Inheritance_4_FK" */
/*==============================================================*/
create index "Inheritance_4_FK" on ACD_USER_GRP_MAPS (
ACD_USER_ID ASC
);
/*==============================================================*/
/* Index: "Inheritance_5_FK" */
/*==============================================================*/
create index "Inheritance_5_FK" on ACD_USER_GRP_MAPS (
ACD_GRP_ID ASC
);
/*==============================================================*/
/* Table: IVR_CHANNELS */
/*==============================================================*/
create table IVR_CHANNELS (
IVR_CHANNEL_ID INTEGER not null,
IVR_HOST_ID INTEGER,
CHANNEL_NAME VARCHAR2(100) not null,
CHANNEL_NO INTEGER not null,
THREAD_SLEEP_LEN INTEGER,
SIGNALING_TYPE VARCHAR2(20),
SITUATION_PROPERTIES VARCHAR2(1000),
AHOST_IP VARCHAR2(40),
AHOST_PHONE_NUMBER VARCHAR2(20),
CHANNEL_ACT_TYPE INTEGER,
HELP_INFO BLOB,
constraint PK_IVR_CHANNELS primary key (IVR_CHANNEL_ID)
);
comment on table IVR_CHANNELS is
'CHANNEL_ACT_TYPE: 1 CTI 2 录音';
/*==============================================================*/
/* Index: "Relationship_2_FK" */
/*==============================================================*/
create index "Relationship_2_FK" on IVR_CHANNELS (
IVR_HOST_ID ASC
);
/*==============================================================*/
/* Table: IVR_HOSTS */
/*==============================================================*/
create table IVR_HOSTS (
IVR_HOST_ID INTEGER not null,
BCA_AGENT_NAME VARCHAR2(40),
HOST_IP VARCHAR2(20),
HOST_NAME VARCHAR2(100),
FAX_CHANNELS INTEGER,
HELP_INFO BLOB,
constraint PK_IVR_HOSTS primary key (IVR_HOST_ID)
);
/*==============================================================*/
/* Table: IVR_REFUSE_CALLED */
/*==============================================================*/
create table IVR_REFUSE_CALLED (
CALLED_LEADING VARCHAR2(20) not null,
SWITCH_ENABLE INTEGER,
constraint PK_IVR_REFUSE_2 primary key (CALLED_LEADING)
);
/*==============================================================*/
/* Table: IVR_REFUSE_CALL_TIMESPAN */
/*==============================================================*/
create table IVR_REFUSE_CALL_TIMESPAN (
REFUSE_IDX INTEGER not null,
START_TIME VARCHAR2(5),
END_TIME VARCHAR2(5),
SWITCH_ENABLE INTEGER,
constraint PK_IVR_REFUSE_C primary key (REFUSE_IDX)
);
评论
1 楼
dfgxpxz
2008-06-02
建表:(bcacc登录)
/*==============================================================*/
/* DBMS name: ORACLE Version 9i2 */
/* Created on: 2008-6-2 15:34:20 */
/*==============================================================*/
alter table ACD_USER_GRP_MAPS
drop constraint FK_ACD_USER_INH;
alter table ACD_USER_GRP_MAPS
drop constraint FK_ACD_USER_IN2;
alter table ACD_CH_GRP_MAPS
drop constraint FK_ACD_CH_G_INH;
alter table ACD_CH_GRP_MAPS
drop constraint FK_ACD_CH_G_IN2;
alter table IVR_CHANNELS
drop constraint FK_IVR_CHAN_REL;
drop index "Inheritance_6_FK";
drop index "Inheritance_7_FK";
drop index "Relationship_3_FK";
drop index "Inheritance_4_FK";
drop index "Inheritance_5_FK";
drop index "Relationship_2_FK";
drop table ACD_ARITHMETIC cascade constraints;
drop table ACD_AUSERS cascade constraints;
drop table ACD_CH_GRP_MAPS cascade constraints;
drop table ACD_GROUP cascade constraints;
drop table ACD_USER_GRP_MAPS cascade constraints;
drop table IVR_CHANNELS cascade constraints;
drop table IVR_HOSTS cascade constraints;
drop table IVR_REFUSE_CALLED cascade constraints;
drop table IVR_REFUSE_CALL_TIMESPAN cascade constraints;
/*==============================================================*/
/* Table: ACD_ARITHMETIC */
/*==============================================================*/
create table ACD_ARITHMETIC (
ACD_ARITHMETIC_ID INTEGER not null,
ARITHMETIC_NAME VARCHAR2(40),
IMPL_CLASS VARCHAR2(100),
DESIGN_CLASS VARCHAR2(100),
HELP_INFO BLOB,
constraint PK_ACD_ARITHMET primary key (ACD_ARITHMETIC_ID)
);
/*==============================================================*/
/* Table: ACD_AUSERS */
/*==============================================================*/
create table ACD_AUSERS (
ACD_USER_ID INTEGER not null,
ACD_LOGIN_ID VARCHAR2(40),
ACD_USER_NAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
HELP_INFO BLOB,
constraint PK_ACD_AUSERS primary key (ACD_USER_ID)
);
/*==============================================================*/
/* Table: ACD_CH_GRP_MAPS */
/*==============================================================*/
create table ACD_CH_GRP_MAPS (
ACD_GRP_ID INTEGER not null,
IVR_CHANNEL_ID INTEGER not null,
IVR_HOST_ID INTEGER,
CHANNEL_NAME VARCHAR2(100) not null,
CHANNEL_NO INTEGER not null,
THREAD_SLEEP_LEN INTEGER,
SIGNALING_TYPE VARCHAR2(20),
SITUATION_PROPERTIES VARCHAR2(1000),
AHOST_IP VARCHAR2(40),
AHOST_PHONE_NUMBER VARCHAR2(20),
CHANNEL_ACT_TYPE INTEGER,
HELP_INFO BLOB,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
constraint PK_ACD_CH_GRP_M primary key (ACD_GRP_ID, IVR_CHANNEL_ID)
);
/*==============================================================*/
/* Index: "Inheritance_6_FK" */
/*==============================================================*/
create index "Inheritance_6_FK" on ACD_CH_GRP_MAPS (
ACD_GRP_ID ASC
);
/*==============================================================*/
/* Index: "Inheritance_7_FK" */
/*==============================================================*/
create index "Inheritance_7_FK" on ACD_CH_GRP_MAPS (
IVR_CHANNEL_ID ASC
);
/*==============================================================*/
/* Table: ACD_GROUP */
/*==============================================================*/
create table ACD_GROUP (
ACD_GRP_ID INTEGER not null,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
constraint PK_ACD_GROUP primary key (ACD_GRP_ID)
);
/*==============================================================*/
/* Index: "Relationship_3_FK" */
/*==============================================================*/
create index "Relationship_3_FK" on ACD_GROUP (
ACD_ARITHMETIC_ID ASC
);
/*==============================================================*/
/* Table: ACD_USER_GRP_MAPS */
/*==============================================================*/
create table ACD_USER_GRP_MAPS (
ACD_USER_ID INTEGER not null,
ACD_GRP_ID INTEGER not null,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
ACD_LOGIN_ID VARCHAR2(40),
ACD_USER_NAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
HELP_INFO BLOB,
SKILL_WEIGHT NUMBER(5,2),
MONITOR_FLAG INTEGER,
constraint PK_ACD_USER_GRP primary key (ACD_USER_ID, ACD_GRP_ID)
);
/*==============================================================*/
/* Index: "Inheritance_4_FK" */
/*==============================================================*/
create index "Inheritance_4_FK" on ACD_USER_GRP_MAPS (
ACD_USER_ID ASC
);
/*==============================================================*/
/* Index: "Inheritance_5_FK" */
/*==============================================================*/
create index "Inheritance_5_FK" on ACD_USER_GRP_MAPS (
ACD_GRP_ID ASC
);
/*==============================================================*/
/* Table: IVR_CHANNELS */
/*==============================================================*/
create table IVR_CHANNELS (
IVR_CHANNEL_ID INTEGER not null,
IVR_HOST_ID INTEGER,
CHANNEL_NAME VARCHAR2(100) not null,
CHANNEL_NO INTEGER not null,
THREAD_SLEEP_LEN INTEGER,
SIGNALING_TYPE VARCHAR2(20),
SITUATION_PROPERTIES VARCHAR2(1000),
AHOST_IP VARCHAR2(40),
AHOST_PHONE_NUMBER VARCHAR2(20),
CHANNEL_ACT_TYPE INTEGER,
HELP_INFO BLOB,
constraint PK_IVR_CHANNELS primary key (IVR_CHANNEL_ID)
);
comment on table IVR_CHANNELS is
'CHANNEL_ACT_TYPE: 1 CTI 2 录音';
/*==============================================================*/
/* Index: "Relationship_2_FK" */
/*==============================================================*/
create index "Relationship_2_FK" on IVR_CHANNELS (
IVR_HOST_ID ASC
);
/*==============================================================*/
/* Table: IVR_HOSTS */
/*==============================================================*/
create table IVR_HOSTS (
IVR_HOST_ID INTEGER not null,
BCA_AGENT_NAME VARCHAR2(40),
HOST_IP VARCHAR2(20),
HOST_NAME VARCHAR2(100),
FAX_CHANNELS INTEGER,
HELP_INFO BLOB,
constraint PK_IVR_HOSTS primary key (IVR_HOST_ID)
);
/*==============================================================*/
/* Table: IVR_REFUSE_CALLED */
/*==============================================================*/
create table IVR_REFUSE_CALLED (
CALLED_LEADING VARCHAR2(20) not null,
SWITCH_ENABLE INTEGER,
constraint PK_IVR_REFUSE_2 primary key (CALLED_LEADING)
);
/*==============================================================*/
/* Table: IVR_REFUSE_CALL_TIMESPAN */
/*==============================================================*/
create table IVR_REFUSE_CALL_TIMESPAN (
REFUSE_IDX INTEGER not null,
START_TIME VARCHAR2(5),
END_TIME VARCHAR2(5),
SWITCH_ENABLE INTEGER,
constraint PK_IVR_REFUSE_C primary key (REFUSE_IDX)
);
/*==============================================================*/
/* DBMS name: ORACLE Version 9i2 */
/* Created on: 2008-6-2 15:34:20 */
/*==============================================================*/
alter table ACD_USER_GRP_MAPS
drop constraint FK_ACD_USER_INH;
alter table ACD_USER_GRP_MAPS
drop constraint FK_ACD_USER_IN2;
alter table ACD_CH_GRP_MAPS
drop constraint FK_ACD_CH_G_INH;
alter table ACD_CH_GRP_MAPS
drop constraint FK_ACD_CH_G_IN2;
alter table IVR_CHANNELS
drop constraint FK_IVR_CHAN_REL;
drop index "Inheritance_6_FK";
drop index "Inheritance_7_FK";
drop index "Relationship_3_FK";
drop index "Inheritance_4_FK";
drop index "Inheritance_5_FK";
drop index "Relationship_2_FK";
drop table ACD_ARITHMETIC cascade constraints;
drop table ACD_AUSERS cascade constraints;
drop table ACD_CH_GRP_MAPS cascade constraints;
drop table ACD_GROUP cascade constraints;
drop table ACD_USER_GRP_MAPS cascade constraints;
drop table IVR_CHANNELS cascade constraints;
drop table IVR_HOSTS cascade constraints;
drop table IVR_REFUSE_CALLED cascade constraints;
drop table IVR_REFUSE_CALL_TIMESPAN cascade constraints;
/*==============================================================*/
/* Table: ACD_ARITHMETIC */
/*==============================================================*/
create table ACD_ARITHMETIC (
ACD_ARITHMETIC_ID INTEGER not null,
ARITHMETIC_NAME VARCHAR2(40),
IMPL_CLASS VARCHAR2(100),
DESIGN_CLASS VARCHAR2(100),
HELP_INFO BLOB,
constraint PK_ACD_ARITHMET primary key (ACD_ARITHMETIC_ID)
);
/*==============================================================*/
/* Table: ACD_AUSERS */
/*==============================================================*/
create table ACD_AUSERS (
ACD_USER_ID INTEGER not null,
ACD_LOGIN_ID VARCHAR2(40),
ACD_USER_NAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
HELP_INFO BLOB,
constraint PK_ACD_AUSERS primary key (ACD_USER_ID)
);
/*==============================================================*/
/* Table: ACD_CH_GRP_MAPS */
/*==============================================================*/
create table ACD_CH_GRP_MAPS (
ACD_GRP_ID INTEGER not null,
IVR_CHANNEL_ID INTEGER not null,
IVR_HOST_ID INTEGER,
CHANNEL_NAME VARCHAR2(100) not null,
CHANNEL_NO INTEGER not null,
THREAD_SLEEP_LEN INTEGER,
SIGNALING_TYPE VARCHAR2(20),
SITUATION_PROPERTIES VARCHAR2(1000),
AHOST_IP VARCHAR2(40),
AHOST_PHONE_NUMBER VARCHAR2(20),
CHANNEL_ACT_TYPE INTEGER,
HELP_INFO BLOB,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
constraint PK_ACD_CH_GRP_M primary key (ACD_GRP_ID, IVR_CHANNEL_ID)
);
/*==============================================================*/
/* Index: "Inheritance_6_FK" */
/*==============================================================*/
create index "Inheritance_6_FK" on ACD_CH_GRP_MAPS (
ACD_GRP_ID ASC
);
/*==============================================================*/
/* Index: "Inheritance_7_FK" */
/*==============================================================*/
create index "Inheritance_7_FK" on ACD_CH_GRP_MAPS (
IVR_CHANNEL_ID ASC
);
/*==============================================================*/
/* Table: ACD_GROUP */
/*==============================================================*/
create table ACD_GROUP (
ACD_GRP_ID INTEGER not null,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
constraint PK_ACD_GROUP primary key (ACD_GRP_ID)
);
/*==============================================================*/
/* Index: "Relationship_3_FK" */
/*==============================================================*/
create index "Relationship_3_FK" on ACD_GROUP (
ACD_ARITHMETIC_ID ASC
);
/*==============================================================*/
/* Table: ACD_USER_GRP_MAPS */
/*==============================================================*/
create table ACD_USER_GRP_MAPS (
ACD_USER_ID INTEGER not null,
ACD_GRP_ID INTEGER not null,
ACD_ARITHMETIC_ID INTEGER,
ACD_GRP_NAME VARCHAR2(40),
ASSIGN_PARAMETERS BLOB,
PHONE_DECODE_PATTERN VARCHAR2(100),
ACD_LOGIN_ID VARCHAR2(40),
ACD_USER_NAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
HELP_INFO BLOB,
SKILL_WEIGHT NUMBER(5,2),
MONITOR_FLAG INTEGER,
constraint PK_ACD_USER_GRP primary key (ACD_USER_ID, ACD_GRP_ID)
);
/*==============================================================*/
/* Index: "Inheritance_4_FK" */
/*==============================================================*/
create index "Inheritance_4_FK" on ACD_USER_GRP_MAPS (
ACD_USER_ID ASC
);
/*==============================================================*/
/* Index: "Inheritance_5_FK" */
/*==============================================================*/
create index "Inheritance_5_FK" on ACD_USER_GRP_MAPS (
ACD_GRP_ID ASC
);
/*==============================================================*/
/* Table: IVR_CHANNELS */
/*==============================================================*/
create table IVR_CHANNELS (
IVR_CHANNEL_ID INTEGER not null,
IVR_HOST_ID INTEGER,
CHANNEL_NAME VARCHAR2(100) not null,
CHANNEL_NO INTEGER not null,
THREAD_SLEEP_LEN INTEGER,
SIGNALING_TYPE VARCHAR2(20),
SITUATION_PROPERTIES VARCHAR2(1000),
AHOST_IP VARCHAR2(40),
AHOST_PHONE_NUMBER VARCHAR2(20),
CHANNEL_ACT_TYPE INTEGER,
HELP_INFO BLOB,
constraint PK_IVR_CHANNELS primary key (IVR_CHANNEL_ID)
);
comment on table IVR_CHANNELS is
'CHANNEL_ACT_TYPE: 1 CTI 2 录音';
/*==============================================================*/
/* Index: "Relationship_2_FK" */
/*==============================================================*/
create index "Relationship_2_FK" on IVR_CHANNELS (
IVR_HOST_ID ASC
);
/*==============================================================*/
/* Table: IVR_HOSTS */
/*==============================================================*/
create table IVR_HOSTS (
IVR_HOST_ID INTEGER not null,
BCA_AGENT_NAME VARCHAR2(40),
HOST_IP VARCHAR2(20),
HOST_NAME VARCHAR2(100),
FAX_CHANNELS INTEGER,
HELP_INFO BLOB,
constraint PK_IVR_HOSTS primary key (IVR_HOST_ID)
);
/*==============================================================*/
/* Table: IVR_REFUSE_CALLED */
/*==============================================================*/
create table IVR_REFUSE_CALLED (
CALLED_LEADING VARCHAR2(20) not null,
SWITCH_ENABLE INTEGER,
constraint PK_IVR_REFUSE_2 primary key (CALLED_LEADING)
);
/*==============================================================*/
/* Table: IVR_REFUSE_CALL_TIMESPAN */
/*==============================================================*/
create table IVR_REFUSE_CALL_TIMESPAN (
REFUSE_IDX INTEGER not null,
START_TIME VARCHAR2(5),
END_TIME VARCHAR2(5),
SWITCH_ENABLE INTEGER,
constraint PK_IVR_REFUSE_C primary key (REFUSE_IDX)
);
相关推荐
阅读理解部分提供了五个篇章的题目答案,分别是DEAFB、FFTTF、BCACC,以及61到75题的答案,其中涉及到一些细节和主旨的理解。最后,作文题目可能是关于成为环保小卫士的,提到了一些行动和观点。 接下来是关于...
试题包含了多项选择题和填空题,例如1-5题的答案是BCACC,一直到60题的答案CABDB。此外,还有填单词的题目,例如61题答案satisfying/satisfactory,表示令人满意的,以及62题sadness,意为悲伤,这些题目旨在测试...
在选择题部分,虽然没有给出具体题目,但DDBCBC、BCACC、DA的选项顺序提示我们考察了多个概念,可能包括数列、几何、代数等内容。 填空题中,编号6-13的题目涉及到了数列的计算、函数的定义域和值域等问题。第14题...
首先,我们来看听力部分,题目顺序从1到20,答案分别是ABACC、BABAC、BCABA、BCACC,这些答案可以帮助学生核对他们在听力测试中的表现,识别出可能的错误,以便于针对性地改进听力技巧。 接着是阅读理解,共4篇文章...
- 听力部分的答案展示(如1-5 CBCBA,6-10 BCACC等)反映了英语听力理解的训练,这是英语学习中的关键技能,涉及到理解口语表达、捕捉关键信息和快速反应的能力。 2. **阅读理解**: - 阅读理解部分(如21-23 CBA...
题目编号为21-25 BCACC,26-30 BABDD,31-35 ABABD,36-40 DGBEC。这部分考察学生快速获取和理解书面信息的能力,涉及文章的主题理解、细节判断、推理判断等。 【完形填空】 完形填空共20小题,每题1.5分,总分30...
题目中给出了听力部分的部分答案,如1-5 BCACA,6-10 BACAB,11-15 BCACC,16-20 BCBAAA,这是对学生听力反应速度和理解准确性的测试。 阅读理解涉及四篇文章,每篇文章后面都有相应的题目,如21-23 CDDB,24-27 ...
1. **听力部分**:答案序列如ABBCC, BACBA, BCACC, BCBAA,这是听力理解题目的常见格式,每个字母代表一个选项,可能是四个选择中的正确答案。 2. **阅读理解**:DBA, DCBC, CDBB, ACBD, ADGEF,这些序列对应了每篇...
给出了各题的正确选项,如第一节的1-5题答案为CCBAC,第二节的6-20题答案为BCACC, ACBCA, BBBAC。 阅读理解也分为两节,第一节有15个小题,每题2分,满分30分;第二节有5个小题,每题2分,满分10分。给出了对应的...
题目16-20 BCACC、21-25 ACCBB、26-30 CEABD,学生需要根据文章内容选择最佳答案。阅读D篇还要求学生根据文章内容简要回答问题,如第31题询问原因,第32题询问类别,第33题涉及忌讳,第34题为否定回答,第35题总结...
例如,"11.1.1(1)A12BCDEF(2)1abab***ccbabcaa***bcacc921b***(1)(2)(3)" 这部分内容可能是数字规律的识别和字母表或公式的混合使用。 又如,"1.1.2()305ababba11.(1)(2)(3)2.(1)AB***(2)AB***=12;(223)(23)=72(1)...
5. **短文改错**:41-45 BCACC,这部分考查对句子结构、词汇使用和标点符号的准确性。改正错误通常涉及动词时态、主谓一致、名词单复数、形容词副词比较级最高级、介词搭配等。 6. **阅读表达**:如51-55 BCBCA,这...