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/mysql.sql | |
parent | Implement gen_mod callback in ModPresenceDemo module (diff) |
Add OAUTH SQL backend
Diffstat (limited to '')
-rw-r--r-- | sql/mysql.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index 5150fc45b..3d253c574 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -328,3 +328,10 @@ CREATE TABLE sm ( CREATE UNIQUE INDEX i_sid ON sm(usec, pid(75)); CREATE INDEX i_node ON sm(node(75)); CREATE INDEX i_username ON sm(username); + +CREATE TABLE oauth_token ( + token varchar(191) NOT NULL PRIMARY KEY, + jid text NOT NULL, + scope text NOT NULL, + expire bigint NOT NULL +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; |