summaryrefslogtreecommitdiff
path: root/www/mnogosearch/files/cross.txt
diff options
context:
space:
mode:
Diffstat (limited to 'www/mnogosearch/files/cross.txt')
-rw-r--r--www/mnogosearch/files/cross.txt13
1 files changed, 13 insertions, 0 deletions
diff --git a/www/mnogosearch/files/cross.txt b/www/mnogosearch/files/cross.txt
new file mode 100644
index 000000000000..d8dd2048b2fe
--- /dev/null
+++ b/www/mnogosearch/files/cross.txt
@@ -0,0 +1,13 @@
+DROP TABLE crossdict\g
+
+CREATE TABLE crossdict (
+ url_id int NOT NULL,
+ ref_id int NOT NULL,
+ word char(32) NOT NULL,
+ intag int NOT NULL
+)\g
+
+
+CREATE INDEX crossdict_url_id ON crossdict (url_id)\g
+CREATE INDEX crossdict_ref_id ON crossdict (ref_id)\g
+CREATE INDEX crossdict_word ON crossdict (word)\g