
-- 2026-01-05 Add per-user module permissions and export toggles
ALTER TABLE ts_users
  ADD COLUMN can_dashboard TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN can_customers TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN can_users TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN can_reports TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN can_combined TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN can_sales TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN can_settings TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN can_backups TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN can_bulk_import TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN csv_export_enabled TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN pdf_export_enabled TINYINT(1) NOT NULL DEFAULT 1;
