﻿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
29868	Database constraint checks are not retained on sqlite	Scott Stevens	Simon Charette	"This refers to feature #11964, where I initially asked about this.

It appears that adding multiple database constraints to a table results in only the last being stored.

Reviewing the SQL (`./manage.py sqlmigrate`), I'm seeing each constraint being added by way of `ALTER TABLE` (rename), `CREATE TABLE`, `INSERT INTO ... SELECT`, `DROP TABLE`, however only the most recent constraint is added each time, so the previous constraint is dropped with the old table when adding the new one.

Using 38f3de86bd0bfa4c9b57db1237fa55e9fa88bc6e, Python 3.6.6 (Win10x64) with SQLite database."	Bug	closed	Database layer (models, ORM)	dev	Release blocker	fixed	check constraint sqlite		Ready for checkin	1	0	0	0	0	0
