Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='FIC20241024';

if @@ROWCOUNT!=0
	BEGIN
		RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1);
		RETURN;
	END
GO


IF COL_LENGTH('dbo.Seller', 'NationalityId') IS NULL
BEGIN
    ALTER TABLE dbo.Seller
    ADD NationalityId INT NULL
END
GO
IF COL_LENGTH('dbo.Seller', 'LastUpdated') IS NULL
BEGIN
    ALTER TABLE dbo.Seller
    ADD LastUpdated DATETIME NULL
END
GO
IF (SELECT COUNT(0) FROM City WHERE [Description] = 'Out side of SA/BOTSWANA/NAMIBIA') = 0
BEGIN
    INSERT INTO City(Region_ID, [Description]) VALUES((SELECT TOP(1) Region_ID FROM City), 'Out side of SA/BOTSWANA/NAMIBIA')
END
GO
IF (SELECT COUNT(0) FROM SystemSetting WHERE SettingKey = 'BuyshopSellerLastUpdated') = 0
BEGIN
    INSERT INTO SystemSetting(SettingKey, SettingCategoryId, SettingValueInt, SettingValueBit, TypeFlag) VALUES('BuyshopSellerLastUpdated', 1, 12, 1, 4)
END
GO

CREATE TABLE FICLoanRepaymentOptions (
    ID INT IDENTITY(1,1) PRIMARY KEY,
    Description NVARCHAR(255) NOT NULL,
    Active BIT DEFAULT(1) 
);
GO
INSERT INTO FICLoanRepaymentOptions (Description, Active)
VALUES 
    ('Salary', 1),
    ('Own Business', 1),
    ('Interest', 1),
    ('Gift', 1),
    ('Savings', 1),
    ('Other', 1);
GO
IF COL_LENGTH('dbo.Buyshop_FIC_Seller_Info', 'IsSuspicious') IS NULL
BEGIN
    ALTER TABLE Buyshop_FIC_Seller_Info
    ADD IsSuspicious BIT DEFAULT(0)
END
GO
IF COL_LENGTH('dbo.Buyshop_FIC_Seller_Info', 'HasCopyOfID') IS NULL
BEGIN
    ALTER TABLE Buyshop_FIC_Seller_Info
    ADD HasCopyOfID BIT DEFAULT(0)
END
GO
IF COL_LENGTH('dbo.Buyshop_FIC_Seller_Info', 'LoanRepaymentOption') IS NULL
BEGIN
    ALTER TABLE Buyshop_FIC_Seller_Info
    ADD LoanRepaymentOption INT
END
GO
IF (SELECT COUNT(0) FROM SystemSetting WHERE SettingKey = 'FIC') = 0 
BEGIN
    INSERT INTO SystemSetting(SettingKey, SettingCategoryId, SettingValueBit, SettingValueInt, SettingValueString, TypeFlag) VALUES('FIC', 1, 1, 25, 'https://www.web.xds.co.za/XDSConnect/', 4)
END
GO
IF (SELECT COUNT(0) FROM SystemSetting WHERE SettingKey = 'FICCredentials') = 0
BEGIN
    INSERT INTO SystemSetting(SettingKey, SettingCategoryId, SettingValueString, TypeFlag) VALUES('FICCredentials', 1, 'ElNXem+UtPGiFm/33O7Thg==;W+g9j8u+Z0Zpt9cJhZ3DNA==', 4)
END
GO





DECLARE @StoreId INT = (SELECT Default_Value FROM System_Default WHERE Default_Name = 'Main_Store_ID');

