43 lines
1.1 KiB
SQL
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
|