[cowiki-dev] coWiki transactions

Hi,

I've committed transaction demarcation stuff. This means _from now on_
MySQLs MyISAM tables are passé and over the hills. The CVS HEAD _might_
still work with MyISAM tables, but it is strongly recommended to use InnoDB.
Otherwise you will lose data.

coWiki setup installer does not yet upgrade the affected tables to InnoDB
automatically! If you want to play with latest HEAD, you will need to change
the type of the tables manually.

This can be done with the "mysql" command or phpMyAdmin or similar tools:

The SQL command are:

  ALTER TABLE cowiki_comment DROP INDEX content;
  ALTER TABLE cowiki_node DROP INDEX summary;

  ALTER TABLE cowiki_comment TYPE=INNODB;
  ALTER TABLE cowiki_group TYPE=INNODB;
  ALTER TABLE cowiki_node TYPE=INNODB;
  ALTER TABLE cowiki_node_hist TYPE=INNODB;
  ALTER TABLE cowiki_node_hist_spill TYPE=INNODB;
  ALTER TABLE cowiki_node_ref TYPE=INNODB;
  ALTER TABLE cowiki_node_spill TYPE=INNODB;
  ALTER TABLE cowiki_shoutbox TYPE=INNODB;
  ALTER TABLE cowiki_user TYPE=INNODB;
  ALTER TABLE cowiki_user_group TYPE=INNODB;


regards dtg

P.S.
  The transaction demarcation needs to be tested. Go! :)

P.P.S.
  Attention: if you use the installer to create a new database, you will get
  MyISAM tables again - until the installer is able to handle the upgrade
  itself