summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
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