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
1
fork

Configure Feed

Select the types of activity you want to include in your feed.

phorge / resources / sql / autopatches / 20150924.drydock.status.1.sql
at recaptime-dev/main 39 lines 1.2 kB view raw
epriestley Convert Drydock lease and resource constants to strings
e117ace8
1ALTER TABLE {$NAMESPACE}_drydock.drydock_lease 2 CHANGE status status VARCHAR(32) NOT NULL COLLATE {$COLLATE_TEXT}; 3 4UPDATE {$NAMESPACE}_drydock.drydock_lease 5 SET status = 'pending' WHERE status = '0'; 6 7UPDATE {$NAMESPACE}_drydock.drydock_lease 8 SET status = 'acquired' WHERE status = '5'; 9 10UPDATE {$NAMESPACE}_drydock.drydock_lease 11 SET status = 'active' WHERE status = '1'; 12 13UPDATE {$NAMESPACE}_drydock.drydock_lease 14 SET status = 'released' WHERE status = '2'; 15 16UPDATE {$NAMESPACE}_drydock.drydock_lease 17 SET status = 'broken' WHERE status = '3'; 18 19UPDATE {$NAMESPACE}_drydock.drydock_lease 20 SET status = 'destroyed' WHERE status = '4'; 21 22 23ALTER TABLE {$NAMESPACE}_drydock.drydock_resource 24 CHANGE status status VARCHAR(32) NOT NULL COLLATE {$COLLATE_TEXT}; 25 26UPDATE {$NAMESPACE}_drydock.drydock_resource 27 SET status = 'pending' WHERE status = '0'; 28 29UPDATE {$NAMESPACE}_drydock.drydock_resource 30 SET status = 'active' WHERE status = '1'; 31 32UPDATE {$NAMESPACE}_drydock.drydock_resource 33 SET status = 'released' WHERE status = '2'; 34 35UPDATE {$NAMESPACE}_drydock.drydock_resource 36 SET status = 'broken' WHERE status = '3'; 37 38UPDATE {$NAMESPACE}_drydock.drydock_resource 39 SET status = 'destroyed' WHERE status = '4';