resources/sql/autopatches/20170907.ferret.03.user.ngrams.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 / autopatches / 20170907.ferret.03.user.ngrams.sql

at recaptime-dev/main 5 lines 233 B view raw

wrap content

epriestley Support Ferret engine for searching users 8y ago

3ff9d4a4

1CREATE TABLE {$NAMESPACE}_user.user_user_fngrams (
2  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3  documentID INT UNSIGNED NOT NULL,
4  ngram CHAR(3) NOT NULL COLLATE {$COLLATE_TEXT}
5) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};