Page MenuHomestyx hydra

20130508.search_namedquery.sql
No OneTemporary

20130508.search_namedquery.sql

CREATE TABLE {$NAMESPACE}_search.search_namedquery (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
userPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
engineClassName VARCHAR(128) NOT NULL COLLATE utf8_bin,
queryName VARCHAR(255) NOT NULL COLLATE utf8_bin,
queryKey VARCHAR(12) NOT NULL COLLATE utf8_bin,
dateCreated INT(10) UNSIGNED NOT NULL,
dateModified INT(10) UNSIGNED NOT NULL,
UNIQUE KEY `key_userquery` (userPHID, engineClassName, queryKey),
PRIMARY KEY(id)
)
ENGINE=InnoDB, COLLATE utf8_general_ci

File Metadata

Mime Type
text/plain
Expires
Thu, Jan 15, 4:00 AM (1 d, 3 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
616205
Default Alt Text
20130508.search_namedquery.sql (520 B)

Event Timeline