Wikipedia Education Program/Database Analysis Notes


 * Restoring a previous version of a course restores the previous data on students, instructors and volunteers participating. This is confusing, since those things are changed on the course view page, not the course edit page. There are no warnings about this.
 * Deleting institutions is dangerous. Really, it should not be possible to delete an institution without first deleting all the related courses. Related: as noted previously, you can undelete a course without undeleting the institution.
 * When undeleting institutions, the code attempts to restore the courses that were deleted along with the institution, but a bug (, line 124, “Courses” should be “EPCourses”) makes this not work. If we make it impossible to delete an institution if it has courses, this won't be a problem, and the actions marked in the spreadsheet as missing for undeleting courses would not be required, either.
 * Undoing a change for an institution also restores the institution's summary fields, which is wrong. Provided this is fixed, no additional changes should be required to keep summary data current when an org is restored. **CHECKING