/[openfoncier]/trunk/data/pgsql/v3.1.0-b1.sql
ViewVC logotype

Diff of /trunk/data/pgsql/v3.1.0-b1.sql

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

revision 418 by nhaye, Fri Sep 21 14:50:52 2012 UTC revision 443 by nhaye, Tue Sep 25 15:36:24 2012 UTC
# Line 80  ALTER TABLE avis ALTER libelle DROP DEFA Line 80  ALTER TABLE avis ALTER libelle DROP DEFA
80  ALTER TABLE bible ALTER libelle DROP DEFAULT;  ALTER TABLE bible ALTER libelle DROP DEFAULT;
81  ALTER TABLE bible ALTER contenu SET NOT NULL;  ALTER TABLE bible ALTER contenu SET NOT NULL;
82  ALTER TABLE evenement ALTER libelle DROP DEFAULT;  ALTER TABLE evenement ALTER libelle DROP DEFAULT;
 ALTER TABLE evenement RENAME consultation TO pour_consultation;  
83  ALTER TABLE etat ALTER libelle DROP DEFAULT;  ALTER TABLE etat ALTER libelle DROP DEFAULT;
84  ALTER TABLE transition ALTER etat SET NOT NULL;  ALTER TABLE transition ALTER etat SET NOT NULL;
85  ALTER TABLE transition ALTER action SET NOT NULL;  ALTER TABLE transition ALTER action SET NOT NULL;
# Line 94  ALTER TABLE travaux ALTER libelle DROP D Line 93  ALTER TABLE travaux ALTER libelle DROP D
93  ALTER TABLE service ALTER libelle DROP DEFAULT;  ALTER TABLE service ALTER libelle DROP DEFAULT;
94  ALTER TABLE architecte ALTER nom DROP DEFAULT;  ALTER TABLE architecte ALTER nom DROP DEFAULT;
95  ALTER TABLE architecte ALTER note DROP NOT NULL;  ALTER TABLE architecte ALTER note DROP NOT NULL;
96    ALTER TABLE proprietaire ALTER civilite DROP DEFAULT;
97    ALTER TABLE proprietaire ALTER proprietaire SET NOT NULL;
98    ALTER TABLE pos ALTER libelle DROP DEFAULT;
99    ALTER TABLE servitude_surfacique ALTER libelle SET NOT NULL;
100    ALTER TABLE servitude_ligne ALTER libelle SET NOT NULL;
101    ALTER TABLE servitude_point ALTER libelle SET NOT NULL;
102    ALTER TABLE parcelle_lot ALTER lotissement SET NOT NULL;
103    ALTER TABLE dossier ALTER date_depot SET NOT NULL;
104    
105    ALTER TABLE instruction ALTER complement DROP NOT NULL;
106    ALTER TABLE instruction ALTER complement2 DROP NOT NULL;
107    ALTER TABLE instruction ALTER evenement SET NOT NULL;
108    ALTER TABLE instruction ALTER datecourrier SET NOT NULL;
109    
110    ALTER TABLE consultation ALTER dossier SET NOT NULL;
111    ALTER TABLE consultation ALTER service SET NOT NULL;
112    ALTER TABLE consultation ALTER date_envoi SET NOT NULL;
113    
114    ALTER TABLE blocnote ALTER note SET NOT NULL;
115    ALTER TABLE blocnote ALTER categorie DROP DEFAULT;
116    
117    -- Ajout des contraintes de clés étrangères sur les tables métiers
118    
119    UPDATE evenement SET nature = NULL WHERE nature ='';
120    ALTER TABLE evenement ADD CONSTRAINT evenement_nature_fkey FOREIGN KEY (nature) REFERENCES nature (nature);
121    UPDATE evenement SET action = NULL WHERE action ='';
122    ALTER TABLE evenement ADD CONSTRAINT evenement_action_fkey FOREIGN KEY (action) REFERENCES action (action);
123    UPDATE evenement SET etat = NULL WHERE etat ='';
124    ALTER TABLE evenement ADD CONSTRAINT evenement_etat_fkey FOREIGN KEY (etat) REFERENCES etat (etat);
125    UPDATE evenement SET avis = NULL WHERE avis ='';
126    ALTER TABLE evenement ADD CONSTRAINT evenement_avis_fkey FOREIGN KEY (avis) REFERENCES avis (avis);
127    
128    ALTER TABLE bible ADD CONSTRAINT bible_nature_fkey FOREIGN KEY (nature) REFERENCES nature (nature);
129    
130    ALTER TABLE travaux ADD CONSTRAINT travaux_nature_fkey FOREIGN KEY (nature) REFERENCES nature (nature);
131    
132    ALTER TABLE proprietaire ADD CONSTRAINT proprietaire_pkey PRIMARY KEY (proprietaire);
133    ALTER TABLE proprietaire ADD CONSTRAINT proprietaire_civilite_fkey FOREIGN KEY (civilite) REFERENCES civilite (civilite);
134    
135    ALTER TABLE parcelle ALTER rivoli DROP DEFAULT;
136    ALTER TABLE parcelle ALTER rivoli DROP NOT NULL;
137    ALTER TABLE parcelle ADD CONSTRAINT parcelle_rivoli_fkey FOREIGN KEY (rivoli) REFERENCES rivoli (rivoli);
138    ALTER TABLE parcelle ADD CONSTRAINT parcelle_proprietaire_fkey FOREIGN KEY (proprietaire) REFERENCES proprietaire (proprietaire);
139    ALTER TABLE parcelle ADD CONSTRAINT parcelle_pos_fkey FOREIGN KEY (pos) REFERENCES pos (pos);
140    
141    ALTER TABLE ONLY om_widget
142        ADD CONSTRAINT om_widget_om_profil_fkey FOREIGN KEY (om_profil) REFERENCES om_profil(om_profil);
Legend:
Removed from v.418  
changed lines
  Added in v.443
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26