/[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 448 by nhaye, Wed Sep 26 08:12:22 2012 UTC revision 463 by nhaye, Thu Sep 27 13:14:32 2012 UTC
# Line 21  INSERT INTO om_droit (om_droit, om_profi Line 21  INSERT INTO om_droit (om_droit, om_profi
21    
22  ('parametre', '4'),  ('parametre', '4'),
23  ('num_dossier', '4'),  ('num_dossier', '4'),
24    ('regle', '4'),
25    
26  ('edition_d', '2'),  ('edition_d', '2'),
27  ('edition', '2'),  ('edition', '2'),
# Line 147  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);
# Line 158  ALTER TABLE instruction ADD CONSTRAINT i Line 158  ALTER TABLE instruction ADD CONSTRAINT i
158  ALTER TABLE instruction ADD CONSTRAINT instruction_avis_fkey FOREIGN KEY (avis) REFERENCES avis (avis);  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);  ALTER TABLE terrain ADD CONSTRAINT terrain_parcelle_fkey FOREIGN KEY (parcelle) REFERENCES parcelle (parcelle);
161    
162    ALTER TABLE destination_shon ALTER destination SET NOT NULL;
163    
164    ALTER TABLE regle ALTER message DROP DEFAULT;
165    ALTER TABLE regle ALTER valeur DROP DEFAULT;
166    ALTER TABLE regle ALTER champ DROP DEFAULT;
167    ALTER TABLE regle ALTER operateur DROP DEFAULT;
168    ALTER TABLE regle ALTER sens  DROP DEFAULT;
169    ALTER TABLE regle ALTER ordre DROP DEFAULT;
170    
171    UPDATE om_etat SET logo = 'pixel.png' WHERE om_etat=4 OR om_etat=7;
Legend:
Removed from v.448  
changed lines
  Added in v.463
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26