aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_41_schema.sql
diff options
context:
space:
mode:
authorBruno Ais <brunoaiss@gmail.com>2012-04-26 10:37:37 +0100
committerBruno Ais <brunoaiss@gmail.com>2012-05-01 12:44:16 +0100
commitf3e5acf3776083ec39052a3b8bf179638703d47e (patch)
tree5b603cb843576551cc73a8bd6e63e9843d73b2ef /phpBB/install/schemas/mysql_41_schema.sql
parent417caa649a5fb87afa32a8a8f3600b591dddcce0 (diff)
downloadforums-f3e5acf3776083ec39052a3b8bf179638703d47e.tar
forums-f3e5acf3776083ec39052a3b8bf179638703d47e.tar.gz
forums-f3e5acf3776083ec39052a3b8bf179638703d47e.tar.bz2
forums-f3e5acf3776083ec39052a3b8bf179638703d47e.tar.xz
forums-f3e5acf3776083ec39052a3b8bf179638703d47e.zip
[ticket/10845] Changed the report system. Now it saves posts with the bbcode
Now the bitfield and uid of the bbcode is saved in the reports table. This will allow parsing the BBCode while loading the post to show PHPBB3-10845
Diffstat (limited to 'phpBB/install/schemas/mysql_41_schema.sql')
-rw-r--r--phpBB/install/schemas/mysql_41_schema.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql
index 3fd8d4f1d1..606a77c6d8 100644
--- a/phpBB/install/schemas/mysql_41_schema.sql
+++ b/phpBB/install/schemas/mysql_41_schema.sql
@@ -648,6 +648,8 @@ CREATE TABLE phpbb_reports (
report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
report_text mediumtext NOT NULL,
reported_post_text mediumtext NOT NULL,
+ reported_post_bitfield varchar(255) DEFAULT '' NOT NULL,
+ reported_post_uid varchar(8) DEFAULT '' NOT NULL,
PRIMARY KEY (report_id),
KEY post_id (post_id),
KEY pm_id (pm_id)