How to create a geo_zone

[Paula Moss]

Ok, so now I have accidently deleted my geo_zones. :'( How do I add it back in my SQL?

[Guest]

Do you mean you have deleted the whole Geo zones table from your database or just the contents?

 

If its just the contents, then goto your admin panel > Localizations/Taxes > Tax Zones

Hit the insert button and re-create your tax zone to suit you.

 

If its the whole geo zone table thats gone then you need to run the following in your sql admin (phpmyadmin?)

 

CREATE TABLE `geo_zones` (

`geo_zone_id` int(11) NOT NULL auto_increment,

`geo_zone_name` varchar(32) NOT NULL default '',

`geo_zone_description` varchar(255) NOT NULL default '',

`last_modified` datetime default NULL,

`date_added` datetime NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY (`geo_zone_id`)

) ENGINE=MyISAM DEFAULT AUTO_INCREMENT=5 ;

[Paula Moss]

Thanks for that. Yes, the whole geo table is gone. I ran what you told me to do but got this error:

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTO_INCREMENT=5' at line 8

[Paula Moss]

Geo Zone is back!! Thank you! I add to delete that last line and put in:

 

) TYPE=MyISAM;