aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/db
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2001-08-10 13:58:20 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2001-08-10 13:58:20 +0000
commit38444b8f106a020c84977e77134aadee9cbc31bd (patch)
treeb2d3a30d14cc18034c55c9dd11c03f563efa20f5 /phpBB/db
parent3e197abb06e5bc336ed246c3dfe601f60250fc40 (diff)
downloadforums-38444b8f106a020c84977e77134aadee9cbc31bd.tar
forums-38444b8f106a020c84977e77134aadee9cbc31bd.tar.gz
forums-38444b8f106a020c84977e77134aadee9cbc31bd.tar.bz2
forums-38444b8f106a020c84977e77134aadee9cbc31bd.tar.xz
forums-38444b8f106a020c84977e77134aadee9cbc31bd.zip
User posts was not being set as 0 by DEFAULT
git-svn-id: file:///svn/phpbb/trunk@835 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
-rw-r--r--phpBB/db/mysql_schema.sql2
-rw-r--r--phpBB/db/postgres_schema.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql
index c125d5f9b8..f59e5200af 100644
--- a/phpBB/db/mysql_schema.sql
+++ b/phpBB/db/mysql_schema.sql
@@ -462,7 +462,7 @@ CREATE TABLE phpbb_users (
user_aim varchar(255),
user_yim varchar(255),
user_msnm varchar(255),
- user_posts int(11) DEFAULT '0',
+ user_posts int(11) DEFAULT '0' NOT NULL,
user_actkey varchar(32),
user_newpasswd varchar(32),
user_notify tinyint(3),
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql
index 248acd6e7d..e9502a743a 100644
--- a/phpBB/db/postgres_schema.sql
+++ b/phpBB/db/postgres_schema.sql
@@ -451,7 +451,7 @@ CREATE TABLE phpbb_users (
user_aim varchar(255),
user_yim varchar(255),
user_msnm varchar(255),
- user_posts int4 DEFAULT '0',
+ user_posts int4 DEFAULT '0' NOT NULL,
user_viewemail int2,
user_attachsig int2,
user_allowhtml int2,