IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'isCloneable'
      AND Object_ID = Object_ID(N'pal_SurfaceField'))
BEGIN

    ALTER TABLE pal_SurfaceField
	ADD isCloneable BIT NOT NULL
	DEFAULT 1 WITH VALUES;

	ALTER TABLE pal_SurfaceField
	ALTER COLUMN isCloneable BIT NULL;
	
END





IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_STUD1_GetProfileEmailAddresses]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[sp_STUD1_GetProfileEmailAddresses]
END




IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_STUD1_GetDeviceManagerChildData]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[sp_STUD1_GetDeviceManagerChildData]
END




IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_STUD1_GetMentorshipChildSurfaceData]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[sp_STUD1_GetMentorshipChildSurfaceData]
END




IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_GetChildSurfaceQueryData]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[sp_GetChildSurfaceQueryData]
END




IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_STUD1_CalculateTotalMonthlyIncomePostInterview]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[sp_STUD1_CalculateTotalMonthlyIncomePostInterview]
END