Skip to content

Latest commit

 

History

History
41 lines (37 loc) · 1.42 KB

SQL_MIGRATIONS.md

File metadata and controls

41 lines (37 loc) · 1.42 KB
Raw

2/12/2017

ALTER TABLE pool.config MODIFY item_value TEXT;

2/13/2017

ALTER TABLE pool.payments ADD transfer_fee BIGINT(20) DEFAULT 0 NULL;

2/16/2017

ALTER DATABASE pool DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.balance CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.bans CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.block_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.config CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.payments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.pools CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.port_config CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.ports CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.shapeshiftTxn CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.transactions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE pool.xmrtoTxn CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

2/25/2017

ALTER TABLE pool.users ADD enable_email BOOL DEFAULT true NULL;

3/8/2018

ALTER TABLE pool.block_log ADD INDEX `diff` (`find_time`, `difficulty`);