From a1fea05db3370fc99269a35bcbcd7892b4014229 Mon Sep 17 00:00:00 2001
From: Eevee <git@veekun.com>
Date: Sat, 9 Apr 2011 22:58:40 -0700
Subject: [PATCH] Remove old move effect categories.  #389

---
 pokedex/data/csv/move_effect_categories.csv     |  38 ---
 pokedex/data/csv/move_effect_category_map.csv   | 402 ------------------------
 pokedex/data/csv/move_effect_category_prose.csv |  38 ---
 pokedex/db/tables.py                            |  31 --
 4 files changed, 509 deletions(-)
 delete mode 100644 pokedex/data/csv/move_effect_categories.csv
 delete mode 100644 pokedex/data/csv/move_effect_category_map.csv
 delete mode 100644 pokedex/data/csv/move_effect_category_prose.csv

diff --git a/pokedex/data/csv/move_effect_categories.csv b/pokedex/data/csv/move_effect_categories.csv
deleted file mode 100644
index 2b743cd..0000000
--- a/pokedex/data/csv/move_effect_categories.csv
+++ /dev/null
@@ -1,38 +0,0 @@
-id,identifier,can_affect_user
-1,regular-damage,1
-2,power-varies,1
-3,special-damage,1
-4,double-damage,1
-5,faints,1
-6,critical,0
-7,ignores-type,0
-8,ignores-accuracy-modifiers,0
-9,meta,1
-10,multiple-turnshits,0
-11,charge-or-recovery-turn,0
-12,heals-hp,1
-13,cures-status,1
-14,protection,1
-15,attack-up,1
-16,attack-down,1
-17,defense-up,1
-18,defense-down,1
-19,special-attack-up,1
-20,special-attack-down,1
-21,special-defense-up,1
-22,special-defense-down,1
-23,speed-up,1
-24,speed-down,1
-25,accuracy-up,1
-26,accuracy-down,1
-27,evasion-up,1
-28,evasion-down,1
-29,sleep,1
-30,burn,1
-31,paralysis,1
-32,freeze,1
-33,poison,1
-34,confusion,1
-35,flinch,1
-36,trap,1
-37,weather,0
diff --git a/pokedex/data/csv/move_effect_category_map.csv b/pokedex/data/csv/move_effect_category_map.csv
deleted file mode 100644
index 5a8129b..0000000
--- a/pokedex/data/csv/move_effect_category_map.csv
+++ /dev/null
@@ -1,402 +0,0 @@
-move_effect_id,move_effect_category_id,affects_user
-1,1,0
-2,29,0
-3,1,0
-3,33,0
-4,1,0
-4,12,1
-5,1,0
-5,30,0
-6,1,0
-6,32,0
-7,1,0
-7,31,0
-8,1,0
-8,5,1
-9,1,0
-9,12,1
-10,9,0
-11,15,1
-12,17,1
-14,19,1
-17,27,1
-18,1,0
-18,8,0
-19,16,0
-20,18,0
-21,24,0
-24,26,0
-25,28,0
-26,13,1
-27,3,0
-27,10,0
-28,1,0
-28,10,0
-28,34,1
-30,1,0
-30,10,0
-32,1,0
-32,35,0
-33,12,1
-34,33,0
-35,1,0
-36,14,1
-37,1,0
-37,30,0
-37,31,0
-37,32,0
-38,12,1
-38,13,1
-38,29,1
-39,5,0
-39,8,0
-40,1,0
-40,6,0
-40,11,0
-41,3,0
-42,3,0
-43,1,0
-43,10,0
-43,36,0
-44,1,0
-44,6,0
-45,1,0
-45,10,0
-46,1,0
-46,3,1
-47,14,1
-49,1,0
-49,3,1
-50,34,0
-51,15,1
-52,17,1
-53,23,1
-54,19,1
-55,21,1
-58,9,0
-59,16,0
-60,18,0
-61,24,0
-63,22,0
-66,14,1
-67,33,0
-68,31,0
-69,1,0
-69,16,0
-70,1,0
-70,18,0
-71,1,0
-71,24,0
-72,1,0
-72,20,0
-73,1,0
-73,22,0
-74,1,0
-74,26,0
-76,1,0
-76,11,0
-76,35,0
-77,1,0
-77,34,0
-78,1,0
-78,10,0
-78,33,0
-79,1,0
-79,8,0
-80,3,1
-80,14,1
-81,1,0
-81,11,0
-82,1,0
-82,15,1
-83,9,0
-84,9,0
-85,3,0
-85,12,1
-88,3,0
-88,7,0
-89,3,0
-89,7,0
-90,3,0
-92,3,0
-92,3,1
-92,12,0
-92,12,1
-93,1,0
-93,35,0
-94,14,0
-96,9,0
-98,9,0
-99,5,0
-100,1,0
-100,2,0
-102,1,0
-102,14,0
-103,13,1
-104,1,0
-105,1,0
-105,2,0
-105,10,0
-106,1,0
-107,8,0
-107,36,0
-108,3,0
-108,10,0
-109,27,1
-110,3,0
-110,3,1
-110,10,0
-110,15,1
-110,17,1
-110,24,1
-112,14,1
-114,8,0
-114,27,0
-114,28,0
-115,5,0
-115,5,1
-115,10,0
-116,37,0
-117,14,1
-118,1,0
-118,2,0
-119,15,0
-119,34,0
-120,1,0
-120,2,0
-122,1,0
-122,2,0
-123,1,0
-123,2,0
-123,12,0
-124,1,0
-124,2,0
-125,14,1
-126,1,0
-126,30,0
-127,1,0
-127,2,0
-129,1,0
-129,4,0
-130,1,0
-130,13,1
-131,3,0
-133,12,1
-136,1,0
-136,2,0
-137,37,0
-138,37,0
-139,1,0
-139,17,1
-140,1,0
-140,15,1
-141,1,0
-141,15,1
-141,17,1
-141,19,1
-141,21,1
-141,23,1
-143,3,1
-143,15,1
-145,3,0
-146,1,0
-146,11,0
-146,17,1
-147,1,0
-147,35,0
-148,1,0
-149,1,0
-149,7,0
-149,10,0
-150,1,0
-151,1,0
-151,35,0
-152,1,0
-152,11,0
-153,1,0
-153,31,0
-155,1,0
-155,7,0
-155,10,0
-156,1,0
-156,11,0
-157,17,1
-159,1,0
-159,35,0
-160,1,0
-160,10,0
-161,17,1
-161,21,1
-162,1,0
-162,2,0
-163,12,1
-165,37,0
-167,19,0
-167,34,0
-168,30,0
-169,5,1
-169,16,0
-169,20,0
-170,1,0
-170,4,0
-171,1,0
-172,1,0
-172,4,0
-172,13,0
-173,14,1
-174,9,0
-175,21,1
-179,8,0
-180,12,1
-181,9,0
-182,12,1
-182,36,1
-183,1,0
-183,16,1
-183,18,1
-186,1,0
-186,4,0
-187,1,0
-188,29,0
-189,1,0
-190,3,0
-191,1,0
-191,2,0
-192,8,0
-194,13,1
-196,9,0
-197,1,0
-197,2,0
-198,1,0
-198,16,0
-198,26,0
-198,29,0
-198,31,0
-198,32,0
-198,35,0
-199,1,0
-199,3,1
-200,34,0
-201,1,0
-201,6,0
-201,30,0
-203,1,0
-203,33,0
-204,1,0
-204,4,0
-205,1,0
-205,20,1
-206,16,0
-206,18,0
-207,20,0
-207,22,0
-208,1,0
-209,15,1
-209,17,1
-210,1,0
-210,6,0
-210,33,0
-212,19,1
-212,21,1
-213,15,1
-213,23,1
-215,12,1
-217,8,0
-217,28,0
-218,1,0
-218,4,0
-218,13,0
-219,1,0
-219,24,1
-220,1,0
-220,2,0
-221,5,1
-221,12,1
-221,13,1
-222,1,0
-222,4,0
-223,1,0
-223,2,0
-224,1,0
-225,1,0
-225,4,0
-226,23,1
-227,15,1
-227,17,1
-227,19,1
-227,21,1
-227,23,1
-228,3,0
-229,1,0
-230,1,0
-230,18,1
-230,22,1
-231,1,0
-231,2,0
-232,1,0
-232,2,0
-234,1,0
-234,2,0
-235,13,1
-236,1,0
-236,2,0
-238,1,0
-238,2,0
-239,15,1
-239,16,1
-239,17,1
-239,18,1
-242,9,0
-243,9,0
-246,1,0
-246,2,0
-247,1,0
-249,1,0
-252,12,1
-254,1,0
-254,3,1
-254,30,0
-255,1,0
-255,3,1
-255,7,0
-256,1,0
-256,11,0
-257,1,0
-257,11,0
-258,1,0
-259,28,0
-261,1,0
-261,32,0
-262,1,0
-262,4,0
-262,10,0
-262,36,0
-263,1,0
-263,3,1
-263,31,0
-264,1,0
-264,11,0
-266,20,0
-268,1,0
-268,34,0
-269,1,0
-270,1,0
-270,3,1
-271,3,1
-271,12,1
-271,13,1
-272,1,0
-272,22,0
-273,1,0
-273,11,0
-274,1,0
-274,30,0
-274,35,0
-275,1,0
-275,32,0
-275,35,0
-276,1,0
-276,31,0
-276,35,0
-277,1,0
-277,19,1
diff --git a/pokedex/data/csv/move_effect_category_prose.csv b/pokedex/data/csv/move_effect_category_prose.csv
deleted file mode 100644
index edf7734..0000000
--- a/pokedex/data/csv/move_effect_category_prose.csv
+++ /dev/null
@@ -1,38 +0,0 @@
-move_effect_category_id,local_language_id,name
-1,9,Regular damage
-2,9,Power varies
-3,9,Special damage
-4,9,Double damage
-5,9,Faints
-6,9,Critical
-7,9,Ignores type
-8,9,Ignores accuracy modifiers
-9,9,Meta
-10,9,Multiple turns/hits
-11,9,Charge or recovery turn
-12,9,Heals HP
-13,9,Cures status
-14,9,Protection
-15,9,Attack up
-16,9,Attack down
-17,9,Defense up
-18,9,Defense down
-19,9,Special Attack up
-20,9,Special Attack down
-21,9,Special Defense up
-22,9,Special Defense down
-23,9,Speed up
-24,9,Speed down
-25,9,Accuracy up
-26,9,Accuracy down
-27,9,Evasion up
-28,9,Evasion down
-29,9,Sleep
-30,9,Burn
-31,9,Paralysis
-32,9,Freeze
-33,9,Poison
-34,9,Confusion
-35,9,Flinch
-36,9,Trap
-37,9,Weather
diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py
index 08a9809..a42c8f7 100644
--- a/pokedex/db/tables.py
+++ b/pokedex/db/tables.py
@@ -808,34 +808,6 @@ create_translation_table('move_effect_prose', MoveEffect, 'prose',
         info=dict(description="A detailed description of the effect", format='plaintext')),
 )
 
