openwebwork/webwork2 — pull request #400 by mgage (2014-05-21 20:10:04+00:00)
Title: Fix admin database

Fix extra version_id field in problem_user and set_user tables of admin.

This does not remove these fields from those tables but it prevents them from being created.

Here is the story. Every time upgrade tables is run the admin course updates the non-native tables (the ones that are global to the site and not tied to a specific course). The problem_version and set_version tables are virtual tables (and defined as non-native so that courses don't try to create them). The admin course however does create these tables and since they are aliased to problem_user and set_user these tables acquire an extra field that should not be there.

This adds a hack to the updates for admin course (defined in CourseManagement.pm) which specifically skips those two tables. If more virtual tables are created this list will need to be added to.