Files

70 lines
1.8 KiB
SQL

ALTER TABLE `HotBitcoinAddresses`
ADD COLUMN `BitcoinChainId` INT NOT NULL DEFAULT 1 AFTER `OrganizationId`,
ADD COLUMN `AddressStringFallback` VARCHAR(48) NOT NULL DEFAULT '' AFTER `AddressString`,
ADD INDEX `Ix_Chain` (`BitcoinChainId` ASC),
ADD INDEX `Ix_Address2` (`AddressStringFallback` ASC)
#
DROP PROCEDURE IF EXISTS `CreateHotBitcoinAddressConditional`
#
DROP PROCEDURE IF EXISTS `CreateHotBitcoinAddress`
#
CREATE PROCEDURE `CreateHotBitcoinAddressConditional`(
IN organizationId INT,
IN bitcoinChainId INT,
IN derivationPath VARCHAR(256),
IN addressString VARCHAR(48),
IN addressStringFallback VARCHAR(48)
)
BEGIN
IF ((SELECT COUNT(*) FROM HotBitcoinAddresses WHERE HotBitcoinAddresses.AddressString=addressString AND HotBitcoinAddresses.BitcoinChainId=bitcoinChainId) = 0)
THEN
INSERT INTO HotBitcoinAddresses
(OrganizationId,BitcoinChainId,DerivationPath,AddressString,BalanceSatoshis,ThroughputSatoshis)
VALUES
(organizationId,bitcoinChainId,derivationPath,addressString,addressStringFallback,0,0);
SELECT LAST_INSERT_ID() AS Identity;
ELSE
SELECT HotBitcoinAddresses.HotBitcoinAddressId AS Identity
FROM HotBitcoinAddresses
WHERE HotBitcoinAddresses.AddressString=addressString AND HotBitcoinAddresses.BitcoinChainId=bitcoinChainId;
END IF;
END
#
CREATE PROCEDURE `CreateHotBitcoinAddress`(
IN organizationId INT,
IN bitcoinChainId INT,
IN derivationPath VARCHAR(256),
IN addressString VARCHAR(48),
IN addressStringFallback VARCHAR(48)
)
BEGIN
INSERT INTO HotBitcoinAddresses
(OrganizationId,BitcoinChainId,DerivationPath,AddressString,AddressStringFallback,BalanceSatoshis,ThroughputSatoshis)
VALUES
(organizationId,bitcoinChainId,derivationPath,addressString,addressStringFallback,0,0);
SELECT LAST_INSERT_ID() AS Identity;
END