Schema

Callboot uses a SQLite3 database to manage call logs, whitelist and blacklists. We use the script below to create the database on a freshly installed device.

ATTACH DATABASE 'callboot.db' AS 'callboot';

-- #####################################################

CREATE TABLE IF NOT EXISTS callboot.whitelist
(
        wl_id INTEGER PRIMARY KEY AUTOINCREMENT,
        wl_name VARCHAR,
        wl_number INTEGER,
        wl_date DATETIME
);

CREATE INDEX IF NOT EXISTS callboot.wl_index ON whitelist(wl_number);

-- #####################################################

CREATE TABLE IF NOT EXISTS callboot.blacklist_lcl
(
        bl_id INTEGER PRIMARY KEY AUTOINCREMENT,
        bl_name VARCHAR,
        bl_number INTEGER,
        bl_date DATETIME
);

CREATE INDEX IF NOT EXISTS callboot.bl_lcl_index ON blacklist_lcl(bl_number);

-- #####################################################

CREATE TABLE IF NOT EXISTS callboot.blacklist_ftc
(
        bl_id INTEGER PRIMARY KEY AUTOINCREMENT,
        bl_name VARCHAR,
        bl_number INTEGER,
        bl_date DATETIME
);

CREATE INDEX IF NOT EXISTS callboot.bl_ftc_index ON blacklist_ftc(bl_number);

-- #####################################################

CREATE TABLE IF NOT EXISTS callboot.call_log
(
        cl_id INTEGER PRIMARY KEY AUTOINCREMENT,
        cl_name VARCHAR,
        cl_number VARCHAR,
        cl_date DATETIME,
        cl_wht BOOLEAN DEFAULT 0,     -- whitelist table
        cl_ftc BOOLEAN DEFAULT 0,     -- dist blacklist table
        cl_lcl BOOLEAN DEFAULT 0,     -- user blacklist table
        cl_loc BOOLEAN DEFAULT 0,     -- call localization
        cl_term BOOLEAN DEFAULT 0,    -- call terminated
        cl_rpt_trc BOOLEAN DEFAULT 0, -- carrier trace
        cl_rpt_fcc BOOLEAN DEFAULT 0, -- FCC report
        cl_rpt_ftc BOOLEAN DEFAULT 0  -- FTC report
);

-- #####################################################

CREATE TABLE IF NOT EXISTS callboot.imported
(
        imp_id INTEGER PRIMARY KEY AUTOINCREMENT,
        imp_fname VARCHAR,
        CONSTRAINT unique_fname UNIQUE (imp_fname)
);