essential_node_db_sql::create

Constant CONTRACT_PREDICATE

source 
pub const CONTRACT_PREDICATE: &str = "CREATE TABLE IF NOT EXISTS contract_predicate (\n    id INTEGER PRIMARY KEY,\n    contract_id INTEGER NOT NULL,\n    predicate_id INTEGER NOT NULL,\n    FOREIGN KEY (contract_id) REFERENCES contract (id),\n    FOREIGN KEY (predicate_id) REFERENCES predicate (id),\n    UNIQUE(contract_id, predicate_id)\n);\n";
Expand description
CREATE TABLE IF NOT EXISTS contract_predicate (
    id INTEGER PRIMARY KEY,
    contract_id INTEGER NOT NULL,
    predicate_id INTEGER NOT NULL,
    FOREIGN KEY (contract_id) REFERENCES contract (id),
    FOREIGN KEY (predicate_id) REFERENCES predicate (id),
    UNIQUE(contract_id, predicate_id)
);