Assembla home | Assembla project page
 

Ticket #74 (closed Enhancement Request: fixed)

Opened 3 years ago

Last modified 3 years ago

Better versioning of database changes

Reported by: swiss Assigned to:
Priority: High Milestone: 1.19
Component: Auto Update Version: 1.16
Keywords: Cc:

Description

We need to handle changes to the database schema in a more controlled, but automatic manner.

At the moment, when an update occurs all of the database scripts that have been modified are re-run. This should not be the case. We should store the version number either in the filename or somewhere inside the file and only apply the changes to the database if this number is greater than the current database schema version.

Change History

06/14/07 14:43:31 changed by swiss

  • status changed from new to closed.
  • resolution set to fixed.

The method used to patch the database has been change in changeset [807].

All new database changes should be saved in the swisscenter database directory with a filename like patch_nnnn.sql (where "nnnn" is an incrementing number, not connected to the swisscenter version number in any way).

Patches are applied immediately as soon as they are detected (when the configuration utility is accessed or the main menu is loaded). Swisscenter keeps track of the last database change applied to ensure that patches are not applied more than once.

06/14/07 14:43:37 changed by swiss

  • milestone changed from Undecided to 1.19.