Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/124.subpriority.sql
| ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task | ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task | ||||
| ADD subpriority DOUBLE NOT NULL; | ADD subpriority DOUBLE NOT NULL; | ||||
| ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task | ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task | ||||
| ADD KEY (priority, subpriority); | ADD KEY (priority, subpriority); | ||||
| /* Seed the subpriority column with reasonable values that keep order stable. */ | /* Seed the subpriority column with reasonable values that keep order stable. */ | ||||
| UPDATE {$NAMESPACE}_maniphest.maniphest_task | UPDATE {$NAMESPACE}_maniphest.maniphest_task | ||||
| SET subpriority = (UNIX_TIMESTAMP() - dateModified); | SET subpriority = (UNIX_TIMESTAMP() - dateModified); | ||||