function nodequeue_update_5000 in Nodequeue 6.2

Same name and namespace in other branches

1. 5.2 nodequeue.install \nodequeue_update_5000()
2. 5 nodequeue.install \nodequeue_update_5000()

File

./nodequeue.install, line 266

Install, update and uninstall functions for the nodequeue module.

Code

function nodequeue_update_5000() {
  $ret = array();
  $ret[] = array(
    'success' => TRUE,
    'query' => t('Some of the following queries may appear to fail. This is not a problem.'),
  );
  db_add_field($ret, "nodequeue_queue", "link", array(
    'description' => 'The link text to show under a node to add it to the queue.',
    'type' => 'varchar',
    'length' => 40,
  ));
  db_add_field($ret, "nodequeue_queue", "link_remove", array(
    'description' => 'The link text to show under a node to remove it from the queue.',
    'type' => 'varchar',
    'length' => 40,
  ));

  //$ret[] = update_sql("ALTER TABLE {nodequeue_queue} ADD COLUMN link VARCHAR(40) DEFAULT '' NOT NULL");

  //$ret[] = update_sql("ALTER TABLE {nodequeue_queue} ADD COLUMN link_remove VARCHAR(40) DEFAULT '' NOT NULL");
  db_add_index($ret, 'nodequeue_roles', "{nodequeue_roles}_qid", array(
    'qid',
  ));
  db_add_index($ret, "nodequeue_roles", "{nodequeue_roles}_rid", array(
    'rid',
  ));
  db_add_index($ret, "nodequeue_types", "{nodequeue_types}_qid", array(
    'qid',
  ));
  db_add_index($ret, "nodequeue_nodes", "{nodequeue_nodes}_qid", array(
    'qid',
    'position',
  ));
  db_add_index($ret, "nodequeue_nodes", "{nodequeue_nodes}_nid", array(
    'nid',
  ));

  //$ret[] = update_sql("CREATE INDEX {nodequeue_roles}_qid_idx ON {nodequeue_roles} (qid)");

  //$ret[] = update_sql("CREATE INDEX {nodequeue_roles}_rid_idx ON {nodequeue_roles} (rid)");

  //$ret[] = update_sql("CREATE INDEX {nodequeue_types}_qid_idx ON {nodequeue_types} (qid)");

  //$ret[] = update_sql("CREATE INDEX {nodequeue_nodes}_qid_idx ON {nodequeue_nodes} (qid, position)");

  //$ret[] = update_sql("CREATE INDEX {nodequeue_nodes}_nid_idx ON {nodequeue_nodes} (nid)");

  // TODO: Figure out how to fix this?

  //$ret[] = _system_update_utf8(array('nodequeue_queue', 'nodequeue_roles', 'nodequeue_types', 'nodequeue_nodes'));
  return $ret;
}