SET @org_id = 'clx00000000000000000000001';

INSERT INTO `organizations` (`id`, `name`, `slug`, `isActive`, `createdAt`, `updatedAt`)
VALUES (
  @org_id,
  'Lusoloc',
  'lusoloc',
  true,
  NOW(),
  NOW()
)
ON DUPLICATE KEY UPDATE `name` = 'Lusoloc';

UPDATE `utilizadores` 
SET `organizationId` = @org_id 
WHERE `organizationId` IS NULL;

UPDATE `equipamentos` 
SET `organizationId` = @org_id 
WHERE `organizationId` IS NULL;

UPDATE `documentos` d
INNER JOIN `equipamentos` e ON d.`equipamentoId` = e.`id`
SET d.`organizationId` = e.`organizationId`
WHERE d.`organizationId` IS NULL;

UPDATE `eventos` ev
INNER JOIN `equipamentos` e ON ev.`equipamentoId` = e.`id`
SET ev.`organizationId` = e.`organizationId`
WHERE ev.`organizationId` IS NULL;

UPDATE `auditoria` a
INNER JOIN `utilizadores` u ON a.`userId` = u.`id`
SET a.`organizationId` = u.`organizationId`
WHERE a.`organizationId` IS NULL;

INSERT INTO `user_modules` (`id`, `userId`, `moduleName`, `createdAt`)
SELECT 
  CONCAT('um_', u.`id`, '_equipamentos') as `id`,
  u.`id` as `userId`,
  'equipamentos' as `moduleName`,
  NOW() as `createdAt`
FROM `utilizadores` u
WHERE u.`role` = 'EDITOR'
ON DUPLICATE KEY UPDATE `moduleName` = 'equipamentos';