diff options
| author | yo mama <pepper@scannerjammer.com> | 2015-03-23 15:57:36 -0700 |
|---|---|---|
| committer | yo mama <pepper@scannerjammer.com> | 2015-03-23 15:57:36 -0700 |
| commit | a6bbef0937649cd92a4b378a8454a96e6110bd99 (patch) | |
| tree | 582079ef3abdce03aeefa1b3b9ddd5d352bc9843 /database/schema.sqlite | |
| parent | 00c7f6129f87d77788aa92e08dd77b7b473f9a71 (diff) | |
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 +); + |