Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r14726 -r14789 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14726) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14789) @@ -814,6 +814,19 @@ KEY `Status` (`Status`) ); +CREATE TABLE SpamReports ( + ReportId int(11) NOT NULL AUTO_INCREMENT, + ItemPrefix varchar(255) NOT NULL, + ItemId int(11) NOT NULL, + MessageText text, + ReportedOn int(11) DEFAULT NULL, + ReportedById int(11) DEFAULT NULL, + PRIMARY KEY (ReportId), + KEY ItemPrefix (ItemPrefix), + KEY ItemId (ItemId), + KEY ReportedById (ReportedById) +); + CREATE TABLE ItemTypes ( ItemType int(11) NOT NULL default '0', Module varchar(50) NOT NULL default '',