[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
   2    ADD subpriority DOUBLE NOT NULL;
   3  
   4  ALTER TABLE {$NAMESPACE}_maniphest.maniphest_task
   5    ADD KEY (priority, subpriority);
   6  
   7  /* Seed the subpriority column with reasonable values that keep order stable. */
   8  UPDATE {$NAMESPACE}_maniphest.maniphest_task
   9    SET subpriority = (UNIX_TIMESTAMP() - dateModified);