Last modified: 2013-12-10 23:02:19 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T59547, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 57547 - Use ISO country codes instead of a numeric id to reference countries
Use ISO country codes instead of a numeric id to reference countries
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
Wikimania Scholarships (Other open bugs)
wmf-deployment
All All
: High major (vote)
: ---
Assigned To: Bryan Davis
:
Depends on:
Blocks: 57545
  Show dependency treegraph
 
Reported: 2013-11-25 17:26 UTC by Bryan Davis
Modified: 2013-12-10 23:02 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Bryan Davis 2013-11-25 17:26:32 UTC
The countries table uses a numeric autoincrement field as a primary key. This PK is used as a foreign key in the scholarships table. The existing system is fragile and requires synchronization of the keys in the countries table with element order in a PHP array. The application would be easier to maintain if we switched to using standard ISO 3166-1 alpha-2 country codes.
Comment 1 Gerrit Notification Bot 2013-11-26 00:03:56 UTC
Change 97654 had a related patch set uploaded by BryanDavis:
Use ISO 3166-1 alpha-2 country codes

https://gerrit.wikimedia.org/r/97654
Comment 2 Gerrit Notification Bot 2013-11-27 21:22:30 UTC
Change 97654 merged by jenkins-bot:
Use ISO 3166-1 alpha-2 country codes

https://gerrit.wikimedia.org/r/97654

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links