ALTER TABLE dbo.Vpos_trs_GeneralDetails ADD
	VoidServicecharge bit NULL
GO
ALTER TABLE dbo.Vpos_Trs_GeneralDetails ADD CONSTRAINT
	DF_Vpos_trs_GeneralDetails_VoidServicecharge DEFAULT 0 FOR VoidServicecharge
GO

ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD
	VoidServicecharge bit NULL
GO
ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD CONSTRAINT
	DF_Vpos_eod_GeneralDetails_VoidServicecharge DEFAULT 0 FOR VoidServicecharge
GO
UPDATE Vs_DefaultAccess SET ctype='XOXXXXXXXX',DEFAULTNAME='[E8] Void Service Charge'
WHERE (DefaultType = 'E') and DefaultNo=8 
UPDATE Vs_DefaultAccess SET ctype='XOXXXXXXXX',DEFAULTNAME='[E9] Force to Swipe Member Card'
WHERE (DefaultType = 'E') and DefaultNo=9
UPDATE Vs_DefaultAccess SET ctype='XOXXXXXXXX',DEFAULTNAME='[B58] Sublevel Item'
WHERE (DefaultType = 'B') and DefaultNo=58 
/*
   Sunday, June 21, 200902:19:57 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
CREATE TABLE dbo.vstk_mt_SubLevel
	(
	ID bigint NOT NULL,
	ItemCode varchar(20) NULL,
	SubItemCode varchar(20) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.vstk_mt_SubLevel ADD CONSTRAINT
	PK_vstk_mt_SubLevel PRIMARY KEY CLUSTERED 
	(
	ID
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

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


/*
   Sunday, June 21, 200902:22:55 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
CREATE TABLE dbo.Tmp_vstk_mt_SubLevel
	(
	ID bigint NOT NULL IDENTITY (1, 1),
	ItemCode varchar(20) NULL,
	SubItemCode varchar(20) NULL
	)  ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_vstk_mt_SubLevel ON
GO
IF EXISTS(SELECT * FROM dbo.vstk_mt_SubLevel)
	 EXEC('INSERT INTO dbo.Tmp_vstk_mt_SubLevel (ID, ItemCode, SubItemCode)
		SELECT ID, ItemCode, SubItemCode FROM dbo.vstk_mt_SubLevel WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_vstk_mt_SubLevel OFF
GO
DROP TABLE dbo.vstk_mt_SubLevel
GO
EXECUTE sp_rename N'dbo.Tmp_vstk_mt_SubLevel', N'vstk_mt_SubLevel', 'OBJECT' 
GO
ALTER TABLE dbo.vstk_mt_SubLevel ADD CONSTRAINT
	PK_vstk_mt_SubLevel PRIMARY KEY CLUSTERED 
	(
	ID
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

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

update vpos_mt_report set rptname1=rptname

ALTER TABLE Vstk_mt_Payment ADD
	IntIn numeric(20, 6) NULL,
	IntOut numeric(20, 6) NULL
GO

ALTER TABLE Vstk_mt_Payment ADD CONSTRAINT
	DF_Vstk_mt_Payment_IntIn DEFAULT 0 FOR IntIn
GO

ALTER TABLE Vstk_mt_Payment ADD CONSTRAINT
	DF_Vstk_mt_Payment_IntOut DEFAULT 0 FOR IntOut
GO

update vstk_mt_payment set intin=0 where intin is null
update vstk_mt_payment set intout=0 where intout is null

DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=83) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) VALUES('[L83] Fire to kitchen if table exchanged',83,'L',83,'XOXXXXXXXX')

/*
   Tuesday, June 23, 20094:55:39 PM
   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
CREATE TABLE dbo.vpos_trs_PrintKitchen
	(
	ID bigint NOT NULL IDENTITY (1, 1),
	Remark1 varchar(100) NULL,
	Remark2 varchar(100) NULL,
	Remark3 varchar(100) NULL,
	Remark4 varchar(100) NULL,
	Remark5 varchar(100) NULL,
	FromTableCode varchar(100) NULL,
	ToTableCode varchar(100) NULL,
	PrintStatus bit NULL,
	TrsDate varchar(50) NULL,
	TrsTime varchar(50) NULL,
	PrinterGroupCode varchar(20) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.vpos_trs_PrintKitchen ADD CONSTRAINT
	PK_vpos_trs_PrintKitchen PRIMARY KEY CLUSTERED 
	(
	ID
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

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