CMS MADE SIMPLE FORGE

CGExtensions

 
Back Back to List

[#11163] Make it possible to store county and state codes that are larger than 2 letters

avatar
Created By: Deleted User (deleteduser_11200)
Date Submitted: 2016-09-15 12:20

Assigned To: Robert Campbell (calguy1000)
Resolution: None
State: Open
Summary:
Make it possible to store county and state codes that are larger than 2 letters
Detailed Description:
Currently only 2 letter codes are supported under: Calguys Module Extensions ->
[States] and [Countries] tab

Outside the US and CA state codes are larger than 2 letters. Also country codes
have a 3 characters ISO standard.  For details on ISO standards see:
https://en.wikipedia.org/wiki/ISO_3166-2

mysql> desc cms_module_cge_countries;
+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| id      | int(11)     | NO   | PRI | NULL    | auto_increment |
| code    | varchar(2)  | NO   | PRI | NULL    |                |
| name    | varchar(50) | YES  |     | NULL    |                |
| sorting | int(11)     | YES  |     | 0       |                |
+---------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> desc cms_module_cge_states;
+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| id      | int(11)     | NO   | PRI | NULL    | auto_increment |
| code    | varchar(2)  | NO   | PRI | NULL    |                |
| name    | varchar(50) | YES  |     | NULL    |                |
| sorting | int(11)     | YES  |     | 0       |                |
+---------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

History