aboutsummaryrefslogtreecommitdiff
path: root/sql/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/mysql.sql')
-rw-r--r--sql/mysql.sql7
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;