/[openfoncier]/trunk/data/pgsql/v3.3.0-fix.sql
ViewVC logotype

Diff of /trunk/data/pgsql/v3.3.0-fix.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1562 by nhaye, Tue Mar 26 16:25:30 2013 UTC revision 1563 by nhaye, Tue Mar 26 16:37:42 2013 UTC
# Line 1  Line 1 
1  -- Script suivant le ver_3.3.0-dev.sql  -- Script suivant le ver_3.3.0-dev.sql
2    
3    -- Suppression des champs co_finan* des tables cerfa et donnee_techniques
4    ALTER TABLE cerfa DROP COLUMN co_finan1_id;
5  ALTER TABLE cerfa DROP COLUMN co_finan1_nb;  ALTER TABLE cerfa DROP COLUMN co_finan1_nb;
6  ALTER TABLE cerfa DROP COLUMN co_finan2_id;  ALTER TABLE cerfa DROP COLUMN co_finan2_id;
7  ALTER TABLE cerfa DROP COLUMN co_finan2_nb;  ALTER TABLE cerfa DROP COLUMN co_finan2_nb;
# Line 10  ALTER TABLE cerfa DROP COLUMN co_finan4_ Line 12  ALTER TABLE cerfa DROP COLUMN co_finan4_
12  ALTER TABLE cerfa DROP COLUMN co_finan5_id;  ALTER TABLE cerfa DROP COLUMN co_finan5_id;
13  ALTER TABLE cerfa DROP COLUMN co_finan5_nb;  ALTER TABLE cerfa DROP COLUMN co_finan5_nb;
14    
15    ALTER TABLE donnees_techniques DROP COLUMN co_finan1_id;
16  ALTER TABLE donnees_techniques DROP COLUMN co_finan1_nb;  ALTER TABLE donnees_techniques DROP COLUMN co_finan1_nb;
17  ALTER TABLE donnees_techniques DROP COLUMN co_finan2_id;  ALTER TABLE donnees_techniques DROP COLUMN co_finan2_id;
18  ALTER TABLE donnees_techniques DROP COLUMN co_finan2_nb;  ALTER TABLE donnees_techniques DROP COLUMN co_finan2_nb;
# Line 20  ALTER TABLE donnees_techniques DROP COLU Line 23  ALTER TABLE donnees_techniques DROP COLU
23  ALTER TABLE donnees_techniques DROP COLUMN co_finan5_id;  ALTER TABLE donnees_techniques DROP COLUMN co_finan5_id;
24  ALTER TABLE donnees_techniques DROP COLUMN co_finan5_nb;  ALTER TABLE donnees_techniques DROP COLUMN co_finan5_nb;
25    
26    -- Mise à jour des contraintes de la table demande_type
27  UPDATE demande_type SET contraintes = '' WHERE code = 'DI';  UPDATE demande_type SET contraintes = '' WHERE code = 'DI';
28  UPDATE demande_type SET contraintes = 'sans_recup' WHERE code = 'DT';  UPDATE demande_type SET contraintes = 'sans_recup' WHERE code = 'DT';
29  UPDATE demande_type SET contraintes = 'avec_recup' WHERE code = 'DM';  UPDATE demande_type SET contraintes = 'avec_recup' WHERE code = 'DM';
30  UPDATE demande_type SET contraintes = 'sans_recup' WHERE code = 'DAACT';  UPDATE demande_type SET contraintes = 'sans_recup' WHERE code = 'DAACT';
31  UPDATE demande_type SET contraintes = 'sans_recup' WHERE code = 'DOC';  UPDATE demande_type SET contraintes = 'sans_recup' WHERE code = 'DOC';
32    
33    -- Modification de la table evenement
34    ALTER TABLE ONLY evenement ADD COLUMN evenement_retour_signature integer;
35    ALTER TABLE ONLY evenement
36        ADD CONSTRAINT evenement_evenement_retour_signature_fkey FOREIGN KEY (evenement_retour_signature) REFERENCES evenement(evenement);
Legend:
Removed from v.1562  
changed lines
  Added in v.1563
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26