Added identifiers for move meta categories.

diff --git a/pokedex/data/csv/move_meta_categories.csv b/pokedex/data/csv/move_meta_categories.csv
index 75d5394..b904b53 100644 (file)
--- 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 (file)
--- 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"))
     __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',
         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"))
     __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',
 
 create_translation_table('move_meta_category_prose', MoveMetaCategory, 'prose',
     relation_lazy='joined',