Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r14745 -r14789 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14745) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14789) @@ -2282,3 +2282,16 @@ 'lu_field_CachedDescendantCatsQty', 'lu_field_hits', 'lu_field_cachedrating', 'lu_field_cachedvotesqty', 'lu_field_cachedreviewsqty', 'lu_field_orgid' ); + +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) +); \ No newline at end of file