<?php
// $Id: options.install,v 1.4 2006/03/11 22:08:35 JonBob Exp $

/**
 * Implementation of hook_install().
 */
function options_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {node_field_options_data} (
          nid int unsigned NOT NULL default '0',
          vid int unsigned NOT NULL default '0',
          field_name varchar(32) NOT NULL default '',
          delta int unsigned NOT NULL default '0',
          field_options char(17) NOT NULL default '00010101T00:00:00',
          PRIMARY KEY (vid,field_name,delta)
        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;

    case 'pgsql':
      db_query("CREATE TABLE {node_field_options_data} (
          nid integer unsigned NOT NULL default '0',
          vid integer unsigned NOT NULL default '0',
          field_name varchar(32) NOT NULL default '',
          delta integer unsigned NOT NULL default '0',
          field_options char(17) NOT NULL default '00010101T00:00:00',
          PRIMARY KEY (vid,field_name,delta)
        )");
      break;
  }
}

function options_upoptions_1() {
  $ret = array();

  switch ($GLOBALS['db_type']) {
    case 'pgsql':
      db_add_column($ret, 'node_field_options_data', 'nid', 'integer', array('not null' => TRUE, 'default' => 0));
      break;

    case 'mysql':
    case 'mysqli':
      $ret[] = upoptions_sql("ALTER TABLE {node_field_options_data} ADD COLUMN nid int(10) NOT NULL DEFAULT 0");
      break;
  }

  return $ret;
}

function options_upoptions_2() {
  // Multi-part upoptions
  if (!isset($_SESSION['options_upoptions_2'])) {
    $_SESSION['options_upoptions_2'] = 0;
    $_SESSION['options_upoptions_2_max'] = db_result(db_query("SELECT COUNT(*) FROM {node_field_options_data}"));;
  }

  $limit = 20;
  $result = db_query_range("SELECT nr.nid, nfdd.vid, nfdd.field_name, nfdd.delta FROM {node_field_options_data} nfdd LEFT JOIN {node_revisions} nr ON nr.vid = nfdd.vid", $_SESSION['options_upoptions_2'], $limit);
  if (db_num_rows($result) == 0) {
    unset($_SESSION['options_upoptions_2']);
    unset($_SESSION['options_upoptions_2_max']);
    return array();
  }
  while ($data = db_fetch_object($result)) {
    $_SESSION['options_upoptions_2']++;
    db_query("UPDATE {node_field_options_data} SET nid = %d WHERE vid = %d AND field_name = '%s' AND delta = %d", $data->nid, $data->vid, $data->field_name, $data->delta);
  }

  return array('#finished' => $_SESSION['options_upoptions_2'] / $_SESSION['options_upoptions_2_max']);
}