Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /***********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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement