alter table patient_data..tbOPD_settings
add isAllowSendClearance bit default ((0))
go

update patient_data..tbOpd_Settings set  isAllowSendClearance=0
go

alter table patient_data..tbOPD_settings
add isAllowSysAndPathExamForm bit default ((0))
go
update patient_data..tbOpd_Settings set  isAllowSysAndPathExamForm=0
go
if not exists  (select menuid from PATIENT_DATA..tbOPDmenu where MenuID='93')
begin
INSERT INTO PATIENT_DATA..tbOPDMenu (MenuID,Menu,Status,MenuGroup,MainMenu)
VALUES ('93','CF4 Entries','1','A','2')
end