diff options
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
-rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index ea2d0cede9..8bfe248489 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -443,9 +443,11 @@ CREATE TABLE phpbb_posts ( post_edit_time int(11), post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (post_id), - KEY topic_id (topic_id), - KEY poster_ip (poster_ip), - KEY poster_id (poster_id) + KEY forum_id (forum_id), + KEY topic_id (topic_id), + KEY poster_ip (poster_ip), + KEY poster_id (poster_id), + KEY post_approved (post_approved) ); @@ -524,6 +526,7 @@ CREATE TABLE phpbb_reports ( reason_id smallint(5) unsigned NOT NULL default '0', post_id mediumint(8) unsigned NOT NULL default '0', user_id mediumint(8) unsigned NOT NULL default '0', + user_notify tinyint(1) NOT NULL default '0', report_time int(10) unsigned NOT NULL default '0', report_text text NOT NULL, PRIMARY KEY (report_id) |