/*
   Thursday, May 21, 20095:21:04 PM
   User: sa
   Server: VIEWSONIC
   Database: FnbSample
   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_mt_rma
	(
	ID bigint NOT NULL IDENTITY (1, 1),
	RmaCode varchar(20) NOT NULL,
	ItemCode varchar(20) NULL,
	PluCode varchar(20) NULL,
	InTrsNo varchar(100) NULL,
	InBillID bigint NULL,
	Status bit NOT NULL,
	OutTrsNo varchar(100) NULL,
	OutBillID bigint NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.vpos_mt_rma ADD CONSTRAINT
	DF_vpos_mt_rma_InBillID DEFAULT ((0)) FOR InBillID
GO
ALTER TABLE dbo.vpos_mt_rma ADD CONSTRAINT
	DF_vpos_mt_rma_Status DEFAULT ((0)) FOR Status
GO
ALTER TABLE dbo.vpos_mt_rma ADD CONSTRAINT
	DF_vpos_mt_rma_OutBillID DEFAULT ((0)) FOR OutBillID
GO
ALTER TABLE dbo.vpos_mt_rma ADD CONSTRAINT
	PK_vpos_mt_rma 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_mt_rma', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.vpos_mt_rma', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.vpos_mt_rma', 'Object', 'CONTROL') as Contr_Per 



/*
   Thursday, May 21, 20096:13:22 PM
   User: sa
   Server: VIEWSONIC
   Database: FnbSample
   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_mt_ItemModifier ADD
	SortNo int NULL,
	ControlQty int NULL
GO
ALTER TABLE dbo.Vpos_mt_ItemModifier ADD CONSTRAINT
	DF_Vpos_mt_ItemModifier_SortNo DEFAULT 0 FOR SortNo
GO
ALTER TABLE dbo.Vpos_mt_ItemModifier ADD CONSTRAINT
	DF_Vpos_mt_ItemModifier_ControlQty DEFAULT 0 FOR ControlQty
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_mt_ItemModifier', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_mt_ItemModifier', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_mt_ItemModifier', 'Object', 'CONTROL') as Contr_Per 

/*
   Thursday, May 21, 20097:01:11 PM
   User: sa
   Server: VIEWSONIC
   Database: RetSample
   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_mt_ModifierGroup
	DROP CONSTRAINT DF_Vpos_mt_ModifierGroup_SortNo
GO
ALTER TABLE dbo.Vpos_mt_ModifierGroup
	DROP CONSTRAINT DF_Vpos_mt_ModifierGroup_ControlQty
GO
ALTER TABLE dbo.Vpos_mt_ModifierGroup
	DROP COLUMN SortNo, ControlQty
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vpos_mt_ModifierGroup', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_mt_ModifierGroup', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_mt_ModifierGroup', 'Object', 'CONTROL') as Contr_Per