-- =============================================
-- Add Comp Set Name Column to mstProductCompetitorSet
-- Purpose: Store custom name for competitive product sets
-- Created: [Date]
-- =============================================

IF NOT EXISTS (SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[dbo].[mstProductCompetitorSet]') AND name = 'strCompSetName')
BEGIN
    ALTER TABLE [dbo].[mstProductCompetitorSet]
    ADD [strCompSetName] [NVARCHAR](100) NULL
    
    PRINT 'Column strCompSetName added successfully to mstProductCompetitorSet.'
END
ELSE
BEGIN
    PRINT 'Column strCompSetName already exists in mstProductCompetitorSet.'
END
GO

