Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 3456 → Rev 3457

/trunk/scripts/modules/migrat2019/Migrat2019.php
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)