-- 20260416_04_app_domain_slices.sql
-- Operational JSON slices (sites, tasks, CRM, templates, time logs). Loaded by API — no static client seeds.

CREATE TABLE IF NOT EXISTS app_domain_slices (
  slice_key VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  slice_json JSON NOT NULL,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (slice_key)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;