diff options
Diffstat (limited to 'database/schema.sqlite')
| -rw-r--r-- | database/schema.sqlite | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/database/schema.sqlite b/database/schema.sqlite new file mode 100644 index 0000000..1fe63c0 --- /dev/null +++ b/database/schema.sqlite @@ -0,0 +1,8 @@ +PRAGMA foreign_keys = ON; +CREATE TABLE journals( + id INTEGER PRIMARY KEY NOT NULL, --optional + date INTEGER NOT NULL, + fulltext TEXT, + image_url TEXT +); + |