-- migration des dates des actions (optionnel) pour la version 2.5
-- date debut = null
-- date fin = null
-- pour les actions en statut 3 et sans codemodif = 'mig dates actions' et oł datecrea est 'assez vieux'

Set client_encoding To Latin1;
Set DateStyle To European;

BEGIN;

UPDATE action SET
	debut = NULL,
	codemodif = 'mig dates actions 2'
WHERE ref_statut = 3
AND datecrea::date < '18/08/2006'::date
AND debut::date < '18/08/2006'::date
AND (codemodif != 'mig dates actions' OR codemodif IS NULL)
AND fin IS NULL;

END;