[EMAIL PROTECTED] wrote:
I have been trying to generate sql from the schemas using the following print $schema->storage->deployment_statements($schema, 'MySQL'); It does generate the sql. The only problem is that the resulting sql does not have AUTO_INCREMENT set for the id field(primary key). The schemas do have the PK::Auto (or PK::Auto::MySQL) components loaded and id column is set as a primary key. Is there something else that I need to do, in order that the resulting sql contains AUTO_IMCREMENT for the id(with primary key) ?
I'll assume you are specifying the is_auto_increment attribute on the columns in the ResultSource (table) class.
If you have, then examine the SQL::Translator::Parser::DBIx::Class (in the DBIC tarball) and SQL::Translator::Producer::MySQL to see if it does anything with the above attribute.
Ash _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
