function location_update_1 in Location 5

Same name in this branch

1. 5 location.install \location_update_1()
2. 5 location_upgrade.php \location_update_1()

Same name and namespace in other branches

1. 5.3 location.install \location_update_1()
2. 6.3 location.install \location_update_1()
3. 7.5 location.install \location_update_1()
4. 7.3 location.install \location_update_1()
5. 7.4 location.install \location_update_1()

File

./location_upgrade.php, line 141

Code

function location_update_1() {
  db_query("ALTER TABLE {location_node} ADD type varchar(6) NOT NULL DEFAULT ''");
  db_query("UPDATE {location_node} SET type = 'node'");
  db_query("ALTER TABLE {location_node} DROP PRIMARY KEY");
  db_query("ALTER TABLE {location_node} CHANGE nid oid int(10) unsigned NOT NULL default '0'");
  db_query("ALTER TABLE {location_node} ADD PRIMARY KEY (type, oid)");
  $result = db_query("SELECT * FROM {location_user}");
  while ($row = db_fetch_object($result)) {
    db_query("INSERT INTO {location_node} (oid, name, street, additional, city, province, postal_code, country, latitude, longitude, exact, type) VALUES (%d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%f', '%f', %d, 'user')", $row->uid, $row->name, $row->street, $row->additional, $row->city, $row->province, $row->postal_code, $row->country, $row->latitude, $row->longitude, $row->exact, $row->type);
  }
  db_query("RENAME TABLE {location_node} TO {location}");
}