4 files changed, 231 insertions, 24 deletions
diff --git a/phpBB/install/schemas/firebird_basic.sql b/phpBB/install/schemas/firebird_basic.sql
index e6b2def9c2..82025c8a2b 100644
--- a/phpBB/install/schemas/firebird_basic.sql
+++ b/phpBB/install/schemas/firebird_basic.sql
@@ -20,6 +20,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1')
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_attachments','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_topic_notify','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_forum_notify','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
@@ -81,6 +82,10 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_server', '');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_base_dn', '');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_uid', '');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('lastread', '432000');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize', '262144');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('attachment_quota', '52428800');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments', '3');
+INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('upload_dir', 'files', 1);
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_users', '0', 1);
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_date', '0', 1);
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_user_id', '2', 1);
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 5ccfd80bf7..b0ea7fec99 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -6,31 +6,52 @@
 
 # --------------------------------------------------------
 #
-# Table structure for table 'phpbb_attach_desc'
+# Table structure for table `phpbb_attachments`
+#
+CREATE TABLE phpbb_attachments (
+  attach_id INTEGER DEFAULT 0 NOT NULL,
+  post_id INTEGER DEFAULT 0 NOT NULL,
+  privmsgs_id INTEGER DEFAULT 0 NOT NULL,
+  user_id_from INTEGER NOT NULL,
+  user_id_to INTEGER NOT NULL
+); 
+
+CREATE INDEX phpbb_attachments_attach_id ON phpbb_attachments (attach_id);
+CREATE INDEX phpbb_attachments_post_id ON phpbb_attachments (post_id);
+CREATE INDEX phpbb_attachments_privmsgs_id ON phpbb_attachments (privmsgs_id);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table `phpbb_attach_desc`
 #
 CREATE TABLE phpbb_attach_desc (
-  attach_id NUMERIC NOT NULL,
-  attach_filename VARCHAR(255) DEFAULT '' NOT NULL,
+  attach_id INTEGER NOT NULL,
+  physical_filename VARCHAR(255) NOT NULL,
+  real_filename VARCHAR(255) NOT NULL,
   download_count INTEGER DEFAULT 0 NOT NULL,
-  filename VARCHAR(255) DEFAULT '' NOT NULL,
-  comment VARCHAR(60),
-  mimetype VARCHAR(60),
-  filesize INTEGER DEFAULT 0 NOT NULL,
-  filetime INTEGER DEFAULT 0 NOT NULL, 
-  PRIMARY KEY (attach_id) 
+  comment VARCHAR(255) DEFAULT '',
+  extension VARCHAR(100),
+  mimetype VARCHAR(100),
+  filesize INTEGER NOT NULL,
+  filetime INTEGER DEFAULT 0 NOT NULL,
+  thumbnail SMALLINT DEFAULT 0 NOT NULL,
+  PRIMARY KEY (attach_id)
 );
 
 CREATE GENERATOR phpbb_attach_desc_gen;
 SET GENERATOR phpbb_attach_desc_gen TO 0;
+CREATE INDEX phpbb_attach_desc_filetime ON phpbb_attach_desc (filetime);
+CREATE INDEX phpbb_attach_desc_physical_filename ON phpbb_attach_desc (physical_filename);
+CREATE INDEX phpbb_attach_desc_filesize ON phpbb_attach_desc (filesize);
 
 CREATE TRIGGER phpbb_attach_desc_trig 
-	FOR phpbb_attach_desc BEFORE INSERT  
+	FOR phpbb_attach_desc BEFORE INSERT
 	AS BEGIN 
 		IF (NEW.attach_id IS NULL) THEN 
-			NEW.attach_id = GEN_ID(phpbb_attach_desc_gen, 1)| 
+			NEW.attach_id = GEN_ID(phpbb_attach_desc_gen, 1)|
 	END;
 
-
 # --------------------------------------------------------
 #
 # Table structure for table `phpbb_auth_groups`
@@ -188,6 +209,74 @@ CREATE TRIGGER phpbb_disallow_trig
 
 # --------------------------------------------------------
 #
