data/pgsql/v3.0.0-b5.sql


-- 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';

-- ajout de complement d'adresse pour le service
alter table service add adresse2 character varying(39);

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

-- 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	fraynaud	325
2			-- schema
3			-- SET search_path = openfoncier, pg_catalog;
4
5	atreal	316	-- complement travaux
6	atreal	310	alter table dossier add travaux_complement character varying(100);
7	atreal	316
8			-- mise à jour des civilites
9	atreal	310	insert into civilite(civilite) values ('M.');
10	atreal	309	insert into civilite(civilite) values ('Mlle');
11	atreal	316	update dossier set demandeur_civilite='M.' where demandeur_civilite='Mr';
12	atreal	309	update dossier set demandeur_civilite='Mlle' where demandeur_civilite='Melle';
13	atreal	310	update dossier set delegataire_civilite='M.' where delegataire_civilite='Mr';
14	atreal	309	update dossier set delegataire_civilite='Mlle' where delegataire_civilite='Melle';
15	atreal	310	update proprietaire set civilite='M.' where civilite = 'Mr';
16	atreal	309	update proprietaire set civilite='Mlle' where civilite = 'Melle';
17			delete from civilite where civilite='Mr';
18	atreal	316	delete from civilite where civilite='Melle';
19
20			-- ajout de complement d'adresse pour le service
21			alter table service add adresse2 character varying(39);
22
23			-- version
24			update om_version set om_version='3.0.0-b4';
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	atreal	318	-- table service
31			alter table service add adresse2 character varying(39) NOT NULL default '';