CREATE TABLE ncrossdict ( url_id int4 DEFAULT '0' NOT NULL, ref_id int4 DEFAULT '0' NOT NULL, word_id int4 DEFAULT '0' NOT NULL, intag int4 DEFAULT '0' NOT NULL ); CREATE INDEX ncrossdict_url_id ON ncrossdict (url_id); CREATE INDEX ncrossdict_ref_id ON ncrossdict (ref_id); CREATE INDEX ncrossdict_word_id ON ncrossdict (word_id);