reverse

INSERT INTO `phpbb_reports_config` (`config_name`, `config_value`) VALUES ('user_panels', 'report_info,1,1|post_info,1,0|user_reports_info,1,0');
INSERT INTO `phpbb_reports_config` (`config_name`, `config_value`) VALUES ('mod_panels', 'report_info,1,1|post_info,1,0|poster_info,1,0|action_info,1,0');

INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (1, 'Wrong forum', 'The message has been posted in a wrong forum', 0, 20, 1);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (2, 'Bad words', 'The post contains bad words', 0, 30, 1);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (3, 'Double post', 'User has already posted the same message before', 0, 40, 1);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (4, 'Spam', 'The post contains spam', 0, 50, 1);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (5, 'User banned', 'User was banned from the forum', 0, 40, 2);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (6, 'Post deleted', 'Post was deleted from the topic', 0, 20, 2);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (7, 'Post moved', 'Post was moved to another topic', 0, 50, 2);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (8, 'Post edited', 'Post was edited', 0, 30, 2);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (9, 'Other', 'Everything else', 1, 10, 1);
INSERT INTO `phpbb_reports_data` (`data_id`, `data_name`, `data_desc`, `data_comments`, `data_order`, `data_code`) VALUES (10, 'Other', 'Everything else', 1, 10, 2);

ALTER TABLE `phpbb_users` ADD `user_report_optout` tinyint(1) default '0' NOT NULL;

ALTER TABLE `phpbb_posts` ADD `post_reported` tinyint(1) default '0' NOT NULL;

DELETE FROM `phpbb_reports_config` WHERE config_name = 'user_panels';
DELETE FROM `phpbb_reports_config` WHERE config_name = 'mod_panels';
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 1;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 2;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 3;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 4;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 5;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 6;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 7;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 8;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 9;
DELETE FROM `phpbb_reports_data` WHERE `data_id` = 10;
ALTER TABLE `phpbb_users` DROP `user_report_optout`;
ALTER TABLE `phpbb_posts` DROP `post_reported`;