IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'pal_MedicalAdministrator' AND COLUMN_NAME = 'splitModifiers')
BEGIN
ALTER TABLE [dbo].[pal_MedicalAdministrator]
    ADD [splitModifiers] BIT CONSTRAINT [DF_pal_MedicalAdministrator_splitModifiers] DEFAULT ((0)) NULL;
END
