DECLARE @Id INT;
SELECT @Id = id
FROM sysobjects
WHERE name = 'tmpDrugH';
IF NOT EXISTS
(
    SELECT *
    FROM syscolumns
    WHERE id = @Id
          AND name = 'MultipleFactorUserId'
)
    ALTER TABLE dbo.TmpDrugH
    ADD MultipleFactorUserId SMALLINT NULL
            DEFAULT (0);

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[Cash_CalcTransactionMultiplePrescription]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[Cash_CalcTransactionMultiplePrescription];

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[Cash_GetMultiplePrescriptionByUserId]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[Cash_GetMultiplePrescriptionByUserId];


IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[Cash_SaveMultilplePrescription]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[Cash_SaveMultilplePrescription];

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[GetIRIPrescription]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[GetIRIPrescription];

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[SupplementaryInsurance_CheckDuplicate]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[SupplementaryInsurance_CheckDuplicate];

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[SupplementaryInsurance_LoadDrugCondition]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[SupplementaryInsurance_LoadDrugCondition];

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[SupplementaryInsurance_SaveData]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[SupplementaryInsurance_SaveData];
