Wikipedia Education Program/Database Analysis Notes

Patches
* Merged
 * 1) Fix summary info for institutions* (supersedes previous version*)
 * 2) Fix enrollment status on Special:Student*
 * 3) Only add students to Special:Students*
 * 4) Accurately report institution activity* (requires a small change to the DB schema*)
 * 5) Update summary data when undeleting courses*
 * 6) Prevent the undeletion of courses of still-deleted institutions
 * 7) Refactor logic for some redundant data
 * 8) One-time maintenance script to repair summary data
 * 9) Prevent the deletion of institutions that have courses

Please note that the rest of this page is about the codebase prior to these patches.

Analysis by Transaction
This is analysis is for version  of the extension: