function seochecklist_update_6205 in SEO Checklist 6.3

Same name and namespace in other branches

1. 7.3 seochecklist.install \seochecklist_update_6205()

Remove the {seo_checklist}.subgroup_id field and add {seo_checklist}.uid.

File

./seochecklist.install, line 148

Install, update and uninstall functions for the seochecklist module.

Code

function seochecklist_update_6205() {
  $ret = array();
  db_drop_field($ret, 'seo_checklist', 'subgroup_id');
  db_add_field($ret, 'seo_checklist', 'uid', array(
    'type' => 'int',
    'unsigned' => TRUE,
    'not null' => TRUE,
    'default' => 0,
    'description' => 'The {user}.uid of the account that completed this task.',
  ));
  $ret[] = update_sql("UPDATE {seo_checklist} SET module = LOWER(module)");
  return $ret;
}