[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) ?
Have you set is_auto_increment true on that column?
package Some::Table::Class;
use base 'DBIx::Class';
__PACKAGE__->add_column( uid => { is_auto_increment => 1 } );
Tom
_______________________________________________
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]/
