function nodequeue_update_6007 in Nodequeue 6.2

Provide machine names, and auto-generation of machine names for existing queues.

File

./nodequeue.install, line 539

Install, update and uninstall functions for the nodequeue module.

Code

function nodequeue_update_6007() {
  $ret = array();
  db_add_field($ret, 'nodequeue_queue', 'name', array(
    'type' => 'varchar',
    'length' => 128,
  ));
  db_add_unique_key($ret, 'nodequeue_queue', 'name', array(
    'name',
  ));

  // Auto-generate machine names for existing queues and subqueues. Existing
  // queues will be named "queue{$qid}" while subqueues will be named
  // "queue{$qid}_subqueue{$sqid}"
  global $db_type;
  if ($db_type == 'mysql' || $db_type == 'mysqli') {
    $queue_update_sql = "UPDATE {nodequeue_queue} SET name = CONCAT('queue', qid)";
  }
  else {
    $queue_update_sql = "UPDATE {nodequeue_queue} SET name = 'queue'||qid";
  }
  $ret[] = update_sql($queue_update_sql);
  return $ret;
}