Files

57 lines
1.2 KiB
SQL

CREATE TABLE `MaintenanceDonations` (
`MaintenanceDonationId` INT NOT NULL AUTO_INCREMENT,
`OrganizationId` INT NOT NULL,
`OpenedFinancialTransactionId` INT NOT NULL,
`Satoshis` BIGINT NOT NULL,
`ClosedFinancialTransactionId` INT NOT NULL DEFAULT 0,
PRIMARY KEY (`MaintenanceDonationId`),
INDEX `ixOpened` (`OpenedFinancialTransactionId` ASC),
INDEX `ixClosed` (`ClosedFinancialTransactionId` ASC),
INDEX `ixOrg` (`OrganizationId` ASC))
#
DROP PROCEDURE IF EXISTS `CreateMaintenanceDonation`
#
DROP PROCEDURE IF EXISTS `SetMaintenanceDonationClosed`
#
CREATE PROCEDURE `CreateMaintenanceDonation` (
IN organizationId INT,
IN openedFinancialId INT,
IN satoshis BIGINT
)
BEGIN
INSERT INTO MaintenanceDonations (OrganizationId,OpenedFinancialId,Satoshis)
VALUES (organizationId,openedFinancialId,satoshis);
SELECT LAST_INSERT_ID() AS Identity;
END
#
CREATE PROCEDURE `SetMaintenanceDonationClosed` (
IN maintenanceDonationId INT,
IN closedFinancialId INT
)
BEGIN
UPDATE MaintenanceDonations
SET MaintenanceDonations.ClosedFinancialId=closedFinancialId
WHERE MaintenanceDonations.MaintenanceDonationId=maintenanceDonationId;
SELECT ROW_COUNT() AS RecordsUpdated;
END