delete vs4tsystem WHERE tsysname='ColorJobComplete'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'ColorJobComplete','',8454016,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO
delete vs4tsystem WHERE tsysname='ColorJobFinish'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'ColorJobFinish','',16777088,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO
delete vs4tsystem WHERE tsysname='ColorJobBreak'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'ColorJobBreak','',12632256,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO
delete vs4tsystem WHERE tsysname='ColorJobDM'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'ColorJobDM','',65535,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO
delete vs4tsystem WHERE tsysname='ColorJobOrder'
GO
insert into vs4tsystem (tsysid,tsysname,tsystext,tsysvalue,tsysflag1) values (-1,'ColorJobOrder','',8454143,1)
GO
update vs4tsystem set tsysid=(select max(tsysid)+1 from vs4tsystem) where tsysid=-1
GO

