resources/sql/patches/104.searchkey.sql at recaptime-dev/main

@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge

phorge phabricator

fork atom

phorge / resources / sql / patches / 104.searchkey.sql

at recaptime-dev/main 15 lines 483 B view raw

wrap content

epriestley SQL Patch Management: SQL Changes 14y ago

68b597ff

 1ALTER TABLE {$NAMESPACE}_search.search_query
 2  DROP authorPHID;
 3
 4ALTER 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. */
 8UPDATE {$NAMESPACE}_search.search_query
 9  SET queryKey = id;
10
11ALTER TABLE {$NAMESPACE}_search.search_query
12  ADD UNIQUE KEY (queryKey);
13
14/* NOTE: Accidentally added this as 104, merging. */
15UPDATE {$NAMESPACE}_project.project SET status = IF(status = 5, 100, 0);