updated copyright dates
don't check course if user says no. improved status messages. ignore non_native tables. allow conversions from TEXT->INT by first converting to VARCHAR(255)
make this compatible with wwdb_upgrade
check against "database version 0", the db structure during 2.2.x. this utility is designed to be used ONCE when upgrading from 2.2.x to 2.3.0, and then all future updates will be handled by wwdb_upgrade. at some point, i may reinstate the ability to check against the current version, but at this point it's not necessary.
allow user to continue if an sql statement fails.
check for 'dbupgrade' table and 'db_version' value within that table.
some improvements: * warn if dbLayoutName doesn't match for a course (this can be extended to to more sophisticated checking) * add a summary of tables that weren't checked because they weren't part of any course * -n flag == don't attempt to fix problems
a utility to check and repair the webwork SQL database. functionality so far: * check for table existence, add tables that don't exist * check for field existence, add fields that don't exist * check field types, change types of fields that have incorrect types still TODO: * check index structure with SHOW INDEXES FROM * add indexes that aren't present * display tables in webwork database that weren't part of any course * check for dbupgrade table, offer to add it
This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.
|aubreyja at gmail dot com||ViewVC Help|
|Powered by ViewVC 1.0.9|