diff options
Diffstat (limited to 'www/mnogosearch31/files/msql_ispell.txt')
| -rw-r--r-- | www/mnogosearch31/files/msql_ispell.txt | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/www/mnogosearch31/files/msql_ispell.txt b/www/mnogosearch31/files/msql_ispell.txt new file mode 100644 index 000000000000..12936c8bf252 --- /dev/null +++ b/www/mnogosearch31/files/msql_ispell.txt @@ -0,0 +1,21 @@ +DROP TABLE affix\g +DROP TABLE spell\g + +CREATE TABLE affix ( + flag char(1) NOT NULL, + type char(1) NOT NULL, + lang char(3) NOT NULL, + mask char(32) NOT NULL, + find char(32) NOT NULL, + repl char(32) NOT NULL +) \g + +CREATE TABLE spell ( + word char(64) NOT NULL, + flag text(32) NOT NULL, + lang char(3) NOT NULL +) \g + + +CREATE INDEX affix_flag ON affix (flag)\g +CREATE INDEX spell_word ON spell (word)\g |