3,035
edits
Update:Remora Download Counting: Difference between revisions
Update:Remora Download Counting (view source)
Revision as of 08:26, 7 February 2007
, 7 February 2007no edit summary
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
Old script - weekly downloads were kept as records in downloads using downloads.downloadcount. | 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? | 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? | 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 [[Update:Remora_Database_Migration#main_to_addons.2C_translations|migration notes]] | |||