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

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

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

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

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

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

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

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

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