aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
-rw-r--r--phpBB/install/schemas/mysql_schema.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 156606385f..ab67729743 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -245,12 +245,14 @@ CREATE TABLE phpbb_log_moderator (
log_id mediumint(5) UNSIGNED NOT NULL DEFAULT '0' auto_increment,
user_id mediumint(8) NOT NULL DEFAULT '0',
forum_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+ topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
log_ip varchar(40) NOT NULL,
log_time int(11) NOT NULL,
log_operation text,
log_data text,
PRIMARY KEY (log_id),
KEY forum_id (forum_id),
+ KEY topic_id (forum_id),
KEY user_id (user_id)
);