aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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,