[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * MyBB 1.8
   4   * Copyright 2014 MyBB Group, All Rights Reserved
   5   *
   6   * Website: http://www.mybb.com
   7   * License: http://www.mybb.com/about/license
   8   *
   9   */
  10  
  11  /**
  12   * Upgrade Script: 1.8.32
  13   */
  14  
  15  $upgrade_detail = array(
  16      "revert_all_templates" => 0,
  17      "revert_all_themes" => 0,
  18      "revert_all_settings" => 0
  19  );
  20  
  21  function upgrade56_dbchanges()
  22  {
  23      global $output, $cache, $db, $mybb;
  24  
  25      $output->print_header("Updating Database");
  26  
  27      echo "<p>Performing necessary upgrade queries...</p>";
  28      flush();
  29  
  30      // Add missing PostgreSQL indexes expected for DB_Base::replace_query()
  31      if($db->type == 'pgsql')
  32      {
  33          $parameters = '';
  34  
  35          if(version_compare($db->get_version(), '9.5.0', '>='))
  36          {
  37              $parameters = "IF NOT EXISTS";
  38          }
  39  
  40          $db->write_query("CREATE UNIQUE INDEX {$parameters} fid_uid ON ".TABLE_PREFIX."forumsread (fid, uid)");
  41          $db->write_query("CREATE UNIQUE INDEX {$parameters} tid_uid ON ".TABLE_PREFIX."threadsread (tid, uid)");
  42      }
  43  
  44      $output->print_contents("<p>Click next to continue with the upgrade process.</p>");
  45      $output->print_footer("56_done");
  46  }