pub const SUBMISSION: &str = "CREATE TABLE IF NOT EXISTS submission (\n id INTEGER PRIMARY KEY,\n solution_set_id INTEGER NOT NULL,\n timestamp_secs INTEGER NOT NULL,\n timestamp_nanos INTEGER NOT NULL,\n FOREIGN KEY (solution_set_id) REFERENCES solution_set(id) ON DELETE CASCADE\n)\n";
Expand description
CREATE TABLE IF NOT EXISTS submission (
id INTEGER PRIMARY KEY,
solution_set_id INTEGER NOT NULL,
timestamp_secs INTEGER NOT NULL,
timestamp_nanos INTEGER NOT NULL,
FOREIGN KEY (solution_set_id) REFERENCES solution_set(id) ON DELETE CASCADE
)