﻿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
32502	Replace SQLite schema table rebuild by ALTER functions when supported	Simon Charette	Mariusz Felisiak	"Per https://www.sqlite.org/lang_altertable.html

- `ALTER TABLE RENAME COLUMN` is [https://www.sqlite.org/search?s=c&q=RENAME+COLUMN supported since 3.25 but had issues with unique columns until 3.27]
- `ALTER TABLE ADD COLUMN` is [https://www.sqlite.org/search?s=c&q=ADD+COLUMN supported since 3.2.0] not sure why it wasn't used in the first place since 3.2 was released in 2005? (added in 2f73e5406d54cb8945e187eff302a3a3373350be)
- `ALTER TABLE DROP COLUMN` [https://www.sqlite.org/draft/releaselog/3_35_0.html will be supported by 3.35]

This will leave only `ALTER COLUMN` and `ADD/REMOVE CONSTRAINT` that must be emulated on SQLite 3.35+"	Cleanup/optimization	assigned	Migrations	master	Normal				Accepted	0	0	0	0	0	0
