summaryrefslogtreecommitdiff
path: root/www/mnogosearch/files/cross-crc.txt
diff options
context:
space:
mode:
Diffstat (limited to 'www/mnogosearch/files/cross-crc.txt')
-rw-r--r--www/mnogosearch/files/cross-crc.txt12
1 files changed, 12 insertions, 0 deletions
diff --git a/www/mnogosearch/files/cross-crc.txt b/www/mnogosearch/files/cross-crc.txt
new file mode 100644
index 000000000000..b68750b0b1f9
--- /dev/null
+++ b/www/mnogosearch/files/cross-crc.txt
@@ -0,0 +1,12 @@
+DROP TABLE ncrossdict\g
+
+CREATE TABLE ncrossdict (
+ url_id int NOT NULL,
+ ref_id int NOT NULL,
+ word_id int NOT NULL,
+ intag int NOT NULL
+)\g
+
+CREATE INDEX ncrossdict_url_id ON ncrossdict (url_id)\g
+CREATE INDEX ncrossdict_ref_id ON ncrossdict (ref_id)\g
+CREATE INDEX ncrossdict_word_id ON ncrossdict (word_id)\g