id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 13183 db_table case sensitive noppes nobody "I have the model: {{{ class UserProfile(models.Model): user = models.ForeignKey(User) class Meta: db_table = ""UserProfile"" }}} and when i run manage.py syncdb for a second time i get this error: {{{ python manage.py syncdb Creating table UserProfile Traceback (most recent call last): File ""manage.py"", line 11, in execute_manager(settings) File ""D:\Python26\lib\site-packages\django\core\management\__init__.py"", line 438, in execute_manager utility.execute() File ""D:\Python26\lib\site-packages\django\core\management\__init__.py"", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File ""D:\Python26\lib\site-packages\django\core\management\base.py"", line 196, in run_from_argv self.execute(*args, **options.__dict__) File ""D:\Python26\lib\site-packages\django\core\management\base.py"", line 223, in execute output = self.handle(*args, **options) File ""D:\Python26\lib\site-packages\django\core\management\base.py"", line 352, in handle return self.handle_noargs(**options) File ""D:\Python26\lib\site-packages\django\core\management\commands\syncdb.py"" , line 94, in handle_noargs cursor.execute(statement) File ""D:\Python26\lib\site-packages\django\db\backends\util.py"", line 19, in e xecute return self.cursor.execute(sql, params) File ""D:\Python26\lib\site-packages\django\db\backends\mysql\base.py"", line 86 , in execute return self.cursor.execute(query, args) File ""D:\Python26\lib\site-packages\MySQLdb\cursors.py"", line 173, in execute self.errorhandler(self, exc, value) File ""D:\Python26\lib\site-packages\MySQLdb\connections.py"", line 36, in defau lterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1050, ""Table 'userprofile' already exists"") }}} my guess is that this is a case problem. first time I ran manage.py syncdb it said: Creating table UserProfile, but it actually created userprofile in lower case. when i change db_table = ""UserProfile"" to db_table = ""userprofile"" i dont get the error but I ofcourse want my database tables with capital letters" closed Database layer (models, ORM) dev invalid Unreviewed 0 0 0 0 0 0