aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install
diff options
context:
space:
mode:
authorJoseph Warner <hardolaf@hardolaf.com>2013-07-23 22:18:41 -0400
committerJoseph Warner <hardolaf@hardolaf.com>2013-07-23 22:18:56 -0400
commit2483efe9a34df48a82bcceff5f966881fea2a37e (patch)
treebd72b27bab75dc25284d39c2322d2307f8d06805 /phpBB/install
parente60f4bc88b32465b1d31049f2eb14b1793747dc6 (diff)
downloadforums-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')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql8
-rw-r--r--phpBB/install/schemas/mssql_schema.sql8
-rw-r--r--phpBB/install/schemas/mysql_40_schema.sql4
-rw-r--r--phpBB/install/schemas/mysql_41_schema.sql4
-rw-r--r--phpBB/install/schemas/oracle_schema.sql8
-rw-r--r--phpBB/install/schemas/postgres_schema.sql8
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql8
7 files changed, 24 insertions, 24 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 1eabd2f049..55ddd00d7d 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -132,8 +132,8 @@ CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users(auth_role_id);;
CREATE TABLE phpbb_oauth_tokens (
user_id INTEGER DEFAULT 0 NOT NULL,
session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
- provider VARCHAR(255) CHARACTER SET NONE NOT NULL,
- oauth_token BLOB SUB_TYPE TEXT CHARACTER SET UTF8 NOT NULL
+ provider VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
+ oauth_token BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
);;
CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens(user_id);;
@@ -142,8 +142,8 @@ CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens(oauth_provider);;
# Table: 'phpbb_oauth_accounts'
CREATE TABLE phpbb_oauth_accounts (
user_id INTEGER DEFAULT 0 NOT NULL,
- provider VARCHAR(255) CHARACTER SET NONE NOT NULL,
- oauth_provider_id BLOB SUB_TYPE TEXT CHARACTER SET UTF8 NOT NULL
+ provider VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
+ oauth_provider_id BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
);;
ALTER TABLE phpbb_oauth_accounts ADD PRIMARY KEY (user_id, provider);;
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 36e3910bc8..b2fe8d1710 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -172,8 +172,8 @@ GO
CREATE TABLE [phpbb_oauth_tokens] (
[user_id] [int] DEFAULT (0) NOT NULL ,
[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
) ON [PRIMARY]
GO
@@ -189,8 +189,8 @@ GO
*/
CREATE TABLE [phpbb_oauth_accounts] (
[user_id] [int] DEFAULT (0) NOT NULL ,
- [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
) ON [PRIMARY]
GO
diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql
index ea9c6419db..9eb2e10e96 100644
--- a/phpBB/install/schemas/mysql_40_schema.sql
+++ b/phpBB/install/schemas/mysql_40_schema.sql
@@ -94,7 +94,7 @@ CREATE TABLE phpbb_acl_users (
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,
+ provider varbinary(255) DEFAULT '' NOT NULL,
oauth_token blob NOT NULL,
KEY user_id (user_id),
KEY provider (oauth_provider)
@@ -104,7 +104,7 @@ CREATE TABLE phpbb_oauth_tokens (
# Table: 'phpbb_oauth_accounts'
CREATE TABLE phpbb_oauth_accounts (
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- provider varbinary(255) NOT NULL,
+ provider varbinary(255) DEFAULT '' NOT NULL,
oauth_provider_id blob NOT NULL,
PRIMARY KEY (user_id, provider)
);
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql
index 0d81f03d17..a4237acb8a 100644
--- a/phpBB/install/schemas/mysql_41_schema.sql
+++ b/phpBB/install/schemas/mysql_41_schema.sql
@@ -94,7 +94,7 @@ CREATE TABLE phpbb_acl_users (
CREATE TABLE phpbb_oauth_tokens (
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
session_id char(32) DEFAULT '' NOT NULL,
- provider varchar(255) NOT NULL,
+ provider varchar(255) DEFAULT '' NOT NULL,
oauth_token text NOT NULL,
KEY user_id (user_id),
KEY provider (oauth_provider)
@@ -104,7 +104,7 @@ CREATE TABLE phpbb_oauth_tokens (
# Table: 'phpbb_oauth_accounts'
CREATE TABLE phpbb_oauth_accounts (
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- provider varchar(255) NOT NULL,
+ provider varchar(255) DEFAULT '' NOT NULL,
oauth_provider_id text NOT NULL,
PRIMARY KEY (user_id, provider)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 0868972d2d..6a6d691190 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -216,8 +216,8 @@ CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id)
CREATE TABLE phpbb_oauth_tokens (
user_id number(8) DEFAULT '0' NOT NULL,
session_id char(32) DEFAULT '' ,
- provider varchar2(255) NOT NULL,
- oauth_token clob NOT NULL
+ provider varchar2(255) DEFAULT '' ,
+ oauth_token clob DEFAULT ''
)
/
@@ -231,8 +231,8 @@ CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens (oauth_provider)
*/
CREATE TABLE phpbb_oauth_accounts (
user_id number(8) DEFAULT '0' NOT NULL,
- provider varchar2(255) NOT NULL,
- oauth_provider_id clob NOT NULL,
+ provider varchar2(255) DEFAULT '' ,
+ oauth_provider_id clob DEFAULT '' ,
CONSTRAINT pk_phpbb_oauth_accounts PRIMARY KEY (user_id, provider)
)
/
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)
);
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 3e429850b4..625e19eb98 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -93,8 +93,8 @@ CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id);
CREATE TABLE phpbb_oauth_tokens (
user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
session_id char(32) NOT NULL DEFAULT '',
- provider varchar(255) NOT NULL ,
- oauth_token text(65535) NOT NULL
+ provider varchar(255) NOT NULL DEFAULT '',
+ oauth_token text(65535) NOT NULL DEFAULT ''
);
CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens (user_id);
@@ -103,8 +103,8 @@ CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens (oauth_provider);
# Table: 'phpbb_oauth_accounts'
CREATE TABLE phpbb_oauth_accounts (
user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
- provider varchar(255) NOT NULL ,
- oauth_provider_id text(65535) NOT NULL ,
+ provider varchar(255) NOT NULL DEFAULT '',
+ oauth_provider_id text(65535) NOT NULL DEFAULT '',
PRIMARY KEY (user_id, provider)
);
generated by cgit v1.2.1 (git 2.21.0) at 2025-03-19 15:51:31 +0000