[Sommaire] [Imprimer]

   1  <?php
   2  
   3      // add file names table 
   4      // changement in visit because of newsletter bug
   5      // changed archive for strict mysql 5 compliant
   6      
   7  $allQueries = array(
   8  
   9  'DROP TABLE IF EXISTS '.T_A_FILE,
  10  "CREATE TABLE ".T_A_FILE." (
  11    id int(10) unsigned NOT NULL auto_increment,
  12    name text,
  13    PRIMARY KEY (id)
  14  ) TYPE=MyISAM
  15  ",
  16  "ALTER TABLE ".T_VISIT." DROP `browser`",
  17  "ALTER TABLE ".T_VISIT." ADD `entry_idpageurl` INT( 11 ) NOT NULL ",
  18      
  19  "    ALTER TABLE ".T_ARCHIVES." 
  20      CHANGE `vis_period` `vis_period` LONGTEXT NULL DEFAULT NULL ,
  21      CHANGE `vis_nb_vis` `vis_nb_vis` TEXT NULL ,
  22      CHANGE `vis_st` `vis_st` TEXT NULL ,
  23      CHANGE `vis_lt` `vis_lt` TEXT NULL ,
  24      CHANGE `pag_st` `pag_st` TEXT NULL ,
  25      CHANGE `pag_lt` `pag_lt` TEXT NULL ,
  26      CHANGE `vis_lth` `vis_lth` TEXT NULL ,
  27      CHANGE `vis_nb_pag` `vis_nb_pag` TEXT NULL ,
  28      CHANGE `vis_pag_grp` `vis_pag_grp` LONGTEXT NULL ,
  29      CHANGE `vis_country` `vis_country` TEXT NULL ,
  30      CHANGE `vis_continent` `vis_continent` TEXT NULL ,
  31      CHANGE `vis_provider` `vis_provider` LONGTEXT NULL ,
  32      CHANGE `vis_config` `vis_config` LONGTEXT NULL ,
  33      CHANGE `vis_os` `vis_os` TEXT NULL ,
  34      CHANGE `vis_browser` `vis_browser` TEXT NULL ,
  35      CHANGE `vis_browser_type` `vis_browser_type` TEXT NULL ,
  36      CHANGE `vis_resolution` `vis_resolution` LONGTEXT NULL ,
  37      CHANGE `vis_plugin` `vis_plugin` TEXT NULL ,
  38      CHANGE `vis_search_engine` `vis_search_engine` LONGTEXT NULL ,
  39      CHANGE `vis_keyword` `vis_keyword` LONGTEXT NULL ,
  40      CHANGE `vis_site` `vis_site` LONGTEXT NULL ,
  41      CHANGE `vis_partner` `vis_partner` LONGTEXT NULL ,
  42      CHANGE `vis_newsletter` `vis_newsletter` LONGTEXT NULL ,
  43      CHANGE `int_lt` `int_lt` TEXT NULL ,
  44      CHANGE `int_st` `int_st` TEXT NULL ,
  45      CHANGE `int_referer_type` `int_referer_type` LONGTEXT NULL ,
  46      CHANGE `int_search_engine` `int_search_engine` LONGTEXT NULL ,
  47      CHANGE `int_keyword` `int_keyword` LONGTEXT NULL ,
  48      CHANGE `int_site` `int_site` LONGTEXT NULL ,
  49      CHANGE `int_partner` `int_partner` LONGTEXT NULL ,
  50      CHANGE `int_newsletter` `int_newsletter` LONGTEXT NULL ,
  51      CHANGE `int_country` `int_country` LONGTEXT NULL ,
  52      CHANGE `int_continent` `int_continent` LONGTEXT NULL ,
  53      CHANGE `int_config` `int_config` LONGTEXT NULL ,
  54      CHANGE `int_os` `int_os` LONGTEXT NULL ,
  55      CHANGE `int_browser` `int_browser` LONGTEXT NULL ,
  56      CHANGE `int_resolution` `int_resolution` LONGTEXT NULL 
  57      "
  58      );
  59  foreach($allQueries as $query)
  60  {
  61      query($query);
  62  }    
  63      
  64      
  65  ?>