Re: [symfony-users] Re: Doctrine/MySQL: double up of id index
Hi,
On Tue, Aug 24, 2010 at 11:08 AM, pghoratiu wrote:
>> this may sound quite minor, but I'm just getting into Symfony and am
>> interested in some of the details.
>>
>> When I run symfony doctrine:insert-sql, the tables created always have
>> a duplicate index, one called PRIMARY and one called id. Normally this
>> wouldn't matter much, I'm just wondering for big tables, if the index
>> wouldn't eat up unnecessary buffer space. Can this be configured to
>> create only the PRIMARY index?> Post the schema you use.
> Usually a PK ID is autogenerated for a given table if none was
> specified.
for example this:
ReferralSource:
columns:
id: { type: integer(4), notnull: true, unique: true, primary:
true, autoincrement: true }
name: { type: string(100) }
Kind Regards,
Jochen Daum
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Re: Doctrine/MySQL: double up of id index
Post the schema you use. Usually a PK ID is autogenerated for a given table if none was specified. gabriel On Aug 24, 1:52 am, Jochen Daum wrote: > Hi, > > this may sound quite minor, but I'm just getting into Symfony and am > interested in some of the details. > > When I run symfony doctrine:insert-sql, the tables created always have > a duplicate index, one called PRIMARY and one called id. Normally this > wouldn't matter much, I'm just wondering for big tables, if the index > wouldn't eat up unnecessary buffer space. Can this be configured to > create only the PRIMARY index? > > Kind Regards, > > Jochen Daum > > Chief Automation Officer > Automatem Ltd > > Phone: 09 630 3425 > Mobile: 021 567 853 > Email: j...@automatem.co.nz > Skype: jochendaum > Website:www.automatem.co.nzhttp://twitter.com/automatemhttp://nz.linkedin.com/in/automatemhttp://www.xing.com/go/invite/3425509.181107http://www.aucklandbusinessnetworking.co.nz -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
