Drupal 6 Update block cache

Drupal 6 Update block cache

<?php


function mymodule_update_N() {
  $return = array();

  $blocks = mymodule_block('list');
  foreach($blocks as $delta => $block) {
    $cache = ($block['cache']) ? $block['cache'] : BLOCK_CACHE_PER_ROLE;
    $return[] = update_sql('UPDATE {blocks} SET cache = '.$cache.' WHERE module = "mymodule" AND delta = "'.$delta.'" ');

  }

  return $return;
}

Drupal 6 : Update block cache

<?php


function mymodule_update_N() {
  $return = array();

  $blocks = mymodule_block('list');
  foreach($blocks as $delta => $block) {
    $cache = ($block['cache']) ? $block['cache'] : BLOCK_CACHE_PER_ROLE;
    $return[] = update_sql('UPDATE {blocks} SET cache = '.$cache.' WHERE module = "mymodule" AND delta = "'.$delta.'" ');

  }

  return $return;
}