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
26841	Avoid remaking tables for altering index_together and unique_together in sqlite3	Akshesh Doshi	Akshesh Doshi	"Currently the `alter_index_together`/`alter_unique_together` methods of `SchemaEditor` drop and remake the whole table just to add/drop indexes but this doesn't seem to be required. The default methods defined in `base.schema` seem to do the job perfectly (in fact, more efficiently) to me.

I might be missing something here but no tests fail when I remove these methods from `sqlite3.schema`, so we are at least missing the tests to show why we might need to drop and re-create the whole table just to add an index (or a `unique_together` constraint).
"	Cleanup/optimization	closed	Database layer (models, ORM)	dev	Normal	fixed			Ready for checkin	1	0	0	0	0	0