bookie/schema.sql

CREATE TABLE bookmarks (
    url text not null primary key,
    domain text,
    title text,
    author text,
    date text,
    pubDate text,
    comments text,
    mercuryContent text,
    pdfpath text,
    tags text
);
CREATE TABLE ingest (url text not null primary key);