USE [Build_FIle]
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[isAllowCompanyItems] [bit] NULL 
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[AllowAutoDoctorCode] [bit] NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[AllowAutoCompanyCode] [bit] NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[AllowMoAonCompany] [bit] NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD	[AllowIPandOPDiscRate] [bit] NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[AllowEmployeeTagging] [bit] NOT NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[AllowTabularAmenities] [bit] NOT NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[isAllowUserVerification] [bit] NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[AllowBuildItemDiscountPerAmount] [bit] NOT NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[isAutoGenerateDoctorCode] [bit] NOT NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[DoctorID] [varchar](20) NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[CompanyID] [varchar](20) NULL
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD 	[CompanyAccountNum] [varchar](20) NULL
GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD  DEFAULT ((0)) FOR [AllowEmployeeTagging]
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD  DEFAULT ((0)) FOR [AllowTabularAmenities]
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD  DEFAULT ((0)) FOR [AllowBuildItemDiscountPerAmount]
GO

ALTER TABLE [dbo].[tbcoBuildFileSetting] ADD  DEFAULT ((1)) FOR [isAutoGenerateDoctorCode]
GO



USE [Build_FIle]
GO
/****** Object:  Table [dbo].[tbCoPackageGroup]    Script Date: 04/04/2017 15:33:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbCoPackageGroup](
	[Code] [varchar](10) NULL,
	[Description] [varchar](500) NULL,
	[Status] [bit] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [by_Code] ON [dbo].[tbCoPackageGroup] 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Default [DF__tbCoPacka__Statu__42EDA74D]    Script Date: 04/04/2017 15:33:38 ******/
ALTER TABLE [dbo].[tbCoPackageGroup] ADD  DEFAULT ((1)) FOR [Status]
GO