/*
   Saturday, July 04, 200910:24:40 PM
   User: sa
   Server: user
   Database: Fnb
   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.vpos_mt_DisplayNoteDetails ADD
	AppCode varchar(20) NULL,
	SortNo int NULL
GO
ALTER TABLE dbo.vpos_mt_DisplayNoteDetails ADD CONSTRAINT
	DF_vpos_mt_DisplayNoteDetails_AppCode DEFAULT 'NIL' FOR AppCode
GO
ALTER TABLE dbo.vpos_mt_DisplayNoteDetails ADD CONSTRAINT
	DF_vpos_mt_DisplayNoteDetails_SortNo DEFAULT 0 FOR SortNo
GO
COMMIT
select Has_Perms_By_Name(N'dbo.vpos_mt_DisplayNoteDetails', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.vpos_mt_DisplayNoteDetails', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.vpos_mt_DisplayNoteDetails', 'Object', 'CONTROL') as Contr_Per 

UPDATE vpos_mt_displayNoteDetails set appcode='NIL' WHERE appcode is null
UPDATE vpos_mt_displayNoteDetails set SortNo=0 WHERE Sortno is null
UPDATE vpos_mt_displayNoteDetails set name1=name WHERE name1 is null or name1 =''
UPDATE vpos_mt_displayNoteDetails set name2=name WHERE name2 is null or name2 =''
UPDATE vpos_mt_displayNoteDetails set name3=name WHERE name3 is null or name3 =''
UPDATE vpos_mt_displayNoteDetails set name4=name WHERE name4 is null or name4 =''
UPDATE vpos_mt_displayNoteDetails set name5=name WHERE name5 is null or name5 =''
UPDATE vpos_mt_displayNoteDetails set name6=name WHERE name6 is null or name6 =''
UPDATE vpos_mt_displayNoteDetails set name7=name WHERE name7 is null or name7 =''
UPDATE vpos_mt_displayNoteDetails set name8=name WHERE name8 is null or name8 =''
UPDATE vpos_mt_displayNoteDetails set name9=name WHERE name9 is null or name9 =''
UPDATE vpos_mt_displayNoteDetails set name10=name WHERE name10 is null or name10 =''
UPDATE vpos_mt_displayNote set name=autonotename WHERE name is null  or name =''
UPDATE vpos_mt_displayNote set name1=autonotename WHERE name1 is null or name1 =''
UPDATE vpos_mt_displayNote set name2=autonotename WHERE name2 is null or name2 =''
UPDATE vpos_mt_displayNote set name3=autonotename WHERE name3 is null or name3 =''
UPDATE vpos_mt_displayNote set name4=autonotename WHERE name4 is null or name4 =''
UPDATE vpos_mt_displayNote set name5=autonotename WHERE name5 is null or name5 =''
UPDATE vpos_mt_displayNote set name6=autonotename WHERE name6 is null or name6 =''
UPDATE vpos_mt_displayNote set name7=autonotename WHERE name7 is null or name7 =''
UPDATE vpos_mt_displayNote set name8=autonotename WHERE name8 is null or name8 =''
UPDATE vpos_mt_displayNote set name9=autonotename WHERE name9 is null or name9 =''
UPDATE vpos_mt_displayNote set name10=autonotename WHERE name10 is null or name10 =''

/*
   Saturday, July 04, 200911:52:28 PM
   User: sa
   Server: user
   Database: Fnb
   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.Vpos_mt_Client ADD
	Remark1 varchar(50) NULL,
	Remark2 varchar(50) NULL,
	Remark3 varchar(50) NULL,
	Remark4 varchar(50) NULL,
	Remark5 varchar(50) NULL,
	LastPurchaseDate datetime NULL
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_mt_Client', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_mt_Client', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_mt_Client', 'Object', 'CONTROL') as Contr_Per 



/*
   Sunday, July 05, 200905:29:01 PM
   User: sa
   Server: notebook
   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.vpos_Trs_AdvanceBills ADD
	ClientCode varchar(20) NULL
GO
COMMIT
select Has_Perms_By_Name(N'dbo.vpos_Trs_AdvanceBills', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.vpos_Trs_AdvanceBills', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.vpos_Trs_AdvanceBills', 'Object', 'CONTROL') as Contr_Per 

/*
   Monday, July 06, 20099:18:29 AM
   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.Vpos_trs_PrintingDetails ADD
	ClientCode varchar(20) NULL,
	ClientName varchar(100) NULL,
	TempField1 varchar(100) NULL,
	TempField2 varchar(100) NULL,
	TempField3 varchar(100) NULL,
	TempField4 varchar(100) NULL,
	TempField5 varchar(100) NULL
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_trs_PrintingDetails', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_trs_PrintingDetails', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_trs_PrintingDetails', 'Object', 'CONTROL') as Contr_Per