delete from bien_t ;
delete from prospect ;
delete from prospectbien ;
delete from portailagence ;
delete from bien_t ;
delete from photo_t ;
delete from log ;
delete from deleteprospectlog ;
delete from deletebienlog ;

delete from detailbien ;
delete from detailprospect ;
update sequences set nvaleur = 30000 ;
update agence set lgsm = null , ltel = null , lnomagence = null , ladr = null , llocalite = null ; 
update preference set cinternetsite = null , cinternetsiteactivimmo  = null ;
delete from utilisateur where lusername <> 'admin' ; 
update agence set cagence = 'yoohoo';
update preference set cagence = 'yoohoo';
update preference lintraneturl = null ;

update preference_t set lintraneturl = null ;
update agence set lintraneturl = null ;
update agence set lemail = null;

update agence set cagence = 'yoohoo';
update preference set cagence = 'yoohoo';