function page_title_update_6200 in Page Title 8.2

Same name and namespace in other branches

1. 6.2 page_title.install \page_title_update_6200()
2. 7.2 page_title.install \page_title_update_6200()
3. 7 page_title.install \page_title_update_6200()

Implements hook_update_n().

File

./page_title.install, line 29

page_title.install

Code

function page_title_update_6200() {
  $ret = array();
  if (db_column_exists('page_title', 'id')) {
    return $ret;
  }
  db_create_table($ret, 'page_title_temp', array(
    'fields' => array(
      'type' => array(
        'type' => 'varchar',
        'length' => 15,
        'not null' => TRUE,
        'default' => 'node',
      ),
      'id' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'page_title' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
    ),
    'primary key' => array(
      'type',
      'id',
    ),
  ));
  $ret[] = update_sql('INSERT INTO {page_title_temp} (id, page_title) SELECT nid, page_title FROM {page_title}');
  db_rename_table($ret, 'page_title', 'page_title_old');
  db_rename_table($ret, 'page_title_temp', 'page_title');
  $display_settings = variable_get('page_title_display', array());
  foreach ($display_settings as $type) {
    if ($type) {
      variable_set('page_title_type_' . $type . '_showfield', 1);
    }
  }
  variable_del('page_title_display');
  return $ret;
}