/*
   Saturday, May 08, 20102:14:25 PM
   User: sa
   Server: yfp
   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_trs_Bills ADD
	CustomerName varchar(100) NULL,
	PassportNo varchar(100) NULL,
	FlightNo varchar(100) NULL,
	TravelCode varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_eod_Bills ADD
	CustomerName varchar(100) NULL,
	PassportNo varchar(100) NULL,
	FlightNo varchar(100) NULL,
	TravelCode varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	CustomerName1 varchar(100) NULL,
	PassportNo1 varchar(100) NULL,
	FlightNo1 varchar(100) NULL,
	TravelCode1 varchar(100) NULL,
	CustomerName2 varchar(100) NULL,
	PassportNo2 varchar(100) NULL,
	FlightNo2 varchar(100) NULL,
	TravelCode2 varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	CustomerName1 varchar(100) NULL,
	PassportNo1 varchar(100) NULL,
	FlightNo1 varchar(100) NULL,
	TravelCode1 varchar(100) NULL,
	CustomerName2 varchar(100) NULL,
	PassportNo2 varchar(100) NULL,
	FlightNo2 varchar(100) NULL,
	TravelCode2 varchar(100) NULL
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 

ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	SalesOrderNo varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD
	SalesOrderYesNo bit NULL
GO
ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT
	DF_Vpos_trs_BillDetails_SalesOrderYesNo DEFAULT 0 FOR SalesOrderYesNo
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	SalesOrderNo varchar(100) NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD
	SalesOrderYesNo bit NULL
GO
ALTER TABLE dbo.Vpos_eod_BillDetails ADD CONSTRAINT
	DF_Vpos_eod_BillDetails_SalesOrderYesNo DEFAULT 0 FOR SalesOrderYesNo
GO
DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=66) and DefaultType='B'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[B66] Capture Customer Details',66,'B',66,'OOXXXXXXXX')
DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=67) and DefaultType='B'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[B67] Special Printing to TSC Printer',67,'B',67,'OOXXXXXXXX')
DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=103) and DefaultType='L'
INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) 
VALUES('[L103] EOD Reset Stock Count Down',103,'L',103,'OOXXXXXXXX')


/****** Object:  Table [dbo].[Vs_Update]    Script Date: 05/18/2010 15:41:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Vs_Update](
 [ID] [bigint] IDENTITY(1,1) NOT NULL,
 [DbType] [varchar](20) NULL,
 [DbTable] [varchar](50) NULL,
 [DbColumn] [varchar](200) NULL,
 [DbUpdate] [bit] NULL CONSTRAINT [DF_Vs_Update_DbUpdate]  DEFAULT ((0)),
 [DbValue] [varchar](200) NULL,
 CONSTRAINT [PK_Vs_Update] PRIMARY KEY CLUSTERED 
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF