/*
   2009-10-2016:37:28
   User: sa
   Server: viewsonic
   Database: FnbDemoData
   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.Vpay_mt_Staff ADD
	DebtorCode varchar(20) NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	SendLater bit NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_SendLater DEFAULT 0 FOR SendLater
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	SendLater bit NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_SendLater DEFAULT 0 FOR SendLater
GO
GO
ALTER TABLE dbo.Vpos_mt_Device ADD
	PrinterModelCode varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_mt_Device ADD CONSTRAINT
	DF_Vpos_mt_Device_PrinterModelCode DEFAULT 'NIL' FOR PrinterModelCode
GO
ALTER TABLE dbo.Vpos_mt_Device ADD
	BeepYesNo bit NULL
GO
ALTER TABLE dbo.Vpos_mt_Device ADD CONSTRAINT
	DF_Vpos_mt_Device_BeepYesNo DEFAULT 0 FOR BeepYesNo
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpay_mt_Staff', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpay_mt_Staff', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpay_mt_Staff', 'Object', 'CONTROL') as Contr_Per 



UPDATE vpos_mt_Device set PrinterModelCode='NIL' WHERE PrinterModelCode is null
UPDATE vpos_mt_Device set BeepYesNo=0 WHERE BeepYesNo is null