[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_search.search_query
   2    DROP authorPHID;
   3  
   4  ALTER TABLE {$NAMESPACE}_search.search_query
   5    ADD queryKey VARCHAR(12) NOT NULL;
   6  
   7  /* Preserve URIs for old queries in case anyone has them bookmarked. */
   8  UPDATE {$NAMESPACE}_search.search_query
   9    SET queryKey = id;
  10  
  11  ALTER TABLE {$NAMESPACE}_search.search_query
  12    ADD UNIQUE KEY (queryKey);
  13  
  14  /* NOTE: Accidentally added this as 104, merging. */
  15  UPDATE {$NAMESPACE}_project.project SET status = IF(status = 5, 100, 0);