[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo "<p>Creating adminlog table...";
   4  
   5  $query  = "CREATE TABLE ".$config["db_prefix"]."adminlog (";
   6  $query .= "  timestamp int(11),";
   7  $query .= "  user_id int(11),";
   8  $query .= "  username varchar(25),";
   9  $query .= "  item_id int(11),";
  10  $query .= "  item_name varchar(50),";
  11  $query .= "  action varchar(255)";
  12  $query .= ") TYPE=MyISAM";
  13  
  14  $db->Execute($query);
  15  
  16  echo "[done]</p>";
  17  
  18  echo "<p>Creating userprefs table...";
  19  
  20  $query  = "CREATE TABLE ".$config["db_prefix"]."userprefs (";
  21  $query .= "  user_id int(11),";
  22  $query .= "  preference varchar(50),";
  23  $query .= "  value varchar(255),";
  24  $query .= "  type varchar(25)";
  25  $query .= ") TYPE=MyISAM";
  26  
  27  $db->Execute($query);
  28  
  29  $query = "SELECT user_id FROM ".$config["db_prefix"]."users";
  30  $result = $db->Execute($query);
  31  if ($result)
  32  {
  33      while ($row = $result->FetchRow()) {
  34          $query = "INSERT INTO ".$config["db_prefix"]."userprefs (user_id, preference, value) VALUES (".$row["user_id"].", 'use_wysiwyg', '1')";
  35          $db->Execute($query);
  36      }
  37  }
  38  
  39  echo "[done]</p>";
  40  
  41  echo "<p>Creating indexes...";
  42  
  43  $query = "CREATE INDEX idx_template_id_modified_date ON ".$config["db_prefix"]."pages (template_id, modified_date)";
  44  $db->Execute($query);
  45  
  46  echo "[done]</p>";
  47  
  48  echo "<p>Updating sections table schema...";
  49  
  50  $query = "ALTER table ".$config["db_prefix"]."sections ADD parent_id int(11) NOT NULL DEFAULT 0";
  51  $db->Execute($query);
  52  
  53  echo "[done]</p>";
  54  
  55  echo "<p>Updating user table schema...";
  56  
  57  $query = "ALTER table ".$config["db_prefix"]."users CHANGE password password varchar(40)";
  58  $db->Execute($query);
  59  
  60  echo "[done]</p>";
  61  
  62  echo "<p>Hashing passwords...";
  63  
  64  $query = "SELECT user_id, password FROM ".$config["db_prefix"]."users";
  65  $result = $db->Execute($query);
  66  if ($result)
  67  {
  68      while ($row = $result->FetchRow()) {
  69          $query = "UPDATE ".$config["db_prefix"]."users SET password = '".md5($row["password"])."' where user_id = " . $row["user_id"];
  70          $db->Execute($query);
  71      }
  72  }
  73  
  74  echo "[done]</p>";
  75  
  76  echo "<p>Updating content types...";
  77  
  78  $query = "UPDATE ".$config["db_prefix"]."pages SET page_type = 'content'";
  79  $db->Execute($query);
  80  
  81  echo "[done]</p>";
  82  
  83  echo "<p>Added item_order to existing sections... ";
  84  
  85  $count = 1;
  86  $query = "SELECT section_id FROM ".$config["db_prefix"]."sections ORDER BY section_id";
  87  $result = $db->query($query);
  88  
  89  #foreach loop
  90  if ($result)
  91  {
  92      while($row = $result->FetchRow()) {
  93          $query = "UPDATE ".$config["db_prefix"]."sections SET item_order = $count WHERE section_id = " . $row["section_id"];
  94          $db->Execute($query);
  95          $count++;
  96      }
  97  }
  98  
  99  echo "[done]</p>";
 100  
 101  echo "<p>Reseting cache update time...";
 102  
 103  $query = "UPDATE ".$config["db_prefix"]."templates SET modified_date = now()";
 104  $db->Execute($query);
 105  
 106  echo "[done]</p>";
 107  
 108  echo "<p>Updating schema version... ";
 109  
 110  $query = "UPDATE ".$config["db_prefix"]."version SET version = 3";
 111  $db->Execute($query);
 112  
 113  echo "[done]</p>";
 114  
 115  # vim:ts=4 sw=4 noet
 116  ?>