summaryrefslogtreecommitdiff
path: root/schema/sqlite.sql
blob: 00e5f1c2c9e0a9c107c94636718681452a4352e5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
CREATE TABLE users (
  id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  url TEXT,
  authorization_endpoint TEXT,
  token_endpoint TEXT,
  micropub_endpoint TEXT,
  micropub_media_endpoint TEXT,
  micropub_access_token TEXT,
  micropub_scope TEXT,
  micropub_response TEXT,
  micropub_slug_field TEXT default 'mp-slug',
  micropub_syndicate_field TEXT default 'mp-syndicate-to',
  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,
  email_username TEXT,
  default_timezone TEXT
);