bbgo/migrations/mysql/20210307201830_add_deposits_table.sql

27 lines
549 B
SQL

-- +up
-- +begin
CREATE TABLE `deposits`
(
`gid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`exchange` VARCHAR(24) NOT NULL,
-- asset is the asset name (currency)
`asset` VARCHAR(10) NOT NULL,
`address` VARCHAR(128) NOT NULL DEFAULT '',
`amount` DECIMAL(16, 8) NOT NULL,
`txn_id` VARCHAR(256) NOT NULL,
`time` DATETIME(3) NOT NULL,
PRIMARY KEY (`gid`),
UNIQUE KEY `txn_id` (`exchange`, `txn_id`)
);
-- +end
-- +down
-- +begin
DROP TABLE IF EXISTS `deposits`;
-- +end