#56: MySQL id columns should be UNSIGNED
---------------------------------------------------+------------------------
Reporter: Manuzhai <[EMAIL PROTECTED]> | Owner: adrian
Status: reopened | Milestone: post-1.0
Component: Database layer (models, ORM) | Version:
Resolution: | Keywords:
Stage: Ready for checkin | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
---------------------------------------------------+------------------------
Changes (by [EMAIL PROTECTED]):
* stage: Accepted => Ready for checkin
Comment:
Change line 10 in django/db/backends/mysql/creation.py from:
{{{
'AutoField': 'integer AUTO_INCREMENT',
}}}
To:
{{{
'AutoField': 'integer UNSIGNED AUTO_INCREMENT',
}}}
In lines 709-713 of django/db/models/fields/related.py it casts
PositiveIntegerField and SmallPositiveIntegerField, as well as AutoField,
to IntegerField().db_type(). This makes me assume we do not need to make
any changes by changing AutoField to UNSIGNED matching
PositiveIntegerField which is already 'integer UNSIGNED'.
Phillip.
--
Ticket URL: <http://code.djangoproject.com/ticket/56#comment:7>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
