Ignore:
Timestamp:
Apr 7, 2016, 2:08:03 PM (5 years ago)
Author:
jrpelegrina
Message:

Fix migration db from Pandora

File:
1 edited

Legend:

Unmodified
Added
Removed
  • pmb4.2/trunk/fuentes/pmb/admin/misc/mods_vLlxNemo.sql

    r943 r1124  
    1 -- Modificar estructura tabla
    2 
    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 cestas
    11 
    121UPDATE  parametres SET  valeur_param=1 WHERE  type_param='empr' AND sstype_param='show_caddie';
    132
     
    6857ALTER TABLE  empty_words_calculs DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
    6958ALTER TABLE  entites DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
    70 ALTER TABLE  entrepots DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
    7159ALTER TABLE  equations DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
    7260ALTER TABLE  error_log DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Note: See TracChangeset for help on using the changeset viewer.