/*
   Friday, June 18, 20102:57:00 PM
   User: 
   Server: VIEWSONIC\VPOS
   Database: OfficeData
   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_BillDetails ADD
	TempAmt1 numeric(18, 6) NULL,
	TempAmt2 numeric(18, 6) NULL,
	TempAmt3 numeric(18, 6) NULL,
	TempAmt4 numeric(18, 6) NULL,
	TempAmt5 numeric(18, 6) NULL,
	TempAmt6 numeric(18, 6) NULL,
	TempAmt7 numeric(18, 6) NULL,
	TempAmt8 numeric(18, 6) NULL,
	TempAmt9 numeric(18, 6) NULL,
	TempAmt10 numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt1_1 DEFAULT ((0)) FOR TempAmt1
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt2_1 DEFAULT ((0)) FOR TempAmt2
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt3_1 DEFAULT ((0)) FOR TempAmt3
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt4_1 DEFAULT ((0)) FOR TempAmt4
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt5_1 DEFAULT ((0)) FOR TempAmt5
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt6_1 DEFAULT ((0)) FOR TempAmt6
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt7_1 DEFAULT ((0)) FOR TempAmt7
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt8_1 DEFAULT ((0)) FOR TempAmt8
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt9_1 DEFAULT ((0)) FOR TempAmt9
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_TempAmt10_1 DEFAULT ((0)) FOR TempAmt10
GO
COMMIT


ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	TempAmt1 numeric(18, 6) NULL,
	TempAmt2 numeric(18, 6) NULL,
	TempAmt3 numeric(18, 6) NULL,
	TempAmt4 numeric(18, 6) NULL,
	TempAmt5 numeric(18, 6) NULL,
	TempAmt6 numeric(18, 6) NULL,
	TempAmt7 numeric(18, 6) NULL,
	TempAmt8 numeric(18, 6) NULL,
	TempAmt9 numeric(18, 6) NULL,
	TempAmt10 numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt1 DEFAULT ((0)) FOR TempAmt1
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt2 DEFAULT ((0)) FOR TempAmt2
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt3 DEFAULT ((0)) FOR TempAmt3
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt4 DEFAULT ((0)) FOR TempAmt4
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt5 DEFAULT ((0)) FOR TempAmt5
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt6 DEFAULT ((0)) FOR TempAmt6
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt7 DEFAULT ((0)) FOR TempAmt7
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt8 DEFAULT ((0)) FOR TempAmt8
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt9 DEFAULT ((0)) FOR TempAmt9
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_TempAmt10 DEFAULT ((0)) FOR TempAmt10
GO

ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	ClaimStatusYN bit NULL,
	ORNo varchar(20) NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_ClaimStatusYN DEFAULT 0 FOR ClaimStatusYN
GO


/* 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
	TempAmt1 numeric(18, 6) NULL,
	TempAmt2 numeric(18, 6) NULL,
	TempAmt3 numeric(18, 6) NULL,
	TempAmt4 numeric(18, 6) NULL,
	TempAmt5 numeric(18, 6) NULL,
	TempAmt6 numeric(18, 6) NULL,
	TempAmt7 numeric(18, 6) NULL,
	TempAmt8 numeric(18, 6) NULL,
	TempAmt9 numeric(18, 6) NULL,
	TempAmt10 numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt1 DEFAULT ((0)) FOR TempAmt1
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt2 DEFAULT ((0)) FOR TempAmt2
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt3 DEFAULT ((0)) FOR TempAmt3
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt4 DEFAULT ((0)) FOR TempAmt4
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt5 DEFAULT ((0)) FOR TempAmt5
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt6 DEFAULT ((0)) FOR TempAmt6
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt7 DEFAULT ((0)) FOR TempAmt7
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt8 DEFAULT ((0)) FOR TempAmt8
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt9 DEFAULT ((0)) FOR TempAmt9
GO
ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT
	DF_Vstk_mt_Item_TempAmt10 DEFAULT ((0)) FOR TempAmt10
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 TempAmt1=0 where TempAmt1 is null
update vstk_mt_item set TempAmt2=0 where TempAmt2 is null
update vstk_mt_item set TempAmt3=0 where TempAmt3 is null
update vstk_mt_item set TempAmt4=0 where TempAmt4 is null
update vstk_mt_item set TempAmt5=0 where TempAmt5 is null
update vstk_mt_item set TempAmt6=0 where TempAmt6 is null
update vstk_mt_item set TempAmt7=0 where TempAmt7 is null
update vstk_mt_item set TempAmt8=0 where TempAmt8 is null
update vstk_mt_item set TempAmt9=0 where TempAmt9 is null
update vstk_mt_item set TempAmt10=0 where TempAmt10 is null

ALTER TABLE dbo.Vloy_mt_CardType ADD
	PromoPeriod1 varchar(20) NULL,
	PromoPeriod2 varchar(20) NULL,
	PromoPeriod3 varchar(20) NULL
GO
ALTER TABLE dbo.Vloy_mt_CardType ADD CONSTRAINT
	DF_Vloy_mt_CardType_PromoPeriod1 DEFAULT 'BasedUnitPrice' FOR PromoPeriod1
GO
ALTER TABLE dbo.Vloy_mt_CardType ADD CONSTRAINT
	DF_Vloy_mt_CardType_PromoPeriod2 DEFAULT 'BasedUnitPrice' FOR PromoPeriod2
GO
ALTER TABLE dbo.Vloy_mt_CardType ADD CONSTRAINT
	DF_Vloy_mt_CardType_PromoPeriod3 DEFAULT 'BasedUnitPrice' FOR PromoPeriod3
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vloy_mt_CardType', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vloy_mt_CardType', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vloy_mt_CardType', 'Object', 'CONTROL') as Contr_Per 

update vloy_mt_cardtype set PromoPeriod1='BasedUnitPrice' where PromoPeriod1 is null
update vloy_mt_cardtype set PromoPeriod2='BasedUnitPrice' where PromoPeriod2 is null
update vloy_mt_cardtype set PromoPeriod3='BasedUnitPrice' where PromoPeriod3 is null


ALTER TABLE dbo.Vpos_mt_ModifierDetails ADD
	SortNo int NULL
GO
ALTER TABLE dbo.Vpos_mt_ModifierDetails ADD CONSTRAINT
	DF_Vpos_mt_ModifierDetails_SortNo DEFAULT 0 FOR SortNo
GO

update Vpos_mt_ModifierDetails set SortNo=0 where Sortno is null

ALTER TABLE dbo.Vpos_trs_GeneralDetails ADD
	TipsAmt numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_trs_GeneralDetails ADD CONSTRAINT
	DF_Vpos_trs_GeneralDetails_TipsAmt DEFAULT 0 FOR TipsAmt
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	ExpireDate datetime NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	ExpireDate datetime NULL
GO

update Vpos_trs_GeneralDetails set TipsAmt=0 where TipsAmt is null


ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD
	TipsAmt numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD CONSTRAINT
	DF_Vpos_eod_GeneralDetails_TipsAmt DEFAULT 0 FOR TipsAmt
GO

update Vpos_eod_GeneralDetails set TipsAmt=0 where TipsAmt is null

ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	TerminalNo varchar(20) NULL
GO

ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	TerminalNo varchar(20) NULL
GO

ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	FAgentUnitComm numeric(18, 6) NULL,
	FStaffUnitComm numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_FAgentUnitComm DEFAULT ((0)) FOR FAgentUnitComm
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_FStaffUnitComm DEFAULT ((0)) FOR FStaffUnitComm
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	FAgentUnitComm numeric(18, 6) NULL,
	FStaffUnitComm numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_FAgentUnitComm DEFAULT ((0)) FOR FAgentUnitComm
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_FStaffUnitComm DEFAULT ((0)) FOR FStaffUnitComm
GO


update Vpos_trs_BillDetails set TerminalNo='001' where TerminalNo is null
update Vpos_eod_BillDetails set TerminalNo='001' where TerminalNo is null
update Vpos_trs_BillDetails set TerminalNo='001' where TerminalNo is null
update Vpos_eod_BillDetails set TerminalNo='001' where TerminalNo is null
update Vpos_trs_BillDetails set FAgentUnitComm=AgentCommValue where FAgentUnitComm is null
update Vpos_eod_BillDetails set FAgentUnitComm=AgentCommValue where FAgentUnitComm is null
update Vpos_trs_BillDetails set FStaffUnitComm=0 where FStaffUnitComm is null
update Vpos_eod_BillDetails set FStaffUnitComm=0 where FStaffUnitComm is null


DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=107) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[L107] Auto Log out After Guest Check Printed',107,'L',107,'OOXXXXXXXX')
DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=108) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[L108] Accept Zero Pax',108,'L',108,'OOXXXXXXXX')
DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=109) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[L109] Agent Comm Based on AgentCode',109,'L',109,'OOXXXXXXXX')
DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=110) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[L110] Select Agent Code using Keypad',110,'L',110,'OOXXXXXXXX')

DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=1) and DefaultType='X'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[X1] Follow Price Group Only',1,'X',1,'OOXXXXXXXX')
DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=2) and DefaultType='X'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[X2] Follow Member Discount Only',2,'X',2,'OOXXXXXXXX')
select * from Vs_DefaultAccess where defaulttype='x'