[Sommaire] [Imprimer]

   1  <?php
   2      
   3  $allQueries = array(
   4      'ALTER TABLE '.T_ARCHIVES.' CHANGE `vis_period` `vis_period` LONGBLOB DEFAULT NULL ,
   5      CHANGE `vis_nb_vis` `vis_nb_vis` BLOB DEFAULT NULL ,
   6      CHANGE `vis_st` `vis_st` BLOB DEFAULT NULL ,
   7      CHANGE `vis_lt` `vis_lt` BLOB DEFAULT NULL ,
   8      CHANGE `pag_st` `pag_st` BLOB DEFAULT NULL ,
   9      CHANGE `pag_lt` `pag_lt` BLOB DEFAULT NULL ,
  10      CHANGE `vis_lth` `vis_lth` BLOB DEFAULT NULL ,
  11      CHANGE `vis_nb_pag` `vis_nb_pag` BLOB DEFAULT NULL ,
  12      CHANGE `vis_pag_grp` `vis_pag_grp` LONGBLOB DEFAULT NULL ,
  13      CHANGE `vis_country` `vis_country` BLOB DEFAULT NULL ,
  14      CHANGE `vis_continent` `vis_continent` BLOB DEFAULT NULL ,
  15      CHANGE `vis_provider` `vis_provider` LONGBLOB DEFAULT NULL ,
  16      CHANGE `vis_config` `vis_config` LONGBLOB DEFAULT NULL ,
  17      CHANGE `vis_os` `vis_os` BLOB DEFAULT NULL ,
  18      CHANGE `vis_browser` `vis_browser` BLOB DEFAULT NULL ,
  19      CHANGE `vis_browser_type` `vis_browser_type` BLOB DEFAULT NULL ,
  20      CHANGE `vis_resolution` `vis_resolution` LONGBLOB DEFAULT NULL ,
  21      CHANGE `vis_plugin` `vis_plugin` BLOB DEFAULT NULL ,
  22      CHANGE `vis_search_engine` `vis_search_engine` LONGBLOB DEFAULT NULL ,
  23      CHANGE `vis_keyword` `vis_keyword` LONGBLOB DEFAULT NULL ,
  24      CHANGE `vis_site` `vis_site` LONGBLOB DEFAULT NULL ,
  25      CHANGE `vis_partner` `vis_partner` LONGBLOB DEFAULT NULL ,
  26      CHANGE `vis_newsletter` `vis_newsletter` LONGBLOB DEFAULT NULL ,
  27      CHANGE `int_lt` `int_lt` BLOB DEFAULT NULL ,
  28      CHANGE `int_st` `int_st` BLOB DEFAULT NULL ,
  29      CHANGE `int_referer_type` `int_referer_type` LONGBLOB DEFAULT NULL ,
  30      CHANGE `int_search_engine` `int_search_engine` LONGBLOB DEFAULT NULL ,
  31      CHANGE `int_keyword` `int_keyword` LONGBLOB DEFAULT NULL ,
  32      CHANGE `int_site` `int_site` LONGBLOB DEFAULT NULL ,
  33      CHANGE `int_partner` `int_partner` LONGBLOB  DEFAULT NULL ,
  34      CHANGE `int_newsletter` `int_newsletter` LONGBLOB DEFAULT NULL ,
  35      CHANGE `int_country` `int_country` LONGBLOB DEFAULT NULL ,
  36      CHANGE `int_continent` `int_continent` LONGBLOB DEFAULT NULL ,
  37      CHANGE `int_config` `int_config` LONGBLOB DEFAULT NULL ,
  38      CHANGE `int_os` `int_os` LONGBLOB DEFAULT NULL ,
  39      CHANGE `int_browser` `int_browser` LONGBLOB DEFAULT NULL ,
  40      CHANGE `int_resolution` `int_resolution` LONGBLOB DEFAULT NULL ',
  41  'ALTER TABLE '.T_CATEGORY.' CHANGE `name` `name` VARCHAR( 100 ) '
  42  );
  43  
  44  foreach($allQueries as $query)
  45  {
  46      query($query);
  47  }    
  48      
  49      
  50  ?>