/***********Royi Namir  /  * Time: 16/12/2018 18:14:12*************/

USE ma;

--select * from tblsubscriptiontype


--select * from tblSystemParam where name = 'MAX_SAVED_ARTIST_VIP'


USE ma;

IF NOT EXISTS (
       SELECT 1
       FROM   INFORMATION_SCHEMA.columns
       WHERE  COLUMN_NAME = 'SeeMaxDaysBackwardPrice'
              AND TABLE_NAME = 'tblsubscriptiontype'
   )
BEGIN
    ALTER TABLE dbo.tblsubscriptiontype ADD SeeMaxDaysBackwardPrice INT NULL


    SET IDENTITY_INSERT [dbo].[tblSubscriptionType] ON;
END
GO



IF EXISTS (
       SELECT 1
       FROM   INFORMATION_SCHEMA.columns
       WHERE  COLUMN_NAME = 'SeeMaxDaysBackwardPrice'
              AND TABLE_NAME = 'tblsubscriptiontype'
   )
BEGIN
    BEGIN TRANSACTION

    INSERT INTO [dbo].[tblSubscriptionType]
      (
        [IdSubscriptionType],
        [Name],
        [Descr],
        [NoAccessURL],
        [IsVisible],
        [Priority],
        [IsCanSeeAuctionPrices],
        [IsCanSeeUpcomingAuctionPrices],
        [Order],
        [MaxSavedArtistSystemParam],
        [MaxSavedFiltersSystemParam],
        [isGetVenuesAlert],
        [IdMessageTemplateUpgrade],
        [SeeMaxDaysBackwardPrice]
      )
    SELECT 9,
           N'Esseintials',
           N'Esseintials',
           N'/',
           1,
           100,
           1,
           1,
           65,
           'MAX_SAVED_ARTIST_ESSENTIALS',
           NULL,
           1,
           NULL,
           -365


    COMMIT;
    RAISERROR (
        N'[dbo].[tblSubscriptionType]: Insert Batch: 1.....Done!',
        10,
        1
    )
    WITH NOWAIT;


    SET IDENTITY_INSERT [dbo].[tblSubscriptionType] OFF;
END