/usr/share/doc/linkchecker/examples/create.sql is in linkchecker 9.3-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | -- tested with postgresql
-- you can add a unique sequence id to the table if you want
drop table linksdb;
create table linksdb (
urlname varchar(256) not null,
parentname varchar(256),
baseref varchar(256),
valid int,
result varchar(256),
warning varchar(512),
info varchar(512),
url varchar(256),
line int,
col int,
name varchar(256),
checktime int,
dltime int,
size int,
cached int,
level int not null,
modified varchar(256)
);
|