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