PRAGMA foreign_keys = ON; CREATE TABLE journals( id INTEGER PRIMARY KEY NOT NULL, --optional date INTEGER NOT NULL, fulltext TEXT, image_url TEXT );