--{5.8.0.1}  
----------------------  
-- $Change: xxxxx $  
-- $DateTime: 2013/01/30 23:42:00 $  
-- $Author: bdowling $  
----------------------  

IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE Name = N'group_id' AND Object_ID = Object_ID(N'[dbo].[event_template]'))    
ALTER TABLE [dbo].[event_template]
   ADD group_id uniqueidentifier NULL
GO

IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE Name = N'group_encounter_id' AND Object_ID = Object_ID(N'[dbo].[event_template]'))    
ALTER TABLE [dbo].[event_template]
   ADD group_encounter_id uniqueidentifier NULL
GO

IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE Name = N'extended_popup_id' AND Object_ID = Object_ID(N'[dbo].[event_template]'))    
ALTER TABLE [dbo].[event_template]
   ADD extended_popup_id uniqueidentifier NULL
GO