/*
   Thursday, June 18, 20094:03:29 PM
   User: sa
   Server: VIEWSONIC
   Database: TheGate
   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
	AgentCode varchar(20) NULL,
	AgentName varchar(100) NULL,
	BillRef1 varchar(100) NULL,
	BillRef2 varchar(100) NULL,
	BillRef3 varchar(100) NULL,
	SeatNum varchar(50) 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 

ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	AgentName varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_Eod_BillDetails ADD
	AgentName varchar(100) NULL
GO

DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=81) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) VALUES('[L81] [Member] Online Point/Value Updated',81,'L',81,'OOXXXXXXXX')
DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=82) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) VALUES('[L82] [Member] Reject Action if Expired',82,'L',82,'OOXXXXXXXX')