essential_node_db_sql::create

Constant BLOCK_SOLUTION

source
pub const BLOCK_SOLUTION: &str = "CREATE TABLE IF NOT EXISTS block_solution (\n    id INTEGER PRIMARY KEY,\n    block_id INTEGER NOT NULL,\n    solution_id INTEGER NOT NULL,\n    solution_index INTEGER NOT NULL,\n    FOREIGN KEY (block_id) REFERENCES block (id),\n    FOREIGN KEY (solution_id) REFERENCES solution (id),\n    UNIQUE(block_id, solution_id, solution_index)\n);\n";
Expand description
CREATE TABLE IF NOT EXISTS block_solution (
    id INTEGER PRIMARY KEY,
    block_id INTEGER NOT NULL,
    solution_id INTEGER NOT NULL,
    solution_index INTEGER NOT NULL,
    FOREIGN KEY (block_id) REFERENCES block (id),
    FOREIGN KEY (solution_id) REFERENCES solution (id),
    UNIQUE(block_id, solution_id, solution_index)
);