Django messed up the table names.

[songziang@…]

I am working on a project which contains multiple tables in model. I named on table Users with the meta setup to be 'Users'. However, the table was created in mysql is "Users" rather than "users". There are also some tables' names contains upper case characters. Event mysql is case-insensitive, it still causes foreign key creation failure.

When I change all meta table name to lowercase, everything works.

So I guess there must be something wrong with the parser of the model in the current django release.

[Russell Keith-Magee]

Under my testing, if you have the following models:

class Bar(models.Model):
    class Meta:
        db_table = 'Bar'

class Foo(models.Model):
    bar = models.ForeignKey(Bar)

CREATE TABLE `Bar` (
    `id` integer NOT NULL PRIMARY KEY
)
;
CREATE TABLE `myapp_foo` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `bar_id` varchar(10) NOT NULL
)
;
ALTER TABLE `myapp_foo` ADD CONSTRAINT `bar_id_refs_id_34b02b8` FOREIGN KEY (`bar_id`) REFERENCES `Bar` (`id`);

This has capitals where capitals are needed, and quoting where quoting is needed to preserve those capitals. As far as I can make out this is completely correct.