function page_theme_update_7200 in Page Theme 7.2

Add fields {page_theme}.rule and {page_theme}.name.

File

./page_theme.install, line 210

Install, update and uninstall functions for the page_theme module.

Code

function page_theme_update_7200() {
  db_drop_unique_key('page_theme', 'theme');
  db_drop_index('page_theme', 'list');
  db_add_field('page_theme', 'rule', array(
    'description' => 'Rule machine-name.',
    'type' => 'varchar',
    'length' => 255,
    'not null' => TRUE,
    'default' => '',
  ));
  db_add_field('page_theme', 'name', array(
    'description' => 'Rule name.',
    'type' => 'varchar',
    'length' => 255,
    'not null' => TRUE,
    'default' => '',
  ));
  $result = db_query('SELECT theme FROM {page_theme}');
  foreach ($result as $page_theme) {
    db_update('page_theme')
      ->fields(array(
      'rule' => $page_theme->theme,
      'name' => $page_theme->theme,
    ))
      ->condition('theme', $page_theme->theme)
      ->execute();
  }
  db_add_unique_key('page_theme', 'rule', array(
    'rule',
  ));
  db_add_index('page_theme', 'list', array(
    'weight',
    'rule',
  ));
}