Query
CREATE TABLE drills_library (
id INTEGER PRIMARY KEY AUTOINCREMENT,
trainer_id INTEGER NOT NULL REFERENCES trainers(id) ON DELETE CASCADE,
title TEXT NOT NULL,
description TEXT NOT NULL,
category TEXT,
difficulty TEXT,
goal TEXT,
keywords TEXT,
times_used INTEGER NOT NULL DEFAULT 0,
last_used_at TEXT,
created_at TEXT NOT NULL DEFAULT (datetime('now')),
updated_at TEXT NOT NULL DEFAULT (datetime('now')),
media_type TEXT,
media_ref TEXT,
sketch_svg TEXT
)