diff options
| author | Joseph Warner <hardolaf@hardolaf.com> | 2013-07-23 22:15:53 -0400 |
|---|---|---|
| committer | Joseph Warner <hardolaf@hardolaf.com> | 2013-07-23 22:16:09 -0400 |
| commit | e60f4bc88b32465b1d31049f2eb14b1793747dc6 (patch) | |
| tree | 80918d17ebe165c57a17fc6446b24d0e1ec9916b /phpBB/install/schemas/mysql_40_schema.sql | |
| parent | 8d568dae7116ac05eda593835d99e6e6f22dc9f7 (diff) | |
| download | forums-e60f4bc88b32465b1d31049f2eb14b1793747dc6.tar forums-e60f4bc88b32465b1d31049f2eb14b1793747dc6.tar.gz forums-e60f4bc88b32465b1d31049f2eb14b1793747dc6.tar.bz2 forums-e60f4bc88b32465b1d31049f2eb14b1793747dc6.tar.xz forums-e60f4bc88b32465b1d31049f2eb14b1793747dc6.zip | |
[feature/oauth] Finalize schema changes
PHPBB3-11673
Diffstat (limited to 'phpBB/install/schemas/mysql_40_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_40_schema.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql index 2c5931bae4..ea9c6419db 100644 --- a/phpBB/install/schemas/mysql_40_schema.sql +++ b/phpBB/install/schemas/mysql_40_schema.sql @@ -90,6 +90,26 @@ CREATE TABLE phpbb_acl_users ( ); +# Table: 'phpbb_oauth_tokens' +CREATE TABLE phpbb_oauth_tokens ( + user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + session_id binary(32) DEFAULT '' NOT NULL, + provider varbinary(255) NOT NULL, + oauth_token blob NOT NULL, + KEY user_id (user_id), + KEY provider (oauth_provider) +); + + +# Table: 'phpbb_oauth_accounts' +CREATE TABLE phpbb_oauth_accounts ( + user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + provider varbinary(255) NOT NULL, + oauth_provider_id blob NOT NULL, + PRIMARY KEY (user_id, provider) +); + + # Table: 'phpbb_banlist' CREATE TABLE phpbb_banlist ( ban_id mediumint(8) UNSIGNED NOT NULL auto_increment, |