PRINT 'Drop columns "SlogansJSON", "CulturesJSON", "DefaultCulture" from [data].[Panels]...'

GO

ALTER TABLE [data].[Panels] DROP COLUMN SlogansJSON, DefaultCulture, CulturesJSON

GO

PRINT '[PRD-314] Complete!';
PRINT '[PRD-314] Update SettingsJSON in [data].[Panels] for EM Panel...';

GO

UPDATE [data].[Panels]
SET SettingsJSON = N'{"TrackingSettings":[{"Name":"adriver","Provider":"adriver","ClientId":"215862","Data":{"bn":"1"}},{"Name":"Rating Mail.ru","Provider":"ratingMailRu","ClientId":"2782648"},{"Name":"rambler","Provider":"rambler"},{"Name":"aegis","Provider":"aegis"},{"Name":"Google Analytics","Provider":"ga","ClientId":"UA-70363538-1"},{"Name":"Yandex.Metrika","Provider":"yandex-metrika","ClientId":"34261295"}], "IsExpressPollsAllowed": "true","SupportEmail": "support@expertnoemnenie.ru","FromEmail": "no-reply@expertnoemnenie.ru","FromEmailName": "Команда ЭМ","FromSystemEmail": "system@expertnoemnenie.ru","FromSystemEmailName": "Команда ЭМ", "MinRegAge": "14", "MaxRegAge": "100","SocialNetworks":[{"Id":"vk","Url":"http://vk.com/expertnoemnenie","ClientId":"5555325"},{"Id":"fb","Url":"https://www.facebook.com/expertnoemnenie/"},{"Id":"ok","Url":"http://ok.ru/expertnoemnenie","ClientId":"1247643904","PublicKey":"CBAKIOFLEBABABABA", "SecretKey":"1DBF10DCFB5DD5D8E203814F"}],"ReferralReward": "15.50000", "MinAccountBalance": "500.00000","MinRequestAmount": "300.00000", "Slogans":{"ru-RU": "Проходите опросы, получайте вознаграждение. Изменим мир к лучшему вместе!","en-US":"Your opinion changes goods and services<br/>We appreciate it!"}, "DefaultCulture":"ru-RU", "SupportedCultures":[], "SupportReferrals": "true", "SupportFraudCheck":"true", "SupportRating": "true","SupportTickets":"true", "ReferralTarget": 2, "Countries":[1001,1002,1003,1004,1006,1019],"HubOpinionTeamCode":"17"}'
WHERE Id = 1029695;

GO

PRINT '[PRD-314] Complete!';
PRINT '[PRD-314] Update SettingsJSON in [data].[Panels] for DM Panel...';

GO

UPDATE [data].[Panels]
SET SettingsJSON = N'{"FromEmail":"no-reply.demo@panelrider.com","FromEmailName":"Demo","FromSystemEmail":"system.demo@panelrider.com","FromSystemEmailName":"Demo","SupportEmail":"support.demo@panelrider.com","MinRegAge":"18","MaxRegAge":"80","SocialNetworks":[],"SupportExpressPolls":"false","SupportReferrals":"true","SupportFraudCheck":"true","SupportTickets":"true","SupportRating":"true","ReferralTarget":"2","ReferralReward":"15.50000","MinAccountBalance":"500.00000","MinRequestAmount":"300.00000", "Slogans":{"ru-RU": "Демонстрационная панель!<br/>Попробуй, это просто!"}, "DefaultCulture":"ru-RU", "SupportedCultures":[], "Countries":[1001]}'
WHERE Id = 6934082;

GO

PRINT '[PRD-314] Complete!';
PRINT '[PRD-314] Update SettingsJSON in [data].[Panels] for BP Panel...';

GO

