Date index for Aug 2002

While fooling around with Achievo 0.9.1, the following ideas came to mind:

1. Recommend that the customer table have an added field to hold optional
state/province data.
Ideally, it would be a small int that lookups/links to a "provinces" table.

If the provinces table is accepted, I suggest that its contents be at least:
	create table provinces
	(
	province_id int not null auto_increment,
      country_id int not null,
      province_name varchar(50) not null,
      province_abbr varchar(5),
      primary key(province_id),
	key (country_id,province_name)
	);

2. The country field could be linked to a lookup table, as described below.
	create table countries
	(
	country_id int not null,
	country_name varchar(50),
	country_abbr varchar(8),
	primary key(country_name)
	);

3. Entry in the languages table to display state/province or whatever.

4. Add line(s) in class.customer.inc to include the new field.

5. Mod the country entity if changes are made as suggested above.

Dave Nuttall
San Antonio, TX