aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/upgrades/2009051401.sql
blob: 57348968e05f475caba8dd1f44d4d1d0cc96d06a (plain)
1
2
3
4
5
-- Fix error in geocode cache table
DELETE FROM `prefix_geocode_cache`;

ALTER TABLE `prefix_geocode_cache` DROP KEY `location`;
ALTER TABLE `prefix_geocode_cache` ADD UNIQUE KEY `location` (`location`);