On Fri, 13 May 2005, Job Miller wrote:
do you guys have users out there dropping columns that once existed? or do you just want to have applications that work regardless of whether the schema is actually the same or not?
Neither of those.
seems like if a column is missing, and it is worth checking for in a perl script, that there may be many other serious problems in the schema, missing tables, no stats, wrong data type definitions, missing indexes, missing grants, etc.
checksetup.pl in bugzilla goes through checking this sort of thing to determine what needs to be done to make your bugzilla database schema current. The presumption is that the database is in the state that a previous version of checksetup.pl left it in. While this turns out to be a bit crufty in practice it works and doesn't seem totally wrong regardless of its utter lack of elegance or beauty.
-- </chris>
"There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt (Author)
