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