/[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 458 by nhaye, Wed Sep 26 16:14:34 2012 UTC revision 460 by nhaye, Thu Sep 27 10:19:42 2012 UTC
# Line 148  ALTER TABLE dossier ALTER pos DROP DEFAU Line 148  ALTER TABLE dossier ALTER pos DROP DEFAU
148  ALTER TABLE dossier ALTER pos DROP NOT NULL;  ALTER TABLE dossier ALTER pos DROP NOT NULL;
149  ALTER TABLE dossier ALTER parcelle DROP DEFAULT;  ALTER TABLE dossier ALTER parcelle DROP DEFAULT;
150  ALTER TABLE dossier ALTER parcelle DROP NOT NULL;  ALTER TABLE dossier ALTER parcelle DROP NOT NULL;
 ALTER TABLE dossier ALTER delai DROP NOT NULL;  
151  ALTER TABLE dossier ADD CONSTRAINT dossier_rivoli_fkey FOREIGN KEY (rivoli) REFERENCES rivoli (rivoli);  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);  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);  ALTER TABLE dossier ADD CONSTRAINT dossier_parcelle_lot_fkey FOREIGN KEY (parcelle_lot) REFERENCES parcelle_lot (parcelle_lot);
Legend:
Removed from v.458  
changed lines
  Added in v.460
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26