diff options
| author | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-12-10 21:53:27 +0000 |
|---|---|---|
| committer | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-12-10 21:53:27 +0000 |
| commit | 076206dc0c111643e86413c04ac8f17cddf0bcaa (patch) | |
| tree | 4c5149b7a81a021fa9fe667cc74423fe72378004 /phpBB/db/schemas | |
| parent | 7c0e6ff4db26992204005c231fa76806da83e613 (diff) | |
| download | forums-076206dc0c111643e86413c04ac8f17cddf0bcaa.tar forums-076206dc0c111643e86413c04ac8f17cddf0bcaa.tar.gz forums-076206dc0c111643e86413c04ac8f17cddf0bcaa.tar.bz2 forums-076206dc0c111643e86413c04ac8f17cddf0bcaa.tar.xz forums-076206dc0c111643e86413c04ac8f17cddf0bcaa.zip | |
Fix for some small problems with upgrade
git-svn-id: file:///svn/phpbb/trunk@1548 89ea8834-ac86-4346-8a33-228a782c2dd0
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, |