X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=7eb756cf2a3df73aa5140d9cba7c98e18251c7b8;hb=954b95b039ccd481550438a98bc592ce8f08fe96;hp=2f8882d4b4e2ac964b86c898d68f494bd350fa1e;hpb=4c945850f4d9e09f41ea85b82a431943cf35ead3;p=friendica.git diff --git a/database.sql b/database.sql index 2f8882d4b4..7eb756cf2a 100644 --- a/database.sql +++ b/database.sql @@ -1677,6 +1677,8 @@ CREATE TABLE IF NOT EXISTS `report` ( `reporter-id` int unsigned COMMENT 'Reporting contact', `cid` int unsigned NOT NULL COMMENT 'Reported contact', `comment` text COMMENT 'Report', + `category` varchar(20) COMMENT 'Category of the report (spam, violation, other)', + `rules` text COMMENT 'Violated rules', `forward` boolean COMMENT 'Forward the report to the remote server', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `status` tinyint unsigned COMMENT 'Status of the report',