/*
   Wednesday, December 31, 200814:04:27
   User: sa
   Server: VIEWSONIC
   Database: sampleDataFile
   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
	MifareYN bit NULL
GO
ALTER TABLE dbo.Vpos_trs_GeneralDetails ADD CONSTRAINT
	DF_Vpos_trs_GeneralDetails_MifareYN DEFAULT 0 FOR MifareYN
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_trs_GeneralDetails', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_trs_GeneralDetails', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_trs_GeneralDetails', 'Object', 'CONTROL') as Contr_Per 

/* 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_eod_GeneralDetails ADD
	MifareYN bit NULL
GO
ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD CONSTRAINT
	DF_Vpos_eod_GeneralDetails_MifareYN DEFAULT ((0)) FOR MifareYN
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 

/* 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_eod_BillDetails ADD
	MifareYN bit NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_MifareYN DEFAULT 0 FOR MifareYN
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_eod_BillDetails', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_eod_BillDetails', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_eod_BillDetails', 'Object', 'CONTROL') as Contr_Per 


/* 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
	MifareYN bit NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_MifareYN DEFAULT 0 FOR MifareYN
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_trs_BillDetails', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_trs_BillDetails', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_trs_BillDetails', 'Object', 'CONTROL') as Contr_Per 


/* 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_Bills ADD
	MifareCode varchar(20) NULL,
	MifareName varchar(100) NULL,
	MifareBalance numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_trs_Bills ADD CONSTRAINT
	DF_Vpos_trs_Bills_MifareBalance DEFAULT 0 FOR MifareBalance
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_trs_Bills', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_trs_Bills', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_trs_Bills', 'Object', 'CONTROL') as Contr_Per 

/* 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_eod_Bills ADD
	MifareCode varchar(20) NULL,
	MifareName varchar(100) NULL,
	MifareBalance numeric(18, 6) NULL
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD CONSTRAINT
	DF_Vpos_eod_Bills_MifareBalance DEFAULT ((0)) FOR MifareBalance
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_eod_Bills', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_eod_Bills', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_eod_Bills', 'Object', 'CONTROL') as Contr_Per