schema.sqlite - templates/perl_database_template.git - Unnamed repository; edit this file 'description' to name the repository.

summary refs log tree commit diff

path: root/schema.sqlite

blob: 1fe63c031b3554c4135784975926d54237692a29 (plain)

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