diff options
Diffstat (limited to 'phpBB/db/schemas')
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 6 | ||||
| -rw-r--r-- | phpBB/db/schemas/oracle_schema.sql | 6 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 6 |
3 files changed, 9 insertions, 9 deletions
diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index 9a888e0e51..3d33dfe65f 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -472,9 +472,9 @@ CREATE TABLE phpbb_users ( user_emailtime int(11), user_viewemail tinyint(1), user_attachsig tinyint(1), - user_allowhtml tinyint(1), - user_allowbbcode tinyint(1), - user_allowsmile tinyint(1), + user_allowhtml tinyint(1) DEFAULT '1', + user_allowbbcode tinyint(1) DEFAULT '1', + user_allowsmile tinyint(1) DEFAULT '1', user_allowavatar tinyint(1) DEFAULT '1' NOT NULL, user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL, diff --git a/phpBB/db/schemas/oracle_schema.sql b/phpBB/db/schemas/oracle_schema.sql index 99c10e0c37..8f68aab9ca 100644 --- a/phpBB/db/schemas/oracle_schema.sql +++ b/phpBB/db/schemas/oracle_schema.sql @@ -454,9 +454,9 @@ CREATE TABLE phpbb_users ( user_posts number(4) DEFAULT '0' NOT NULL, user_viewemail number(4), user_attachsig number(4), - user_allowhtml number(4), - user_allowbbcode number(4), - user_allowsmile number(4), + user_allowhtml number(4) DEFAULT '1', + user_allowbbcode number(4) DEFAULT '1', + user_allowsmile number(4) DEFAULT '1', user_allow_pm number(4) DEFAULT '1' NOT NULL, user_allowavatar number(4) DEFAULT '1' NOT NULL, user_allow_viewonline number(4) DEFAULT '1' NOT NULL, diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index f6abb73266..952767a3a2 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -467,9 +467,9 @@ CREATE TABLE phpbb_users ( user_emailtime int4, user_viewemail int2, user_attachsig int2, - user_allowhtml int2, - user_allowbbcode int2, - user_allowsmile int2, + user_allowhtml int2 DEFAULT '1', + user_allowbbcode int2 DEFAULT '1', + user_allowsmile int2 DEFAULT '1', user_allow_pm int2 DEFAULT '1' NOT NULL, user_allowavatar int2 DEFAULT '1' NOT NULL, user_allow_viewonline int2 DEFAULT '1' NOT NULL, |