IF (@StoreId = 1) BEGIN UPDATE SystemSetting SET SettingValueString = 'IJj4iaMCQMim/FclAh2+qA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 10) BEGIN UPDATE SystemSetting SET SettingValueString = 'QP3uEDlAjpfUD7S5pJTzWw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 103) BEGIN UPDATE SystemSetting SET SettingValueString = 'AkaF5qGDzfNZWCNJ5YFfNA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 105) BEGIN UPDATE SystemSetting SET SettingValueString = 'yzc5wDJMtWdTrQ8YJxgkAQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 108) BEGIN UPDATE SystemSetting SET SettingValueString = 'MREkuOQWytSDxPIb2eKsPQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 109) BEGIN UPDATE SystemSetting SET SettingValueString = 'tphqNdorcuKOWptWemyf1w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 11) BEGIN UPDATE SystemSetting SET SettingValueString = '8wpKgXx8Y+jCVqUKrNcxTQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 112) BEGIN UPDATE SystemSetting SET SettingValueString = 'q+Kapo5eVb78pUxkKMWO6Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 114) BEGIN UPDATE SystemSetting SET SettingValueString = '2HEh3n3uwl3Z/SjKeLoFnQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 116) BEGIN UPDATE SystemSetting SET SettingValueString = 'BCEHZXPkm7MPICvU9okpOA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 119) BEGIN UPDATE SystemSetting SET SettingValueString = 'y2gRpnBcDFU27hjokuOWqg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 12) BEGIN UPDATE SystemSetting SET SettingValueString = 'ud1UGD/opgPPvVie6r86RQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 120) BEGIN UPDATE SystemSetting SET SettingValueString = 'B75lJw4t4YTFTi+7q5f5/g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 13) BEGIN UPDATE SystemSetting SET SettingValueString = '0fJFwL11RbYGuXZUJhQWwQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 130) BEGIN UPDATE SystemSetting SET SettingValueString = '2Yn7fCy9fosIVT+HIPg2KA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 132) BEGIN UPDATE SystemSetting SET SettingValueString = 'snB87rVItZpIuNBdNGxwxw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 133) BEGIN UPDATE SystemSetting SET SettingValueString = '4BOZdQAMnPr9VMN/P89Mhg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 134) BEGIN UPDATE SystemSetting SET SettingValueString = 'kYJC/fCT+C9hG5nDWIjdNg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 136) BEGIN UPDATE SystemSetting SET SettingValueString = 'GBC06ZL28nE3xqnyIgQLNw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 137) BEGIN UPDATE SystemSetting SET SettingValueString = 'GFX0dRjzF8izzk4Ph/bJ8Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 139) BEGIN UPDATE SystemSetting SET SettingValueString = 'yhnOIh+B/IYyDeKbdX8faA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 14) BEGIN UPDATE SystemSetting SET SettingValueString = 'a1zRqvX+qctgBs+OBhfKrg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 140) BEGIN UPDATE SystemSetting SET SettingValueString = 'iH1Cr8kMVE+ZuFc+7YNW/A==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 141) BEGIN UPDATE SystemSetting SET SettingValueString = 'wYxI0jpkWQUh8j0fxX7Y2Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 143) BEGIN UPDATE SystemSetting SET SettingValueString = 'sl6GIJVAdEkic1Uf43CByQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 144) BEGIN UPDATE SystemSetting SET SettingValueString = 'n98sVQENXAyrIznElIMMtQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 145) BEGIN UPDATE SystemSetting SET SettingValueString = 'XqfBhxK3PvloIMpUXmWOqg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 15) BEGIN UPDATE SystemSetting SET SettingValueString = 'ibReClhn4xlZNkeOSFKU8g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 153) BEGIN UPDATE SystemSetting SET SettingValueString = '1/HtmnEOOtAvwMrxhrSU4g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 154) BEGIN UPDATE SystemSetting SET SettingValueString = 'ss01ZCnjvXy2Mpro9zIG/g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 159) BEGIN UPDATE SystemSetting SET SettingValueString = '4SPqk8rfNjz7prMl451zfQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 16) BEGIN UPDATE SystemSetting SET SettingValueString = 'S2pN8Ub4Fd19rLT9T9jNzA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 161) BEGIN UPDATE SystemSetting SET SettingValueString = 'Z7DPONLBP45VDKn7C2+cgw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 163) BEGIN UPDATE SystemSetting SET SettingValueString = 'BBLgYCXFVSHuxW10E85sbw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 166) BEGIN UPDATE SystemSetting SET SettingValueString = 'MXcEWsbZUvYZngHlUz5gGg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 167) BEGIN UPDATE SystemSetting SET SettingValueString = 'y0C9C1e+9ItfNMeWk293iQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 169) BEGIN UPDATE SystemSetting SET SettingValueString = '4xj2jrL/U7TrcB2dHi8IAQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 176) BEGIN UPDATE SystemSetting SET SettingValueString = 'k3LA2gwKwfOY4PjdrdYF0Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 179) BEGIN UPDATE SystemSetting SET SettingValueString = 'ILrsHhxqujYqAOaE1kMyMw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 18) BEGIN UPDATE SystemSetting SET SettingValueString = 'ttNJn5rm3f50my+lhvp80w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 180) BEGIN UPDATE SystemSetting SET SettingValueString = 'FMWtc1zFkTr37jXGi36neg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 181) BEGIN UPDATE SystemSetting SET SettingValueString = 'bizWDTsL7TBHACdrD8tgzQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 184) BEGIN UPDATE SystemSetting SET SettingValueString = 'en4dTEDUewnmYBcf+zjTcw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 19) BEGIN UPDATE SystemSetting SET SettingValueString = 'Ijn5K23q1kISKrIKLJAjbw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 190) BEGIN UPDATE SystemSetting SET SettingValueString = 'bXZ8TXSdm1zZwtsE2p1gSg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 191) BEGIN UPDATE SystemSetting SET SettingValueString = 'lFlySZbWBSPJDTUWNKV8mg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 193) BEGIN UPDATE SystemSetting SET SettingValueString = 'BvKyudQuSQcgE2gL1H3DUA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 194) BEGIN UPDATE SystemSetting SET SettingValueString = '90Cn9gOIDUBVhtMYyCEZlw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 197) BEGIN UPDATE SystemSetting SET SettingValueString = 'pwYrjN019W9C0XAL5DfLwg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 198) BEGIN UPDATE SystemSetting SET SettingValueString = '4jprRd+j5h6Lz3dwWxUcRw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 20) BEGIN UPDATE SystemSetting SET SettingValueString = 'k+BXZakgHbuIem3xiD6txw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 201) BEGIN UPDATE SystemSetting SET SettingValueString = 'v6wNLRG9IAxVoOsSMm4n1g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 202) BEGIN UPDATE SystemSetting SET SettingValueString = 'WrO24leW9Gv4gQDl36exuA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 203) BEGIN UPDATE SystemSetting SET SettingValueString = 'dRFCyWoEG7PExtbd3pG5hg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 206) BEGIN UPDATE SystemSetting SET SettingValueString = 'TUrwSKRRE3/FEN/mBNQ3Lg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 207) BEGIN UPDATE SystemSetting SET SettingValueString = '+4S259T4reHBedJw7vyVFA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 21) BEGIN UPDATE SystemSetting SET SettingValueString = 'jvrOBWCl/tYD77oZsoyqjA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 210) BEGIN UPDATE SystemSetting SET SettingValueString = 'zSXT/BoONGMXxnk4XlTC2Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 211) BEGIN UPDATE SystemSetting SET SettingValueString = 'jgQhMHHO/kvFxturC263Sw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 212) BEGIN UPDATE SystemSetting SET SettingValueString = 'wO7Pkl9+qy5DPOUZWnb+Ag==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 213) BEGIN UPDATE SystemSetting SET SettingValueString = 'cih4yyIeukbJYz892K2oxA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 214) BEGIN UPDATE SystemSetting SET SettingValueString = 'rFETGdsDab+4oTwYCTy3BA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 217) BEGIN UPDATE SystemSetting SET SettingValueString = 'IEeO9nd/0w0+RE292wayVQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 218) BEGIN UPDATE SystemSetting SET SettingValueString = 'G414vQPOl80YN7LEwLLs3Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 22) BEGIN UPDATE SystemSetting SET SettingValueString = 'Pr+6eNrv1BTDIAf7djgY1Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 221) BEGIN UPDATE SystemSetting SET SettingValueString = 'PGgnJZS06pcOxu6fZiqLXw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 223) BEGIN UPDATE SystemSetting SET SettingValueString = 'prk2xOv0xO4NCQmCKNE0Lw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 224) BEGIN UPDATE SystemSetting SET SettingValueString = 'lwMcrSJtLG32lgjvlBliog==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 226) BEGIN UPDATE SystemSetting SET SettingValueString = 'mkJhRth6IRxs5MMctWfFyw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 228) BEGIN UPDATE SystemSetting SET SettingValueString = 'iA2GU9bCdnehavDhgOQPKg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 229) BEGIN UPDATE SystemSetting SET SettingValueString = 'G2ck6PHr+P9lQx0UX299Kg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 23) BEGIN UPDATE SystemSetting SET SettingValueString = 'kMR33/01HIq3QIqH2RBddQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 230) BEGIN UPDATE SystemSetting SET SettingValueString = 'hEXlrbp3haT+/D/d2DRHpQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 232) BEGIN UPDATE SystemSetting SET SettingValueString = 'qY84zXRQc65nC2Ks8V9q5w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 233) BEGIN UPDATE SystemSetting SET SettingValueString = 'V/MduWEG7yJe0G2KP6F1Pg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 234) BEGIN UPDATE SystemSetting SET SettingValueString = '9o/Vy971c9N7YDejrPXeUQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 235) BEGIN UPDATE SystemSetting SET SettingValueString = 'f1FQfvsGqH2YvZ4/ojlC/g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 236) BEGIN UPDATE SystemSetting SET SettingValueString = '6ayW+15HHjsGfHOsSEakEA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 237) BEGIN UPDATE SystemSetting SET SettingValueString = 'JJfDRYJa8YQ4b0oLDPO78Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 238) BEGIN UPDATE SystemSetting SET SettingValueString = 'AKNAec4b6YRTrgjiG46NHw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 239) BEGIN UPDATE SystemSetting SET SettingValueString = 'aCaFuqqC2wuRuRjvXxCDWA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 241) BEGIN UPDATE SystemSetting SET SettingValueString = 'X+4JHC3iGxuR3BFQ3QrCTg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 244) BEGIN UPDATE SystemSetting SET SettingValueString = 'DFuM4oACMYg6aYKKp/xWWA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 247) BEGIN UPDATE SystemSetting SET SettingValueString = 'y/jhxthaL7nmHcMmTmiSHQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 248) BEGIN UPDATE SystemSetting SET SettingValueString = '/kh6CQ/7WUNzL3JNbkjZBw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 249) BEGIN UPDATE SystemSetting SET SettingValueString = '9voU4lAGIz+JWT4XUlaQFg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 250) BEGIN UPDATE SystemSetting SET SettingValueString = 'PQ7D28UhNJW0V6zSFWPc9w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 254) BEGIN UPDATE SystemSetting SET SettingValueString = 'kXrOvDd/e8j4gLR+IvOvpA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 255) BEGIN UPDATE SystemSetting SET SettingValueString = 'drVL9wx5GilmhAB0Xae0gQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 256) BEGIN UPDATE SystemSetting SET SettingValueString = 'Dp5+4LZoxiL4l68f6qd25A==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 257) BEGIN UPDATE SystemSetting SET SettingValueString = 'AyJ+Jgn+uxTfPHfUCvIWPg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 258) BEGIN UPDATE SystemSetting SET SettingValueString = 'gx7LUhjrFYIEuKrhXrPdIQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 259) BEGIN UPDATE SystemSetting SET SettingValueString = 'Mzh8kWplKnpS9q9LLN4T9Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 260) BEGIN UPDATE SystemSetting SET SettingValueString = 'oYrtmwUl8q75jh/TTH5JxA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 261) BEGIN UPDATE SystemSetting SET SettingValueString = 'k2KqYHCXyfRAZXKUXNIX9w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 264) BEGIN UPDATE SystemSetting SET SettingValueString = 'yjtDjOfqkd9D8pfrjXJbew==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 266) BEGIN UPDATE SystemSetting SET SettingValueString = 'S5D12ATsUDzvsjSBbUUXgA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 267) BEGIN UPDATE SystemSetting SET SettingValueString = 'Ny4KeXVZ2qOQlxVT8fU01A==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 269) BEGIN UPDATE SystemSetting SET SettingValueString = 'JiYzxN/VoTuDWx4UMTixfw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 270) BEGIN UPDATE SystemSetting SET SettingValueString = '4N7V7Zlayz4iPccJUVdtvg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 271) BEGIN UPDATE SystemSetting SET SettingValueString = 'DtfkmSl80GKeItH+tNkzTQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 272) BEGIN UPDATE SystemSetting SET SettingValueString = 'Q1PPfzDXPctQMdNPGzcpIQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 273) BEGIN UPDATE SystemSetting SET SettingValueString = 'j9nGoizV6vYwb2QCziDr3w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 274) BEGIN UPDATE SystemSetting SET SettingValueString = 'eACthicj5W0Oa0DuUJLMHg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 275) BEGIN UPDATE SystemSetting SET SettingValueString = 'E1DcELynuccyg61qJgO9+A==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 277) BEGIN UPDATE SystemSetting SET SettingValueString = 'utngJ9OqGSRHeXg6omkMkQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 278) BEGIN UPDATE SystemSetting SET SettingValueString = 'Kfk3BVhofYM+BvDJKIyRig==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 279) BEGIN UPDATE SystemSetting SET SettingValueString = '6ogvGg8Gl9HgWZDxtBmSPQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 28) BEGIN UPDATE SystemSetting SET SettingValueString = 'Be+QRCNeOXbdQZyJZGxQvg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 280) BEGIN UPDATE SystemSetting SET SettingValueString = 'd7/1bsgnw6KWbUl25mEQJA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 281) BEGIN UPDATE SystemSetting SET SettingValueString = '6G+DvToeLh2wkrgv7/up0w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 282) BEGIN UPDATE SystemSetting SET SettingValueString = 'PE1JBnBY9gxyksDqttceoQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 283) BEGIN UPDATE SystemSetting SET SettingValueString = 'pTAesqIv2ydFrSIEwAJ1ug==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 285) BEGIN UPDATE SystemSetting SET SettingValueString = 'b2DLPEDm6cn6JKBhNb2umw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 286) BEGIN UPDATE SystemSetting SET SettingValueString = 'aAqFRDo+gcRvTaQrjYMQAA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 287) BEGIN UPDATE SystemSetting SET SettingValueString = '0ntfYGPODZEANc61AebHYQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 288) BEGIN UPDATE SystemSetting SET SettingValueString = 'IPoDM7gNVfFvx1vSpI6Cmg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 289) BEGIN UPDATE SystemSetting SET SettingValueString = 'ElpWHfnn86dKuWQPY4cKCQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 29) BEGIN UPDATE SystemSetting SET SettingValueString = 'oNcVN9FItLVcQZO1seqVsQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 290) BEGIN UPDATE SystemSetting SET SettingValueString = '7orGXu0fYIdmQye9eaLKog==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 291) BEGIN UPDATE SystemSetting SET SettingValueString = 'GjWFA5BRYlclecMA2/TLJQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 292) BEGIN UPDATE SystemSetting SET SettingValueString = 'Zqj8fGKaS6qXWkW03VDD9A==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 293) BEGIN UPDATE SystemSetting SET SettingValueString = 'dnSxJbtG16Cp9zy1zl1XSg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 294) BEGIN UPDATE SystemSetting SET SettingValueString = '8SlmIcAB7JZFi99QmLV3fQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 295) BEGIN UPDATE SystemSetting SET SettingValueString = 'aj8taJOiUIdFmx88skybUw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 296) BEGIN UPDATE SystemSetting SET SettingValueString = 'tmZwsO1zy8zSZTdmM0+2dg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 297) BEGIN UPDATE SystemSetting SET SettingValueString = '7vyHImsjKR5VyVSfTuaC/g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 298) BEGIN UPDATE SystemSetting SET SettingValueString = 'djnyQixznEohiwnqgViekw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 299) BEGIN UPDATE SystemSetting SET SettingValueString = 'IPvoDcXgMNLBsv6xSJo+ZA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 300) BEGIN UPDATE SystemSetting SET SettingValueString = 'qRo+VlqIn+zH73PqJ4mYpg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 301) BEGIN UPDATE SystemSetting SET SettingValueString = 'WuqQMDNOzKa3CXa8FdR1Kg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 302) BEGIN UPDATE SystemSetting SET SettingValueString = 'XwBC0vrU/PtIqUzkeFxTJw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 303) BEGIN UPDATE SystemSetting SET SettingValueString = 'J6XRdY+QXL7oUx8jDqmqmg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 305) BEGIN UPDATE SystemSetting SET SettingValueString = '5bChhGwmOWCyvTZ8pwkNbw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 306) BEGIN UPDATE SystemSetting SET SettingValueString = 'jyWRXwq/pZgZ9qXfhpqYiw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 308) BEGIN UPDATE SystemSetting SET SettingValueString = 'wtjsYly/iGS5VUNGWD0aMw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 31) BEGIN UPDATE SystemSetting SET SettingValueString = '7MIh2aUqHw1sF0CMmmo9iQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 32) BEGIN UPDATE SystemSetting SET SettingValueString = 'Sp1MSypg38aHPBGhBzOzng==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 34) BEGIN UPDATE SystemSetting SET SettingValueString = 'MJA24VjIveJNgWRuawna6A==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 36) BEGIN UPDATE SystemSetting SET SettingValueString = 'jV0mOxEK5UmIwkOJzW+cBA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 39) BEGIN UPDATE SystemSetting SET SettingValueString = 'XE1PD88aJtGXgytAcsyKoQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 4) BEGIN UPDATE SystemSetting SET SettingValueString = 'NH8WNyhR2ZuaEvGFkUGLsw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 40) BEGIN UPDATE SystemSetting SET SettingValueString = '6Tww52/pFGcBn+oLg0+ddA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 42) BEGIN UPDATE SystemSetting SET SettingValueString = '2/btXKBAu3hV9nhWfqdMNw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 44) BEGIN UPDATE SystemSetting SET SettingValueString = '+tfil5AUn4SnnplB66oH0w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 45) BEGIN UPDATE SystemSetting SET SettingValueString = '0MH5A3aFIalyEvIYHLpicg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 46) BEGIN UPDATE SystemSetting SET SettingValueString = 'vayn6QaEEXErSlLIMFiLWw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 47) BEGIN UPDATE SystemSetting SET SettingValueString = '1cqW7yWo5AuKXs2EAniz4g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 48) BEGIN UPDATE SystemSetting SET SettingValueString = 'fqiOYG8CCAkrbXrmtHqKxw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 49) BEGIN UPDATE SystemSetting SET SettingValueString = 'FXfTChjXdiIwtIngYFpX6Q==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 5) BEGIN UPDATE SystemSetting SET SettingValueString = 'H7KUBkC4YVCtSBZkO/ReVQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 51) BEGIN UPDATE SystemSetting SET SettingValueString = 'Yc/I0Y4vLeyrwQ5OVonpLw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 52) BEGIN UPDATE SystemSetting SET SettingValueString = 'See8mIui18LuHmbzgn5pWw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 53) BEGIN UPDATE SystemSetting SET SettingValueString = 'n5o1NiWigktLCXsxiK0xJQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 55) BEGIN UPDATE SystemSetting SET SettingValueString = '+bnJF4ObZFL9V9JZT86v9A==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 56) BEGIN UPDATE SystemSetting SET SettingValueString = 'lcYbd5pqeNX11OuhjwcfjQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 57) BEGIN UPDATE SystemSetting SET SettingValueString = '/HxbFAq2S2vePCMWRdqtWA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 58) BEGIN UPDATE SystemSetting SET SettingValueString = 'K3YLHq8I98JqZquJF2ybJg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 59) BEGIN UPDATE SystemSetting SET SettingValueString = 'q43kVzZlVvxpO5D2ClZcTw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 60) BEGIN UPDATE SystemSetting SET SettingValueString = 'lwrShzaKdsFgtqNEcH8JEg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 61) BEGIN UPDATE SystemSetting SET SettingValueString = 'nRbu68HYj8RLlYtIImNCQA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 63) BEGIN UPDATE SystemSetting SET SettingValueString = 'oj/W8iFjxlP1dkY6fnUNkg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 64) BEGIN UPDATE SystemSetting SET SettingValueString = 'YdSnBPtEaTIqAIXzk+w9Dg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 65) BEGIN UPDATE SystemSetting SET SettingValueString = 'sOwRwg5RWKEP5idI1rgYWQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 66) BEGIN UPDATE SystemSetting SET SettingValueString = 'mU74LthU3lsQFbRgynSOXA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 72) BEGIN UPDATE SystemSetting SET SettingValueString = '8crPPxAFcrO/RH026/isjA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 73) BEGIN UPDATE SystemSetting SET SettingValueString = 'NOZqvGZKa961cKIS3ShtBg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 74) BEGIN UPDATE SystemSetting SET SettingValueString = 'ZFpxWnRq2C7YOXL4pTal/w==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 77) BEGIN UPDATE SystemSetting SET SettingValueString = 'kjMuG//F7gfvJfan0QJA6g==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 78) BEGIN UPDATE SystemSetting SET SettingValueString = 'CCIx66yeI/ZvOeTbUHF8Hg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 79) BEGIN UPDATE SystemSetting SET SettingValueString = 'aS+xmH6MJUMIMCI/Im0xdg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 80) BEGIN UPDATE SystemSetting SET SettingValueString = 'NT/nHXNhRdSflcJgZpKRvQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 81) BEGIN UPDATE SystemSetting SET SettingValueString = 'UGThM/22sF1KtO0HhqCGvg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 87) BEGIN UPDATE SystemSetting SET SettingValueString = 'NNiBlVguby/37KQKIBtwWQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 88) BEGIN UPDATE SystemSetting SET SettingValueString = 'ycvO2EYtsbqKtdJvqttNcg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 89) BEGIN UPDATE SystemSetting SET SettingValueString = 'qQfRIrPZL8BHmgtaMUL28A==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 91) BEGIN UPDATE SystemSetting SET SettingValueString = 'j6gJZ+/bFWGdBk9ScRujaA==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 92) BEGIN UPDATE SystemSetting SET SettingValueString = 'VUDs6xSj7UsvNA/hWERiJg==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 95) BEGIN UPDATE SystemSetting SET SettingValueString = 'vXRtL6eC/YL91CTTel+oDQ==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 98) BEGIN UPDATE SystemSetting SET SettingValueString = 'FdWHEQhi5UFfFfz0yLUGJw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
IF (@StoreId = 99) BEGIN UPDATE SystemSetting SET SettingValueString = 'lu/+maHi4Y04ARcPlsHGDw==;QbnNkc7cvR0yol4fGh/S5g==' WHERE SettingKey = 'FICCredentials' END;
GO

