www/mnogosearch31/files/cross-crc.txt


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