From: Mischa POSLAWSKY <perl@shiar.org>
Date: Tue, 28 Apr 2009 00:29:01 +0000 (+0000)
Subject: cc: page listing names for ISO-3166 country codes
X-Git-Tag: v1.3~158
X-Git-Url: http://git.shiar.nl/sheet.git/commitdiff_plain/c26d5da0a9b989982e7897ff5712d0fc79a714b4?hp=c26d5da0a9b989982e7897ff5712d0fc79a714b4;ds=sidebyside

cc: page listing names for ISO-3166 country codes

Initial data set up using:

perl -MDBIx::Simple -MData::Dump=pp -e 'pp({
	DBIx::Simple->new("dbi:SQLite:dbname=locale.db")->query(q[
		SELECT country.code_alpha2, country.name, continent.name
		FROM country LEFT JOIN continent ON country.code_alpha2 = continent.country_code
		ORDER BY country.code_alpha2
	])->map_arrays(0)
})'
---