diff options
| author | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2003-03-06 01:35:03 +0000 |
|---|---|---|
| committer | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2003-03-06 01:35:03 +0000 |
| commit | 553087d0aa8d25d98930a034f3aa886744dd5937 (patch) | |
| tree | 714fd8722f40e577dd78ab30bd4e4bbdae03a01a /phpBB/install | |
| parent | 6251ea71304180352d2d45bf755dddb77c520ca4 (diff) | |
| download | forums-553087d0aa8d25d98930a034f3aa886744dd5937.tar forums-553087d0aa8d25d98930a034f3aa886744dd5937.tar.gz forums-553087d0aa8d25d98930a034f3aa886744dd5937.tar.bz2 forums-553087d0aa8d25d98930a034f3aa886744dd5937.tar.xz forums-553087d0aa8d25d98930a034f3aa886744dd5937.zip | |
Implementing post reporting. 2 new tables plus an extra field for posts and topics tables.
git-svn-id: file:///svn/phpbb/trunk@3603 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_basic.sql | 15 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 30 |
2 files changed, 40 insertions, 5 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql index 449a6d63fc..5fcd0226b1 100644 --- a/phpBB/install/schemas/mysql_basic.sql +++ b/phpBB/install/schemas/mysql_basic.sql @@ -194,15 +194,15 @@ INSERT INTO phpbb_styles_theme (theme_id, css_data, css_external) VALUES (1, 'bo # -- Forums -INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_postable, forum_posts, forum_topics, forum_last_post_id, forum_last_poster_id, forum_last_poster_name) VALUES (1, 'My first Category', '', 1, 4, 0, 0, 1, 1, 1, 2, 'Admin'); +INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_postable, forum_posts, forum_topics, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_post_time) VALUES (1, 'My first Category', '', 1, 4, 0, 0, 1, 1, 1, 2, 'Admin', 972086460); -INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_postable, forum_posts, forum_topics, forum_last_post_id, forum_last_poster_id, forum_last_poster_name) VALUES (2, 'Test Forum 1', 'This is just a test forum.', 2, 3, 1, 1, 1, 1, 1, 2, 'Admin'); +INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_postable, forum_posts, forum_topics, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_post_time) VALUES (2, 'Test Forum 1', 'This is just a test forum.', 2, 3, 1, 1, 1, 1, 1, 2, 'Admin', 972086460); # -- Users INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 1, 'Anonymous', 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', '', '', '', '', 0, 0); -# -- username: admin password: admin (change this or remove it once everything is working!) +# -- username: Admin password: admin (change this or remove it once everything is working!) INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active, user_founder) VALUES ( 2, 'Admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'en', 0, 'd M Y h:i a', '', '', 0, 1, 1); @@ -249,11 +249,11 @@ INSERT INTO phpbb_auth_groups (group_id, forum_id, auth_option_id, auth_allow_de # -- Moderator cache -INSERT INTO phpbb_moderator_cache (user_id, forum_id, username) VALUES (2, 2, 'admin'); +INSERT INTO phpbb_moderator_cache (user_id, forum_id, username) VALUES (2, 2, 'Admin'); # -- Demo Topic -INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_first_post_id, topic_last_post_id, topic_last_poster_id, topic_last_post_time) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 2, 0, 0, 1, 1, 2, 972086460); +INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_first_post_id, topic_first_poster_name, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_post_time) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 2, 0, 0, 1, 'Admin', 1, 2, 'Admin', 972086460); # -- Demo Post @@ -330,3 +330,8 @@ INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 ); INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 ); INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 ); + + +# -- reasons +INSERT INTO phpbb_reports_reasons (reason_id, reason_priority, reason_name, reason_description) VALUES ( 1, 0, '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, 1, 'other', 'The reported post does not fit into any other category, please use the description field.' );
\ No newline at end of file diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 9b4adac724..427274fa7e 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -332,6 +332,7 @@ CREATE TABLE phpbb_posts ( poster_ip varchar(40) NOT NULL, post_time int(11) DEFAULT '0' NOT NULL, post_approved tinyint(1) DEFAULT '1' NOT NULL, + post_reported tinyint(1) DEFAULT '0' NOT NULL, enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, enable_html tinyint(1) DEFAULT '0' NOT NULL, enable_smilies tinyint(1) DEFAULT '1' NOT NULL, @@ -417,6 +418,34 @@ CREATE TABLE phpbb_ratings ( # -------------------------------------------------------- # +# Table structure for table 'phpbb_reports_reasons' +# +CREATE TABLE phpbb_reports_reasons ( + reason_id smallint(6) NOT NULL auto_increment, + reason_priority tinyint(4) NOT NULL default '0', + reason_name varchar(255) NOT NULL default '', + reason_description text NOT NULL, + PRIMARY KEY (reason_id) +); + + +# -------------------------------------------------------- +# +# Table structure for table 'phpbb_reports' +# +CREATE TABLE phpbb_reports ( + report_id smallint(5) unsigned NOT NULL auto_increment, + 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', + report_time int(10) unsigned NOT NULL default '0', + report_text text NOT NULL, + PRIMARY KEY (report_id) +); + + +# -------------------------------------------------------- +# # Table structure for table `phpbb_search_results` # CREATE TABLE phpbb_search_results ( @@ -614,6 +643,7 @@ CREATE TABLE phpbb_topics ( forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL, icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL, topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, + topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, topic_title varchar(60) NOT NULL, topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_time int(11) DEFAULT '0' NOT NULL, |