From f94a5cb87d10247c02faf93ca5c99d2de2a57c36 Mon Sep 17 00:00:00 2001
From: Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net>
Date: Wed, 2 Apr 2003 23:13:47 +0000
Subject: Added user notification for post reporting, moved lang strings to
 lang_main, added CSS style for mcp_jumpbox

git-svn-id: file:///svn/phpbb/trunk@3779 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

(limited to 'phpBB/install/schemas/mysql_schema.sql')

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)
-- 
cgit v1.2.1