-class MoveEffectCategory(TableBase):
-    u"""Category of a move effect
-    """
-    __tablename__ = 'move_effect_categories'
-    __singlename__ = 'move_effect_category'
-    id = Column(Integer, primary_key=True, nullable=False,
-        info=dict(description="A numeric ID"))
-    identifier = Column(Unicode(64), nullable=False,
-        info=dict(description="An identifier", format='identifier'))
-    can_affect_user = Column(Boolean, nullable=False,
-        info=dict(description="Set if the user can be affected"))
-
-create_translation_table('move_effect_category_prose', MoveEffectCategory, 'prose',
-    name = Column(Unicode(64), nullable=False, index=True,
-        info=dict(description="The name", format='plaintext', official=False)),
-)
-
-class MoveEffectCategoryMap(TableBase):
-    u"""Maps a move effect category to a move effect
-    """
-    __tablename__ = 'move_effect_category_map'
-    move_effect_id = Column(Integer, ForeignKey('move_effects.id'), primary_key=True, nullable=False,
-        info=dict(description="ID of the move effect"))
-    move_effect_category_id = Column(Integer, ForeignKey('move_effect_categories.id'), primary_key=True, nullable=False,
-        info=dict(description="ID of the category"))
-    affects_user = Column(Boolean, primary_key=True, nullable=False,
-        info=dict(description="Set if the user is affected"))
-
 class MoveEffectChangelog(TableBase):
     """History of changes to move effects across main game versions."""
     __tablename__ = 'move_effect_changelog'
@@ -1902,12 +1874,9 @@ MoveChangelog.effect_map = markdown.MoveEffectPropertyMap('effect_map')
 MoveChangelog.short_effect = markdown.MoveEffectProperty('short_effect')
 MoveChangelog.short_effect_map = markdown.MoveEffectPropertyMap('short_effect_map')
 
-MoveEffect.category_map = relation(MoveEffectCategoryMap)
-MoveEffect.categories = association_proxy('category_map', 'category')
 MoveEffect.changelog = relation(MoveEffectChangelog,
     order_by=MoveEffectChangelog.changed_in_version_group_id.desc(),
     backref='move_effect')
-MoveEffectCategoryMap.category = relation(MoveEffectCategory)
 
 MoveEffectChangelog.changed_in = relation(VersionGroup,
     innerjoin=True, lazy='joined',
-- 
2.7.4