www/mnoGoSearch-current/files/cross.txt


1
2
3
4
5
6
7
8
9
10
11
12
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