/*
   Tuesday, July 07, 20093:18:33 PM
   User: sa
   Server: viewsonic
   Database: DemoFnb
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Vstk_mt_Item ADD
	SubGroupCount int NULL
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_SubGroupCount DEFAULT 999 FOR SubGroupCount
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vstk_mt_Item', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vstk_mt_Item', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vstk_mt_Item', 'Object', 'CONTROL') as Contr_Per 

update vstk_mt_item set SubGroupCount=1 WHERE SubGroupCount is null
update vpos_mt_app set ButtonForeColor=8454016 WHERE ButtonForeColor is null
update vpos_mt_app set ButtonBackColor=0 WHERE ButtonBackColor is null