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