CREATE TABLE "services" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
trainer_id INTEGER NOT NULL REFERENCES trainers(id) ON DELETE CASCADE,
label TEXT NOT NULL,
duration_min INTEGER,
price_cents INTEGER NOT NULL DEFAULT 0,
unit TEXT NOT NULL DEFAULT 'Std',
category TEXT NOT NULL DEFAULT 'lesson'
CHECK(category IN ('lesson','video','other','card','trial')),
is_card_redemption INTEGER NOT NULL DEFAULT 0,
active INTEGER NOT NULL DEFAULT 1,
sort_order INTEGER NOT NULL DEFAULT 0,
created_at TEXT NOT NULL DEFAULT (datetime('now')),
updated_at TEXT NOT NULL DEFAULT (datetime('now')),
units INTEGER,
is_trial INTEGER NOT NULL DEFAULT 0
)