From 076206dc0c111643e86413c04ac8f17cddf0bcaa Mon Sep 17 00:00:00 2001
From: Bart van Bragt <bartvb@users.sourceforge.net>
Date: Mon, 10 Dec 2001 21:53:27 +0000
Subject: Fix for some small problems with upgrade
git-svn-id: file:///svn/phpbb/trunk@1548 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/db/schemas/mysql_schema.sql | 6 +++---
phpBB/db/schemas/oracle_schema.sql | 6 +++---
phpBB/db/schemas/postgres_schema.sql | 6 +++---
3 files changed, 9 insertions(+), 9 deletions(-)
(limited to 'phpBB/db/schemas')
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,
--
cgit v1.2.1