/[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 437 by nhaye, Tue Sep 25 13:16:39 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    
Legend:
Removed from v.433  
changed lines
  Added in v.437
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26