Skip to content

Instantly share code, notes, and snippets.

@3manuek

3manuek/fts_doc_id.sql

Created April 27, 2016 20:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 3manuek/df441753ea7666c3df7d13babc566c52 to your computer and use it in GitHub Desktop.
Save 3manuek/df441753ea7666c3df7d13babc566c52 to your computer and use it in GitHub Desktop.
Download ZIP
Create a table with FTS_DOC_ID
Raw
fts_doc_id.sql
CREATE TABLE test ( FTS_DOC_ID bigint unsigned AUTO_INCREMENT,
mainPk bigint, other text,
PRIMARY KEY(mainPk),
UNIQUE(FTS_DOC_ID)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment