1 files changed, 8 insertions, 0 deletions
diff --git a/sql/pgsql/ejabberd_oauth.sql b/sql/pgsql/ejabberd_oauth.sql
new file mode 100644
index 000000000..527331e9e
--- /dev/null
+++ b/sql/pgsql/ejabberd_oauth.sql
@@ -0,0 +1,8 @@
+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 (token);