+# Table structure for table 'phpbb_extensions'
+#
+CREATE TABLE phpbb_extensions (
+  extension_id INTEGER NOT NULL,
+  group_id INTEGER DEFAULT 0 NOT NULL,
+  extension VARCHAR(100) NOT NULL,
+  comment VARCHAR(100),
+  PRIMARY KEY (extension_id)
+);
+
+CREATE GENERATOR phpbb_extensions_gen;
+SET GENERATOR phpbb_extensions_gen TO 0;
+
+CREATE TRIGGER phpbb_extensions_trig 
+	FOR phpbb_extensions BEFORE INSERT
+	AS BEGIN 
+		IF (NEW.extension_id IS NULL) THEN 
+			NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1)|
+	END;
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_extension_groups'
+#
+CREATE TABLE phpbb_extension_groups (
+  group_id INTEGER NOT NULL,
+  group_name VARCHAR(20) NOT NULL,
+  cat_id SMALLINT DEFAULT 0 NOT NULL, 
+  allow_group SMALLINT DEFAULT 0 NOT NULL,
+  download_mode SMALLINT UNSIGNED DEFAULT 1 NOT NULL,
+  max_filesize INTEGER DEFAULT 0 NOT NULL,
+  PRIMARY KEY (group_id)
+);
+
+CREATE GENERATOR phpbb_extension_groups_gen;
+SET GENERATOR phpbb_extension_groups_gen TO 0;
+
+CREATE TRIGGER phpbb_extension_groups_trig 
+	FOR phpbb_extension_groups BEFORE INSERT
+	AS BEGIN 
+		IF (NEW.group_id IS NULL) THEN 
+			NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1)|
+	END;
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_forbidden_extensions'
+#
+CREATE TABLE phpbb_forbidden_extensions (
+  extension_id INTEGER NOT NULL, 
+  extension VARCHAR(100) NOT NULL, 
+  PRIMARY KEY (extension_id)
+);
+
+CREATE GENERATOR phpbb_forbidden_extensions_gen;
+SET GENERATOR phpbb_forbidden_extensions_gen TO 0;
+
+CREATE TRIGGER phpbb_forbidden_extensions_trig 
+	FOR phpbb_forbidden_extensions BEFORE INSERT
+	AS BEGIN 
+		IF (NEW.extension_id IS NULL) THEN 
+			NEW.extension_id = GEN_ID(phpbb_forbidden_extensions_gen, 1)|
+	END;
+
+
+# --------------------------------------------------------
+#
 # Table structure for table 'phpbb_forums'
 #
 CREATE TABLE phpbb_forums (
@@ -329,7 +418,7 @@ CREATE TRIGGER phpbb_lang_trig
 	FOR phpbb_lang BEFORE INSERT
 	AS BEGIN 
 		IF (NEW.lang_id IS NULL) THEN 
-			NEW.lang_id = GEN_ID(phpbb_icons_gen, 1)|
+			NEW.lang_id = GEN_ID(phpbb_lang_gen, 1)|
 	END;
 
 
@@ -460,7 +549,6 @@ CREATE TABLE phpbb_posts (
    topic_id INTEGER DEFAULT 0 NOT NULL,
    forum_id SMALLINT DEFAULT 0 NOT NULL,
    poster_id INTEGER DEFAULT 0 NOT NULL,
-   attach_id INTEGER DEFAULT 0 NOT NULL,
    icon_id SMALLINT DEFAULT 1 NOT NULL,
    poster_ip VARCHAR(40) DEFAULT '' NOT NULL,
    post_time INTEGER DEFAULT 0 NOT NULL,
@@ -476,6 +564,7 @@ CREATE TABLE phpbb_posts (
    post_text BLOB SUB_TYPE 1 DEFAULT '' NOT NULL,
    post_checksum VARCHAR(32) DEFAULT '' NOT NULL,
    post_encoding VARCHAR(11) DEFAULT 'iso-8859-15' NOT NULL, 
+   post_attachment SMALLINT DEFAULT 0 NOT NULL,
    bbcode_bitfield INTEGER DEFAULT 0 NOT NULL,
    bbcode_uid VARCHAR(10) DEFAULT '' NOT NULL,
    post_edit_time INTEGER DEFAULT 0 NOT NULL,
@@ -503,7 +592,7 @@ CREATE TRIGGER phpbb_posts_trig
 #
 CREATE TABLE phpbb_privmsgs (
    privmsgs_id INTEGER NOT NULL,
-   attach_id INTEGER DEFAULT 0 NOT NULL,
+   privmsgs_attachment SMALLINT DEFAULT 0 NOT NULL,
    privmsgs_type SMALLINT DEFAULT 0 NOT NULL,
    privmsgs_subject VARCHAR(60) DEFAULT 0 NOT NULL,
    privmsgs_from_userid INTEGER DEFAULT 0 NOT NULL,
@@ -875,6 +964,7 @@ CREATE TABLE phpbb_topics (
    topic_id INTEGER NOT NULL,
    forum_id INTEGER DEFAULT 0 NOT NULL,
    icon_id SMALLINT DEFAULT 1 NOT NULL,
+   topic_attachment SMALLINT DEFAULT 0 NOT NULL,
    topic_approved SMALLINT DEFAULT 1 NOT NULL,
    topic_reported SMALLINT DEFAULT 0 NOT NULL,
    topic_title VARCHAR(60) NOT NULL,
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql
index 040a269bd5..d36f91b022 100644
--- a/phpBB/install/schemas/mysql_basic.sql
+++ b/phpBB/install/schemas/mysql_basic.sql
@@ -20,6 +20,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1')
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_attachments','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_topic_notify','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_forum_notify','1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
@@ -81,6 +82,10 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_server', '');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_base_dn', '');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_uid', '');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('lastread', '432000');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_filesize', '262144');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('attachment_quota', '52428800');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments', '3');
+INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('upload_dir', 'files', 1);
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_users', '0', 1);
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_date', '0', 1);
 INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_user_id', '2', 1);
@@ -345,4 +350,52 @@ INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1
 
 # -- reasons
 INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES ( 1, 0, 'warez', 'The reported post contains links to pirated or illegal software.' );
-INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES ( 2, 1, 'other', 'The reported post does not fit into any other category, please use the description field.' );
-\ No newline at end of file
+INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES ( 2, 1, 'other', 'The reported post does not fit into any other category, please use the description field.' );
+
+# -- forbidden_extensions
+INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (1,'php');
+INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (2,'php3');
+INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (3,'php4');
+INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (4,'phtml');
+INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (5,'pl');
+INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (6,'asp');
+INSERT INTO phpbb_forbidden_extensions (extension_id, extension) VALUES (7,'cgi');
+
+# -- extension_groups
+INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (1,'Images',1,1,1,0);
+INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (2,'Archives',0,1,1,0);
+INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (3,'Plain Text',0,0,1,0);
+INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (4,'Documents',0,0,1,0);
+INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (5,'Real Media',0,0,2,0);
+INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (6,'Streams',2,0,1,0);
+INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, max_filesize) VALUES (7,'Flash Files',3,0,1,0);
+
+# -- extensions
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (1, 1,'gif', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (2, 1,'png', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (3, 1,'jpeg', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (4, 1,'jpg', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (5, 1,'tif', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (6, 1,'tga', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (7, 2,'gtar', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (8, 2,'gz', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (9, 2,'tar', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (10, 2,'zip', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (11, 2,'rar', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (12, 2,'ace', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (13, 3,'txt', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (14, 3,'c', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (15, 3,'h', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (16, 3,'cpp', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (17, 3,'hpp', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (18, 3,'diz', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (19, 4,'xls', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (20, 4,'doc', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (21, 4,'dot', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (22, 4,'pdf', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (23, 4,'ai', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (24, 4,'ps', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (25, 4,'ppt', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (26, 5,'rm', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (27, 6,'wma', '');
+INSERT INTO phpbb_extensions (extension_id, group_id, extension, comment) VALUES (28, 7,'swf', '');
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 68da2f0bd3..d33466a82a 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -6,18 +6,37 @@
 
 # --------------------------------------------------------
 #
-# Table structure for table 'phpbb_attach_desc'
+# Table structure for table `phpbb_attachments`
+#
+CREATE TABLE phpbb_attachments (
+  attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 
+  post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 
+  privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+  user_id_from mediumint(8) NOT NULL,
+  user_id_to mediumint(8) NOT NULL,
+  KEY attach_id (attach_id)
+); 
+
+
+# --------------------------------------------------------
+#
+# Table structure for table `phpbb_attachments_desc`
 #
 CREATE TABLE phpbb_attach_desc (
   attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-  attach_filename varchar(255) NOT NULL,
+  physical_filename varchar(255) NOT NULL,
+  real_filename varchar(255) NOT NULL,
   download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-  filename varchar(255) NOT NULL,
-  comment varchar(60),
-  mimetype varchar(60),
+  comment varchar(255),
+  extension varchar(100),
+  mimetype varchar(100),
   filesize int(20) NOT NULL,
   filetime int(11) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (attach_id)
+  thumbnail tinyint(1) DEFAULT '0' NOT NULL,
+  PRIMARY KEY (attach_id),
+  KEY filetime (filetime),
+  KEY physical_filename (physical_filename(10)),
+  KEY filesize (filesize)
 );
 
 
@@ -136,6 +155,45 @@ CREATE TABLE phpbb_disallow (
 
 # --------------------------------------------------------
 #
+# Table structure for table 'phpbb_extensions'
+#
+CREATE TABLE phpbb_extensions (
+  extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+  group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+  extension varchar(100) NOT NULL,
+  comment varchar(100),
+  PRIMARY KEY (extension_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_extension_groups'
+#
+CREATE TABLE phpbb_extension_groups (
+  group_id mediumint(8) NOT NULL auto_increment,
+  group_name char(20) NOT NULL,
+  cat_id tinyint(2) DEFAULT '0' NOT NULL, 
+  allow_group tinyint(1) DEFAULT '0' NOT NULL,
+  download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
+  max_filesize int(20) DEFAULT '0' NOT NULL,
+  PRIMARY KEY (group_id)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_forbidden_extensions'
+#
+CREATE TABLE phpbb_forbidden_extensions (
+  extension_id mediumint(8) UNSIGNED NOT NULL auto_increment, 
+  extension varchar(100) NOT NULL, 
+  PRIMARY KEY (extension_id)
+);
+
+
+# --------------------------------------------------------
+#
 # Table structure for table 'phpbb_forums'
 #
 CREATE TABLE phpbb_forums (
@@ -327,7 +385,6 @@ CREATE TABLE phpbb_posts (
    topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
    poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-   attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL,
    poster_ip varchar(40) NOT NULL,
    post_time int(11) DEFAULT '0' NOT NULL,
@@ -343,6 +400,7 @@ CREATE TABLE phpbb_posts (
    post_text text,
    post_checksum varchar(32) NOT NULL,
    post_encoding varchar(11) DEFAULT 'iso-8859-15' NOT NULL, 
+   post_attachment tinyint(1) DEFAULT '0' NOT NULL,
    bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL,
    bbcode_uid varchar(10) NOT NULL,
    post_edit_time int(11),
@@ -360,7 +418,7 @@ CREATE TABLE phpbb_posts (
 #
 CREATE TABLE phpbb_privmsgs (
    privmsgs_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-   attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+   privmsgs_attachment tinyint(1) DEFAULT '0' NOT NULL,
    privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
    privmsgs_subject varchar(60) DEFAULT '0' NOT NULL,
    privmsgs_from_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -636,6 +694,7 @@ CREATE TABLE phpbb_topics (
    topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
    forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL,
    icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL,
+   topic_attachment tinyint(1) DEFAULT '0' NOT NULL,
    topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
    topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
    topic_title varchar(60) NOT NULL,