if exists (select 1
from sysobjects
where id = object_id('SYSUPWEBFEENODZB')
and type = 'U')
drop table SYSUPWEBFEENODZB
go
/*==============================================================*/
/* Table: SYSUPWEBFEENODZB */
/*==============================================================*/
create table SYSUPWEBFEENODZB (
FEE_NO_LOCAL varchar(50) not null,
FEE_NO_WEB varchar(50) not null,
FEE_NO_CLASSID varchar(20) null default '',
FEE_NO_NOSFISADD varchar(20) null default '1',
constraint PK_SYSUPWEBFEENODZB primary key nonclustered (FEE_NO_LOCAL, FEE_NO_WEB)
)
go
delete from SYSUPWEBFEENODZB
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0001', '0001', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0003', '0001', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0005', '0050', '01', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0006', '0050', '01', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0007', '1000', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0011', '0010', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0013', '0055', '02', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0015', '0010', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0016', '0001', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0018', '0071', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0019', '0072', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0020', '1000', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0021', '0070', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0024', '0050', '01', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0027', '0073', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0028', '0075', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0029', '0074', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0032', '0025', '', '0')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0033', '0030', '', '0')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0034', '1001', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0037', '0055', '02', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0038', '0050', '01', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0039', '0055', '02', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0040', '9990', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0041', '0076', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0050', '0020', '10', '0')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0051', '0055', '02', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('0060', '0020', '10', '0')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('042', '0065', '', '0')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('046', '0001', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('047', '0010', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('43', '0066', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('44', '0067', '', '1')
go
insert into SYSUPWEBFEENODZB(FEE_NO_LOCAL, FEE_NO_WEB, FEE_NO_CLASSID, FEE_NO_NOSFISADD) values('45', '0020', '10', '0')
go
if exists (select 1
from sysobjects
where id = object_id('SYSUPWEBRMFEENODZB')
and type = 'U')
drop table SYSUPWEBRMFEENODZB
go
/*==============================================================*/
/* Table: SYSUPWEBRMFEENODZB */
/*==============================================================*/
create table SYSUPWEBRMFEENODZB (
CORP_ID varchar(50) not null,
GARD_ID varchar(50) not null,
RM_ID varchar(50) not null,
FEE_NO_LOCAL varchar(50) not null,
FEE_NO_WEB varchar(50) not null,
constraint PK_SYSUPWEBRMFEENODZB primary key nonclustered (CORP_ID, GARD_ID, RM_ID, FEE_NO_LOCAL, FEE_NO_WEB)
)
go
