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 (file)
--- 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 (file)
--- 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)
     __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'
 
 class GrowthRate(TableBase):
     __tablename__ = 'growth_rates'