/*
   Wednesday, November 12, 20089:46:47 PM
   User: sa
   Server: user
   Database: FnBdatafile
   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_Period
	(
	PeriodCode varchar(20) NOT NULL,
	PeriodName varchar(100) NULL,
	PeriodFrom datetime NULL,
	PeriodThru datetime NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.vpos_mt_Period ADD CONSTRAINT
	PK_vpos_mt_Period PRIMARY KEY CLUSTERED 
	(
	PeriodCode
	) 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_Period', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.vpos_mt_Period', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.vpos_mt_Period', '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
	TourComm numeric(18, 6) NULL,
	TourCommAmt numeric(18, 6) NULL
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