1alter table PAGE_ALIASES add column TYPE text; -- the type ie redirection or synonym 2CREATE UNIQUE INDEX PAGE_ALIAS_TYPE ON PAGE_ALIASES (TYPE); 3 4create view IF NOT EXISTS PAGE_ALIASES_VW as 5select 6 p.path as page_path, 7 pa.path as alias_path, 8 pa.type as alias_type 9from 10 page_aliases pa 11 inner join pages p on pa.page_id = p.page_id; 12