-- Grant remaining permissions to Super Admin (role_id = 1)

INSERT INTO `role_permissions` (`role_id`, `resource`, `action`) VALUES
  -- Assets
  (1, 'asset', 'create'),
  (1, 'asset', 'read'),
  (1, 'asset', 'update'),
  (1, 'asset', 'delete'),
  -- Categories
  (1, 'category', 'create'),
  (1, 'category', 'read'),
  (1, 'category', 'update'),
  (1, 'category', 'delete'),
  -- Locations
  (1, 'location', 'create'),
  (1, 'location', 'read'),
  (1, 'location', 'update'),
  (1, 'location', 'delete'),
  -- Users
  (1, 'user', 'create'),
  (1, 'user', 'read'),
  (1, 'user', 'update'),
  (1, 'user', 'delete')
ON DUPLICATE KEY UPDATE `role_id` = `role_id`; -- Do nothing if the permission already exists