function page_theme_update_6100 in Page Theme 6

Same name and namespace in other branches

1. 7.2 page_theme.install \page_theme_update_6100()
2. 7 page_theme.install \page_theme_update_6100()

Implementation of hook_update_N().

Add status and weight field.

File

./page_theme.install, line 87

Install, update and uninstall functions for the page_theme module.

Code

function page_theme_update_6100() {
  $ret = array();
  db_add_field($ret, 'page_theme', 'status', array(
    'type' => 'int',
    'size' => 'tiny',
    'not null' => TRUE,
    'default' => 0,
  ));
  db_add_field($ret, 'page_theme', 'weight', array(
    'type' => 'int',
    'size' => 'tiny',
    'not null' => TRUE,
    'default' => 0,
  ));
  $result = db_query('SELECT theme FROM {page_theme}');
  while ($page_theme = db_fetch_object($result)) {
    db_query('UPDATE {page_theme} SET status = 1 WHERE theme = "%s"', $page_theme->theme);
  }
  return $ret;
}