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
3722	[boulder-oracle] Minimum value of an Oracle PositiveIntegerField should be zero	Ben Khoo <benk@…>	Adrian Holovaty	"In order to be consistent with PostgreSQL the PositiveIntegerField and PositiveSmallIntegerField should begin at zero instead of one.

Currently it reads ({{{django\django\db\backends\oracle\creation.py}}})
{{{
'PositiveIntegerField':         'NUMBER(11) CHECK (%(column)s >= 1)',
'PositiveSmallIntegerField':    'NUMBER(11) CHECK (%(column)s >= 1)',
}}}

however I believe it should be
{{{
'PositiveIntegerField':         'NUMBER(11) CHECK (%(column)s >= 0)',
'PositiveSmallIntegerField':    'NUMBER(11) CHECK (%(column)s >= 0)',
}}}

PostgreSQL uses the following ({{{django\django\db\backends\postgresql\creation.py}}})
{{{
'PositiveIntegerField': 'integer CHECK (""%(column)s"" >= 0)',
'PositiveSmallIntegerField': 'smallint CHECK (""%(column)s"" >= 0)',
}}}"		closed	Database layer (models, ORM)	other branch		fixed	Oracle PositiveIntegerField		Ready for checkin	1	0	0	0	0	0