it depends of the table type :-)
actually we use innoDB for website otherwise it can become corrupted with the transaction volume we have.
we recommand using innoDB of course
I thought it should be InnoDB but just wanted to check, thanks.
That raises the question though, should the ddl's and the installer be configured to specify a TYPE = InnoDB for all the CREATE table statements. Can we specify a table type with jbosscmp-jdbc.xml for the CMP modules or would it have to be a ALTER TABLE command inside of <post-table-create>? I'm thinking that we'd have db portability issues if we went that route....
Or should the Nukes installation instructions just tell people to change MySQL's default table type to InnoDB?