Modifying Existing Tables

[freshJet]

Here's the deal. I want to add a new field to the schedules table. I've done this before with the bids but it was a bit easier in that case because when you went to edit the php files there was very little to change, whereas with the schedules there's a bit more.

Question is, is there an easy way to do this? And is there any way to prevent the changes being overwritten by updates? I know the usual way round the update overwrite issue is to create a new class file but this isn't going to work in this case because I need to modify an existing one.

Any ideas?

[mark1million]

Just add a new field to the database this will not get undone on any update then just modify the stock file and create a back up of it which sits on the server, on any update all you have to do is then compare the differences from your modified backed up file against the new one.

[freshJet]

modify the stock file and create a back up of it which sits on the server, on any update all you have to do is then compare the differences from your modified backed up file against the new one.

That was the other option I had in mind. Shouldn't be too hard with the change log I suppose.