[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_worker.worker_task
   2    ADD dataID int unsigned;
   3  
   4  ALTER TABLE {$NAMESPACE}_worker.worker_task
   5    ADD UNIQUE KEY (dataID);
   6  
   7  UPDATE {$NAMESPACE}_worker.worker_task t,
   8         {$NAMESPACE}_worker.worker_taskdata d
   9    SET t.dataID = d.id
  10    WHERE d.taskID = t.id;
  11  
  12  ALTER TABLE {$NAMESPACE}_worker.worker_taskdata
  13    DROP taskID;