use  Patient_Data
go
Alter  TABLE  tbAdmittingSetUp add
[IsAllowByPeriodReport] [bit] NOT   NULL   DEFAULT  ('1'),
[isAllowDischargewithoutBillingDate] [bit] NOT   NULL   DEFAULT  ('1'),
[isAllowDischargeBlockListed] [bit] NOT   NULL   DEFAULT  ((0)),
[isAllowAdmitBlockListed] [bit] NOT   NULL   DEFAULT  ((0))

go


USE  [PATIENT_DATA]
go

Alter  TABLE  tbAdmReportSetup add [DoctorsPatientLoad] [bit] NOT  NULL  DEFAULT  ((0))