@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<?php
2
3// See T6615. We're about to change the nullability on the "dataID" column,
4// but it may have a UNIQUE KEY on it. Make sure we get rid of this key first
5// so we don't run into trouble.
6
7// There's no "IF EXISTS" modifier for "ALTER TABLE" so run this as a PHP patch
8// instead of an SQL patch.
9
10$table = new PhabricatorWorkerActiveTask();
11$conn = $table->establishConnection('w');
12
13try {
14 queryfx(
15 $conn,
16 'ALTER TABLE %R DROP KEY %T',
17 $table,
18 'dataID');
19} catch (AphrontQueryException $ex) {
20 // Ignore.
21}