[Sommaire] [Imprimer]

   1  <?php
   2  
   3      // add send_mail to users and adjust table varchar variables to 255
   4      
   5  $allQueries = array(
   6  "ALTER TABLE ".T_USERS."  ADD `send_mail` INT( 10 ) DEFAULT '0' NOT NULL AFTER `email`",
   7  "ALTER TABLE ".T_VARS." CHANGE `name` `name` VARCHAR( 255 ) NOT NULL, CHANGE `varchar_value` `varchar_value` VARCHAR( 255 ) DEFAULT NULL "
   8  );
   9  
  10  
  11  
  12  foreach($allQueries as $query)
  13  {
  14      query($query);
  15  }    
  16  ?>