--{5.8.0.16}  
----------------------  
-- $Change: xxxxx $  
-- $DateTime: 2013/02/14 23:42:00 $  
-- $Author: bdowling $  
----------------------  

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