diff options
author | Aaron Parecki <aaron@parecki.com> | 2015-07-25 03:42:47 -0700 |
---|---|---|
committer | Aaron Parecki <aaron@parecki.com> | 2015-07-25 03:42:47 -0700 |
commit | 41fac1f6f109912defa07d7acb6b95e015ad4339 (patch) | |
tree | daeb304c6a427836166c4ccb65cb247add0b3de0 /schema | |
parent | 0c27b5bdd561aa27e1138f4fdc2be04bd828ff69 (diff) | |
parent | 8de9fd30276a273e715c0f3ee4cf227d2927bb36 (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.sql | 22 |
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 |