After thinking about this a bit more - is this really a good idea? It might really screw up existing users. Migrating from an existing database that uses MyISAM to InnoDB might be pretty tough. I would say that the createdb.sql script use InnoDB, but leave it out of upgrade scripts.
Matt On 9/20/05, Elias Torres <[EMAIL PROTECTED]> wrote: > +1 > > On 9/20/05, Allen Gilliland <[EMAIL PROTECTED]> wrote: > > team, > > > > how do folks feel about making the mysql schema default to using InnoDB > > type mysql tables? which table type to choose is a pretty complex > > issue, but the big bonus for InnoDB is that it offers referential > > integrity. right now a default install of Roller on mysql will yield > > all MyISAM tables, which means that our foreign keys mean nothing. > > InnoDB would help fix this. > > > > what do others think? should we make InnoDB the default table type? > > > > -- Allen > > > > >
