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