Skip to content

Update customers manager

Eve-Gwenaelle Bourhis requested to merge CAASCHR-2287 into master

Une fois les pods déployés, se connecter à la db et tapper la commande:

    update project p set zone_id = (select zp.zone_id from zone_projects zp where zp.projects_id = p.id);

Vérifier:

    select p.id, p.zone_id, zp.projects_id, zp.zone_id from project p, zone_projects zp where zp.projects_id = p.id;

Si OK:

    drop table zone_projects;

ensuite:

    update customer set active = true where active is null;
Edited by Eve-Gwenaelle Bourhis

Merge request reports

Loading