resources/sql/patches/liskcounters-task.sql at recaptime-dev/main

@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge

phorge phabricator

fork atom

phorge / resources / sql / patches / liskcounters-task.sql

at recaptime-dev/main 8 lines 296 B view raw

wrap content

epriestley Fix several migration issues with the Task/Counter patch 13y ago

ee2e85a0

1ALTER TABLE `{$NAMESPACE}_worker`.worker_task
2  CHANGE id id INT UNSIGNED NOT NULL;
3
4RENAME TABLE `{$NAMESPACE}_worker`.worker_task
5  TO `{$NAMESPACE}_worker`.worker_activetask;
6
7UPDATE `{$NAMESPACE}_worker`.lisk_counter
8  SET counterName = 'worker_activetask' WHERE counterName = 'worker_task';