Changeset 1124
- Timestamp:
- Apr 7, 2016, 2:08:03 PM (5 years ago)
- Location:
- pmb4.2/trunk/fuentes/pmb
- Files:
-
- 1 added
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
pmb4.2/trunk/fuentes/pmb/admin/misc/alter.php
r1111 r1124 134 134 if ($version_pmb_bdd=="vLlxNemo"){ 135 135 include ("./alter_vLlxNemo.inc.php") ; 136 } 137 if ($version_pmb_bdd=="vLlxPandora"){ 138 include ("./alter_vLlxPandora.inc.php") ; 136 139 } 137 140 if ($version_pmb_bdd=="vLlxTrusty"){ -
pmb4.2/trunk/fuentes/pmb/admin/misc/alter_vLlxTrusty.inc.php
r1119 r1124 701 701 702 702 //break; 703 //case "v5.15": 703 704 echo "<table ><tr><th>".$msg['admin_misc_action']."</th><th>".$msg['admin_misc_resultat']."</th></tr>"; 704 705 // +-------------------------------------------------+ … … 2871 2872 2872 2873 // // Parcheamos la base de datos 2873 //require("$base_path/includes/db_param.inc.php");2874 //$comando= "cat ".$base_path."/admin/misc/mods_vLlxNemo.sql | mysql -u ". USER_NAME ." --password=". USER_PASS ." ". DATA_BASE;2875 //if (system($comando, $salida)==0){2876 //echo "$msg[db_patched]";2877 //}2878 //echo "<SCRIPT>alert(\"".$msg[actualizacion_ok]."\");</SCRIPT>";2874 require("$base_path/includes/db_param.inc.php"); 2875 $comando= "cat ".$base_path."/admin/misc/mods_vLlxNemo.sql | mysql -u ". USER_NAME ." --password=". USER_PASS ." ". DATA_BASE; 2876 if (system($comando, $salida)==0){ 2877 echo "$msg[db_patched]"; 2878 } 2879 echo "<SCRIPT>alert(\"".$msg[actualizacion_ok]."\");</SCRIPT>"; 2879 2880 //echo("<SCRIPT LANGUAGE='JavaScript'> window.location = \"$base_path/\"</SCRIPT>"); 2880 2881 break; -
pmb4.2/trunk/fuentes/pmb/admin/misc/mods_vLlxNemo.sql
r943 r1124 1 -- Modificar estructura tabla2 3 ALTER TABLE notices_mots_global_index CHANGE nbr_mot num_word INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';4 ALTER TABLE notices_mots_global_index DROP mot ,DROP lang ;5 ALTER TABLE notices_mots_global_index DROP PRIMARY KEY;6 ALTER TABLE notices_mots_global_index DROP INDEX i_id_mot;7 ALTER TABLE notices_mots_global_index ADD PRIMARY KEY ( id_notice , code_champ , code_ss_champ , num_word , position );8 ALTER TABLE notices_mots_global_index ADD INDEX i_id_mot ( num_word , id_notice );9 10 -- Habilitamos el módulo de cestas11 12 1 UPDATE parametres SET valeur_param=1 WHERE type_param='empr' AND sstype_param='show_caddie'; 13 2 … … 68 57 ALTER TABLE empty_words_calculs DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 69 58 ALTER TABLE entites DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 70 ALTER TABLE entrepots DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;71 59 ALTER TABLE equations DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 72 60 ALTER TABLE error_log DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; -
pmb4.2/trunk/fuentes/pmb/copia_seg_importa.php
r1119 r1124 86 86 break; 87 87 } 88 case 'v5.10':{ 89 //cambiamos la versión para que el proceso de actualización sea más rápido 90 $rqt = "update parametres set valeur_param='vLlxPandora' where type_param='pmb' and sstype_param='bdd_version' "; 91 $res = mysql_query($rqt, $dbh); 92 echo "<SCRIPT>alert(\"".$msg[close_session]." ".$msg[database_update]."\");</SCRIPT>"; 93 echo("<SCRIPT LANGUAGE='JavaScript'> window.alert($msg[close_session])</SCRIPT>"); 94 echo("<SCRIPT LANGUAGE='JavaScript'> window.location = \"$base_path/\"</SCRIPT>"); 95 break; 96 97 } 88 98 case 'v5.14':{ 89 99 //cambiamos la versión para que el proceso de actualización sea más rápido
Note: See TracChangeset
for help on using the changeset viewer.