From: Eevee <git@veekun.com>
Date: Wed, 4 Mar 2009 01:58:10 +0000 (-0800)
Subject: Added region names to the generations table.
X-Git-Tag: veekun-promotions/2010050901~296
X-Git-Url: http://git.veekun.com/zzz-pokedex.git/commitdiff_plain/5a00063bacd17e48547e943444597e3ee8be1972

Added region names to the generations table.
---

diff --git a/pokedex/data/csv/generations.csv b/pokedex/data/csv/generations.csv
index e503bbb..31c91ff 100644
--- a/pokedex/data/csv/generations.csv
+++ b/pokedex/data/csv/generations.csv
@@ -1,5 +1,5 @@
-id,name
-1,Generation I
-2,Generation II
-3,Generation III
-4,Generation IV
+id,name,main_region
+1,Generation I,Kanto
+2,Generation II,Johto
+3,Generation III,Hoenn
+4,Generation IV,Sinnoh
diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py
index f946078..1829f25 100644
--- a/pokedex/db/tables.py
+++ b/pokedex/db/tables.py
@@ -44,6 +44,7 @@ class Generation(TableBase):
     __tablename__ = 'generations'
     id = Column(Integer, primary_key=True, nullable=False)
     name = Column(Unicode(16), nullable=False)
+    main_region = Column(Unicode(16), nullable=False)
 
 class GrowthRate(TableBase):
     __tablename__ = 'growth_rates'