DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Table For Linkchecker Sql Output Type

  • submit to reddit
        // Table for linkchecker sql output type

create table linksdb (
    urlname        varchar(512),
    recursionlevel smallint not null,
    parentname     varchar(256),
    baseref        varchar(256),
    result         varchar(256),
    warning        varchar(512),
    info           varchar(512),
    valid          smallint not null,
    url            varchar(1024) not null,
    line           int not null,
    col            int not null,
    name           varchar(256),
    checktime      int not null,
    dltime         smallint not null,
    dlsize         smallint not null,
    cached         smallint not null