resources/sql/patches/129.savedquery.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 / 129.savedquery.sql

at recaptime-dev/main 13 lines 472 B view raw

wrap content

epriestley SQL Patch Management: SQL Changes 14y ago

68b597ff

 1CREATE TABLE {$NAMESPACE}_maniphest.maniphest_savedquery (
 2  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 3  userPHID varchar(64) COLLATE utf8_bin NOT NULL,
 4  queryKey varchar(64) COLLATE utf8_bin NOT NULL,
 5  name varchar(128) COLLATE utf8_general_ci NOT NULL,
 6  isDefault BOOL NOT NULL,
 7  dateCreated INT UNSIGNED NOT NULL,
 8  dateModified INT UNSIGNED NOT NULL,
 9
10  KEY (userPHID, name),
11  KEY (userPHID, isDefault, name)
12
13) ENGINE=InnoDB, COLLATE utf8_general_ci;