After briefly review the table structure, I have the following suggestions:
CONFIG_NEW Add C_NAME TEXT 255 (for MOD development similar to how slash was created)
FORUM F_PASSWORD_NEW TEXT 255 -> TEXT 65 (to follow other password defs)
MEMBERS M_COUNTRY TEXT 50 -> TEXT 75 or NUM (dropdown option from inc_countrylist.asp) M_FIRSTNAME TEXT 100 -> TEXT 50 M_LASTNAME TEXT 100 -> TEXT 50 M_SEX TEXT 50 -> M_GENDER TEXT 25 M_MARSTATUS TEXT 100 -> NUM (add dropdown options) M_STATE TEXT 100 -> TEXT 2 (state abbreviation) or NUM (add dropdown options in inc_countrylist.asp) M_AIM/M_ICQ/M_MSN/M_YAHOO TEXT 150 -> TEXT 100? Add M_ZIPCODE TEXT 10 (99999-9999)
Zip code can be a very useful bit of information to include. I intend on adding it myself at some point so I can offer some services based on it such as weather forecasts. But I would leave it hidden.
quote:Zip code can be a very useful bit of information to include. I intend on adding it myself at some point so I can offer some services based on it such as weather forecasts.
I had a few ideas for zipcode also. Another possible use for it is city/state lookup and/or verification. Basically, for U.S. residents, a zipcode can eliminate the need for city AND state as they'd be included in a zipcode table. There were some other member fields I was considering adding as search fields for my particular application, but I thought zip could be used by others too.
Zip code can be a very useful bit of information to include. I intend on adding it myself at some point so I can offer some services based on it such as weather forecasts. But I would leave it hidden.
@tomic
US wise maybe. Don't think it's that important for the rest of us. I agree with Richard: changes like these should be left for mods-added tables.
Does this mean you'd approve adding a zipcode/postcode field which currently isn't in the database?
quote:USA <-> UK STATE <-> COUNTY
The idea behind supplying number fields here is to provide dropdowns for the countries and possibly for the states/counties associated with the selected country.
Topic Locked
Posted - 29 August 2002 : 11:26:19
