<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On Aug 2, 2010, at 5:39 PM, Greg Zapp wrote:</div><br><blockquote type="cite"><span class="gI">I keep having to manually change '<span style="color: rgb(204, 0, 0);">role_id</span>' and <span style="color: rgb(0, 0, 0);">'<span style="color: rgb(204, 0, 0);">user_id</span></span>' to '<span style="color: rgb(204, 0, 0);">role</span>' and '<span style="color: rgb(204, 0, 0);">user</span>'. My data base is MySQL and I have the foreign keys setup in the UserRole table. Why is this happening? It happens for the BookAuthor as well, and it causes checksum mismatches due to my manual intervention:(</span><br></blockquote><br></div><div>Try passing a 'naming' option when you generate the schema:</div><div><a href="http://search.cpan.org/~rkitover/DBIx-Class-Schema-Loader-0.07001/lib/DBIx/Class/Schema/Loader/Base.pm#naming">http://search.cpan.org/~rkitover/DBIx-Class-Schema-Loader-0.07001/lib/DBIx/Class/Schema/Loader/Base.pm#naming</a></div><div><br></div><div>e.g. naming='{relationships=>"current",monikers=>"current"}'</div></body></html>