diff options
| author | Bart van Bragt <bartvb@users.sourceforge.net> | 2006-03-04 13:50:52 +0000 |
|---|---|---|
| committer | Bart van Bragt <bartvb@users.sourceforge.net> | 2006-03-04 13:50:52 +0000 |
| commit | 70b20a98f756c0bd3081d5de92997776ae39d6ce (patch) | |
| tree | beb2962e8588a3c91cab9b13efda12a884149aa9 /phpBB/install/schemas | |
| parent | 0525406c3b71654b33928932903360a9a3e2d6ff (diff) | |
| download | forums-70b20a98f756c0bd3081d5de92997776ae39d6ce.tar forums-70b20a98f756c0bd3081d5de92997776ae39d6ce.tar.gz forums-70b20a98f756c0bd3081d5de92997776ae39d6ce.tar.bz2 forums-70b20a98f756c0bd3081d5de92997776ae39d6ce.tar.xz forums-70b20a98f756c0bd3081d5de92997776ae39d6ce.zip | |
Reporting system revised. Needs some major cleanup and is missig some functionality (assign report, some overviews, decent notifications) but the basics are there. More after the weekend :)
git-svn-id: file:///svn/phpbb/trunk@5601 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 38 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 13 |
2 files changed, 36 insertions, 15 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 182cb32e4f..b13a2092f3 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -550,26 +550,42 @@ CREATE TABLE phpbb_ranks ( PRIMARY KEY (rank_id) ); +# Table: 'phpbb_reports' +CREATE TABLE `phpbb_reports` ( + `report_id` smallint(5) unsigned NOT NULL auto_increment, + `report_type` tinyint(4) unsigned NOT NULL default '0', + `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, + `report_status` tinyint(4) NOT NULL default '0', + `bbcode_uid` varchar(5) NOT NULL default '', + `bbcode_bitfield` int(11) NOT NULL default '0', + PRIMARY KEY (`report_id`) +); + # Table: 'phpbb_reports_reasons' CREATE TABLE phpbb_reports_reasons ( reason_id smallint(6) NOT NULL auto_increment, + report_type tinyint(4) unsigned NOT NULL default '0', reason_priority tinyint(4) DEFAULT '0' NOT NULL, reason_name varchar(255) DEFAULT '' NOT NULL, reason_description text NOT NULL, PRIMARY KEY (reason_id) ); -# Table: 'phpbb_reports' -CREATE TABLE phpbb_reports ( - report_id smallint(5) UNSIGNED NOT NULL auto_increment, - reason_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_notify tinyint(1) DEFAULT '0' NOT NULL, - report_time int(10) UNSIGNED DEFAULT '0' NOT NULL, - report_text text NOT NULL, - PRIMARY KEY (report_id) +# Table: `phpbb_reports_replies` +CREATE TABLE `phpbb_reports_replies` ( + `reply_id` mediumint(8) unsigned NOT NULL auto_increment, + `report_id` mediumint(8) unsigned NOT NULL default '0', + `reply_time` int(10) unsigned NOT NULL default '0', + `reply_text` text NOT NULL, + `from_user_id` mediumint(9) NOT NULL default '0', + `status` tinyint(4) NOT NULL default '0', + `to_user_id` mediumint(9) NOT NULL default '0', + PRIMARY KEY (`reply_id`) ); # Table: 'phpbb_search_results' diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index a676b934e3..a416e66e09 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -754,10 +754,15 @@ INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES (3, 1, # MSSQL IDENTITY phpbb_reports_reasons ON # # -- reasons -INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES (1, 3, 'warez', 'The reported post contains links to pirated or illegal software'); -INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES (2, 2, 'spam', 'The reported post has for only purpose to advertise for a website or another product'); -INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES (3, 1, 'off_topic', 'The reported post is off topic'); -INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES (4, 0, 'other', 'The reported post does not fit into any other category, please use the description field'); +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description, report_type) VALUES (1, 0, 'other', 'The reported post does not fit into any other category (please use the description field)', 1); +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description, report_type) VALUES (2, 90, 'warez', 'The reported post contains links to pirated or illegal software', 1); +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description, report_type) VALUES (3, 60, 'spam', 'The reported post has for only purpose to advertise for a website or another product', 1); +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description, report_type) VALUES (4, 20, 'off_topic', 'The reported post is off topic', 1); + +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description, report_type) VALUES (5, 0, 'other', 'Other reason (please use the description field)', 2); +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description, report_type) VALUES (6, 40, 'bug', 'The forum is not behaving as I expected', 2); +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description, report_type) VALUES (7, 30, 'email', 'I have a problem with receiving email.', 2); +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description, report_type) VALUES (8, 20, 'user', 'I have a complaint about a user', 2); # MSSQL IDENTITY phpbb_reports_reasons OFF # |