1alter table PAGES add column REGION TEXT; 2update PAGES set REGION = COUNTRY; 3update pages set COUNTRY = null; 4 5ALTER TABLE PAGES_ALIAS RENAME TO DEPRECATED_PAGES_ALIAS; 6DROP INDEX PAGES_ALIAS_UK; 7CREATE INDEX DEPRECATED_PAGES_ALIAS_UK ON DEPRECATED_PAGES_ALIAS (ALIAS); 8 9 10CREATE TABLE PAGE_ALIASES 11( 12 PAGE_ID TEXT, -- The page id 13 PATH TEXT -- The path value 14); 15 16CREATE UNIQUE INDEX PAGE_ALIAS_UK ON PAGE_ALIASES (PAGE_ID,PATH); 17