Page MenuHomestyx hydra
Files F18451898

104.searchkey.sql
No OneTemporary
Actions

104.searchkey.sql
View Options

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

File Metadata

Mime Type
text/plain
Expires
Tue, May 26, 9:34 PM (1 d, 12 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
1545710
Default Alt Text
104.searchkey.sql (483 B)

Event Timeline

styx copyright 2020 sirocyl / ellie (kymkdd) / ncommander / styx contributors
Use of other names and brands is not intended to reflect a claim of, or right to, use the name or brand.
styx is an operating system using the Linux kernel and components, and "styx Linux" as a phrase does not reflect the inclusion of the Linux brand or trademark in the styx project.
Linux® is the registered trademark of Linus Torvalds in the U.S. and other countries.
Terms and Conditions (TODO: fix this!)