/[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 426 by nhaye, Fri Sep 21 16:30:55 2012 UTC revision 431 by nhaye, Mon Sep 24 16:29:46 2012 UTC
# Line 100  ALTER TABLE pos ALTER libelle DROP DEFAU Line 100  ALTER TABLE pos ALTER libelle DROP DEFAU
100  ALTER TABLE servitude_surfacique ALTER libelle SET NOT NULL;  ALTER TABLE servitude_surfacique ALTER libelle SET NOT NULL;
101  ALTER TABLE servitude_ligne ALTER libelle SET NOT NULL;  ALTER TABLE servitude_ligne ALTER libelle SET NOT NULL;
102  ALTER TABLE servitude_point ALTER libelle SET NOT NULL;  ALTER TABLE servitude_point ALTER libelle SET NOT NULL;
 ALTER TABLE parcelle_lot ALTER lotissement SET NOT NULL;  
103    ALTER TABLE parcelle_lot ALTER lotissement SET NOT NULL;
104    ALTER TABLE dossier ALTER date_depot SET NOT NULL;
105    
106    ALTER TABLE instruction ALTER complement DROP NOT NULL;
107    ALTER TABLE instruction ALTER complement2 DROP NOT NULL;
108    ALTER TABLE instruction ALTER evenement SET NOT NULL;
109    ALTER TABLE instruction ALTER datecourrier SET NOT NULL;
110    
111    ALTER TABLE consultation ALTER dossier SET NOT NULL;
112    ALTER TABLE consultation ALTER service SET NOT NULL;
113    ALTER TABLE consultation ALTER date_envoi SET NOT NULL;
114    
115    ALTER TABLE blocnote ALTER note SET NOT NULL;
116    ALTER TABLE blocnote ALTER categorie DROP DEFAULT;
Legend:
Removed from v.426  
changed lines
  Added in v.431
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26