A setup for transactions

transactions.sql

CREATE TABLE transactions
(
    id INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
    accountId INT(11) NOT NULL,
    amount DECIMAL(10,2) NOT NULL
);

INSERT INTO transactions (accountId, amount) VALUES (1, 10);