/[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 432 by nhaye, Mon Sep 24 16:29:46 2012 UTC revision 433 by nhaye, Tue Sep 25 12:49:08 2012 UTC
# Line 80  ALTER TABLE avis ALTER libelle DROP DEFA Line 80  ALTER TABLE avis ALTER libelle DROP DEFA
80  ALTER TABLE bible ALTER libelle DROP DEFAULT;  ALTER TABLE bible ALTER libelle DROP DEFAULT;
81  ALTER TABLE bible ALTER contenu SET NOT NULL;  ALTER TABLE bible ALTER contenu SET NOT NULL;
82  ALTER TABLE evenement ALTER libelle DROP DEFAULT;  ALTER TABLE evenement ALTER libelle DROP DEFAULT;
 ALTER TABLE evenement RENAME consultation TO pour_consultation;  
83  ALTER TABLE etat ALTER libelle DROP DEFAULT;  ALTER TABLE etat ALTER libelle DROP DEFAULT;
84  ALTER TABLE transition ALTER etat SET NOT NULL;  ALTER TABLE transition ALTER etat SET NOT NULL;
85  ALTER TABLE transition ALTER action SET NOT NULL;  ALTER TABLE transition ALTER action SET NOT NULL;
# Line 113  ALTER TABLE consultation ALTER service S Line 112  ALTER TABLE consultation ALTER service S
112  ALTER TABLE consultation ALTER date_envoi SET NOT NULL;  ALTER TABLE consultation ALTER date_envoi SET NOT NULL;
113    
114  ALTER TABLE blocnote ALTER note SET NOT NULL;  ALTER TABLE blocnote ALTER note SET NOT NULL;
 ALTER TABLE blocnote ALTER categorie DROP DEFAULT;  
115    ALTER TABLE blocnote ALTER categorie DROP DEFAULT;
116    
117    -- Ajout des contraintes de clés étrangères sur les tables métiers
118    
119    UPDATE evenement SET nature = NULL WHERE nature ='';
120    ALTER TABLE evenement ADD CONSTRAINT evenement_nature_fkey FOREIGN KEY (nature) REFERENCES nature (nature);
121    UPDATE evenement SET action = NULL WHERE action ='';
122    ALTER TABLE evenement ADD CONSTRAINT evenement_action_fkey FOREIGN KEY (action) REFERENCES action (action);
123    UPDATE evenement SET etat = NULL WHERE etat ='';
124    ALTER TABLE evenement ADD CONSTRAINT evenement_etat_fkey FOREIGN KEY (etat) REFERENCES etat (etat);
125    UPDATE evenement SET avis = NULL WHERE avis ='';
126    ALTER TABLE evenement ADD CONSTRAINT evenement_avis_fkey FOREIGN KEY (avis) REFERENCES avis (avis);
Legend:
Removed from v.432  
changed lines
  Added in v.433
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26