Wednesday, April 28, 2010

Is it safe to alter Django generated tables in MySQL to have composite PK?

I'm using MySQL with Django.

MySQL uses clustered index. I have a class AuctionBid for which the
"natural" PK is (user_id, auction_id).

I'd like to set (user_id, aucton_id) as the PK so that it'll be the
clustered index. I understand that Django doesn't support composite
PK. But what if after syncdb I just ALTER TABLE to make (user_id,
aucton_id) the PK. Would that work with Django or would that introduce
some unwanted behavior under the hood?

Thanks.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate