you can use join table inheritance, which would allow you to split one class into multiple tables.
On Thu, Mar 17, 2016 at 7:22 PM, Dan Ferguson <[email protected]> wrote: > I'm using MySql with Doctrine 2 and as I understand it, Doctrine 2 has to > use the InnoDB storage engine to create foreign keys. But InnoDB has a > limit of 1000 columns. I've got one table that is approaching that limit. > Naturally, I'm considering some options for redesigning the database to > avoid this problem, but I'm not seeing any great options. Before I make > major changes to my code, I wanted to confirm my suspicion that there's > really no way to have an entity with more than 1000 columns while still > making use of foreign keys (which are not supported by MyISAM). > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