DELETE FROM Country
WHERE [Description] IN 
('North Korea' 
,'Korea'
,'Myanmar'
,'Iran' 
,'Bulgaria' 
,'Burkina Faso' 
,'Cameroon' 
,'Croatia' 
,'Congo'
,'Congo Free State, The*'
,'Republic of the Congo'
,'Haiti' 
,'Kenya'
,'Mali' 
,'Monaco' 
,'Mozambique' 
,'Nigeria' 
,'Philippines'
,'Senegal' 
,'South Sudan'
,'Syria' 
,'Tanzania' 
,'Venezuela' 
,'Vietnam' 
,'Yemen')
GO


/****** Object:  Trigger [dbo].[Buyshop_FIC_Seller_Info_LOG_TR]    Script Date: 2024/10/24 15:02:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[Buyshop_FIC_Seller_Info_LOG_TR] ON [dbo].[Buyshop_FIC_Seller_Info] FOR INSERT, UPDATE,
DELETE AS declare @i varchar(max), @d varchar(max)   set @i = convert (varchar(max),(select * from inserted for xml auto, BINARY BASE64 )) 
set @d = convert (varchar(max),(select * from deleted for xml auto , BINARY BASE64 ))  exec LogDMLEvent  @TableName = 'Buyshop_FIC_Seller_Info', @Deleted = @D,  @Inserted = @i;
GO

ALTER TABLE [dbo].[Buyshop_FIC_Seller_Info] ENABLE TRIGGER [Buyshop_FIC_Seller_Info_LOG_TR]
GO



Print 'Insert into script history if everything else is cool';

	Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'FIC20241024');
	IF @@ERROR != 0
		BEGIN
			RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			RETURN;
		END
GO