[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo "<p>Making user preferences field bigger...";
   4  
   5  $dbdict = NewDataDictionary($db);
   6  
   7  if ($config["dbms"] == 'postgres7')
   8  {
   9      $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."userprefs", "tmp X"); 
  10      $dbdict->ExecuteSQLArray($sqlarray);
  11      $query = "UPDATE ".cms_db_prefix()."userprefs SET tmp = value";
  12      $db->Execute($query);
  13      $sqlarray = $dbdict->DropColumnSQL(cms_db_prefix()."userprefs", "value"); 
  14      $dbdict->ExecuteSQLArray($sqlarray);
  15      $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."userprefs", "value X"); 
  16      $dbdict->ExecuteSQLArray($sqlarray);
  17      $query = "UPDATE ".cms_db_prefix()."userprefs SET value = tmp";
  18      $db->Execute($query);
  19      $sqlarray = $dbdict->DropColumnSQL(cms_db_prefix()."userprefs", "tmp"); 
  20      $dbdict->ExecuteSQLArray($sqlarray);
  21  }
  22  else
  23  {
  24      $sqlarray = $dbdict->AlterColumnSQL(cms_db_prefix()."userprefs", "value X"); 
  25      $dbdict->ExecuteSQLArray($sqlarray);
  26  }
  27  
  28  echo '[done]</p>';
  29  
  30  echo '<p>Setting up core events...';
  31  
  32  Events::SetupCoreEvents();
  33  
  34  echo '[done]</p>';
  35  
  36  echo '<p>Updating schema version... ';
  37  
  38  $query = "UPDATE ".cms_db_prefix()."version SET version = 24";
  39  $db->Execute($query);
  40  
  41  echo '[done]</p>';
  42  
  43  # vim:ts=4 sw=4 noet
  44  ?>