[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_worker.worker_activetask
   2    ADD COLUMN priority int unsigned NOT NULL;
   3  
   4  ALTER TABLE {$NAMESPACE}_worker.worker_activetask
   5    ADD KEY (leaseOwner, priority, id);
   6  
   7  ALTER TABLE {$NAMESPACE}_worker.worker_archivetask
   8    ADD COLUMN priority int unsigned NOT NULL;
   9  
  10  ALTER TABLE {$NAMESPACE}_worker.worker_archivetask
  11    ADD KEY (leaseOwner, priority, id);