# MySQL dump 4.0
#
# Host: localhost    Database: anders
#--------------------------------------------------------

#
# Table structure for table 'files'
#
CREATE TABLE files (
  fileNum int(11) DEFAULT '0' NOT NULL auto_increment,
  fileName char(100) binary DEFAULT '' NOT NULL,
  UNIQUE fileName (fileName),
  PRIMARY KEY (fileNum)
);

#
# Table structure for table 'ftp_mp3'
#
CREATE TABLE ftp_mp3 (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'hosts'
#
CREATE TABLE hosts (
  hostNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostName char(60) DEFAULT '' NOT NULL,
  hostRobotsRead enum('N','Y') DEFAULT 'N' NOT NULL,
  robotReadDate datetime,
  topDomain char(8) DEFAULT '' NOT NULL,
  subdomainNum int(11) DEFAULT '0' NOT NULL,
  robotLastModified datetime,
  status int(11),
  server char(80) DEFAULT '',
  use_c_l char(1) DEFAULT '' NOT NULL,
  readAgain int(11) DEFAULT '0',
  doNotReadAgain int(11) DEFAULT '0',
  days_min int(11) DEFAULT '0',
  extra_cr char(1) DEFAULT 'N' NOT NULL,
  dns_ok char(1) DEFAULT '' NOT NULL,
  is_alias char(1) DEFAULT '' NOT NULL,
  dnsDate datetime,
  realName char(60) DEFAULT '',
  is_dns char(1) DEFAULT '' NOT NULL,
  hinfoquery char(1) DEFAULT '' NOT NULL,
  cpu char(20) DEFAULT '' NOT NULL,
  os char(20) DEFAULT '' NOT NULL,
  UNIQUE hostName (hostName),
  PRIMARY KEY (hostNum),
  KEY topDomainKey (topDomain),
  KEY subdomainKey (subdomainNum)
);

#
# Table structure for table 'links'
#
CREATE TABLE links (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  wordNum int(11) DEFAULT '0' NOT NULL,
  urlNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY urlword (urlNum,wordNum),
  KEY wordurl (wordNum,urlNum)
);

#
# Table structure for table 'links_dk'
#
CREATE TABLE links_dk (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  wordNum int(11) DEFAULT '0' NOT NULL,
  urlNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY urlword (urlNum,wordNum),
  KEY wordurl (wordNum,urlNum)
);

#
# Table structure for table 'links_fi'
#
CREATE TABLE links_fi (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  wordNum int(11) DEFAULT '0' NOT NULL,
  urlNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY urlword (urlNum,wordNum),
  KEY wordurl (wordNum,urlNum)
);

#
# Table structure for table 'links_is'
#
CREATE TABLE links_is (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  wordNum int(11) DEFAULT '0' NOT NULL,
  urlNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY urlword (urlNum,wordNum),
  KEY wordurl (wordNum,urlNum)
);

#
# Table structure for table 'links_no'
#
CREATE TABLE links_no (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  wordNum int(11) DEFAULT '0' NOT NULL,
  urlNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY urlword (urlNum,wordNum),
  KEY wordurl (wordNum,urlNum)
);

#
# Table structure for table 'links_nu'
#
CREATE TABLE links_nu (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  wordNum int(11) DEFAULT '0' NOT NULL,
  urlNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY urlword (urlNum,wordNum),
  KEY wordurl (wordNum,urlNum)
);

#
# Table structure for table 'links_se'
#
CREATE TABLE links_se (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  wordNum int(11) DEFAULT '0' NOT NULL,
  urlNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY urlword (urlNum,wordNum),
  KEY wordurl (wordNum,urlNum)
);

#
# Table structure for table 'paths'
#
CREATE TABLE paths (
  pathNum int(11) DEFAULT '0' NOT NULL auto_increment,
  pathName char(100) binary DEFAULT '' NOT NULL,
  UNIQUE pathName (pathName),
  PRIMARY KEY (pathNum)
);

#
# Table structure for table 'robots'
#
CREATE TABLE robots (
  robotNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  textIndex int(11),
  textLines int(11),
  PRIMARY KEY (robotNum),
  KEY hostKey (hostNum)
);

#
# Table structure for table 'subdomains'
#
CREATE TABLE subdomains (
  subdomainNum int(11) DEFAULT '0' NOT NULL auto_increment,
  subDomain char(60) DEFAULT '' NOT NULL,
  dug char(1) DEFAULT '' NOT NULL,
  UNIQUE subDomain (subDomain),
  PRIMARY KEY (subdomainNum)
);

#
# Table structure for table 'url'
#
CREATE TABLE url (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_aif'
#
CREATE TABLE url_aif (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_aiff'
#
CREATE TABLE url_aiff (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_avi'
#
CREATE TABLE url_avi (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_bmp'
#
CREATE TABLE url_bmp (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_dk'
#
CREATE TABLE url_dk (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum),
  KEY hostnys (hostNum,nyStatus)
);

#
# Table structure for table 'url_fi'
#
CREATE TABLE url_fi (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum),
  KEY hostnys (hostNum,nyStatus)
);

#
# Table structure for table 'url_gif'
#
CREATE TABLE url_gif (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_ico'
#
CREATE TABLE url_ico (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_is'
#
CREATE TABLE url_is (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum),
  KEY hostnys (hostNum,nyStatus)
);

#
# Table structure for table 'url_jpeg'
#
CREATE TABLE url_jpeg (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_jpg'
#
CREATE TABLE url_jpg (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_lzh'
#
CREATE TABLE url_lzh (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_mid'
#
CREATE TABLE url_mid (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_mov'
#
CREATE TABLE url_mov (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_mp3'
#
CREATE TABLE url_mp3 (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_mpeg'
#
CREATE TABLE url_mpeg (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_no'
#
CREATE TABLE url_no (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum),
  KEY hostnys (hostNum,nyStatus)
);

#
# Table structure for table 'url_nu'
#
CREATE TABLE url_nu (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum),
  KEY hostnys (hostNum,nyStatus)
);

#
# Table structure for table 'url_pic'
#
CREATE TABLE url_pic (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_pud'
#
CREATE TABLE url_pud (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_ram'
#
CREATE TABLE url_ram (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_se'
#
CREATE TABLE url_se (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum),
  KEY hostnys (hostNum,nyStatus)
);

#
# Table structure for table 'url_sound'
#
CREATE TABLE url_sound (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_tiff'
#
CREATE TABLE url_tiff (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_video'
#
CREATE TABLE url_video (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_viv'
#
CREATE TABLE url_viv (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_wav'
#
CREATE TABLE url_wav (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'url_xbm'
#
CREATE TABLE url_xbm (
  urlNum int(11) DEFAULT '0' NOT NULL auto_increment,
  hostNum int(11) DEFAULT '0' NOT NULL,
  pathNum int(11) DEFAULT '0' NOT NULL,
  fileNum int(11) DEFAULT '0' NOT NULL,
  urlReadDate datetime,
  status int(11) DEFAULT '0' NOT NULL,
  lastModified datetime,
  nyStatus char(1) DEFAULT '' NOT NULL,
  content_length int(11),
  Expires datetime,
  linkcount int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (urlNum),
  KEY pathKey (pathNum),
  KEY fileKey (fileNum),
  KEY nystatusKey (nyStatus),
  KEY hpf (hostNum,pathNum,fileNum)
);

#
# Table structure for table 'urllinks'
#
CREATE TABLE urllinks (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  linkToNum int(11) DEFAULT '0' NOT NULL,
  linkFromNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY linkTolinkFrom (linkToNum,linkFromNum)
);

#
# Table structure for table 'urllinks_dk'
#
CREATE TABLE urllinks_dk (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  linkToNum int(11) DEFAULT '0' NOT NULL,
  linkFromNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY linkTolinkFrom (linkToNum,linkFromNum)
);

#
# Table structure for table 'urllinks_fi'
#
CREATE TABLE urllinks_fi (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  linkToNum int(11) DEFAULT '0' NOT NULL,
  linkFromNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY linkTolinkFrom (linkToNum,linkFromNum)
);

#
# Table structure for table 'urllinks_is'
#
CREATE TABLE urllinks_is (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  linkToNum int(11) DEFAULT '0' NOT NULL,
  linkFromNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY linkTolinkFrom (linkToNum,linkFromNum)
);

#
# Table structure for table 'urllinks_no'
#
CREATE TABLE urllinks_no (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  linkToNum int(11) DEFAULT '0' NOT NULL,
  linkFromNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY linkTolinkFrom (linkToNum,linkFromNum)
);

#
# Table structure for table 'urllinks_nu'
#
CREATE TABLE urllinks_nu (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  linkToNum int(11) DEFAULT '0' NOT NULL,
  linkFromNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY linkTolinkFrom (linkToNum,linkFromNum)
);

#
# Table structure for table 'urllinks_se'
#
CREATE TABLE urllinks_se (
  linkNum int(11) DEFAULT '0' NOT NULL auto_increment,
  linkToNum int(11) DEFAULT '0' NOT NULL,
  linkFromNum int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (linkNum),
  KEY linkTolinkFrom (linkToNum,linkFromNum)
);

#
# Table structure for table 'words'
#
CREATE TABLE words (
  wordNum int(11) DEFAULT '0' NOT NULL auto_increment,
  wordName char(32) DEFAULT '' NOT NULL,
  UNIQUE wordName (wordName),
  PRIMARY KEY (wordNum)
);

