File: create.sql

package info (click to toggle)

linkchecker 1.3.7.1

links: PTS
area: main
in suites: woody
size: 848 kB
ctags: 889
sloc: python: 5,726; ansic: 264; makefile: 162; sh: 57; sql: 16

file content (19 lines) | stat: -rw-r--r-- 476 bytes

-- tested with postgresql

drop table linksdb;

create table linksdb (
    urlname        varchar(50) not null,
    recursionlevel int not null,
    parentname     varchar(50),
    baseref        varchar(50),
    errorstring    varchar(50),
    validstring    varchar(50),
    warningstring  varchar(50),
    infoString     varchar(150),
    valid          int,
    url            varchar(50),
    line           int,
    name           varchar(50),
    cached         int
);