/*
   Tuesday, June 30, 200909:30:29 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_GeneralDetails ADD
	ExeSales bit NULL
GO
ALTER TABLE dbo.Vpos_trs_GeneralDetails ADD CONSTRAINT
	DF_Vpos_trs_GeneralDetails_ExeSales DEFAULT 0 FOR ExeSales
GO

ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD
	ExeSales bit NULL
GO
ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD CONSTRAINT
	DF_Vpos_eod_GeneralDetails_ExeSales DEFAULT 0 FOR ExeSales
GO



ALTER TABLE dbo.Vpos_trs_Bills ADD
	CashierCode2 varchar(20) NULL
GO
ALTER TABLE dbo.Vpos_trs_Bills ADD
	CashierName2 varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_trs_Bills ADD
	AgentCode varchar(20) NULL
GO
ALTER TABLE dbo.Vpos_trs_Bills ADD
	AgentName varchar(100) NULL
GO	

ALTER TABLE dbo.Vpos_trs_Bills ADD
	ServerCode varchar(20) NULL
GO
ALTER TABLE dbo.Vpos_trs_Bills ADD
	ServerName varchar(100) NULL
GO

ALTER TABLE dbo.Vpos_eod_Bills ADD
	CashierCode2 varchar(20) NULL
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD
	CashierName2 varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD
	AgentCode varchar(20) NULL
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD
	AgentName varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD
	ServerCode varchar(20) NULL
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD
	ServerName varchar(100) NULL
GO

ALTER TABLE dbo.Vpos_trs_GeneralDetails ADD
	TempField1 varchar(50) NULL,
	TempField2 varchar(50) NULL,
	TempField3 varchar(50) NULL,
	TempField4 varchar(50) NULL,
	TempField5 varchar(50) NULL
GO

COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_eod_GeneralDetails', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_eod_GeneralDetails', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_eod_GeneralDetails', 'Object', 'CONTROL') as Contr_Per