UPDATE [data].[Panels]
SET SettingsJSON = N'{"TrackingSettings":[{"Name":"aegis","Provider":"aegis"},{"Name":"Google Analytics","Provider":"ga","ClientId":"UA-1963280-24"},{"Name":"LiveInternet","Provider":"liveInternet"}],"FromEmail":"no-reply@bigpoll.ru","FromEmailName":"Bigpoll","FromSystemEmail":"system@bigpoll.ru","FromSystemEmailName":"Bigpoll","SupportEmail":"support@bigpoll.ru","MinRegAge":"18","MaxRegAge":"90","SocialNetworks":[],"SupportExpressPolls":"false","SupportReferrals":"true","SupportFraudCheck":"true","SupportTickets":"true","SupportRating":"true","SupportSurveyReview":"true","SupportIframe":"true","ReferralTarget":"2","ReferralReward":"10.00000","MinAccountBalance":"500.00000","MinRequestAmount":"300.00000", "Slogans":{"ru-RU": ""}, "DefaultCulture":"ru-RU","SupportedCultures":[],"Countries":[1001],"Copyright":"","HubOpinionTeamCode":"37"}'
WHERE Id = 7110218;

GO

PRINT '[PRD-314] Complete!';

PRINT '[PRD-598] Update [sec].[Partners] table...';

GO

UPDATE [sec].[Partners]
SET SettingsJSON = '{"ShowReviewPage" : false, "Currency" : 301, "ShowCaptcha" : false}';

GO

PRINT '[PRD-598] Complete!';
<<<<<<< HEAD

GO

ALTER TABLE [data].[PanelUserReferrals] ADD PrevUrlHost		NVARCHAR(256) NULL
ALTER TABLE [data].[PanelUserReferrals] ADD PrevUrlPath		NVARCHAR(256) NULL
ALTER TABLE [data].[PanelUserReferrals] ADD PrevUrlQuery	NVARCHAR(256) NULL

GO

PRINT '[PRD-635] Complete!';

PRINT '[PRD-575] Add new column to [data].[PanelCountryRequestTypes]...';

GO

ALTER TABLE [data].[PanelCountryRequestTypes] ADD SettingsJSON nvarchar(MAX);

GO

PRINT '[PRD-575] Complete!';
PRINT '[PRD-575] Add default values to [SettingsJSON] from [data].[PanelCountryRequestTypes]...'

GO

UPDATE [PanelCountryRequestTypes]
SET SettingsJSON = '{"MinAccountBalance":"500.00000","MinRequestAmount":"300.00000"}'

GO

PRINT '[PRD-575] Complete!';

