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

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


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

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

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