-- ====================================================================
-- AI Ad Autopilot module permissions (2026-09-25)
-- Run AFTER src/lib/db/create_table_ads.sql (the tables).
--   • ads:read        — see campaigns, ads, insights
--   • ads:create      — generate ads with AI / create ads by hand
--   • ads:approve     — approve (publish to Facebook) or reject ads
--   • ads:manage      — edit / pause / resume / archive ads, sync insights
--   • ads:settings    — Facebook connection, AI key, autopilot guardrails
--   • ads:competitors — competitor research (Ad Library search, saved ads)
-- Named `module:action` like every other permission in this project (the
-- spec's `ads.view` style was adapted to that convention).
-- All granted to super_admin. Plain statements only, safe to run more than once.
-- ====================================================================

SET NAMES utf8mb4;

INSERT IGNORE INTO `permissions` (`id`, `name`, `module`, `action`) VALUES
  (UUID(), 'ads:read', 'ads', 'read'),
  (UUID(), 'ads:create', 'ads', 'create'),
  (UUID(), 'ads:approve', 'ads', 'approve'),
  (UUID(), 'ads:manage', 'ads', 'manage'),
  (UUID(), 'ads:settings', 'ads', 'settings'),
  (UUID(), 'ads:competitors', 'ads', 'competitors');

INSERT IGNORE INTO `role_permissions` (`id`, `role_id`, `permission_id`)
SELECT UUID(), r.id, p.id
FROM `roles` r
JOIN `permissions` p ON p.name IN ('ads:read', 'ads:create', 'ads:approve', 'ads:manage', 'ads:settings', 'ads:competitors')
WHERE r.name = 'super_admin';
