From 8de9fd30276a273e715c0f3ee4cf227d2927bb36 Mon Sep 17 00:00:00 2001
From: Jeena <spam@jeenaparadies.net>
Date: Wed, 15 Jul 2015 20:04:07 -0700
Subject: adds possibility to use sqlite as a db

---
 schema/sqlite.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 schema/sqlite.sql

(limited to 'schema/sqlite.sql')

diff --git a/schema/sqlite.sql b/schema/sqlite.sql
new file mode 100644
index 0000000..ac691e3
--- /dev/null
+++ b/schema/sqlite.sql
@@ -0,0 +1,22 @@
+CREATE TABLE users (
+  id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+  url TEXT,
+  authorization_endpoint TEXT,
+  token_endpoint TEXT,
+  micropub_endpoint TEXT,
+  micropub_access_token TEXT,
+  micropub_scope TEXT,
+  micropub_response TEXT,
+  micropub_success INTEGER default 0,
+  date_created datetime,
+  last_login datetime,
+  last_micropub_response TEXT,
+  last_micropub_response_date datetime,
+  location_enabled INTEGER NOT NULL default 0,
+  syndication_targets TEXT,
+  facebook_access_token TEXT,
+  twitter_access_token TEXT,
+  twitter_token_secret TEXT,
+  twitter_username TEXT,
+  instagram_access_token TEXT
+);
\ No newline at end of file
-- 
cgit v1.2.3

