|
-- Your SQL goes here
|
|
CREATE TABLE game_file (
|
|
id INTEGER PRIMARY KEY,
|
|
original_path BLOB NOT NULL, -- TEXT assumes a Unicode Encoding
|
|
file_hash INTEGER NOT NULL, -- u64, but that's not
|
|
game_save_id INTEGER NOT NULL,
|
|
FOREIGN KEY (game_save_id) REFERENCES game_save_location (id)
|
|
) |