-- 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';

-- Modificamos duración de los carnets a 10 años

UPDATE empr_categ SET duree_adhesion = '3650';

-- Habilitamos la modificación extendida de registros (libros) 

UPDATE  parametres SET  valeur_param =  '1' WHERE  parametres.sstype_param ='use_uniform_title' and parametres.type_param ='pmb';

-- Modificar codificacion tablas

ALTER TABLE  abts_abts DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  abts_abts_modeles DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  abts_grille_abt DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  abts_grille_modele DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  abts_modeles DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  abts_periodicites DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  actes DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  admin_session DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  analysis DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  audit DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  authors DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  avis DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  bannettes DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  bannette_abon DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  bannette_contenu DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  bannette_equation DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  bannette_exports DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  budgets DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  bulletins DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  caddie DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  caddie_content DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  caddie_procs DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  categories DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  classements DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  cms_modules_extensions_datas DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  collections DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  collections_state DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  comptes DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  connectors DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  connectors_sources DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  coordonnees DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  docsloc_section DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  docs_codestat DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  docs_location DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  docs_section DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  docs_statut DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  docs_type DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_caddie DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_caddie_content DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_caddie_procs DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_categ DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_codestat DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_custom DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_custom_lists DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_custom_values DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_groupe DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  empr_statut DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
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;
ALTER TABLE  etagere DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  etagere_caddie DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  exemplaires DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  exemplaires_temp DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  exercices DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  explnum DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  expl_custom DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  expl_custom_lists DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  expl_custom_values DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  frais DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  grilles DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  groupe DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  import_marc DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  indexint DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  lenders DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  liens_actes DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  lignes_actes DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  linked_mots DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  mots DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  noeuds DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices_categories DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices_custom DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices_custom_lists DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices_custom_values DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices_global_index DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices_langues DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices_mots_global_index DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notices_relations DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  notice_statut DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  offres_remises DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  opac_sessions DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  origine_notice DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  ouvertures DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  paiements DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  parametres DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  pclassement DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  pret DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  pret_archive DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  procs DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  publishers DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  quotas DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  quotas_finance DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  recouvrements DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  resa DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  resa_planning DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  resa_ranger DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  responsability DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  rss_content DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  rss_flux DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  rss_flux_content DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  rubriques DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  sauv_lieux DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  sauv_log DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  sauv_sauvegardes DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  sauv_tables DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  series DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  sessions DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  source_sync DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  sub_collections DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  suggestions DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  suggestions_categ DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  suggestions_origine DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  tags DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  thesaurus DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  transactions DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  tris DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  tva_achats DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  type_abts DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  type_comptes DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  types_produits DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  users DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  voir_aussi DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  z_attr DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  z_bib DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  z_notices DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE  z_query DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

