1*c3437056SNickeau-- Add the type (ie http or id) 2*c3437056SNickeaualter table REDIRECTIONS_LOG add column METHOD TEXT; 3*c3437056SNickeau 4*c3437056SNickeau-- Rename redirection to page rules 5*c3437056SNickeaucreate table PAGE_RULES_tmp 6*c3437056SNickeau( 7*c3437056SNickeau ID INTEGER PRIMARY KEY, 8*c3437056SNickeau MATCHER TEXT unique NOT NULL, -- the matcher pattern 9*c3437056SNickeau TARGET TEXT NOT NULL, -- the target 10*c3437056SNickeau PRIORITY INTEGER NOT NULL, -- the priority in which the match must be performed 11*c3437056SNickeau TIMESTAMP TIMESTAMP NOT NULL -- a update/create timestamp 12*c3437056SNickeau); 13*c3437056SNickeau 14*c3437056SNickeauinsert into PAGE_RULES_tmp(ID, MATCHER, TARGET, PRIORITY, TIMESTAMP) 15*c3437056SNickeauselect NULL, SOURCE, TARGET, 1, CREATION_TIMESTAMP 16*c3437056SNickeaufrom REDIRECTIONS; 17*c3437056SNickeaudrop table REDIRECTIONS; 18*c3437056SNickeaualter table PAGE_RULES_tmp rename to PAGE_RULES; 19*c3437056SNickeau 20*c3437056SNickeau 21