summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorJeena <spam@jeenaparadies.net>2015-07-15 20:04:07 -0700
committerJeena <spam@jeenaparadies.net>2015-07-24 20:52:16 +0200
commit8de9fd30276a273e715c0f3ee4cf227d2927bb36 (patch)
tree9cda9fbe2cd4ea6a80541445cec223b6e8de9bc4 /schema
parent91307d4a362a8fab0022aba19ab74bec9cb46f8f (diff)
adds possibility to use sqlite as a db
Diffstat (limited to 'schema')
-rw-r--r--schema/mysql.sql (renamed from schema/schema.sql)0
-rw-r--r--schema/sqlite.sql22
2 files changed, 22 insertions, 0 deletions
diff --git a/schema/schema.sql b/schema/mysql.sql
index 5f33ce6..5f33ce6 100644
--- a/schema/schema.sql
+++ b/schema/mysql.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