[Koha-bugs] [Bug 7167] updatedatabase improvements

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7167

--- Comment #114 from Paul Poulain <paul.poulain at biblibre.com> ---
Proposal for the wiki:

How to submit an database update ?
Let's suppose you need one for the bugzilla bug 1234.
Create a file in $KOHA/installer/data/mysql/version/.
It's suggested that the file is named Bug_1234.sql or Bug_1234.pl
You can find 2 example files in the version directory.
When you submit your patch, submit this file.
Anyone testing your patch will be redirected to the installer page, will see
which changes your patch will do in the database, and will be able to apply
this update.

Once the patch has been validated and is pushed by the Release Manager, it will
be renamed to a numbered filename.
If your DBRev is the 33th one for version 3.10, it will be renamed as:
$KOHA/installer/data/mysql/version/3.09/3.0900033.sql
and pushed.

If your patch need to be backported to the previous (stable) version, the
Release Maintainer will also rename it. Let's suppose it's the 46th dbrev for
3.8, your file will be renamed to
$KOHA/installer/data/mysql/version/3.08/3.0800046.sql

What will happend if I've already applied my patch locally as Bug_1234.sql ?
The magic of the updatedatabase will find that both are in fact the same thing.
You'll just have to confirm that 3.09/3.0900033.sql is the same as
Bug_1234.sql, and Koha will remember it, and won't try to apply it twice.

What will happend if I've updated to 3.8.6 that contains the 3.0800046.sql and
I upgrade to 3.10.0 ?
The magic of the updatedatabase will find that both are in fact the same thing.
You'll just have to confirm that 3.09/3.0900033.sql is the same as
3.0800046.sql, and Koha will remember it, and won't try to apply it twice.

-- 
You are receiving this mail because:
You are watching all bug changes.