From b668cf69b068d647af6d9cb394dbff7c2d0a78bf Mon Sep 17 00:00:00 2001
From: Eevee <git@veekun.com>
Date: Sat, 9 Apr 2011 22:22:58 -0700
Subject: [PATCH] Added identifiers for move meta categories.

---
 pokedex/data/csv/move_meta_categories.csv | 30 +++++++++++++++---------------
 pokedex/db/tables.py                      |  4 +++-
 2 files changed, 18 insertions(+), 16 deletions(-)

diff --git a/pokedex/data/csv/move_meta_categories.csv b/pokedex/data/csv/move_meta_categories.csv
index 75d5394..b904b53 100644
--- a/pokedex/data/csv/move_meta_categories.csv
+++ b/pokedex/data/csv/move_meta_categories.csv
@@ -1,15 +1,15 @@
-id
-0
-1
-2
-3
-4
-5
-6
-7
-8
-9
-10
-11
-12
-13
+id,identifier
+0,damage
+1,ailment
+2,net-good-stats
+3,heal
+4,damage+ailment
+5,swagger
+6,damage+lower
+7,damage+raise
+8,damage+heal
+9,ohko
+10,whole-field-effect
+11,field-effect
+12,force-switch
+13,unique
diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py
index 6747d88..08a9809 100644
--- a/pokedex/db/tables.py
+++ b/pokedex/db/tables.py
@@ -938,7 +938,7 @@ class MoveMetaAilment(TableBase):
     __singlename__ = 'move_meta_ailment'
     id = Column(Integer, primary_key=True, nullable=False, autoincrement=False,
         info=dict(description="A numeric ID"))
-    identifier = Column(Unicode(24), nullable=False,
+    identifier = Column(Unicode(24), nullable=False, index=True, unique=True,
         info=dict(description="An identifier", format='identifier'))
 
 create_translation_table('move_meta_ailment_names', MoveMetaAilment, 'names',
@@ -953,6 +953,8 @@ class MoveMetaCategory(TableBase):
     __singlename__ = 'move_meta_category'
     id = Column(Integer, primary_key=True, nullable=False,
         info=dict(description="A numeric ID"))
+    identifier = Column(Unicode(32), nullable=False, index=True, unique=True,
+        info=dict(description="An identifier", format='identifier'))
 
 create_translation_table('move_meta_category_prose', MoveMetaCategory, 'prose',
     relation_lazy='joined',
-- 
2.7.4