/[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 433 by nhaye, Tue Sep 25 12:49:08 2012 UTC revision 448 by nhaye, Wed Sep 26 08:12:22 2012 UTC
# Line 124  UPDATE evenement SET etat = NULL WHERE e Line 124  UPDATE evenement SET etat = NULL WHERE e
124  ALTER TABLE evenement ADD CONSTRAINT evenement_etat_fkey FOREIGN KEY (etat) REFERENCES etat (etat);  ALTER TABLE evenement ADD CONSTRAINT evenement_etat_fkey FOREIGN KEY (etat) REFERENCES etat (etat);
125  UPDATE evenement SET avis = NULL WHERE avis ='';  UPDATE evenement SET avis = NULL WHERE avis ='';
126  ALTER TABLE evenement ADD CONSTRAINT evenement_avis_fkey FOREIGN KEY (avis) REFERENCES avis (avis);  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);
143    
144    ALTER TABLE dossier ALTER rivoli DROP DEFAULT;
145    ALTER TABLE dossier ALTER rivoli DROP NOT NULL;
146    ALTER TABLE dossier ALTER pos DROP DEFAULT;
147    ALTER TABLE dossier ALTER pos DROP NOT NULL;
148    ALTER TABLE dossier ALTER parcelle DROP DEFAULT;
149    ALTER TABLE dossier ALTER parcelle DROP NOT NULL;
150    ALTER TABLE dossier ALTER delai DROP NOT NULL;
151    ALTER TABLE dossier ADD CONSTRAINT dossier_rivoli_fkey FOREIGN KEY (rivoli) REFERENCES rivoli (rivoli);
152    ALTER TABLE dossier ADD CONSTRAINT dossier_pos_fkey FOREIGN KEY (pos) REFERENCES pos (pos);
153    ALTER TABLE dossier ADD CONSTRAINT dossier_parcelle_lot_fkey FOREIGN KEY (parcelle_lot) REFERENCES parcelle_lot (parcelle_lot);
154    ALTER TABLE dossier ADD CONSTRAINT dossier_parcelle_fkey FOREIGN KEY (parcelle) REFERENCES parcelle (parcelle);
155    
156    ALTER TABLE instruction ADD CONSTRAINT instruction_action_fkey FOREIGN KEY (action) REFERENCES action (action);
157    ALTER TABLE instruction ADD CONSTRAINT instruction_etat_fkey FOREIGN KEY (etat) REFERENCES etat (etat);
158    ALTER TABLE instruction ADD CONSTRAINT instruction_avis_fkey FOREIGN KEY (avis) REFERENCES avis (avis);
159    
160    ALTER TABLE terrain ADD CONSTRAINT terrain_parcelle_fkey FOREIGN KEY (parcelle) REFERENCES parcelle (parcelle);
Legend:
Removed from v.433  
changed lines
  Added in v.448
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26