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