Added type and ability data to species model

2 files changed, 31 insertions, 0 deletions

@@ -0,0 +1,12 @@
+class CreatePokeviewerAbilities < ActiveRecord::Migration[5.1]
+  def change
+    create_table :pokeviewer_abilities do |t|
+      t.string :name, null: false, limit: 191
+      t.string :description, null: false
+
+      t.timestamps
+    end
+
+    add_index :pokeviewer_abilities, :name, unique: true
+  end
+end
@@ -0,0 +1,19 @@
+class AddTypeAndAbilityToSpecies < ActiveRecord::Migration[5.1]
+  def change
+    change_table :pokeviewer_species do |t|
+      t.string :type_1, null: false, default: ""
+      t.string :type_2
+      t.integer :ability_1_id, null: false, default: 0
+      t.integer :ability_2_id
+    end
+
+    change_column_default :pokeviewer_species, :type_1, nil
+    change_column_default :pokeviewer_species, :ability_1_id, nil
+
+    add_foreign_key :pokeviewer_species, :pokeviewer_abilities,
+      column: :ability_1_id
+
+    add_foreign_key :pokeviewer_species, :pokeviewer_abilities,
+      column: :ability_2_id
+  end
+end