andersonchagas

I converted the sql statements to SQlite sintax and it is working now:

CREATE TABLE IF NOT EXISTS wp_redirection_items (
    id INTEGER PRIMARY KEY,
    url TEXT NOT NULL,
    match_url VARCHAR(2000),
    match_data TEXT,
    regex INTEGER NOT NULL DEFAULT 0,
    position INTEGER NOT NULL DEFAULT 0,
    last_count INTEGER NOT NULL DEFAULT 0,
    last_access TEXT NOT NULL DEFAULT '1970-01-01 00:00:00',
    group_id INTEGER NOT NULL DEFAULT 0,
    status TEXT NOT NULL DEFAULT 'enabled',
    action_type VARCHAR(20) NOT NULL,
    action_code INTEGER NOT NULL,
    action_data TEXT,
    match_type VARCHAR(20) NOT NULL,
    title TEXT,
    FOREIGN KEY (group_id) REFERENCES wp_redirection_groups(id)
);

CREATE TABLE IF NOT EXISTS wp_redirection_groups (
    id INTEGER PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    tracking INTEGER NOT NULL DEFAULT 1,
    module_id INTEGER NOT NULL DEFAULT 0,
    status TEXT NOT NULL DEFAULT 'enabled',
    position INTEGER NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS wp_redirection_logs (
    id INTEGER PRIMARY KEY,
    created TEXT NOT NULL,
    url TEXT NOT NULL,
    domain VARCHAR(255),
    sent_to TEXT,
    agent TEXT,
    referrer TEXT,
    http_code INTEGER NOT NULL DEFAULT 0,
    request_method VARCHAR(10),
    request_data TEXT,
    redirect_by VARCHAR(50),
    redirection_id INTEGER,
    ip VARCHAR(45),
    FOREIGN KEY (redirection_id) REFERENCES wp_redirection_items(id)
);

CREATE TABLE IF NOT EXISTS wp_redirection_404 (
    id INTEGER PRIMARY KEY,
    created TEXT NOT NULL,
    url TEXT NOT NULL,
    domain VARCHAR(255),
    agent VARCHAR(255),
    referrer VARCHAR(255),
    http_code INTEGER NOT NULL DEFAULT 0,
    request_method VARCHAR(10),
    request_data TEXT,
    ip VARCHAR(45)
);