[Qingu-developers] new usage scheme of sql folder, changelog file

[Jago <ja...@no...>]

Hi,
with the new release 1.1.4 that is available since today we decided to 
use a different scheme for the sql folder. We removed all files for the 
single tables and only left the files db_structure.sql and data.sql. 
These should be sufficient to restore all non dynamic data.
In the future whenever you have a change for one of the tables (new 
columns, new values for non dynamic data) you have to create a new file 
for the table you altered. For example when you add a setting in 
sys_settings then you create the file sys_settings.sql (if not already 
available) and add the string in this file, so everybody know what to 
add. The release creator will then remove the single table files and 
create a new db_structure.sql and data.sql for the release.
This enables the other developers to see easily what changes they need 
in the database when they update the code. A second advantage for the 
release team is that the production systems can be easily upgraded.

 From now on (after release 1.1.4beta) there will be a release file. 
When you have finished a new function or have a fix, please update this 
file. This will make it easier for everybody to follow the changes and 
check if everything is working correctly.

kind regards
Joern / Jago / sutester