data/pgsql/v3.0.0-b5.sql


-- version atreal - greasque

-- schema
-- SET search_path = openfoncier, pg_catalog;

-- complement travaux
alter table dossier add travaux_complement character varying(100);

-- mise à jour des civilites
insert into civilite(civilite) values ('M.');
insert into civilite(civilite) values ('Mlle');
update dossier set demandeur_civilite='M.' where demandeur_civilite='Mr';
update dossier set demandeur_civilite='Mlle' where demandeur_civilite='Melle';
update dossier set delegataire_civilite='M.' where delegataire_civilite='Mr';
update dossier set delegataire_civilite='Mlle' where delegataire_civilite='Melle';
update proprietaire set civilite='M.' where civilite = 'Mr';
update proprietaire set civilite='Mlle' where civilite = 'Melle';
delete from civilite where civilite='Mr';
delete from civilite where civilite='Melle';


-- version
update om_version set om_version='3.0.0-b5';

-- ajout de complement d'adresses dans le dossier
alter table dossier add demandeur_adresse_complement character varying(39) NOT NULL default '';
alter table dossier add delegataire_adresse_complement character varying(39) NOT NULL default '';

-- table service
alter table service add adresse2 character varying(39) NOT NULL default '';

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
23	-- version
24	update om_version set om_version='3.0.0-b5';
25
26	-- ajout de complement d'adresses dans le dossier
27	alter table dossier add demandeur_adresse_complement character varying(39) NOT NULL default '';
28	alter table dossier add delegataire_adresse_complement character varying(39) NOT NULL default '';
29
30	-- table service
31	alter table service add adresse2 character varying(39) NOT NULL default '';
32