Files

43 lines
1.1 KiB
SQL

CREATE TABLE `FinancialTransactionRowsNativeCurrency` (
`FinancialTransactionRowId` INT NOT NULL,
`CurrencyId` INT NOT NULL,
`NativeAmountCents` BIGINT NOT NULL,
PRIMARY KEY (`FinancialTransactionRowId`))
#
DROP procedure IF EXISTS `SetFinancialTransactionRowNativeCurrency`
#
CREATE PROCEDURE `SetFinancialTransactionRowNativeCurrency`(
IN financialTransactionRowId INT,
IN currencyId INT,
IN nativeAmountCents BIGINT
)
BEGIN
IF ((SELECT COUNT(*) FROM FinancialTransactionRows
WHERE FinancialTransactionRows.FinancialTransactionRowId=financialTransactionRowId) = 0)
THEN
INSERT INTO FinancialTransactionRowsNativeCurrency (FinancialTransactionRowId,CurrencyId,NativeAmountCents)
VALUES (financialTransactionRowId,currencyId,nativeAmountCents);
ELSE
UPDATE FinancialTransactionRowsNativeCurrency
SET FinancialTransactionRowsNativeCurrency.CurrencyId=currencyId,
FinancialTransactionRowsNativeCurrency.NativeAmountCents=nativeAmountCents
WHERE FinancialTransactionRowsNativeCurrency.FinancialTransactionRowId=
financialTransactionRowId;
END IF;
END