CREATE TABLE dogs ( id INTEGER PRIMARY KEY AUTOINCREMENT, first_seen TEXT, last_seen TEXT, visit_count INTEGER DEFAULT 1, breed_guess TEXT, breed_confidence TEXT, reference_crop TEXT, clip_embedding BLOB , coat_color TEXT, nickname TEXT, status TEXT DEFAULT 'loose', hero_locked INTEGER DEFAULT 0); CREATE TABLE sqlite_sequence(name,seq); CREATE TABLE processed ( filename TEXT PRIMARY KEY, processed_at TEXT, matched_dog_id INTEGER , hidden INTEGER DEFAULT 0); CREATE TABLE triage_queue ( id INTEGER PRIMARY KEY AUTOINCREMENT, new_crop TEXT, new_dog_id INTEGER, known_dog_id INTEGER, ref_crop TEXT, clip_sim REAL, created_at TEXT, resolved INTEGER DEFAULT 0 ); CREATE TABLE crop_directions ( filename TEXT PRIMARY KEY, direction TEXT , direction_confidence TEXT); CREATE TABLE picker_queue ( id INTEGER PRIMARY KEY AUTOINCREMENT, new_crop TEXT, new_dog_id INTEGER, known_dog_id INTEGER, ref_crop TEXT, clip_sim REAL, created_at TEXT, resolved INTEGER DEFAULT 0 ); CREATE TABLE direction_reviewed ( filename TEXT PRIMARY KEY, reviewed_at TEXT ); CREATE TABLE ingest_log ( filename TEXT PRIMARY KEY, action TEXT, reason TEXT, hero TEXT, at TEXT); CREATE TABLE crop_emb ( filename TEXT PRIMARY KEY, emb BLOB); CREATE TABLE match_log ( filename TEXT PRIMARY KEY, at TEXT, decision TEXT, dog_id INTEGER, suggested_dog_id INTEGER, sim REAL, vision_same INTEGER, vision_conf TEXT, vision_why TEXT, reviewed INTEGER DEFAULT 0);