Files
2017-10-07 12:24:14 +02:00

35 lines
668 B
SQL

ALTER TABLE `FinancialTransactionRows`
DROP COLUMN `Amount`
#
DROP PROCEDURE IF EXISTS `CreateFinancialTransactionRow`
#
DROP PROCEDURE IF EXISTS `CreateFinancialTransactionRowPrecise`
#
CREATE PROCEDURE `CreateFinancialTransactionRow`(
IN financialTransactionId INTEGER,
IN financialAccountId INTEGER,
IN amountCents BIGINT,
IN dateTime DATETIME,
IN personId INTEGER
)
BEGIN
INSERT INTO FinancialTransactionRows (FinancialAccountId, FinancialTransactionId, AmountCents, CreatedDateTime, CreatedByPersonId)
VALUES (financialAccountId, financialTransactionid, amountCents, dateTime, personId);
SELECT LAST_INSERT_ID() AS Identity;
END