diff options
author | Joseph Warner <hardolaf@hardolaf.com> | 2013-07-23 22:18:41 -0400 |
---|---|---|
committer | Joseph Warner <hardolaf@hardolaf.com> | 2013-07-23 22:18:56 -0400 |
commit | 2483efe9a34df48a82bcceff5f966881fea2a37e (patch) | |
tree | bd72b27bab75dc25284d39c2322d2307f8d06805 /phpBB/install/schemas/postgres_schema.sql | |
parent | e60f4bc88b32465b1d31049f2eb14b1793747dc6 (diff) | |
download | forums-2483efe9a34df48a82bcceff5f966881fea2a37e.tar forums-2483efe9a34df48a82bcceff5f966881fea2a37e.tar.gz forums-2483efe9a34df48a82bcceff5f966881fea2a37e.tar.bz2 forums-2483efe9a34df48a82bcceff5f966881fea2a37e.tar.xz forums-2483efe9a34df48a82bcceff5f966881fea2a37e.zip |
[feature/oauth] Actual final schema changes
PHPBB3-11673
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
-rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 4b8f8f61e1..135cd23fb8 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -194,8 +194,8 @@ CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id); CREATE TABLE phpbb_oauth_tokens ( user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0), session_id char(32) DEFAULT '' NOT NULL, - provider varchar(255) NOT NULL, - oauth_token varchar(4000) NOT NULL + provider varchar(255) DEFAULT '' NOT NULL, + oauth_token varchar(4000) DEFAULT '' NOT NULL ); CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens (user_id); @@ -206,8 +206,8 @@ CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens (oauth_provider); */ CREATE TABLE phpbb_oauth_accounts ( user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0), - provider varchar(255) NOT NULL, - oauth_provider_id varchar(4000) NOT NULL, + provider varchar(255) DEFAULT '' NOT NULL, + oauth_provider_id varchar(4000) DEFAULT '' NOT NULL, PRIMARY KEY (user_id, provider) ); |