summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAaron Parecki <aaron@parecki.com>2015-07-25 03:42:47 -0700
committerAaron Parecki <aaron@parecki.com>2015-07-25 03:42:47 -0700
commit41fac1f6f109912defa07d7acb6b95e015ad4339 (patch)
treedaeb304c6a427836166c4ccb65cb247add0b3de0 /schema
parent0c27b5bdd561aa27e1138f4fdc2be04bd828ff69 (diff)
parent8de9fd30276a273e715c0f3ee4cf227d2927bb36 (diff)
Merge pull request #20 from jeena/sqlite
Adds possibility to use SQLite as 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