Skip to content

Instantly share code, notes, and snippets.

@joshsmith

joshsmith/search_table.sql

Created October 2, 2010 17:43
Show Gist options
  • Save joshsmith/607821 to your computer and use it in GitHub Desktop.
Save joshsmith/607821 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
search_table.sql
CREATE TABLE search_table (
id INT(10) UNSIGNED NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
group_id INTEGER, INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://localhost:9312/test1";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment