[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_timeline.timeline_event
   2    ADD dataID int unsigned;
   3  
   4  ALTER TABLE {$NAMESPACE}_timeline.timeline_event
   5    ADD UNIQUE KEY (dataID);
   6  
   7  UPDATE {$NAMESPACE}_timeline.timeline_event e,
   8         {$NAMESPACE}_timeline.timeline_eventdata d
   9    SET e.dataID = d.id
  10    WHERE d.eventID = e.id;
  11  
  12  ALTER TABLE {$NAMESPACE}_timeline.timeline_eventdata
  13    DROP eventID;