View Single Post
Old March 30th, 2005, 07:54 AM   #13 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
Does the zipData table get created on install or when running the 1.8 upgrade script?

$query[] = "CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM";


The zipcode upgrade just adds the zipcodes
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote