function migrate_example_update_6001 in Migrate 6.2

Convert modificationdate datetime field to modificationdatetime int field.

File

migrate_example/migrate_example.install, line 54

Code

function migrate_example_update_6001() {
  $ret = array();
  db_add_field($ret, 'migrate_example_beer_legacy_urls', 'modificationdatetime', array(
    'type' => 'int',
    'unsigned' => TRUE,
    'not null' => FALSE,
  ));
  $result = db_query("SELECT id, modificationdate\n                      FROM {migrate_example_beer_legacy_urls}");
  while ($row = db_fetch_object($result)) {
    $modificationdatetime = strtotime($row->modificationdate);
    db_query("UPDATE {migrate_example_beer_legacy_urls}\n              SET modificationdatetime=%d\n              WHERE id=%d", $modificationdatetime, $row->id);
  }
  db_drop_field($ret, 'migrate_example_beer_legacy_urls', 'modificationdate');
  $ret[] = t('Converted modificationdate datetime field to modificationdatetime int field');
  return $ret;
}