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