LeakDatabase.cpp File Reference

Go to the source code of this file.

Variables
static const char *	SCHEMA_SQL

Variable Documentation

SCHEMA_SQL

const char* SCHEMA_SQL

static

Initial value:

                             = R"SQL(
CREATE TABLE IF NOT EXISTS identity (
    email_hash TEXT PRIMARY KEY,
    first_seen INTEGER DEFAULT (strftime('%s','now'))
);
 
CREATE TABLE IF NOT EXISTS leak (
    email_hash TEXT NOT NULL,
    breach_name TEXT NOT NULL,
    breach_date TEXT NOT NULL,
    severity INTEGER NOT NULL,
    provider TEXT,
    description TEXT,
    PRIMARY KEY (email_hash, breach_name, breach_date)
);
)SQL"

Definition at line 29 of file LeakDatabase.cpp.

Referenced by LeakDatabase::initSchema().