All pastes #267183 Raw Edit

Anonymous

public sql v1 · immutable
·published 2006-12-04 18:01 UTC
rendered paste body
------- Add the longitude field-----ALTER TABLE users ADD (longitude varchar(25));------- Add the latitude field-----ALTER TABLE users ADD (latitude varchar(25));------- Add the index for searches.-----ALTER TABLE users ADD INDEX IDX_geoloc(latitude, longitude);