generate.sql

CREATE DATABASE p2pooltip;

USE p2pooltip;

CREATE TABLE IF NOT EXISTS `tips` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,                        -- index
    `commentid` VARCHAR(10) NOT NULL,                           -- Reddit comment id of tip
    `messageid` VARCHAR(10) NOT NULL,                           -- Reddit message id of Changetip message
    `amount` BIGINT NOT NULL,                                   -- original tip amount, in satoshis
    `sent` BIGINT NOT NULL,                                     -- final tip amount after fees, in satoshis
    `username` VARCHAR(20) NOT NULL,                            -- Reddit username of tipper
    `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,        -- timestamp
    `txid` VARCHAR(64) NOT NULL,                                -- Bitcoin transaction id
    PRIMARY KEY (`id`),
    KEY `commentid` (`commentid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;