[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo "<p>Making permission field bigger...";
   4  
   5  if ($config["dbms"] == 'postgres7')
   6  {
   7      $dbdict = NewDataDictionary($db);
   8      $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."permissions", "tmp C(255)"); 
   9      $dbdict->ExecuteSQLArray($sqlarray);
  10      $query = "UPDATE ".cms_db_prefix()."permissions SET tmp = permission_name";
  11      $db->Execute($query);
  12      $sqlarray = $dbdict->DropColumnSQL(cms_db_prefix()."permissions", "permission_name"); 
  13      $dbdict->ExecuteSQLArray($sqlarray);
  14      $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."permissions", "permission_name C(255)"); 
  15      $dbdict->ExecuteSQLArray($sqlarray);
  16      $query = "UPDATE ".cms_db_prefix()."permissions SET permission_name = tmp";
  17      $db->Execute($query);
  18      $sqlarray = $dbdict->DropColumnSQL(cms_db_prefix()."permissions", "tmp"); 
  19      $dbdict->ExecuteSQLArray($sqlarray);
  20  }
  21  else
  22  {
  23      $sqlarray = $dbdict->AlterColumnSQL(cms_db_prefix()."permissions", "permission_name C(255)"); 
  24      $dbdict->ExecuteSQLArray($sqlarray);
  25  }
  26  
  27  echo "[done]</p>";
  28  
  29  echo "<p>Make active boolean in modules table...";
  30  
  31  $dbdict = NewDataDictionary($db);
  32  if ($config["dbms"] == 'postgres7')
  33  {
  34      $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."modules", "tmp I1"); 
  35      $dbdict->ExecuteSQLArray($sqlarray);
  36      $query = "UPDATE ".cms_db_prefix()."modules SET tmp = 1 WHERE active = true";
  37      $db->Execute($query);
  38      $query = "UPDATE ".cms_db_prefix()."modules SET tmp = 0 WHERE active = false";
  39      $db->Execute($query);
  40      $sqlarray = $dbdict->DropColumnSQL(cms_db_prefix()."modules", "active"); 
  41      $dbdict->ExecuteSQLArray($sqlarray);
  42      $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."modules", "active I1"); 
  43      $dbdict->ExecuteSQLArray($sqlarray);
  44      $query = "UPDATE ".cms_db_prefix()."modules SET active = tmp";
  45      $db->Execute($query);
  46      $sqlarray = $dbdict->DropColumnSQL(cms_db_prefix()."modules", "tmp"); 
  47      $dbdict->ExecuteSQLArray($sqlarray);
  48  }
  49  else
  50  {
  51      $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."modules", "active I1"); 
  52      $dbdict->ExecuteSQLArray($sqlarray);
  53  }
  54  
  55  echo "[done]</p>";
  56  
  57  echo "<p>Fixing permission names...";
  58  
  59  $query = "UPDATE ".cms_db_prefix()."permissions set permission_name = 'Add Global Content Blocks', permission_text = 'Add Global Content Blocks' WHERE permission_name = 'Add Html Blobs'";
  60  $db->Execute($query);
  61  $query = "UPDATE ".cms_db_prefix()."permissions set permission_name = 'Modify Global Content Blocks', permission_text = 'Modify Global Content Blocks' WHERE permission_name = 'Modify Html Blobs'";
  62  $db->Execute($query);
  63  $query = "UPDATE ".cms_db_prefix()."permissions set permission_name = 'Remove Global Content Blocks', permission_text = 'Remove Global Content Blocks' WHERE permission_name = 'Remove Html Blobs'";
  64  $db->Execute($query);
  65  $query = "UPDATE ".cms_db_prefix()."permissions set permission_name = 'Modify User-defined Tags', permission_text = 'Modify User-defined Tags' WHERE permission_name = 'Modify Code Blocks'";
  66  $db->Execute($query);
  67  
  68  echo "[done]</p>";
  69  
  70  echo '<p>Updating hierarchy positions...';
  71  
  72  ContentManager::SetAllHierarchyPositions();
  73  
  74  echo '[done]</p>';
  75  
  76  echo '<p>Updating schema version... ';
  77  
  78  $query = "UPDATE ".cms_db_prefix()."version SET version = 18";
  79  $db->Execute($query);
  80  
  81  echo '[done]</p>';
  82  
  83  # vim:ts=4 sw=4 noet
  84  ?>