Ooohhhh! Sorry about that. Yes, that looks sketchy. On Mon, Sep 24, 2012 at 4:24 PM, John Moses <[email protected]> wrote: > Thanks for your response, it seems that there is some miscommunication. > > We both agree that FKs on a join table should not be auto incremented. I > did not make the FKs on my join table auto increment. The file generated by > the command `cake schema dump` that contains the create statements listed > that they were auto incremented. You can see from my table declaration that > they are not auto incremented. > > I hope that clears up any confusion. > > On Monday, September 24, 2012 2:12:31 PM UTC-5, cricket wrote: >> >> This has nothing at all to do with CakePHP. In a join table, the >> columns are foreign keys pointing to the id of some other tables. >> THOSE values are usually (but not always) auto_increment. There's no >> sense in making your FKs auto_inc because they're not being generated >> out of thin air (for the join table). >> >> You're also using InnoDB so you may as well explicitly define the FKs >> and add constraints. >> >> On Sun, Sep 23, 2012 at 10:06 PM, John Moses <[email protected]> wrote: >> > Hey guys, >> > I was going to report a bug, but wanted to make sure it wasn't an error >> > on >> > my part or something in a model I was unaware of. A quick search didn't >> > show anything in the groups or stackoverflow for this exact issue. >> > There is >> > a related issue at >> > >> > https://rails.lighthouseapp.com/projects/8994/tickets/4721-schema-dump-does-not-respect-autoincrement >> > >> > Here is the schema dump for the table in question: >> > >> >> CREATE TABLE `events`.`attendees_packages` ( >> >> `attendee_id` int(11) NOT NULL AUTO_INCREMENT, >> >> `package_id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY >> >> (`attendee_id`, >> >> `package_id`)) DEFAULT CHARSET=latin1, >> >> COLLATE=latin1_swedish_ci, >> >> ENGINE=InnoDB; >> > >> > >> > And here is the column information in mysql: >> >> >> >> mysql> show full columns from attendees_packages; >> >> >> >> >> >> +-------------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+ >> >> | Field | Type | Collation | Null | Key | Default | Extra | >> >> Privileges | Comment | >> >> >> >> >> >> +-------------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+ >> >> | attendee_id | int(11) | NULL | NO | PRI | NULL | | >> >> select,insert,update,references | | >> >> | package_id | int(11) | NULL | NO | PRI | NULL | | >> >> select,insert,update,references | | >> >> >> >> >> >> +-------------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+ >> >> 2 rows in set (0.11 sec) >> > >> > >> > It is all of my hasMany association tables. >> > >> > Has anybody seen this before? Is it a configuration item I am missing? >> > Thanks. >> > John >> > >> > -- >> > Like Us on FacekBook https://www.facebook.com/CakePHP >> > Find us on Twitter http://twitter.com/CakePHP >> > >> > --- >> > You received this message because you are subscribed to the Google >> > Groups >> > "CakePHP" group. >> > To post to this group, send email to [email protected]. >> > To unsubscribe from this group, send email to >> > [email protected]. >> > Visit this group at http://groups.google.com/group/cake-php?hl=en. >> > >> > > > -- > Like Us on FacekBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > >
-- Like Us on FacekBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
