You are here: Foswiki>Oscar Web>UserFAQ (15 Feb 2010, JamesBusser)EditAttach

Database changes

What is the mechanism to file a database update?

The mechanism for database changes is :
  1. Change the install sql files
  2. add an update file to the updates directory in the format "update-yyyy-MM-dd.sql" this file be expected to run in the format of
    oscar@oscar:~$mysql  database < update-yyyy.MM.dd.sql
  • This file should migrate the current database schema to the new database schema. (DO NOT DROP DATA)
  1. Send this same script to the developers mailing-list so that people are aware.

NOTE. Generally we don't add update files that add data to tables unless it has been discussed, to protect against unintended duplication where data may already exist.
Topic revision: 15 Feb 2010, JamesBusser
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback
Powered by Olark