[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  @set_time_limit(0);
  22  
  23  function upgrade56_dbchanges()
  24  {
  25      global $output, $cache, $db, $mybb;
  26  
  27      $output->print_header("Updating Database");
  28  
  29      echo "<p>Performing necessary upgrade queries...</p>";
  30      flush();
  31  
  32      // Add missing PostgreSQL indexes expected for DB_Base::replace_query()
  33      if($db->type == 'pgsql')
  34      {
  35          $parameters = '';
  36  
  37          if(version_compare($db->get_version(), '9.5.0', '>='))
  38          {
  39              $parameters = "IF NOT EXISTS";
  40          }
  41  
  42          $db->write_query("CREATE UNIQUE INDEX {$parameters} fid_uid ON ".TABLE_PREFIX."forumsread (fid, uid)");
  43          $db->write_query("CREATE UNIQUE INDEX {$parameters} tid_uid ON ".TABLE_PREFIX."threadsread (tid, uid)");
  44      }
  45  
  46      $output->print_contents("<p>Click next to continue with the upgrade process.</p>");
  47      $output->print_footer("56_done");
  48  }