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

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 308 - (hide annotations)
Wed Mar 28 14:26:18 2012 UTC (12 years, 10 months ago) by atreal
Original Path: trunk/data/pgsql/v3.0.0-b4.sql
File size: 369 byte(s)
remplacement de la civilité Mr par M

1 atreal 308 alter table dossier add objet_dossier_complement character varying(100);
2     insert into civilite(civilite) values ('M');
3     update dossier set demandeur_civilite='M' where demandeur_civilite='Mr';
4     update dossier set delegataire_civilite='M' where delegataire_civilite='Mr';
5     update proprietaire set civilite='M' where civilite = 'Mr';
6     delete from civilite where civilite='Mr';

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26