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
4820	add ability to report inconsistencies between Django models and configured database	Gary Wilson <gary.wilson@…>	nobody	"Sort of taking inspectdb/syncdb a little further.  This could be a step closer to having database migration/versioning.

For example, if I had the following Model:

{{{
#!python
class Book(models.Model):
    name = models.CharField(maxlength=50, unique=True)
    author = models.CharField(maxlength=100)
}}}

the function could report things like:
 * ""name"" field doesn't have `UNIQUE` specified
 * ""name"" field is `varchar(100)` instead of `varchar(50)`
 * ""name"" field is set `NULL` instead of `NOT NULL`
 * ""author"" field does not exist in the database
"		closed	Database layer (models, ORM)	dev		duplicate			Design decision needed	0	0	0	0	0	0