DELETE FROM [dbo].[Currencies]
DECLARE @currencyId nvarchar(50)
DECLARE @currencyName nvarchar(50)
DECLARE @oldCurrencyId nvarchar(50)
DECLARE @siteId nvarchar(50)
SET @currencyId = '[currency id]' /* new currency ID*/
SET @currencyName = '[currency friendly name]'/* new currency friendly name */
SET @oldCurrencyId = '[current currency id]'/* current currency ID. case-sensitive. */
SET @siteId = '[site id]'/* ID of the site where currency should be changed */
INSERT INTO [dbo].[Currencies]
VALUES
(@currencyId,
@currencyName,
NULL)
/* Next step should be performed for every site that uses Sql-provider*/
DECLARE @fields nvarchar(MAX)
SET @fields = CAST((SELECT Fields FROM [dbo].[Settings] WHERE Id=@siteId) as nvarchar(MAX))
SET @fields = REPLACE(@fields,
'' + @oldCurrencyId + '',
'' + @currencyId + ''
)
UPDATE [dbo].[Settings]
SET Fields = CAST(@fields as xml)
WHERE Id=@siteId