[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo "<p>Modifying Event Handler Table(s)...";
   4  
   5  $dbdict = NewDataDictionary($db);
   6  
   7  $flds = "
   8            event_id      I,
   9            tag_name      c(255),
  10            module_name   c(255),
  11            removable     I,
  12            handler_order I,
  13            handler_id    I KEY
  14          ";
  15  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  16  $sqlarray = $dbdict->CreateTableSQL(cms_db_prefix()."event_handlers", $flds, $taboptarray);
  17  $dbdict->ExecuteSQLArray($sqlarray);
  18  
  19  $flds = "
  20            originator   c(200) NOTNULL,
  21            event_name   c(200) NOTNULL,
  22            event_id     I KEY
  23          ";
  24  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  25  $sqlarray = $dbdict->CreateTableSQL(cms_db_prefix()."events", $flds, $taboptarray);
  26  $dbdict->ExecuteSQLArray($sqlarray);
  27  
  28  $db->CreateSequence(cms_db_prefix()."events_seq");
  29  $db->CreateSequence(cms_db_prefix()."event_handler_seq");
  30  
  31  //Just in case someone has the table in 19-20
  32  $db->Execute( 'DROP TABLE '.cms_db_prefix().'eventhandlers' );
  33  
  34  echo "[done]</p>";
  35  
  36  echo '<p>Updating schema version... ';
  37  
  38  $query = "UPDATE ".cms_db_prefix()."version SET version = 22";
  39  $db->Execute($query);
  40  
  41  echo '[done]</p>';
  42  
  43  # vim:ts=4 sw=4 noet
  44  ?>