alter table PAGES add column PAGE_ID_ABBR TEXT; CREATE INDEX PAGES_PAGE_ID_ABBR_UK ON PAGES (PAGE_ID_ABBR); DROP INDEX PAGES_UK;