You are here

function migrate_example_update_6002 in Migrate 6.2

Add image alt/title/description columns.

File

migrate_example/migrate_example.install, line 81

Code

function migrate_example_update_6002() {
  $ret = array();
  db_add_field($ret, 'migrate_example_beer_node', 'image_alt', array(
    'type' => 'varchar',
    'length' => 255,
    'not null' => FALSE,
    'description' => 'Image ALT',
  ));
  db_add_field($ret, 'migrate_example_beer_node', 'image_title', array(
    'type' => 'varchar',
    'length' => 255,
    'not null' => FALSE,
    'description' => 'Image title',
  ));
  db_add_field($ret, 'migrate_example_beer_node', 'image_description', array(
    'type' => 'varchar',
    'length' => 255,
    'not null' => FALSE,
    'description' => 'Image description',
  ));
  db_query("UPDATE {migrate_example_beer_node}\n            SET image_alt='%s', image_title='%s', image_description='%s'\n            WHERE bid=%d", 'Heinekin alt', 'Heinekin title', 'Heinekin description', 99999999);
  $ret[] = t('Added image_alt, image_title, and image_description fields.');
  return $ret;
}