Update

We try to keep the updates simple and most of the time updates only require a simple rerun of the installation script, selecting to update a current database. Below you'll find additional steps that need to be done if updating existing databases.

Beta 2 to 2.0

If you have a beta 2 installation and want to update to 2.0 you'll have to run the installation script and choose to update an existing database. This will take care of most database updates. Though the following changes must be done manually(Note the syntax is for MySQL databases)

ALTER TABLE News MODIFY COLUMN news_date datetime;
ALTER TABLE News MODIFY COLUMN start_date datetime;
ALTER TABLE News MODIFY COLUMN end_date datetime;
ALTER TABLE BioMaterialEvents MODIFY COLUMN entry_date datetime;
ALTER TABLE BioMaterialEvents MODIFY COLUMN event_date datetime;
ALTER TABLE PlateEvents MODIFY COLUMN entry_date datetime;
ALTER TABLE PlateEvents MODIFY COLUMN event_date datetime;
ALTER TABLE Experiments MODIFY COLUMN publication_date datetime;