aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/oracle_schema.sql
diff options
context:
space:
mode:
authorDavid King <imkingdavid@gmail.com>2013-09-10 15:48:29 -0700
committerDavid King <imkingdavid@gmail.com>2013-09-10 15:48:29 -0700
commitfc1dfd779da37128382322ffdc75bf751a0834a3 (patch)
tree5d43d1847832169510c55c3358c42ccd095b2128 /phpBB/install/schemas/oracle_schema.sql
parent71aeec40f6c4c5e6a69699486b618c2ba67dff2d (diff)
parent18f6a161017f5350d9487181f4b4ed66a53a0284 (diff)
downloadforums-fc1dfd779da37128382322ffdc75bf751a0834a3.tar
forums-fc1dfd779da37128382322ffdc75bf751a0834a3.tar.gz
forums-fc1dfd779da37128382322ffdc75bf751a0834a3.tar.bz2
forums-fc1dfd779da37128382322ffdc75bf751a0834a3.tar.xz
forums-fc1dfd779da37128382322ffdc75bf751a0834a3.zip
Merge remote-tracking branch 'Hardolaf/feature/oauth' into develop
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
-rw-r--r--phpBB/install/schemas/oracle_schema.sql28
1 files changed, 28 insertions, 0 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 75c01446d8..f32980e378 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -211,6 +211,34 @@ CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id)
/
/*
+ Table: 'phpbb_oauth_tokens'
+*/
+CREATE TABLE phpbb_oauth_tokens (
+ user_id number(8) DEFAULT '0' NOT NULL,
+ session_id char(32) DEFAULT '' ,
+ provider varchar2(255) DEFAULT '' ,
+ oauth_token clob DEFAULT ''
+)
+/
+
+CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens (user_id)
+/
+CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens (provider)
+/
+
+/*
+ Table: 'phpbb_oauth_accounts'
+*/
+CREATE TABLE phpbb_oauth_accounts (
+ user_id number(8) DEFAULT '0' NOT NULL,
+ provider varchar2(255) DEFAULT '' ,
+ oauth_provider_id clob DEFAULT '' ,
+ CONSTRAINT pk_phpbb_oauth_accounts PRIMARY KEY (user_id, provider)
+)
+/
+
+
+/*
Table: 'phpbb_banlist'
*/
CREATE TABLE phpbb_banlist (