delete vs4tsystem WHERE tsysname='DefaultSDBook'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysflag1) values (-1,'DefaultSDBook','',1)
GO
update vs4tsystem set tsystext=(select tsystext from vs4tsystem where tsysname='DefaultSVBook') where tsysid=-1
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

delete vs4tsystem WHERE tsysname='DefaultPDBook'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysflag1) values (-1,'DefaultPDBook','',1)
GO
update vs4tsystem set tsystext=(select tsystext from vs4tsystem where tsysname='DefaultPJBook') where tsysid=-1
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

delete vs4tsystem WHERE tsysname='GLAUTO-RD'
GO
insert into vs4tsystem (tsysid,tsysname,tsysvalue,tsysflag1) values (-1,'GLAUTO-RD',0,1)
GO
update vs4tsystem set tsysvalue=(select tsysvalue from vs4tsystem where tsysname='GLAUTO-IV') where tsysid=-1
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

delete vs4tsystem WHERE tsysname='GLAUTO-PD'
GO
insert into vs4tsystem (tsysid,tsysname,tsysvalue,tsysflag1) values (-1,'GLAUTO-PD',0,1)
GO
update vs4tsystem set tsysvalue=(select tsysvalue from vs4tsystem where tsysname='GLAUTO-PIV') where tsysid=-1
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

