/[openfoncier]/trunk/data/pgsql/v3.0.0-b5.sql
ViewVC logotype

Diff of /trunk/data/pgsql/v3.0.0-b5.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

trunk/data/pgsql/v3.0.0-b4.sql revision 310 by atreal, Wed Mar 28 17:17:22 2012 UTC trunk/data/pgsql/v3.0.0-b5.sql revision 320 by atreal, Wed Mar 28 22:14:15 2012 UTC
# Line 1  Line 1 
1    -- complement travaux
2  alter table dossier add travaux_complement character varying(100);  alter table dossier add travaux_complement character varying(100);
3    
4    -- mise à jour des civilites
5  insert into civilite(civilite) values ('M.');  insert into civilite(civilite) values ('M.');
6  insert into civilite(civilite) values ('Mlle');  insert into civilite(civilite) values ('Mlle');
7  update dossier set demandeur_civilite='M' where demandeur_civilite='Mr';  update dossier set demandeur_civilite='M.' where demandeur_civilite='Mr';
8  update dossier set demandeur_civilite='Mlle' where demandeur_civilite='Melle';  update dossier set demandeur_civilite='Mlle' where demandeur_civilite='Melle';
9  update dossier set delegataire_civilite='M.' where delegataire_civilite='Mr';  update dossier set delegataire_civilite='M.' where delegataire_civilite='Mr';
10  update dossier set delegataire_civilite='Mlle' where delegataire_civilite='Melle';  update dossier set delegataire_civilite='Mlle' where delegataire_civilite='Melle';
11  update proprietaire set civilite='M.' where civilite = 'Mr';  update proprietaire set civilite='M.' where civilite = 'Mr';
12  update proprietaire set civilite='Mlle' where civilite = 'Melle';  update proprietaire set civilite='Mlle' where civilite = 'Melle';
13  delete from civilite where civilite='Mr';  delete from civilite where civilite='Mr';
 delete from civilite where civilite='Melle';  
14    delete from civilite where civilite='Melle';
15    
16    -- ajout de complement d'adresse pour le service
17    alter table service add adresse2 character varying(39);
18    
19    -- version
20    update om_version set om_version='3.0.0-b4';
21    
22    -- ajout de complement d'adresses dans le dossier
23    alter table dossier add demandeur_adresse_complement character varying(39) NOT NULL default '';
24    alter table dossier add delegataire_adresse_complement character varying(39) NOT NULL default '';
25    
26    -- table service
27    alter table service add adresse2 character varying(39) NOT NULL default '';
Legend:
Removed from v.310  
changed lines
  Added in v.320
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26