37,6 → 37,7 |
switch($cmd) { |
case 'tout' : |
$this->migrerObservations(); |
$this->migrerProjet(); |
$this->migrerObsEtendusChampsUtilisateur(); |
$this->migrerObsEtendusUtilisateur(); |
$this->migrerObsEtendusProjet(); |
50,6 → 51,9 |
case 'obs': |
$this->migrerObservations(); |
break; |
case 'projet': |
$this->migrerProjet(); |
break; |
case 'obs_etendus': |
$this->migrerObsEtendusChampsUtilisateur(); |
$this->migrerObsEtendusUtilisateur(); |
75,7 → 79,7 |
} |
|
private function migrerObservations() { |
$requete = "ALTER TABLE ".$this->bd_new_cel.".`occurrence` ADD project varchar(50);"; |
$requete = "ALTER TABLE ".$this->bd_new_cel.".`occurrence` ADD IF NOT EXISTS project varchar(50);"; |
$this->bdd->requeter($requete); |
|
$requete = "INSERT INTO ".$this->bd_new_cel.".`occurrence` |
89,7 → 93,7 |
} |
|
private function migrerObsEtendusChampsUtilisateur() { |
$requete = "ALTER TABLE ".$this->bd_new_cel.".`user_custom_field` ADD `field_id` VARCHAR(500) NOT NULL AFTER `default_value`;"; |
$requete = "ALTER TABLE ".$this->bd_new_cel.".`user_custom_field` ADD IF NOT EXISTS `field_id` VARCHAR(500) NOT NULL AFTER `default_value`;"; |
$this->bdd->requeter($requete); |
$requete = "INSERT INTO ".$this->bd_new_cel.".`user_custom_field` |
(name, data_type, default_value, field_id) |
120,6 → 124,18 |
$this->bdd->requeter($requete); |
} |
|
private function migrerProjet() { |
$requete = "INSERT INTO ".$this->bd_new_cel.".`project_settings` (`id`, `project_id`, `project`, `language`, `title`, `logo`, `description`, `type`, `is_type`, `css_style`, `image_font`, `date_created`, `date_updated`, `taxo_restriction_type`, `taxo_restriction_value`, `location_type`, `location`, `published_location`, `environments`, `project_tag_name`, `info`) |
SELECT * FROM ".$this->bd_cel.".`project_settings`"; |
$this->bdd->requeter($requete); |
$requete = "INSERT INTO ".$this->bd_new_cel.".`extended_field` (`id`, `project_id`, `field_id`, `project`, `data_type`, `is_visible`, `is_mandatory`, `min_value`, `max_value`, `regexp`, `unit`) |
SELECT * FROM ".$this->bd_cel.".`extended_field`"; |
$this->bdd->requeter($requete); |
$requete = "INSERT INTO ".$this->bd_new_cel.".`extendedfield_translation`(`id`, `extended_field_id`, `project`, `label`, `description`, `default_value`, `error_message`, `language_iso_code`, `help`) |
SELECT * FROM ".$this->bd_cel.".`extendedfield_translation`"; |
$this->bdd->requeter($requete); |
} |
|
private function migrerMotsClesObs() { |
$requete = "INSERT INTO ".$this->bd_new_cel.".user_occurrence_tag |
(id, user_id, name, path) |