Changeset 1124

Timestamp:

Apr 7, 2016, 2:08:03 PM (5 years ago)

Author:

jrpelegrina

Message:

Fix migration db from Pandora

Location:

pmb4.2/trunk/fuentes/pmb

Files:

• admin/misc/alter.php (modified) (1 diff)
• admin/misc/alter_vLlxPandora.inc.php (added)
• admin/misc/alter_vLlxTrusty.inc.php (modified) (2 diffs)
• admin/misc/mods_vLlxNemo.sql (modified) (2 diffs)
• copia_seg_importa.php (modified) (1 diff)

pmb4.2/trunk/fuentes/pmb/admin/misc/alter.php

@@ -134 +134 @@
             if ($version_pmb_bdd=="vLlxNemo"){  
                     include ("./alter_vLlxNemo.inc.php") ;
+                }
+                if ($version_pmb_bdd=="vLlxPandora"){   
+                    include ("./alter_vLlxPandora.inc.php") ;
             }   
                 if ($version_pmb_bdd=="vLlxTrusty"){    

pmb4.2/trunk/fuentes/pmb/admin/misc/alter_vLlxTrusty.inc.php

@@ -701 +701 @@
 
         //break;
+//case "v5.15":         
                 echo "<table ><tr><th>".$msg['admin_misc_action']."</th><th>".$msg['admin_misc_resultat']."</th></tr>";
                         // +-------------------------------------------------+
@@ -2871 +2872 @@
 
                 // // Parcheamos la base de datos
-                // require("$base_path/includes/db_param.inc.php");
-                // $comando= "cat ".$base_path."/admin/misc/mods_vLlxNemo.sql | mysql -u ". USER_NAME ." --password=". USER_PASS ." ". DATA_BASE;
-                // if (system($comando, $salida)==0){
-                //      echo "$msg[db_patched]";
-                // }
-                //echo "<SCRIPT>alert(\"".$msg[actualizacion_ok]."\");</SCRIPT>";
+                require("$base_path/includes/db_param.inc.php");
+                $comando= "cat ".$base_path."/admin/misc/mods_vLlxNemo.sql | mysql -u ". USER_NAME ." --password=". USER_PASS ." ". DATA_BASE;
+                if (system($comando, $salida)==0){
+                        echo "$msg[db_patched]";
+                }
+                echo "<SCRIPT>alert(\"".$msg[actualizacion_ok]."\");</SCRIPT>";
                 //echo("<SCRIPT LANGUAGE='JavaScript'> window.location = \"$base_path/\"</SCRIPT>");
                 break;

pmb4.2/trunk/fuentes/pmb/admin/misc/mods_vLlxNemo.sql

@@ -1 @@
--- Modificar estructura tabla
-
-ALTER TABLE  notices_mots_global_index CHANGE  nbr_mot  num_word INT( 10 ) UNSIGNED NOT NULL DEFAULT  '0';
-ALTER TABLE  notices_mots_global_index DROP  mot ,DROP  lang ;
-ALTER TABLE  notices_mots_global_index DROP PRIMARY KEY;
-ALTER TABLE  notices_mots_global_index DROP INDEX  i_id_mot;
-ALTER TABLE  notices_mots_global_index ADD PRIMARY KEY (  id_notice ,  code_champ ,  code_ss_champ ,  num_word ,  position );
-ALTER TABLE  notices_mots_global_index ADD INDEX  i_id_mot (  num_word ,  id_notice );
-
--- Habilitamos el módulo de cestas
-
 UPDATE  parametres SET  valeur_param=1 WHERE  type_param='empr' AND sstype_param='show_caddie';
 
@@ -68 +57 @@
 ALTER TABLE  empty_words_calculs DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
 ALTER TABLE  entites DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-ALTER TABLE  entrepots DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
 ALTER TABLE  equations DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
 ALTER TABLE  error_log DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

pmb4.2/trunk/fuentes/pmb/copia_seg_importa.php

@@ -86 +86 @@
                                 break;
                         }
+                        case 'v5.10':{
+                                //cambiamos la versión para que el proceso de actualización sea más rápido
+                                $rqt = "update parametres set valeur_param='vLlxPandora' where type_param='pmb' and sstype_param='bdd_version' ";
+                                $res = mysql_query($rqt, $dbh);
+                                echo "<SCRIPT>alert(\"".$msg[close_session]." ".$msg[database_update]."\");</SCRIPT>";
+                                echo("<SCRIPT LANGUAGE='JavaScript'> window.alert($msg[close_session])</SCRIPT>");
+                                echo("<SCRIPT LANGUAGE='JavaScript'> window.location = \"$base_path/\"</SCRIPT>");
+                                break;  
+
+                        }
                         case 'v5.14':{
                                 //cambiamos la versión para que el proceso de actualización sea más rápido