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

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

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

revision 1640 by nhaye, Wed Apr 10 16:49:22 2013 UTC revision 1641 by nhaye, Wed Apr 10 17:06:14 2013 UTC
# Line 47  ALTER TABLE dossier_autorisation ADD COL Line 47  ALTER TABLE dossier_autorisation ADD COL
47  ALTER TABLE ONLY dossier_autorisation  ALTER TABLE ONLY dossier_autorisation
48      ADD CONSTRAINT dossier_autorisation_avis_decision_fkey FOREIGN KEY (avis_decision) REFERENCES avis_decision(avis_decision);      ADD CONSTRAINT dossier_autorisation_avis_decision_fkey FOREIGN KEY (avis_decision) REFERENCES avis_decision(avis_decision);
49    
50  ALTER TABLE dossier_autorisation ADD COLUMN dernier_etat_dossier_autorisation_accepte integer;  ALTER TABLE dossier_autorisation ADD COLUMN etat_dernier_dossier_instruction_accepte integer;
51  ALTER TABLE ONLY dossier_autorisation  ALTER TABLE ONLY dossier_autorisation
     ADD CONSTRAINT dossier_autorisation_dernier_etat_dossier_autorisation_accepte_fkey  
     FOREIGN KEY (dernier_etat_dossier_autorisation_accepte) REFERENCES etat_dossier_autorisation(etat_dossier_autorisation);  
52        ADD CONSTRAINT dossier_autorisation_etat_dernier_dossier_instruction_accepte_fkey
53        FOREIGN KEY (etat_dernier_dossier_instruction_accepte) REFERENCES etat_dossier_autorisation(etat_dossier_autorisation);
Legend:
Removed from v.1640  
changed lines
  Added in v.1641
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26