/[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 402 by nhaye, Thu Sep 20 14:36:44 2012 UTC revision 429 by nhaye, Mon Sep 24 15:08:54 2012 UTC
# Line 78  ALTER TABLE om_lettretype ALTER actif DR Line 78  ALTER TABLE om_lettretype ALTER actif DR
78    
79  ALTER TABLE avis ALTER libelle DROP DEFAULT;  ALTER TABLE avis ALTER libelle DROP DEFAULT;
80  ALTER TABLE bible ALTER libelle DROP DEFAULT;  ALTER TABLE bible ALTER libelle DROP DEFAULT;
 ALTER TABLE bible ALTER contenu SET NOT NULL;  
81    ALTER TABLE bible ALTER contenu SET NOT NULL;
82    ALTER TABLE evenement ALTER libelle DROP DEFAULT;
83    ALTER TABLE evenement RENAME consultation TO pour_consultation;
84    ALTER TABLE etat ALTER libelle DROP DEFAULT;
85    ALTER TABLE transition ALTER etat SET NOT NULL;
86    ALTER TABLE transition ALTER action SET NOT NULL;
87    ALTER TABLE action ALTER libelle DROP DEFAULT;
88    ALTER TABLE parametre ALTER actif DROP NOT NULL;
89    ALTER TABLE rivoli ALTER libelle DROP DEFAULT;
90    ALTER TABLE nature ALTER libelle DROP DEFAULT;
91    ALTER TABLE destination ALTER libelle DROP DEFAULT;
92    ALTER TABLE categorie_demandeur ALTER libelle DROP DEFAULT;
93    ALTER TABLE travaux ALTER libelle DROP DEFAULT;
94    ALTER TABLE service ALTER libelle DROP DEFAULT;
95    ALTER TABLE architecte ALTER nom DROP DEFAULT;
96    ALTER TABLE architecte ALTER note DROP NOT NULL;
97    ALTER TABLE proprietaire ALTER civilite DROP DEFAULT;
98    ALTER TABLE proprietaire ALTER proprietaire SET NOT NULL;
99    ALTER TABLE pos ALTER libelle DROP DEFAULT;
100    ALTER TABLE servitude_surfacique ALTER libelle SET NOT NULL;
101    ALTER TABLE servitude_ligne ALTER libelle SET NOT NULL;
102    ALTER TABLE servitude_point ALTER libelle 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;
Legend:
Removed from v.402  
changed lines
  Added in v.429
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26