1-- Event Queue table
2-- The id is the sqlite rowid
3CREATE TABLE EVENTS_QUEUE (
4  NAME                TEXT, -- Name
5  DATA                TEXT, -- JSON
6  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  METHOD       TEXT
17);
18
19create index if not exists REDIRECTIONS_LOG_TIMESTAMP ON REDIRECTIONS_LOG (TIMESTAMP DESC);
20
21