diff options
| author | yo mama <pepper@scannerjammer.com> | 2014-09-25 19:02:14 -0700 |
|---|---|---|
| committer | yo mama <pepper@scannerjammer.com> | 2014-09-25 19:02:14 -0700 |
| commit | e61580d80721da69eb91dc8c1a8f450402b7c1e5 (patch) | |
| tree | 9b9627a225449b545c86be5dbf444a17f4b004d3 /schema.sqlite | |
| parent | a4e35936612d7169839b4b52a6ca8b5761b31bc1 (diff) | |
added2
Diffstat (limited to 'schema.sqlite')
| -rw-r--r-- | schema.sqlite | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/schema.sqlite b/schema.sqlite new file mode 100644 index 0000000..1fe63c0 --- /dev/null +++ b/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 +); + |