Table geo zones

From Zen Cart(tm) Wiki

Contents 1 Database Version 2 Description 3 Table Details 3.1 Primary Key 3.2 Indexed Fields 4 Columns 4.1 geo_zone_id 4.2 geo_zone_name 4.3 geo_zone_description 4.4 last_modified 4.5 date_added 5 Default Entries

Database Version

1.3.5

Description

Holds the data for all the information shown in Admin > Locations/Taxes > Zones Definitions.

Essentially, it is the list of custom zones you've created to handle zone-related processing for your site.

Table Details

Primary Key

geo_zone_id

Indexed Fields

None.

Columns

geo_zone_id

A unique, auto incremented value, to identify each geo zones record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

geo_zone_name

The name of the geo zone record.

Type:	varchar(32)
Null:	No
Default:

geo_zone_description

The description of the geo zone record.

Type:	varchar(255)
Null:	No
Default:

last_modified

The date and time that the geo zone was last modified.

Type:	datetime
Null:	Yes
Default:	NULL

date_added

The date and time that the geo zone was first added.

Type:	datetime
Null:	No
Default:	0001-01-01 00:00:00

Default Entries

geo_zone_id:	1
geo_zone_name:	Florida
geo_zone_description:	Florida local sales tax zone
last_modified:	NULL
date_added:	This will always be set to the date and time that Zen Cart was first setup.