Update:Remora Download Counting

From MozillaWiki
Revision as of 08:26, 7 February 2007 by Morgamic (talk | contribs)
Jump to navigation Jump to search

http://lxr.mozilla.org/webtools/source/addons/shared/bin/maintenance.php

Old script - weekly downloads were kept as records in downloads using downloads.downloadcount.

  • unless there is a good reason to deviate from this, we should keep that method.

New schema has addons.weeklydownloads in addition to addons.totaldownloads - do we now want to stop using the downloads table to keep counts, and keep them both in the addons table?

  • the old schema had two columns - main.totaldownloads and main.downloadcount
  • totaldownloads had total downloads, and downloadcount had the weekly count

Weeklydownloads are only for the last 7 days since the maintenance script was run?

  • the maintenance script only deletes the last 8 days, erring on the side of caution
  • downloadcount -> weeklydownloads
  • totaldownloads -> totaldownloads
  • Both of these mappings are in the migration notes