set quoted_identifier on;

--
-- In MS SQL  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(1,1) NOT NULL PRIMARY KEY,
        "status"          "int" NOT NULL DEFAULT 0,
        "docsize"         "int" NOT NULL DEFAULT 0,
        "next_index_time" "int" NOT NULL,
        "last_mod_time"   "int" NOT NULL DEFAULT 0,
        "referrer"        "int" NOT NULL DEFAULT 0,
        "hops"            "int" NOT NULL DEFAULT 0,
        "crc32"           "int" NOT NULL DEFAULT -1,
        "seed"            "int" NOT NULL DEFAULT 0,
        "bad_since_time"  "int"     NULL,
        "site_id"         "int"     NULL,
        "server_id"       "int"     NULL,
        "shows"           "int" NOT NULL DEFAULT 0,
        "pop_rank"        float NOT NULL DEFAULT 0,
        "url"             varchar(4096)  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           not null default 0,
        "url"        varchar(4096) not null default '',
        "tag"        varchar(96)   not null default '',
        "category"   int           not null default 0,
        "command"    char(1)       not null default 'S',
        "ordre"      int           not null default 0,
        "parent"     int           not null default 0,
        "weight"     float         not null default 1,
        "pop_weight" float         not null default 0
);
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 not null default 0
);
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(1,1) 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(1,1) 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);
