1*c3437056SNickeau-- Redirection from a page id to a target page id 2*c3437056SNickeau-- saved by the user in the admin page 3*c3437056SNickeauCREATE TABLE REDIRECTIONS ( 4*c3437056SNickeau SOURCE TEXT CONSTRAINT REDIRECTION_PK PRIMARY KEY, -- Source page id 5*c3437056SNickeau TARGET TEXT, -- Target Page id, 6*c3437056SNickeau CREATION_TIMESTAMP TIMESTAMP -- Timestamp creation 7*c3437056SNickeau); 8*c3437056SNickeau 9*c3437056SNickeau-- Log of the redirections 10*c3437056SNickeauCREATE TABLE REDIRECTIONS_LOG ( 11*c3437056SNickeau TIMESTAMP TIMESTAMP, 12*c3437056SNickeau SOURCE TEXT, 13*c3437056SNickeau TARGET TEXT, 14*c3437056SNickeau TYPE TEXT, -- which algorithm or manual entry 15*c3437056SNickeau REFERRER TEXT 16*c3437056SNickeau); 17*c3437056SNickeau 18*c3437056SNickeau 19*c3437056SNickeau-- Table redirection cache 20*c3437056SNickeau-- This table can be make empty 21*c3437056SNickeau-- NOT yet implemented. 22*c3437056SNickeau-- Was kept to show that that the type of redirections is needed 23*c3437056SNickeau-- as it seems that the engine goes two times through the php page (bug ??) 24*c3437056SNickeau-- 25*c3437056SNickeau-- CREATE TABLE REDIRECTION_CACHE ( 26*c3437056SNickeau-- SOURCE TEXT CONSTRAINT REDIRECTION_PK PRIMARY KEY, -- Source page id 27*c3437056SNickeau-- TARGET TEXT, -- target page id 28*c3437056SNickeau-- TYPE TEXT -- The algo 29*c3437056SNickeau-- ); 30*c3437056SNickeau 31*c3437056SNickeau 32*c3437056SNickeau 33*c3437056SNickeau 34