/* ------------------------------------------------------------

   DESCRIPTION:  clinical area from UPHMC to VSS VER

    tables:
        [dbo].[tbEyeCareMaster], [dbo].[tbLinacMaster], [dbo].[tbHospitalInfo], [dbo].[tbPulmoChargeSlip], [dbo].[tbEndoMaster], [dbo].[tbPTResult]

   AUTHOR:	philipp

   DATE:	01/04/2012 6:18:57 PM

   ------------------------------------------------------------ */

SET NOEXEC OFF
SET ANSI_WARNINGS ON
SET XACT_ABORT ON
SET IMPLICIT_TRANSACTIONS OFF
SET ARITHABORT ON
SET NOCOUNT ON
SET QUOTED_IDENTIFIER ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
GO
USE [Clinical_Area]
GO

-- Add Default Constraint DF__tbHospita__IsMar__76818E95 to tbHospitalInfo
Print 'Add Default Constraint DF__tbHospita__IsMar__76818E95 to tbHospitalInfo'
GO
ALTER TABLE [dbo].[tbHospitalInfo]
	ADD
	CONSTRAINT [DF__tbHospita__IsMar__76818E95]
	DEFAULT ((0)) FOR [IsMarkup]
GO


-- Create Index IX_tbLinacMaster on tbLinacMaster
Print 'Create Index IX_tbLinacMaster on tbLinacMaster'
GO
CREATE INDEX [IX_tbLinacMaster]
	ON [dbo].[tbLinacMaster] ([HospNum], [IdNum])
GO
-- Create Index IX_tbLinacMaster_1 on tbLinacMaster
Print 'Create Index IX_tbLinacMaster_1 on tbLinacMaster'
GO
CREATE CLUSTERED INDEX [IX_tbLinacMaster_1]
	ON [dbo].[tbLinacMaster] ([RequestNum])
GO

-- Add Column IsPrinted to tbEyeCareMaster
Print 'Add Column IsPrinted to tbEyeCareMaster'
GO
ALTER TABLE [dbo].[tbEyeCareMaster]
	ADD [IsPrinted] bit NOT NULL
	CONSTRAINT [DF_tbEyeCareMaster_IsPrinted] DEFAULT (0)

GO
-- Add Column Doctor to tbPulmoChargeSlip
Print 'Add Column Doctor to tbPulmoChargeSlip'
GO
ALTER TABLE [dbo].[tbPulmoChargeSlip]
	ADD [Doctor] varchar(50) NULL

GO
-- Add Column Tag to tbPulmoChargeSlip
Print 'Add Column Tag to tbPulmoChargeSlip'
GO
ALTER TABLE [dbo].[tbPulmoChargeSlip]
	ADD [Tag] varchar(1) NULL

GO
-- Add Primary Key PK_tbPTResult to tbPTResult
Print 'Add Primary Key PK_tbPTResult to tbPTResult'
GO
ALTER TABLE [dbo].[tbPTResult]
	ADD
	CONSTRAINT [PK_tbPTResult]
	PRIMARY KEY
	NONCLUSTERED
	([IDNum])
GO
-- Add Default Constraint DF_tbEndoMaster_ReaderFee to tbEndoMaster
Print 'Add Default Constraint DF_tbEndoMaster_ReaderFee to tbEndoMaster'
GO
ALTER TABLE [dbo].[tbEndoMaster]
	ADD
	CONSTRAINT [DF_tbEndoMaster_ReaderFee]
	DEFAULT ('') FOR [ReaderFee]
GO