function nodequeue_update_5000 in Nodequeue 5

Same name and namespace in other branches

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

File

./nodequeue.install, line 105

Code

function nodequeue_update_5000() {
  $ret = array();
  $ret[] = t(array(
    'success' => TRUE,
    'query' => 'Some of the following queries may appear to fail. This is not a problem.',
  ));
  $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");
  $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)");
  $ret[] = _system_update_utf8(array(
    'nodequeue_queue',
    'nodequeue_roles',
    'nodequeue_types',
    'nodequeue_nodes',
  ));
  return $ret;
}