diff options
| author | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2003-04-02 23:13:47 +0000 |
|---|---|---|
| committer | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2003-04-02 23:13:47 +0000 |
| commit | f94a5cb87d10247c02faf93ca5c99d2de2a57c36 (patch) | |
| tree | f5b720c3b6b84d73e05f1bd7aaa9c18a39fdb616 /phpBB/install/schemas/mysql_schema.sql | |
| parent | 2c94c4659efa6835dd1034fc67dd8cda9dfee21a (diff) | |
| download | forums-f94a5cb87d10247c02faf93ca5c99d2de2a57c36.tar forums-f94a5cb87d10247c02faf93ca5c99d2de2a57c36.tar.gz forums-f94a5cb87d10247c02faf93ca5c99d2de2a57c36.tar.bz2 forums-f94a5cb87d10247c02faf93ca5c99d2de2a57c36.tar.xz forums-f94a5cb87d10247c02faf93ca5c99d2de2a57c36.zip | |
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
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) |