From e61580d80721da69eb91dc8c1a8f450402b7c1e5 Mon Sep 17 00:00:00 2001 From: yo mama Date: Thu, 25 Sep 2014 19:02:14 -0700 Subject: added2 --- schema.sqlite | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 schema.sqlite (limited to 'schema.sqlite') 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 +); + -- cgit v1.2.3-70-g09d2