| 1 |
alter table dossier add objet_dossier_complement character varying(100); |
alter table dossier add objet_dossier_complement character varying(100); |
| 2 |
insert into civilite(civilite) values ('M'); |
insert into civilite(civilite) values ('M'); |
| 3 |
|
insert into civilite(civilite) values ('Mlle'); |
| 4 |
update dossier set demandeur_civilite='M' where demandeur_civilite='Mr'; |
update dossier set demandeur_civilite='M' where demandeur_civilite='Mr'; |
| 5 |
|
update dossier set demandeur_civilite='Mlle' where demandeur_civilite='Melle'; |
| 6 |
update dossier set delegataire_civilite='M' where delegataire_civilite='Mr'; |
update dossier set delegataire_civilite='M' where delegataire_civilite='Mr'; |
| 7 |
|
update dossier set delegataire_civilite='Mlle' where delegataire_civilite='Melle'; |
| 8 |
update proprietaire set civilite='M' where civilite = 'Mr'; |
update proprietaire set civilite='M' where civilite = 'Mr'; |
|
delete from civilite where civilite='Mr'; |
|
| 9 |
|
update proprietaire set civilite='Mlle' where civilite = 'Melle'; |
| 10 |
|
delete from civilite where civilite='Mr'; |
| 11 |
|
delete from civilite where civilite='Melle'; |
Parent Directory
| 
Revision Log
| 
Patch