JezK
Edit File: create.multi.sql
set quoted_identifier on; -- -- In Sybase we can't use TEXT type like in PgSQL or MySQL: -- -- The text, ntext, and image data types cannot be compared or sorted, -- except when using IS NULL or LIKE operator. -- -- We use VARCHAR() instead. -- CREATE TABLE "dict" ( "url_id" "int" NOT NULL , "word" varchar (32) NOT NULL , "intag" "int" NOT NULL ); CREATE INDEX "dict_url_id" ON "dict" ("url_id"); CREATE INDEX "dict_word_url_id" ON "dict" ("word", "url_id"); CREATE TABLE bdict ( word VARCHAR(255) NOT NULL, secno INT NOT NULL, intag IMAGE NOT NULL ); CREATE INDEX bdict_word ON bdict (word); CREATE TABLE qcache ( id INT NOT NULL, tm INT NOT NULL, doclist IMAGE NOT NULL, wordinfo TEXT NOT NULL, PRIMARY KEY (id,tm) ); CREATE INDEX key_qcache_tmstamp ON qcache(tm); CREATE TABLE "url" ( "rec_id" "int" IDENTITY NOT NULL PRIMARY KEY, "status" "int" DEFAULT 0 NOT NULL, "docsize" "int" DEFAULT 0 NOT NULL, "next_index_time" "int" DEFAULT 0 NOT NULL, "last_mod_time" "int" DEFAULT 0 NOT NULL, "referrer" "int" DEFAULT 0 NOT NULL, "hops" "int" DEFAULT 0 NOT NULL, "crc32" "int" DEFAULT -1 NOT NULL, "seed" "int" DEFAULT 0 NOT NULL, "bad_since_time" "int" NULL, "site_id" "int" NULL, "server_id" "int" NULL, "shows" "int" DEFAULT 0 NOT NULL, "pop_rank" float DEFAULT 0 NOT NULL, "url" varchar(600) NOT NULL, CONSTRAINT "UQ_url_url" UNIQUE ("url") ); CREATE UNIQUE INDEX "url_url" ON "url" ( "url" ); CREATE INDEX "url_crc" ON "url" ( "crc32" ); CREATE INDEX "url_seed" ON "url" ( "seed" ); CREATE INDEX "url_referrer" ON "url" ( "referrer" ); CREATE INDEX "url_next_index_time" ON "url" ( "next_index_time" ); CREATE INDEX "url_status" ON "url" ( "status" ); CREATE INDEX "url_bad_since_time" ON "url" ( "bad_since_time" ); CREATE INDEX "url_hops" ON "url" ( "hops" ); CREATE INDEX "url_siteid" ON "url" ( "site_id" ); CREATE INDEX "url_server_id" ON url ( "server_id" ); CREATE TABLE "urlinfo" ( "url_id" "int" NOT NULL, "sname" VARCHAR(96) NOT NULL, "sval" TEXT NOT NULL ); CREATE INDEX "urlinfo_id" ON "urlinfo" (url_id); CREATE TABLE "server" ( "rec_id" int not null primary key, "enabled" int default 0 not null , "url" varchar(4096) default '' not null , "tag" varchar(96) default '' not null , "category" int default 0 not null , "command" char(1) default 'S' not null , "ordre" int default 0 not null , "parent" int default 0 not null , "weight" float default 1 not null , "pop_weight" float default 0 not null ); CREATE INDEX "srv_ordre" ON "server" ("ordre"); CREATE INDEX "srv_parent" ON "server" ("parent"); CREATE INDEX "srv_command" ON "server" ("command"); CREATE INDEX "srv_tag" ON "server" ("tag"); CREATE INDEX "srv_category" ON "server" ("category"); CREATE TABLE "srvinfo" ( srv_id int NOT NULL, sname varchar(96) NOT NULL, sval varchar(4096) NOT NULL ); CREATE INDEX srvinfo_id ON srvinfo (srv_id); CREATE TABLE "links" ( "ot" int not null, "k" int not null, "weight" float default 0 not null ); CREATE UNIQUE INDEX links_links ON links (ot, k); CREATE INDEX links_ot ON links (ot); CREATE INDEX links_k ON links (k); CREATE TABLE "categories" ( "rec_id" "int" IDENTITY NOT NULL PRIMARY KEY, "path" varchar(10) DEFAULT '' NOT NULL, "link" varchar(10) DEFAULT '' NOT NULL, "name" varchar(64) DEFAULT '' NOT NULL ); CREATE TABLE "qtrack" ( "rec_id" "int" IDENTITY NOT NULL PRIMARY KEY, "ip" varchar(16) NOT NULL, "qwords" varchar(4096) NOT NULL, "qtime" int NOT NULL, "wtime" int NOT NULL, "found" int NOT NULL ); CREATE INDEX qtrack_ipt ON qtrack(ip,qtime); CREATE TABLE "qinfo" ( "q_id" int, "name" text, "value" text ); CREATE INDEX qinfo_id ON qinfo (q_id); CREATE TABLE crossdict ( url_id int DEFAULT '0' NOT NULL, ref_id int DEFAULT '0' NOT NULL, intag int DEFAULT '0' NOT NULL, word varchar(32) DEFAULT '0' NOT NULL ); CREATE INDEX crossdict_url_id ON crossdict (url_id); CREATE INDEX crossdict_ref_id ON crossdict (ref_id); CREATE INDEX crossdict_word ON crossdict (word); CREATE INDEX crossdict_word_url_id ON crossdict (word, url_id); CREATE TABLE wrdstat ( word varchar(64) NOT NULL, snd varchar(64) NOT NULL, cnt int NOT NULL ); CREATE INDEX wrdstat_word ON wrdstat (word); CREATE INDEX wrdstat_snd ON wrdstat (snd); CREATE TABLE dict00 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict00 ON dict00 (url_id); CREATE TABLE dict01 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict01 ON dict01 (url_id); CREATE TABLE dict02 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict02 ON dict02 (url_id); CREATE TABLE dict03 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict03 ON dict03 (url_id); CREATE TABLE dict04 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict04 ON dict04 (url_id); CREATE TABLE dict05 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict05 ON dict05 (url_id); CREATE TABLE dict06 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict06 ON dict06 (url_id); CREATE TABLE dict07 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict07 ON dict07 (url_id); CREATE TABLE dict08 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict08 ON dict08 (url_id); CREATE TABLE dict09 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict09 ON dict09 (url_id); CREATE TABLE dict0A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict0A ON dict0A (url_id); CREATE TABLE dict0B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict0B ON dict0B (url_id); CREATE TABLE dict0C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict0C ON dict0C (url_id); CREATE TABLE dict0D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict0D ON dict0D (url_id); CREATE TABLE dict0E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict0E ON dict0E (url_id); CREATE TABLE dict0F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict0F ON dict0F (url_id); CREATE TABLE dict10 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict10 ON dict10 (url_id); CREATE TABLE dict11 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict11 ON dict11 (url_id); CREATE TABLE dict12 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict12 ON dict12 (url_id); CREATE TABLE dict13 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict13 ON dict13 (url_id); CREATE TABLE dict14 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict14 ON dict14 (url_id); CREATE TABLE dict15 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict15 ON dict15 (url_id); CREATE TABLE dict16 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict16 ON dict16 (url_id); CREATE TABLE dict17 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict17 ON dict17 (url_id); CREATE TABLE dict18 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict18 ON dict18 (url_id); CREATE TABLE dict19 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict19 ON dict19 (url_id); CREATE TABLE dict1A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict1A ON dict1A (url_id); CREATE TABLE dict1B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict1B ON dict1B (url_id); CREATE TABLE dict1C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict1C ON dict1C (url_id); CREATE TABLE dict1D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict1D ON dict1D (url_id); CREATE TABLE dict1E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict1E ON dict1E (url_id); CREATE TABLE dict1F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict1F ON dict1F (url_id); CREATE TABLE dict20 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict20 ON dict20 (url_id); CREATE TABLE dict21 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict21 ON dict21 (url_id); CREATE TABLE dict22 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict22 ON dict22 (url_id); CREATE TABLE dict23 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict23 ON dict23 (url_id); CREATE TABLE dict24 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict24 ON dict24 (url_id); CREATE TABLE dict25 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict25 ON dict25 (url_id); CREATE TABLE dict26 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict26 ON dict26 (url_id); CREATE TABLE dict27 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict27 ON dict27 (url_id); CREATE TABLE dict28 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict28 ON dict28 (url_id); CREATE TABLE dict29 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict29 ON dict29 (url_id); CREATE TABLE dict2A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict2A ON dict2A (url_id); CREATE TABLE dict2B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict2B ON dict2B (url_id); CREATE TABLE dict2C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict2C ON dict2C (url_id); CREATE TABLE dict2D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict2D ON dict2D (url_id); CREATE TABLE dict2E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict2E ON dict2E (url_id); CREATE TABLE dict2F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict2F ON dict2F (url_id); CREATE TABLE dict30 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict30 ON dict30 (url_id); CREATE TABLE dict31 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict31 ON dict31 (url_id); CREATE TABLE dict32 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict32 ON dict32 (url_id); CREATE TABLE dict33 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict33 ON dict33 (url_id); CREATE TABLE dict34 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict34 ON dict34 (url_id); CREATE TABLE dict35 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict35 ON dict35 (url_id); CREATE TABLE dict36 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict36 ON dict36 (url_id); CREATE TABLE dict37 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict37 ON dict37 (url_id); CREATE TABLE dict38 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict38 ON dict38 (url_id); CREATE TABLE dict39 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict39 ON dict39 (url_id); CREATE TABLE dict3A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict3A ON dict3A (url_id); CREATE TABLE dict3B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict3B ON dict3B (url_id); CREATE TABLE dict3C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict3C ON dict3C (url_id); CREATE TABLE dict3D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict3D ON dict3D (url_id); CREATE TABLE dict3E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict3E ON dict3E (url_id); CREATE TABLE dict3F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict3F ON dict3F (url_id); CREATE TABLE dict40 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict40 ON dict40 (url_id); CREATE TABLE dict41 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict41 ON dict41 (url_id); CREATE TABLE dict42 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict42 ON dict42 (url_id); CREATE TABLE dict43 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict43 ON dict43 (url_id); CREATE TABLE dict44 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict44 ON dict44 (url_id); CREATE TABLE dict45 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict45 ON dict45 (url_id); CREATE TABLE dict46 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict46 ON dict46 (url_id); CREATE TABLE dict47 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict47 ON dict47 (url_id); CREATE TABLE dict48 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict48 ON dict48 (url_id); CREATE TABLE dict49 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict49 ON dict49 (url_id); CREATE TABLE dict4A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict4A ON dict4A (url_id); CREATE TABLE dict4B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict4B ON dict4B (url_id); CREATE TABLE dict4C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict4C ON dict4C (url_id); CREATE TABLE dict4D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict4D ON dict4D (url_id); CREATE TABLE dict4E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict4E ON dict4E (url_id); CREATE TABLE dict4F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict4F ON dict4F (url_id); CREATE TABLE dict50 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict50 ON dict50 (url_id); CREATE TABLE dict51 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict51 ON dict51 (url_id); CREATE TABLE dict52 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict52 ON dict52 (url_id); CREATE TABLE dict53 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict53 ON dict53 (url_id); CREATE TABLE dict54 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict54 ON dict54 (url_id); CREATE TABLE dict55 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict55 ON dict55 (url_id); CREATE TABLE dict56 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict56 ON dict56 (url_id); CREATE TABLE dict57 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict57 ON dict57 (url_id); CREATE TABLE dict58 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict58 ON dict58 (url_id); CREATE TABLE dict59 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict59 ON dict59 (url_id); CREATE TABLE dict5A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict5A ON dict5A (url_id); CREATE TABLE dict5B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict5B ON dict5B (url_id); CREATE TABLE dict5C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict5C ON dict5C (url_id); CREATE TABLE dict5D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict5D ON dict5D (url_id); CREATE TABLE dict5E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict5E ON dict5E (url_id); CREATE TABLE dict5F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict5F ON dict5F (url_id); CREATE TABLE dict60 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict60 ON dict60 (url_id); CREATE TABLE dict61 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict61 ON dict61 (url_id); CREATE TABLE dict62 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict62 ON dict62 (url_id); CREATE TABLE dict63 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict63 ON dict63 (url_id); CREATE TABLE dict64 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict64 ON dict64 (url_id); CREATE TABLE dict65 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict65 ON dict65 (url_id); CREATE TABLE dict66 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict66 ON dict66 (url_id); CREATE TABLE dict67 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict67 ON dict67 (url_id); CREATE TABLE dict68 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict68 ON dict68 (url_id); CREATE TABLE dict69 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict69 ON dict69 (url_id); CREATE TABLE dict6A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict6A ON dict6A (url_id); CREATE TABLE dict6B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict6B ON dict6B (url_id); CREATE TABLE dict6C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict6C ON dict6C (url_id); CREATE TABLE dict6D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict6D ON dict6D (url_id); CREATE TABLE dict6E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict6E ON dict6E (url_id); CREATE TABLE dict6F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict6F ON dict6F (url_id); CREATE TABLE dict70 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict70 ON dict70 (url_id); CREATE TABLE dict71 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict71 ON dict71 (url_id); CREATE TABLE dict72 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict72 ON dict72 (url_id); CREATE TABLE dict73 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict73 ON dict73 (url_id); CREATE TABLE dict74 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict74 ON dict74 (url_id); CREATE TABLE dict75 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict75 ON dict75 (url_id); CREATE TABLE dict76 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict76 ON dict76 (url_id); CREATE TABLE dict77 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict77 ON dict77 (url_id); CREATE TABLE dict78 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict78 ON dict78 (url_id); CREATE TABLE dict79 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict79 ON dict79 (url_id); CREATE TABLE dict7A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict7A ON dict7A (url_id); CREATE TABLE dict7B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict7B ON dict7B (url_id); CREATE TABLE dict7C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict7C ON dict7C (url_id); CREATE TABLE dict7D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict7D ON dict7D (url_id); CREATE TABLE dict7E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict7E ON dict7E (url_id); CREATE TABLE dict7F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict7F ON dict7F (url_id); CREATE TABLE dict80 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict80 ON dict80 (url_id); CREATE TABLE dict81 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict81 ON dict81 (url_id); CREATE TABLE dict82 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict82 ON dict82 (url_id); CREATE TABLE dict83 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict83 ON dict83 (url_id); CREATE TABLE dict84 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict84 ON dict84 (url_id); CREATE TABLE dict85 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict85 ON dict85 (url_id); CREATE TABLE dict86 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict86 ON dict86 (url_id); CREATE TABLE dict87 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict87 ON dict87 (url_id); CREATE TABLE dict88 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict88 ON dict88 (url_id); CREATE TABLE dict89 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict89 ON dict89 (url_id); CREATE TABLE dict8A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict8A ON dict8A (url_id); CREATE TABLE dict8B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict8B ON dict8B (url_id); CREATE TABLE dict8C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict8C ON dict8C (url_id); CREATE TABLE dict8D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict8D ON dict8D (url_id); CREATE TABLE dict8E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict8E ON dict8E (url_id); CREATE TABLE dict8F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict8F ON dict8F (url_id); CREATE TABLE dict90 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict90 ON dict90 (url_id); CREATE TABLE dict91 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict91 ON dict91 (url_id); CREATE TABLE dict92 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict92 ON dict92 (url_id); CREATE TABLE dict93 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict93 ON dict93 (url_id); CREATE TABLE dict94 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict94 ON dict94 (url_id); CREATE TABLE dict95 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict95 ON dict95 (url_id); CREATE TABLE dict96 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict96 ON dict96 (url_id); CREATE TABLE dict97 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict97 ON dict97 (url_id); CREATE TABLE dict98 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict98 ON dict98 (url_id); CREATE TABLE dict99 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict99 ON dict99 (url_id); CREATE TABLE dict9A ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict9A ON dict9A (url_id); CREATE TABLE dict9B ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict9B ON dict9B (url_id); CREATE TABLE dict9C ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict9C ON dict9C (url_id); CREATE TABLE dict9D ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict9D ON dict9D (url_id); CREATE TABLE dict9E ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict9E ON dict9E (url_id); CREATE TABLE dict9F ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdict9F ON dict9F (url_id); CREATE TABLE dictA0 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA0 ON dictA0 (url_id); CREATE TABLE dictA1 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA1 ON dictA1 (url_id); CREATE TABLE dictA2 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA2 ON dictA2 (url_id); CREATE TABLE dictA3 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA3 ON dictA3 (url_id); CREATE TABLE dictA4 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA4 ON dictA4 (url_id); CREATE TABLE dictA5 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA5 ON dictA5 (url_id); CREATE TABLE dictA6 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA6 ON dictA6 (url_id); CREATE TABLE dictA7 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA7 ON dictA7 (url_id); CREATE TABLE dictA8 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA8 ON dictA8 (url_id); CREATE TABLE dictA9 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictA9 ON dictA9 (url_id); CREATE TABLE dictAA ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictAA ON dictAA (url_id); CREATE TABLE dictAB ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictAB ON dictAB (url_id); CREATE TABLE dictAC ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictAC ON dictAC (url_id); CREATE TABLE dictAD ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictAD ON dictAD (url_id); CREATE TABLE dictAE ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictAE ON dictAE (url_id); CREATE TABLE dictAF ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictAF ON dictAF (url_id); CREATE TABLE dictB0 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB0 ON dictB0 (url_id); CREATE TABLE dictB1 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB1 ON dictB1 (url_id); CREATE TABLE dictB2 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB2 ON dictB2 (url_id); CREATE TABLE dictB3 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB3 ON dictB3 (url_id); CREATE TABLE dictB4 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB4 ON dictB4 (url_id); CREATE TABLE dictB5 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB5 ON dictB5 (url_id); CREATE TABLE dictB6 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB6 ON dictB6 (url_id); CREATE TABLE dictB7 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB7 ON dictB7 (url_id); CREATE TABLE dictB8 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB8 ON dictB8 (url_id); CREATE TABLE dictB9 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictB9 ON dictB9 (url_id); CREATE TABLE dictBA ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictBA ON dictBA (url_id); CREATE TABLE dictBB ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictBB ON dictBB (url_id); CREATE TABLE dictBC ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictBC ON dictBC (url_id); CREATE TABLE dictBD ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictBD ON dictBD (url_id); CREATE TABLE dictBE ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictBE ON dictBE (url_id); CREATE TABLE dictBF ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictBF ON dictBF (url_id); CREATE TABLE dictC0 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC0 ON dictC0 (url_id); CREATE TABLE dictC1 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC1 ON dictC1 (url_id); CREATE TABLE dictC2 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC2 ON dictC2 (url_id); CREATE TABLE dictC3 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC3 ON dictC3 (url_id); CREATE TABLE dictC4 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC4 ON dictC4 (url_id); CREATE TABLE dictC5 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC5 ON dictC5 (url_id); CREATE TABLE dictC6 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC6 ON dictC6 (url_id); CREATE TABLE dictC7 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC7 ON dictC7 (url_id); CREATE TABLE dictC8 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC8 ON dictC8 (url_id); CREATE TABLE dictC9 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictC9 ON dictC9 (url_id); CREATE TABLE dictCA ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictCA ON dictCA (url_id); CREATE TABLE dictCB ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictCB ON dictCB (url_id); CREATE TABLE dictCC ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictCC ON dictCC (url_id); CREATE TABLE dictCD ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictCD ON dictCD (url_id); CREATE TABLE dictCE ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictCE ON dictCE (url_id); CREATE TABLE dictCF ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictCF ON dictCF (url_id); CREATE TABLE dictD0 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD0 ON dictD0 (url_id); CREATE TABLE dictD1 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD1 ON dictD1 (url_id); CREATE TABLE dictD2 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD2 ON dictD2 (url_id); CREATE TABLE dictD3 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD3 ON dictD3 (url_id); CREATE TABLE dictD4 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD4 ON dictD4 (url_id); CREATE TABLE dictD5 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD5 ON dictD5 (url_id); CREATE TABLE dictD6 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD6 ON dictD6 (url_id); CREATE TABLE dictD7 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD7 ON dictD7 (url_id); CREATE TABLE dictD8 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD8 ON dictD8 (url_id); CREATE TABLE dictD9 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictD9 ON dictD9 (url_id); CREATE TABLE dictDA ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictDA ON dictDA (url_id); CREATE TABLE dictDB ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictDB ON dictDB (url_id); CREATE TABLE dictDC ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictDC ON dictDC (url_id); CREATE TABLE dictDD ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictDD ON dictDD (url_id); CREATE TABLE dictDE ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictDE ON dictDE (url_id); CREATE TABLE dictDF ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictDF ON dictDF (url_id); CREATE TABLE dictE0 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE0 ON dictE0 (url_id); CREATE TABLE dictE1 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE1 ON dictE1 (url_id); CREATE TABLE dictE2 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE2 ON dictE2 (url_id); CREATE TABLE dictE3 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE3 ON dictE3 (url_id); CREATE TABLE dictE4 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE4 ON dictE4 (url_id); CREATE TABLE dictE5 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE5 ON dictE5 (url_id); CREATE TABLE dictE6 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE6 ON dictE6 (url_id); CREATE TABLE dictE7 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE7 ON dictE7 (url_id); CREATE TABLE dictE8 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE8 ON dictE8 (url_id); CREATE TABLE dictE9 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictE9 ON dictE9 (url_id); CREATE TABLE dictEA ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictEA ON dictEA (url_id); CREATE TABLE dictEB ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictEB ON dictEB (url_id); CREATE TABLE dictEC ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictEC ON dictEC (url_id); CREATE TABLE dictED ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictED ON dictED (url_id); CREATE TABLE dictEE ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictEE ON dictEE (url_id); CREATE TABLE dictEF ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictEF ON dictEF (url_id); CREATE TABLE dictF0 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF0 ON dictF0 (url_id); CREATE TABLE dictF1 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF1 ON dictF1 (url_id); CREATE TABLE dictF2 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF2 ON dictF2 (url_id); CREATE TABLE dictF3 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF3 ON dictF3 (url_id); CREATE TABLE dictF4 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF4 ON dictF4 (url_id); CREATE TABLE dictF5 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF5 ON dictF5 (url_id); CREATE TABLE dictF6 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF6 ON dictF6 (url_id); CREATE TABLE dictF7 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF7 ON dictF7 (url_id); CREATE TABLE dictF8 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF8 ON dictF8 (url_id); CREATE TABLE dictF9 ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictF9 ON dictF9 (url_id); CREATE TABLE dictFA ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictFA ON dictFA (url_id); CREATE TABLE dictFB ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictFB ON dictFB (url_id); CREATE TABLE dictFC ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictFC ON dictFC (url_id); CREATE TABLE dictFD ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictFD ON dictFD (url_id); CREATE TABLE dictFE ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictFE ON dictFE (url_id); CREATE TABLE dictFF ( url_id int NOT NULL, secno smallint NOT NULL, word varchar(255) NOT NULL, intag varbinary(4000) NOT NULL, PRIMARY KEY(word,url_id,secno) ); CREATE INDEX wdictFF ON dictFF (url_id);