mirror of
https://github.com/LBRYFoundation/pool.git
synced 2025-08-23 09:27:25 +00:00
0bf982da95
wallets without getinfo will be handled in a later commit... ps: remember to restart memcached service after the db change..
13 lines
578 B
SQL
13 lines
578 B
SQL
-- Recent additions to add after db init (.gz)
|
|
-- mysql yaamp -p < file.sql
|
|
|
|
-- filled by the stratum instance, to allow to handle/watch multiple instances
|
|
|
|
ALTER TABLE `coins` ADD `hasgetinfo` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' AFTER `account`;
|
|
|
|
UPDATE coins SET hassubmitblock=0 WHERE hassubmitblock IS NULL;
|
|
UPDATE coins SET hassubmitblock=1 WHERE hassubmitblock > 0;
|
|
ALTER TABLE `coins` CHANGE `hassubmitblock` `hassubmitblock` tinyint(1) UNSIGNED NOT NULL DEFAULT '1';
|
|
|
|
ALTER TABLE `coins` ADD `no_explorer` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `visible`;
|
|
|