if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVERHIS')
and name = 'IDX_WF_ENTRUSTRCH_CSTATUS'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVERHIS.IDX_WF_ENTRUSTRCH_CSTATUS
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVERHIS')
and name = 'IDX_WF_ENTRUSTRCH_CONSIGNOR'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVERHIS.IDX_WF_ENTRUSTRCH_CONSIGNOR
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVERHIS')
and name = 'IDX_WF_ENTRUSTRCH_RULEID'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVERHIS.IDX_WF_ENTRUSTRCH_RULEID
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVERHIS')
and name = 'IDX_WF_ENTRUSTRCH_RULEENTRYID'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVERHIS.IDX_WF_ENTRUSTRCH_RULEENTRYID
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVERHIS')
and name = 'IDX_WF_ENTRUSTRCH_RECEIVERID'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVERHIS.IDX_WF_ENTRUSTRCH_RECEIVERID
go
if exists (select 1
from sysindexes
where id = object_id('T_WF_ENTRUSTRECEIVERHIS')
and name = 'IDX_WF_ENTRUSTRCH_FID'
and indid > 0
and indid < 255)
drop index T_WF_ENTRUSTRECEIVERHIS.IDX_WF_ENTRUSTRCH_FID
go
if exists (select 1
from sysobjects
where id = object_id('T_WF_ENTRUSTRECEIVERHIS')
and type = 'U')
drop table T_WF_ENTRUSTRECEIVERHIS
go
/*==============================================================*/
/* Table: T_WF_ENTRUSTRECEIVERHIS */
/*==============================================================*/
create table T_WF_ENTRUSTRECEIVERHIS (
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_ENTRUSTRECEIVERHIS primary key (FENTRUSTRECEIVERID)
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_FID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_FID on T_WF_ENTRUSTRECEIVERHIS (
FID ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_RECEIVERID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_RECEIVERID on T_WF_ENTRUSTRECEIVERHIS (
FRECEIVERID ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_RULEENTRYID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_RULEENTRYID on T_WF_ENTRUSTRECEIVERHIS (
FENTRUSTRULEENTRYID ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_RULEID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_RULEID on T_WF_ENTRUSTRECEIVERHIS (
FENTRUSTRULEID ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_CONSIGNOR */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_CONSIGNOR on T_WF_ENTRUSTRECEIVERHIS (
FCONSIGNOR ASC
)
go
/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_CSTATUS */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_CSTATUS on T_WF_ENTRUSTRECEIVERHIS (
FCONSIGNSTATUS ASC
)
go
|