I have a list of country and city names in utf8. When either list is fetched, it should return in the same order it was entered.

For example:

```
Country(country_name|PK)
City(city_name|PK, country_name|FK)

```

Country\_name and city\_name won't change, fixed values. However, ordering would be an issue. To make sure i retain the order values were entered as

```
Country:
UK
US
Africa

```

I added a new column called sortcountry which will numeric values from 1 and up.

```
Country(country_name|PK, sortcountry)

```

Same thing applied to City table.

I think this is a better solution than `country(country_id, countryname)`. Am i doing the right thing?