USE BUILD_FILE 
GO

ALTER TABLE [TbBuildUserSettings]
ADD sInputTax bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sPHICnumber] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sBankAccount] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sDoctorRate] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sDoctorUtilities] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sAmenities] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sLogoandImage] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sBatchUpdate] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sClinicInfo] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sDocAccess] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [sClinicAddinfo] bit NULL


GO

ALTER TABLE [TbBuildUserSettings]
ADD [isAllowUploadDoctor] bit NULL


GO

ALTER TABLE [tbCoDoctor]
ADD [LicenseExpireDate] [varchar](30)


GO

ALTER TABLE [tbCoDoctor]
ADD [S2Number] [varchar](50)


GO

ALTER TABLE [tbCoDoctor]
ADD [S2Expiry] [varchar](20)


GO

ALTER TABLE [tbCoDoctor]
ADD [PHICExpireDate] [varchar](30)


GO

ALTER TABLE [tbCoDoctor]
ADD [CVStatus] [varchar](1)


GO

ALTER TABLE [tbCoDoctor]
ADD S2IssueDate [varchar](30)

use build_File
go

alter table tbcoaudexam
add RateSP  float

use build_File
go

alter table tbcoctexam
add RateSP  float

use build_File
go

alter table tbcohsexam
add RateSP  float

use build_File
go

alter table tbcolabexam
add RateSP float

use build_File
go

alter table tbconucexam
add RateSP float

use build_File
go

alter table tbcoptexam
add RateSP float

use build_File
go

alter table tbcortsexam
add RateSP float

use build_File
go

alter table tbcoultraexam
add RateSP float

use build_File
go

alter table tbcoxrayexam
add RateSP float

use build_File
go

alter table tbcootherrevenue
add RateSP float

USE BUILD_FILE
GO
ALTER TABLE [TbCoRevenueCode]
ADD AllowedEditAmount varchar(1)

USE BUILD_FILE
GO
ALTER TABLE [TbCoRevenueCode]
ADD chkAllowedExemptAllMarkup varchar(1)

USE BUILD_FILE
GO
ALTER TABLE [TbCoRevenueCode]
ADD isAllowedDiscountPerDay BIT

USE BUILD_FILE
GO
ALTER TABLE [TbCoRevenueCode]
ADD AllowDiscountPerDay float

USE BUILD_FILE
GO
ALTER TABLE [TbCoRevenueCode]
ADD PHACTIVE varchar(1)

USE BUILD_FILE
GO
ALTER TABLE [TbCoRevenueCode]
ADD CSActive varchar(1)

USE BUILD_FILE
GO
ALTER TABLE [TbCoDoctor]
ADD PMCCDateExpire varchar(15)


GO

ALTER TABLE tbCoAdmPackage_Items
add SpecimenID varchar(10)


GO