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