Skip to content

Instantly share code, notes, and snippets.

@AlexJLP

AlexJLP/countries_to_geo.sql

Created May 19, 2017 18:51
Show Gist options
  • Save AlexJLP/648157eaf948ca13e37283eb6c01cd40 to your computer and use it in GitHub Desktop.
Save AlexJLP/648157eaf948ca13e37283eb6c01cd40 to your computer and use it in GitHub Desktop.
Download ZIP
Opencart Countries to seperate Geozones
Raw
countries_to_geo.sql
-- Adds all countries as geo zones individually
INSERT INTO oc_zone_to_geo_zone (country_id, geo_zone_id) SELECT `country_id`, `geo_zone_id` FROM `oc_country`, `oc_geo_zone` WHERE oc_country.name = oc_geo_zone.name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment