On Wed, 2003-08-06 at 16:04, Jeroen Peschier wrote: > Hi all, > > My Torque project uses a MySQL 4.1 database. I have many onUpdate and > onDelete restrictions in the project's schema.xml. When the SQL code > gets generated it outputs the foreign keys fine in the SQL, but no > ONUPDATE or ONDELETE constraints to be found... Is this a known issue? > > There's also no table type in the CREATE TABLE statements. I think MySQL > defaults to using MyISAM while I want InnoDB. How do I specify a table > type? Come to think of it, why even specify a table type if foreign keys > plus constraints are defined and the database is MySQL. InnoDB should be > implied, no?
InnoDB => You have to "comment in" that in db.props-file of mysql. > Another minor thing I cannot specify in the schema is the character set > and collation to be used on a table. > > As is it now I have a post-create SQL-script that does a bunch of ALTER > TABLE statement and sets the required character set and collation. I > really don't want to add the referential constraints manually. It kinda > defeats the purpose of having it generated :) > > Open for suggestions... > > Jeroen > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
