Subversion Repositories eFlore/Applications.cel

Rev

Rev 3306 | Rev 3308 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3306 Rev 3307
Line 71... Line 71...
71 
	private function migrerObsEtendusChampsUtilisateur() {
 71 
	private function migrerObsEtendusChampsUtilisateur() {
72 
	    $requete = "ALTER TABLE `user_custom_field` ADD `field_id` VARCHAR(500) NOT NULL AFTER `default_value`;";
 72 
	    $requete = "ALTER TABLE `user_custom_field` ADD `field_id` VARCHAR(500) NOT NULL AFTER `default_value`;";
73 
	    $this->bdd->requeter($requete);
 73 
	    $this->bdd->requeter($requete);
74 
	    $requete = "INSERT INTO ".$this->base.".`user_custom_field`
 74 
	    $requete = "INSERT INTO ".$this->base.".`user_custom_field`
75 
	        (name, data_type, default_value, field_id)
 75 
	        (name, data_type, default_value, field_id)
76 
	        SELECT label, type, valeur, cle
 76 
	        SELECT label, '', valeur, cle
77 
	        FROM tb_nettoye_cel.`cel_catalogue_champs_etendus`
77 
	        FROM tb_nettoye_cel.`cel_catalogue_champs_etendus`
78 
	        WHERE `cle` not in (SELECT `champ` FROM `cel_catalogue_champs_etendus_liaison`)";
 78 
	        WHERE `cle` not in (SELECT `champ` FROM `cel_catalogue_champs_etendus_liaison`)";
79 
	    $this->bdd->requeter($requete);
 79 
	    $this->bdd->requeter($requete);
80 
	}
 80 
	}