Part 1:
Using phpMyAdmin (or similar), import the following:
Save the above as a plain text file called oz-zones.sql, for later use. If you get a warning about a duplicate key, then you will need to renumber the zone_id numbers to begin from, say, 300 or 400. This will depend on whether you have additional zones, other than the default installed.Code:INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (290, 13, 'Australian Capital Territory', 'Australian Capital Territory'), (291, 13, 'New South Wales', 'New South Wales'), (292, 13, 'Northern Territory', 'Northern Territory'), (293, 13, 'Queensland', 'Queensland'), (294, 13, 'South Australia', 'South Australia'), (295, 13, 'Tasmania', 'Tasmania'), (296, 13, 'Victoria', 'Victoria'), (297, 13, 'Western Australia', 'Western Australia');
EJ





LinkBack URL
About LinkBacks









Bookmarks