| Line 310... |
Line 310... |
| 310 |
(select distinct ce_utilisateur from ".$this->bd_cel.".cel_obs) or
|
310 |
(select distinct ce_utilisateur from ".$this->bd_cel.".cel_obs) or
|
| 311 |
id_utilisateur in (SELECT distinct courriel_utilisateur FROM ".$this->bd_cel.".cel_obs))";
|
311 |
id_utilisateur in (SELECT distinct courriel_utilisateur FROM ".$this->bd_cel.".cel_obs))";
|
| 312 |
$this->bdd->requeter($requete_create);
|
312 |
$this->bdd->requeter($requete_create);
|
| 313 |
$requete_index = "ALTER TABLE ".$this->bd_cel.".`user_mot_cle_absent` ADD PRIMARY KEY(`id_utilisateur`);";
|
313 |
$requete_index = "ALTER TABLE ".$this->bd_cel.".`user_mot_cle_absent` ADD PRIMARY KEY(`id_utilisateur`);";
|
| 314 |
$this->bdd->requeter($requete_index);
|
314 |
$this->bdd->requeter($requete_index);
|
| 315 |
$requete_anonyme = "DELETE FROM ".$this->bd_cel.".`cel_arbre_mots_cles_obs` WHERE `id_utilisateur` in (SELECT * FROM `user_mot_cle_absent`);";
|
315 |
$requete_anonyme = "DELETE FROM ".$this->bd_cel.".`cel_arbre_mots_cles_obs` WHERE `id_utilisateur` in (SELECT * FROM ".$this->bd_cel.".`user_mot_cle_absent`);";
|
| 316 |
$this->bdd->requeter($requete_anonyme);
|
316 |
$this->bdd->requeter($requete_anonyme);
|
| 317 |
$requete_anonyme = "DROP TABLE ".$this->bd_cel.".user_mot_cle_absent;";
|
317 |
$requete_anonyme = "DROP TABLE ".$this->bd_cel.".user_mot_cle_absent;";
|
| 318 |
$this->bdd->requeter($requete_anonyme);
|
318 |
$this->bdd->requeter($requete_anonyme);
|
| 319 |
$requete_anonyme = "UPDATE ".$this->bd_cel.".`cel_arbre_mots_cles_obs` a join ".$this->bd_cel.".cel_obs b on a.`id_utilisateur` = b.courriel_utilisateur SET a.`id_utilisateur` = b.ce_utilisateur
|
319 |
$requete_anonyme = "UPDATE ".$this->bd_cel.".`cel_arbre_mots_cles_obs` a join ".$this->bd_cel.".cel_obs b on a.`id_utilisateur` = b.courriel_utilisateur SET a.`id_utilisateur` = b.ce_utilisateur
|
| 320 |
WHERE b.ce_utilisateur IS NOT NULL AND b.ce_utilisateur != ''";
|
320 |
WHERE b.ce_utilisateur IS NOT NULL AND b.ce_utilisateur != ''";
|
| 321 |
$this->bdd->requeter($requete_anonyme);
|
321 |
$this->bdd->requeter($requete_anonyme);
|
| 322 |
$requete_anonyme = "DELETE FROM ".$this->bd_cel.".`cel_mots_cles_obs_liaison` WHERE `id_element_lie` not in (SELECT `id_observation` FROM `cel_obs`) OR `id_mot_cle` NOT IN (SELECT `id_mot_cle` FROM `cel_arbre_mots_cles_obs`);";
|
322 |
$requete_anonyme = "DELETE FROM ".$this->bd_cel.".`cel_mots_cles_obs_liaison` WHERE `id_element_lie` not in (SELECT `id_observation` FROM ".$this->bd_cel.".`cel_obs`) OR `id_mot_cle` NOT IN (SELECT `id_mot_cle` FROM ".$this->bd_cel.".`cel_arbre_mots_cles_obs`);";
|
| 323 |
$this->bdd->requeter($requete_anonyme);
|
323 |
$this->bdd->requeter($requete_anonyme);
|
| 324 |
}
|
324 |
}
|
| Line 325... |
Line 325... |
| 325 |
|
325 |
|
| 326 |
private function unifierNomReferentiel() {
|
326 |
private function unifierNomReferentiel() {
|