how to update infusion?

You can change version of infusion, for examle, from 1.0 to 1.1. After that, infusion's name will be displayed in blue. You need to infuse it without defusing, so changes will be accepted.

thanks, i know that, but how about the sql changes?

for example:
in version 1.0 i add a table and insert 3 rows.
in version 1.1 i insert another 3 rows

now if i install the infusion with version 1.1 i have to add a table and insert 6 rows.
however if i have version 1.0 and update to version 1.1 i can assume that the table is there and the first 3 rows are also, so i only have to insert the last 3 rows.

i don't see the possibility in the infusion.php to differ wether i already have version 1.0 installed or not.
or in general i don't have the possibility to check if a table already is there and instead of add the table i only have to alter it.

Yes. You're right. You can only ALTER TABLE while updating infusion.

If you will have a look in the administration/infusions.php, you will find only this code for updating :
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]if ($inf_version > $data['inf_version']) {

if (isset($inf_altertable) && is_array($inf_altertable) && count($inf_altertable)) {

for ($i = 1; $i < (count($inf_altertable) + 1); $i++) {

$result = dbquery("ALTER TABLE ".$inf_altertable[$i]);

}

}

$result2 = dbquery("UPDATE ".DB_INFUSIONS." SET inf_version='".$inf_version."' WHERE inf_id='".$data['inf_id']."'";

}[/syntaxhighlighter]

it is not that important to create a new table, the thing is, how can i check if the version 1.0 was already installed so that i only have to insert three rows instead of six.

Then I think that you may create a custom Code in your Infusion itself which will check for your infusion's current version and make changes, say an Update button in your Infusion...

I hope you understood my point B)

ah ok, yes i did, great idea :) maybe an infusion update admin panel or something :)

Merged on Mar 04 2012 at 13:55:30:
i ask myself, what is the internal update function good for if you can't actually do something except for alter tables?
as i see it, it does two things, alter the version number to the current one and alter tables if necessary.