essential_node_db_sql::createConstant 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)
);