Log of /trunk/webwork2/bin/wwdb_check

---

Revision 5319 - (view) (download) (annotate) - [select for diffs]
Modified Mon Aug 13 22:59:59 2007 UTC (5 years, 9 months ago) by sh002i
File length: 26959 byte(s)
Diff to previous 4371

updated copyright dates

---

Revision 4371 - (view) (download) (annotate) - [select for diffs]
Modified Mon Aug 14 17:23:56 2006 UTC (6 years, 9 months ago) by sh002i
File length: 26959 byte(s)
Diff to previous 4369

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)

---

Revision 4369 - (view) (download) (annotate) - [select for diffs]
Modified Fri Aug 11 21:51:28 2006 UTC (6 years, 9 months ago) by sh002i
File length: 26427 byte(s)
Diff to previous 4364

make this compatible with wwdb_upgrade

---

Revision 4364 - (view) (download) (annotate) - [select for diffs]
Modified Wed Aug 9 21:21:46 2006 UTC (6 years, 9 months ago) by sh002i
File length: 29563 byte(s)
Diff to previous 4352

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.

---

Revision 4352 - (view) (download) (annotate) - [select for diffs]
Modified Sat Aug 5 02:53:19 2006 UTC (6 years, 9 months ago) by sh002i
File length: 19500 byte(s)
Diff to previous 4069

allow user to continue if an sql statement fails.

---

Revision 4069 - (view) (download) (annotate) - [select for diffs]
Modified Fri May 12 18:40:06 2006 UTC (7 years ago) by sh002i
File length: 19035 byte(s)
Diff to previous 4067

check for 'dbupgrade' table and 'db_version' value within that table.

---

Revision 4067 - (view) (download) (annotate) - [select for diffs]
Modified Wed May 10 21:50:41 2006 UTC (7 years ago) by sh002i
File length: 15565 byte(s)
Diff to previous 4066

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

---

Revision 4066 - (view) (download) (annotate) - [select for diffs]
Added Wed May 10 02:08:35 2006 UTC (7 years ago) by sh002i
File length: 13890 byte(s)

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