[Koha-devel] Update database changes proposal [IMPORTANT]

[Mason James]

On 2011-11-18, at 5:43 AM, Paul Poulain wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Le 09/11/2011 18:54, Mason James a écrit :
>> do other people agree?
> not at all ! Sometimes (not very often, but not rarely either), more
> complex calculations must be made, like for
> 
> For example:
> depending on your marcflavour you do something or something else.
>> $DBversion = '3.05.00.017'; if (C4::Context->preference("Version")
>> < TransformToNum($DBversion)) { if
>> (C4::Context->preference("marcflavour") eq 'MARC21' || 
>> C4::Context->preference("marcflavour") eq 'NORMARC'){ 

...

> 
> So we must have a .pl file, not SQL
> - -- 
> Paul POULAIN


yes, yes... a good point Paul!

i think if we want to do Ian's suggested check/apply/roll-back idea for DB changes, we will indeed need to use .pl files not .sql files for new patches

so, i change my mind on this point :) 


Mason

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 535 bytes
Desc: This is a digitally signed message part
URL: </pipermail/koha-devel/attachments/20111118/df2a3d77/attachment.pgp>