6 files changed, 6 insertions, 5 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index a505ed9578..3b03c818bc 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -16,7 +16,7 @@ CREATE TABLE phpbb_attachments (
   comment BLOB SUB_TYPE TEXT,
   extension VARCHAR(100),
   mimetype VARCHAR(100),
-  filesize INTEGER NOT NULL,
+  filesize INTEGER DEFAULT 0  NOT NULL,
   filetime INTEGER DEFAULT 0  NOT NULL,
   thumbnail INTEGER DEFAULT 0  NOT NULL
 );;
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 72db08a523..a74e214aa7 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -44,6 +44,7 @@ ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD
 	CONSTRAINT [DF_phpbb_attach_poster_id] DEFAULT (0) FOR [poster_id],
 	CONSTRAINT [DF_phpbb_attach_download_count] DEFAULT (0) FOR [download_count],
 	CONSTRAINT [DF_phpbb_attach_filetime] DEFAULT (0) FOR [filetime],
+	CONSTRAINT [DF_phpbb_attach_filesize] DEFAULT (0) FOR [filesize],
 	CONSTRAINT [DF_phpbb_attach_thumbnail] DEFAULT (0) FOR [thumbnail]
 GO
 
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 88d02429ef..f89f468085 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -17,7 +17,7 @@ CREATE TABLE phpbb_attachments (
   comment text,
   extension varchar(100),
   mimetype varchar(100),
-  filesize int(20) UNSIGNED NOT NULL,
+  filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
   filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
   thumbnail tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (attach_id),
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 900232b79a..5851bed653 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -54,7 +54,7 @@ CREATE TABLE phpbb_attachments (
   "COMMENT" clob,
   extension varchar2(100),
   mimetype varchar2(100),
-  filesize number(20) NOT NULL,
+  filesize number(20) DEFAULT '0' NOT NULL,
   filetime number(11) DEFAULT '0' NOT NULL,
   thumbnail number(1) DEFAULT '0' NOT NULL,
   CONSTRAINT pk_phpbb_attachments PRIMARY KEY (attach_id)
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index f52d6fe278..8dc3d9d977 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -95,7 +95,7 @@ CREATE TABLE phpbb_attachments (
   comment varchar(8000),
   extension varchar(100),
   mimetype varchar(100),
-  filesize INT4  NOT NULL,
+  filesize INT4  DEFAULT '0' NOT NULL,
   filetime INT4  DEFAULT '0' NOT NULL,
   thumbnail INT2 DEFAULT '0' NOT NULL,
   PRIMARY KEY (attach_id),
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 74ac458057..af59df634b 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -19,7 +19,7 @@ CREATE TABLE phpbb_attachments (
   comment text(65535),
   extension varchar(100),
   mimetype varchar(100),
-  filesize int(20) NOT NULL,
+  filesize int(20) NOT NULL DEFAULT '0',
   filetime int(11) NOT NULL DEFAULT '0',
   thumbnail tinyint(1) NOT NULL DEFAULT '0'
 );