Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 3444 Rev 3448
Line 91... Line 91...
91 
	private function migrerObsEtendusChampsUtilisateur() {
 91 
	private function migrerObsEtendusChampsUtilisateur() {
92 
	    $requete = "ALTER TABLE ".$this->bd_new_cel.".`user_custom_field` ADD `field_id` VARCHAR(500) NOT NULL AFTER `default_value`;";
 92 
	    $requete = "ALTER TABLE ".$this->bd_new_cel.".`user_custom_field` ADD `field_id` VARCHAR(500) NOT NULL AFTER `default_value`;";
93 
	    $this->bdd->requeter($requete);
 93 
	    $this->bdd->requeter($requete);
94 
	    $requete = "INSERT INTO ".$this->bd_new_cel.".`user_custom_field`
 94 
	    $requete = "INSERT INTO ".$this->bd_new_cel.".`user_custom_field`
95 
	        (name, data_type, default_value, field_id)
 95 
	        (name, data_type, default_value, field_id)
96 
	        SELECT label, 'text', '', cle
 96 
	        SELECT label, 'Texte', '', cle
97 
	        FROM ".$this->bd_cel.".`cel_catalogue_champs_etendus`
97 
	        FROM ".$this->bd_cel.".`cel_catalogue_champs_etendus`
98 
	        WHERE `cle` not in (SELECT `champ` FROM ".$this->bd_cel.".`cel_catalogue_champs_etendus_liaison`)";
 98 
	        WHERE `cle` not in (SELECT `champ` FROM ".$this->bd_cel.".`cel_catalogue_champs_etendus_liaison`)";
99 
	    $this->bdd->requeter($requete);
 99 
	    $this->bdd->requeter($requete);
100 
	}
 100 
	}