recaptime.dev / phorge
@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 / 031.workerrace.sql
at recaptime-dev/main 13 lines 342 B view raw
epriestley SQL Patch Management: SQL Changes
68b597ff
1ALTER TABLE {$NAMESPACE}_worker.worker_task 2 ADD dataID int unsigned; 3 4ALTER TABLE {$NAMESPACE}_worker.worker_task 5 ADD UNIQUE KEY (dataID); 6 7UPDATE {$NAMESPACE}_worker.worker_task t, 8 {$NAMESPACE}_worker.worker_taskdata d 9 SET t.dataID = d.id 10 WHERE d.taskID = t.id; 11 12ALTER TABLE {$NAMESPACE}_worker.worker_taskdata 13 DROP taskID;