1  
   2  create table linksdb (
   3      urlname        varchar(512),
   4      recursionlevel smallint not null,
   5      parentname     varchar(256),
   6      baseref        varchar(256),
   7      result         varchar(256),
   8      warning        varchar(512),
   9      info           varchar(512),
  10      valid          smallint not null,
  11      url            varchar(1024) not null,
  12      line           int not null,
  13      col            int not null,
  14      name           varchar(256),
  15      checktime      int not null,
  16      dltime         smallint not null,
  17      dlsize         smallint not null,
  18      cached         smallint not null
  19  );