From 5a00063bacd17e48547e943444597e3ee8be1972 Mon Sep 17 00:00:00 2001
From: Eevee <git@veekun.com>
Date: Tue, 3 Mar 2009 17:58:10 -0800
Subject: [PATCH] Added region names to the generations table.

---
 pokedex/data/csv/generations.csv | 10 +++++-----
 pokedex/db/tables.py             |  1 +
 2 files changed, 6 insertions(+), 5 deletions(-)

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'
-- 
2.7.4