I need to buy zipcode data for our Znode 6.0 installation. What schema does znode need?
Will be below schema work?

Database Schema for USA 5-digit ZIP Code Database, Premium Edition

Click on any field name for a description of the contents of that field.
ZIPCode char(5)
ZIPType char(1)
CityName varchar(64)
CityType char(1)
StateName varchar(64)
StateAbbr char(2)
AreaCode varchar(16)
Latitude decimal(9, 6)
Longitude decimal(9, 6)

Or can I use the below?

Database Schema for 5-digit ZIP Code Database, Basic Edition

Click on any field name for a description of the contents of that field.
ZIPCode char(5)
CityName varchar(64)
StateAbbr char(2)

Or this one:
Database Schema for USA 5-digit ZIP Code Database, Commercial Edition

Click on any field name for a description of the contents of that field.
ZIPCode char(5)
ZIPType char(1)
CityName varchar(64)
CityType char(1)
CountyName varchar(64)
CountyFIPS char(5)
StateName varchar(64)
StateAbbr char(2)
StateFIPS char(2)
MSACode char(4)
AreaCode varchar(16)
TimeZone varchar(16)
UTC decimal(3,1)
DST char(1)
Latitude decimal(9, 6)
Longitude decimal(9, 6)

The basic edition does not have the ZipType.
Do I have to modify this data before I import into znode?

Thanks,
Bill