resources/sql/patches/050.taskdenormal.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 / 050.taskdenormal.sql

at recaptime-dev/main 20 lines 554 B view raw

wrap content

epriestley SQL Patch Management: SQL Changes 14y ago

68b597ff

 1ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
 2  ADD ownerOrdering varchar(64);
 3
 4ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
 5  ADD UNIQUE KEY (phid);
 6
 7ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
 8  ADD KEY (priority, status);
 9
10ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
11  ADD KEY (status);
12
13ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
14  ADD KEY (ownerPHID, status);
15
16ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
17  ADD KEY (authorPHID, status);
18
19ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
20  ADD KEY (ownerOrdering);