diff options
author | Alexey Shchepin <alexey@process-one.net> | 2016-08-01 16:53:25 +0300 |
---|---|---|
committer | Alexey Shchepin <alexey@process-one.net> | 2016-08-01 16:55:43 +0300 |
commit | 4add262090653e3b2e026f9181247c31acdf6090 (patch) | |
tree | 0145c68126a4aebf291217190a2c57241b6bbba6 /sql/pg.sql | |
parent | 76eba3647a9763e7e1e65759f13f61d3b9e73e87 (diff) |
Add OAUTH SQL backend
Diffstat (limited to 'sql/pg.sql')
-rw-r--r-- | sql/pg.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/pg.sql b/sql/pg.sql index 1bc4f397c..3d7de4285 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -330,3 +330,12 @@ CREATE TABLE sm ( CREATE UNIQUE INDEX i_sm_sid ON sm USING btree (usec, pid); CREATE INDEX i_sm_node ON sm USING btree (node); CREATE INDEX i_sm_username ON sm USING btree (username); + +CREATE TABLE oauth_token ( + token text NOT NULL, + jid text NOT NULL, + scope text NOT NULL, + expire bigint NOT NULL +); + +CREATE UNIQUE INDEX i_oauth_token_token ON oauth_token USING btree (token); |