/*
А вот эту хрень нужно проверять вручную!!!!

PRINT '[PRD-314] Update SettingsJSON in [data].[Panels] for EM Panel...';

GO

UPDATE [data].[Panels]
SET SettingsJSON = N'{"TrackingSettings":[{"Name":"adriver","Provider":"adriver","ClientId":"215862","Data":{"bn":"1"}},{"Name":"Rating Mail.ru","Provider":"ratingMailRu","ClientId":"2782648"},{"Name":"rambler","Provider":"rambler"},{"Name":"aegis","Provider":"aegis"},{"Name":"Google Analytics","Provider":"ga","ClientId":"UA-70363538-1"},{"Name":"Yandex.Metrika","Provider":"yandex-metrika","ClientId":"34261295"}], "IsExpressPollsAllowed": "true","SupportEmail": "support@expertnoemnenie.ru","FromEmail": "no-reply@expertnoemnenie.ru","FromEmailName": "Команда ЭМ","FromSystemEmail": "system@expertnoemnenie.ru","FromSystemEmailName": "Команда ЭМ", "MinRegAge": "14", "MaxRegAge": "100","SocialNetworks":[{"Id":"vk","Url":"http://vk.com/expertnoemnenie","ClientId":"5555325"},{"Id":"fb","Url":"https://www.facebook.com/expertnoemnenie/"},{"Id":"ok","Url":"http://ok.ru/expertnoemnenie","ClientId":"1247643904","PublicKey":"CBAKIOFLEBABABABA", "SecretKey":"1DBF10DCFB5DD5D8E203814F"}],"ReferralReward": "15.50000", "MinAccountBalance": "500.00000","MinRequestAmount": "300.00000", "Slogans":{"ru-RU": "Проходите опросы, получайте вознаграждение. Изменим мир к лучшему вместе!","en-US":"Your opinion changes goods and services<br/>We appreciate it!"},"SupportedCultures":[], "SupportReferrals": "true", "SupportFraudCheck":"true", "SupportRating": "true","SupportTickets":"true", "ReferralTarget": 2, "Countries":[1001,1002,1003,1004,1006,1019],"HubOpinionTeamCode":"17"}'
WHERE Id = 1029695;

GO

PRINT '[PRD-314] Complete!';
PRINT '[PRD-314] Update SettingsJSON in [data].[Panels] for DM Panel...';

GO

UPDATE [data].[Panels]
SET SettingsJSON = N'{"FromEmail":"no-reply.demo@panelrider.com","FromEmailName":"Demo","FromSystemEmail":"system.demo@panelrider.com","FromSystemEmailName":"Demo","SupportEmail":"support.demo@panelrider.com","MinRegAge":"18","MaxRegAge":"80","SocialNetworks":[],"SupportExpressPolls":"false","SupportReferrals":"true","SupportFraudCheck":"true","SupportTickets":"true","SupportRating":"true","ReferralTarget":"2","ReferralReward":"15.50000","MinAccountBalance":"500.00000","MinRequestAmount":"300.00000", "Slogans":{"ru-RU": "Демонстрационная панель!<br/>Попробуй, это просто!"}, "SupportedCultures":[], "Countries":[1001]}'
WHERE Id = 6934082;

GO

PRINT '[PRD-314] Complete!';
PRINT '[PRD-314] Update SettingsJSON in [data].[Panels] for BP Panel...';

GO

UPDATE [data].[Panels]
SET SettingsJSON = N'{"TrackingSettings":[{"Name":"aegis","Provider":"aegis"},{"Name":"Google Analytics","Provider":"ga","ClientId":"UA-1963280-24"},{"Name":"LiveInternet","Provider":"liveInternet"}],"FromEmail":"no-reply@bigpoll.ru","FromEmailName":"Bigpoll","FromSystemEmail":"system@bigpoll.ru","FromSystemEmailName":"Bigpoll","SupportEmail":"support@bigpoll.ru","MinRegAge":"18","MaxRegAge":"90","SocialNetworks":[],"SupportExpressPolls":"false","SupportReferrals":"true","SupportFraudCheck":"true","SupportTickets":"true","SupportRating":"true","SupportSurveyReview":"true","SupportIframe":"true","ReferralTarget":"2","ReferralReward":"10.00000","MinAccountBalance":"500.00000","MinRequestAmount":"300.00000", "Slogans":{"ru-RU": ""},"SupportedCultures":[],"Countries":[1001],"Copyright":"","HubOpinionTeamCode":"37"}'
WHERE Id = 7110218;

GO

PRINT '[PRD-314] Complete!';
*/

PRINT '[PRD-716] Add column `FileId` in [data].[SurveyCollectors]...'

GO

ALTER TABLE [data].[SurveyCollectors] ADD FileId bigint NULL

GO

ALTER TABLE [data].[SurveyCollectors]  WITH CHECK ADD  CONSTRAINT [FK_SurveyCollectors_FileId] FOREIGN KEY([FileId])
REFERENCES [data].[Files] ([Id])

GO

ALTER TABLE [data].[SurveyCollectors] CHECK CONSTRAINT [FK_SurveyCollectors_FileId]

GO

PRINT '[PRD-716] Complete!';
=======
PRINT '[PRD-682] Update PanelSettings (Add prm AverageResponse)...';

GO

WITH EM AS
(
    SELECT	SettingsJSON
    FROM	[data].[Panels]
    WHERE	id = 1029695
)
UPDATE [data].[Panels]
SET SettingsJSON = (SELECT JSON_MODIFY((SELECT * FROM EM), '$.AverageResponse', 10))
WHERE id = 1029695

GO

PRINT '[PRD-682] Complete!';
>>>>>>> feature/PRD-422-lite-admin