Constant BLOCK_SOLUTION_SET
Source pub const BLOCK_SOLUTION_SET: &str = "CREATE TABLE IF NOT EXISTS block_solution_set (\n id INTEGER PRIMARY KEY,\n block_id INTEGER NOT NULL,\n solution_set_id INTEGER NOT NULL,\n solution_set_index INTEGER NOT NULL,\n FOREIGN KEY (block_id) REFERENCES block (id),\n FOREIGN KEY (solution_set_id) REFERENCES solution_set (id),\n UNIQUE(block_id, solution_set_id, solution_set_index)\n);\n";
Expand description
CREATE TABLE IF NOT EXISTS block_solution_set (
id INTEGER PRIMARY KEY,
block_id INTEGER NOT NULL,
solution_set_id INTEGER NOT NULL,
solution_set_index INTEGER NOT NULL,
FOREIGN KEY (block_id) REFERENCES block (id),
FOREIGN KEY (solution_set_id) REFERENCES solution_set (id),
UNIQUE(block_id, solution_set_id, solution_set_index)
);