104.searchkey.sql
View Options

			ALTER TABLE phabricator_search.search_query
			DROP authorPHID;

			ALTER TABLE phabricator_search.search_query
			ADD queryKey VARCHAR(12) NOT NULL;

			/* Preserve URIs for old queries in case anyone has them bookmarked. */
			UPDATE phabricator_search.search_query
			SET queryKey = id;

			ALTER TABLE phabricator_search.search_query
			ADD UNIQUE KEY (queryKey);

			/* NOTE: Accidentally added this as 104, merging. */
			UPDATE phabricator_project.project SET status = IF(status = 5, 100, 0);

phab/resources/sql/patches/104.searchkey.sql35c5852d3ff3stable