<?php
// $Id$

function context_prefix_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("CREATE TABLE {context_prefix} (provider VARCHAR(255) NOT NULL, prefix VARCHAR(255) NOT NULL, id INT(10) NOT NULL, PRIMARY KEY (prefix))");
      db_query("UPDATE {system} SET weight = -20 WHERE name = 'context_prefix'");
      break;
  }
}

function context_prefix_update_1() {
  $items = array();
  $items[] = update_sql("UPDATE {system} SET weight = -20 WHERE name = 'context_prefix'");
  return $items;
}

function context_prefix_update_2() {
  $items = array();
  $items[] = update_sql("CREATE TABLE {context_prefix} (space VARCHAR(255) NOT NULL, path VARCHAR(255) NOT NULL, id INT(10) NOT NULL, PRIMARY KEY (path))");
  $paths = variable_get('context_paths', array());
  if ($paths) {
    foreach ($paths as $space => $p) {
      foreach ($p as $path => $nid) {
        db_query("REPLACE INTO {context_prefix} (space, path, id) VALUES('%s', '%s', %d)", $space, $path, $nid);
      }
    }
    variable_del('context_paths');
  }
  return $items;
}

function context_prefix_update_3() {
  $items = array();
  $items[] = update_sql("ALTER TABLE {context_prefix} CHANGE COLUMN space space VARCHAR(255) NOT NULL;");
  $items[] = update_sql("ALTER TABLE {context_prefix} CHANGE COLUMN path path VARCHAR(255) NOT NULL;");
  $items[] = update_sql("ALTER TABLE {context_prefix} CHANGE COLUMN id id VARCHAR(255) NOT NULL;");
  return $items;
}

function context_prefix_update_4() {
  $items = array();
  $items[] = update_sql("ALTER TABLE {context_prefix} CHANGE COLUMN space module VARCHAR(255) NOT NULL;");
  $items[] = update_sql("ALTER TABLE {context_prefix} CHANGE COLUMN path prefix VARCHAR(255) NOT NULL;");
  return $items;
}

function context_prefix_update_5() {
  $items = array();
  $items[] = update_sql("ALTER TABLE {context_prefix} CHANGE COLUMN module provider VARCHAR(255) NOT NULL;");
  return $items;
}