if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVER')
and name = 'IDX_WF_ENTRUSTRCV_CSTATUS'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVER.IDX_WF_ENTRUSTRCV_CSTATUS
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVER')
and name = 'IDX_WF_ENTRUSTRCV_CONSIGNOR'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVER.IDX_WF_ENTRUSTRCV_CONSIGNOR
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVER')
and name = 'IDX_WF_ENTRUSTRCV_RULEID'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVER.IDX_WF_ENTRUSTRCV_RULEID
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVER')
and name = 'IDX_WF_ENTRUSTRCV_RULEENTRYID'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVER.IDX_WF_ENTRUSTRCV_RULEENTRYID
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVER')
and name = 'IDX_WF_ENTRUSTRCV_RECEIVERID'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVER.IDX_WF_ENTRUSTRCV_RECEIVERID
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVER')
and name = 'IDX_WF_ENTRUSTRCV_FID'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVER.IDX_WF_ENTRUSTRCV_FID
go
if exists (select 1
from sysobjects
where id = object_id('T_WF_ENTRUSTRECEIVER')
and type = 'U')
drop table T_WF_ENTRUSTRECEIVER
go
/*==============================================================*/
/* Table: T_WF_ENTRUSTRECEIVER */
/*==============================================================*/
create table T_WF_ENTRUSTRECEIVER (
FENTRUSTRECEIVERID int not null default 0,
FID varchar(36) not null default '',
FRECEIVERID int not null default 0,
FENTRUSTRULEENTRYID int not null default 0,
FENTRUSTRULEID int not null default 0,
FCONSIGNOR int not null default 0,
FCONSIGNORPOSTID int not null default 0,
FCONSIGNSTATUS smallint not null default 0,
FCONSIGNTIME datetime null,
constraint PK_T_WF_ENTRUSTRECEIVER primary key (FENTRUSTRECEIVERID)
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_FID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_FID on T_WF_ENTRUSTRECEIVER (
FID ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_RECEIVERID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_RECEIVERID on T_WF_ENTRUSTRECEIVER (
FRECEIVERID ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_RULEENTRYID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_RULEENTRYID on T_WF_ENTRUSTRECEIVER (
FENTRUSTRULEENTRYID ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_RULEID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_RULEID on T_WF_ENTRUSTRECEIVER (
FENTRUSTRULEID ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_CONSIGNOR */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_CONSIGNOR on T_WF_ENTRUSTRECEIVER (
FCONSIGNOR ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_CSTATUS */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_CSTATUS on T_WF_ENTRUSTRECEIVER (
FCONSIGNSTATUS ASC
)
go
|