update copixconfig set value_ccfg='GMAO V 1.4.1' where id_ccfg='default|titlePage';

-- Column: astreinte_active

ALTER TABLE personnes ADD COLUMN astreinte_active boolean;
ALTER TABLE personnes ALTER COLUMN astreinte_active SET STORAGE PLAIN;
ALTER TABLE personnes ALTER COLUMN astreinte_active SET DEFAULT false;

update personnes set astreinte_active=false where astreinte_active is null;

-- Column: ast_heure_debut

ALTER TABLE personnes ADD COLUMN ast_heure_debut character varying(02);
ALTER TABLE personnes ALTER COLUMN ast_heure_debut SET STORAGE PLAIN;
ALTER TABLE personnes ALTER COLUMN ast_heure_debut SET DEFAULT '00';

update personnes set ast_heure_debut='00' where ast_heure_debut is null;

-- Column: ast_min_debut


ALTER TABLE personnes ADD COLUMN ast_min_debut character varying(02);
ALTER TABLE personnes ALTER COLUMN ast_min_debut SET STORAGE PLAIN;
ALTER TABLE personnes ALTER COLUMN ast_min_debut SET DEFAULT '00';

update personnes set ast_min_debut='00' where ast_min_debut is null;

-- Column: ast_heure_fin

ALTER TABLE personnes ADD COLUMN ast_heure_fin character varying(02);
ALTER TABLE personnes ALTER COLUMN ast_heure_fin SET STORAGE PLAIN;
ALTER TABLE personnes ALTER COLUMN ast_heure_fin SET DEFAULT '00';

update personnes set ast_heure_fin='00' where ast_heure_fin is null;


-- Column: ast_min_fin

ALTER TABLE personnes ADD COLUMN ast_min_fin character varying(02);
ALTER TABLE personnes ALTER COLUMN ast_min_fin SET STORAGE PLAIN;
ALTER TABLE personnes ALTER COLUMN ast_min_fin SET DEFAULT '00';

update personnes set ast_min_fin='00' where ast_min_fin is null;

INSERT INTO copixconfig(
            id_ccfg, module_ccfg, value_ccfg)
    VALUES ('default|url', 'default|', 'http://81.93.2.8/TEST');