From 1d621019d7bf74b65898e009aef31766c7e7572b Mon Sep 17 00:00:00 2001 From: Kelly Rauchenberger Date: Sat, 16 Sep 2017 22:40:16 -0400 Subject: Created a bunch of models --- .../20170916225306_create_pokeviewer_trainers.rb | 13 +++++++++ .../20170916232015_create_pokeviewer_species.rb | 11 ++++++++ .../20170916234251_create_pokeviewer_pokemon.rb | 31 ++++++++++++++++++++++ .../20170917002857_create_pokeviewer_revisions.rb | 31 ++++++++++++++++++++++ .../20170917011102_create_pokeviewer_moves.rb | 12 +++++++++ ...70917011258_create_pokeviewer_revision_moves.rb | 20 ++++++++++++++ 6 files changed, 118 insertions(+) create mode 100644 db/migrate/20170916225306_create_pokeviewer_trainers.rb create mode 100644 db/migrate/20170916232015_create_pokeviewer_species.rb create mode 100644 db/migrate/20170916234251_create_pokeviewer_pokemon.rb create mode 100644 db/migrate/20170917002857_create_pokeviewer_revisions.rb create mode 100644 db/migrate/20170917011102_create_pokeviewer_moves.rb create mode 100644 db/migrate/20170917011258_create_pokeviewer_revision_moves.rb (limited to 'db/migrate') diff --git a/db/migrate/20170916225306_create_pokeviewer_trainers.rb b/db/migrate/20170916225306_create_pokeviewer_trainers.rb new file mode 100644 index 0000000..18e7952 --- /dev/null +++ b/db/migrate/20170916225306_create_pokeviewer_trainers.rb @@ -0,0 +1,13 @@ +class CreatePokeviewerTrainers < ActiveRecord::Migration[5.1] + def change + create_table :pokeviewer_trainers do |t| + t.string :game, null: false + t.string :name, null: false, limit: 191 + t.integer :number, null: false + + t.timestamps + end + + add_index :pokeviewer_trainers, [:name, :number], unique: true + end +end diff --git a/db/migrate/20170916232015_create_pokeviewer_species.rb b/db/migrate/20170916232015_create_pokeviewer_species.rb new file mode 100644 index 0000000..e6d5c09 --- /dev/null +++ b/db/migrate/20170916232015_create_pokeviewer_species.rb @@ -0,0 +1,11 @@ +class CreatePokeviewerSpecies < ActiveRecord::Migration[5.1] + def change + create_table :pokeviewer_species do |t| + t.string :name, null: false, limit: 191 + + t.timestamps + end + + add_index :pokeviewer_species, :name, unique: true + end +end diff --git a/db/migrate/20170916234251_create_pokeviewer_pokemon.rb b/db/migrate/20170916234251_create_pokeviewer_pokemon.rb new file mode 100644 index 0000000..dd9994c --- /dev/null +++ b/db/migrate/20170916234251_create_pokeviewer_pokemon.rb @@ -0,0 +1,31 @@ +class CreatePokeviewerPokemon < ActiveRecord::Migration[5.1] + def change + create_table :pokeviewer_pokemon do |t| + t.string :uuid, null: false, limit: 191 + t.references :species, null: false + t.references :trainer, null: true + t.string :key, null: true, limit: 191 + t.string :ot_name, null: false + t.integer :ot_number, null: false + t.string :met_type, null: false + t.string :met_location, null: true + t.integer :met_level, null: false + t.boolean :shiny, null: false, default: false + t.string :nature, null: false + t.string :gender, null: false + t.boolean :second_ability, null: false + t.string :unown_letter, null: true, limit: 1 + + t.timestamps + end + + add_index :pokeviewer_pokemon, :uuid, unique: true + add_index :pokeviewer_pokemon, :key, unique: true + + add_foreign_key :pokeviewer_pokemon, :pokeviewer_species, + column: :species_id + + add_foreign_key :pokeviewer_pokemon, :pokeviewer_trainer, + column: :trainer_id + end +end diff --git a/db/migrate/20170917002857_create_pokeviewer_revisions.rb b/db/migrate/20170917002857_create_pokeviewer_revisions.rb new file mode 100644 index 0000000..f6755da --- /dev/null +++ b/db/migrate/20170917002857_create_pokeviewer_revisions.rb @@ -0,0 +1,31 @@ +class CreatePokeviewerRevisions < ActiveRecord::Migration[5.1] + def change + create_table :pokeviewer_revisions do |t| + t.references :pokemon, null: false + t.integer :sequential_id, null: false + t.string :nickname, null: false + t.integer :experience, null: false + t.integer :level, null: false + t.integer :hp, null: false + t.integer :attack, null: false + t.integer :defense, null: false + t.integer :special_attack, null: false + t.integer :special_defense, null: false + t.integer :speed, null: false + t.integer :coolness, null: false + t.integer :beauty, null: false + t.integer :cuteness, null: false + t.integer :smartness, null: false + t.integer :toughness, null: false + t.integer :sheen, null: false + t.integer :hold_item, null: true + + t.timestamps + end + + add_index :pokeviewer_revisions, [:pokemon_id, :sequential_id], unique: true + + add_foreign_key :pokeviewer_revisions, :pokewalker_pokemon, + column: :pokemon_id + end +end diff --git a/db/migrate/20170917011102_create_pokeviewer_moves.rb b/db/migrate/20170917011102_create_pokeviewer_moves.rb new file mode 100644 index 0000000..86bf45f --- /dev/null +++ b/db/migrate/20170917011102_create_pokeviewer_moves.rb @@ -0,0 +1,12 @@ +class CreatePokeviewerMoves < ActiveRecord::Migration[5.1] + def change + create_table :pokeviewer_moves do |t| + t.string :name, null: false, limit: 191 + t.integer :pp, null: false + + t.timestamps + end + + add_index :pokeviewer_moves, :name, unique: true + end +end diff --git a/db/migrate/20170917011258_create_pokeviewer_revision_moves.rb b/db/migrate/20170917011258_create_pokeviewer_revision_moves.rb new file mode 100644 index 0000000..e061207 --- /dev/null +++ b/db/migrate/20170917011258_create_pokeviewer_revision_moves.rb @@ -0,0 +1,20 @@ +class CreatePokeviewerRevisionMoves < ActiveRecord::Migration[5.1] + def change + create_table :pokeviewer_revision_moves do |t| + t.references :revision, null: false + t.references :move, null: false + t.integer :number, null: false + t.integer :pp_bonuses, null: false, default: 0 + + t.timestamps + end + + add_index :pokeviewer_revision_moves, [:revision_id, :number], unique: true + + add_foreign_key :pokeviewer_revision_moves, :pokeviewer_revisions, + column: :revision_id + + add_foreign_key :pokeviewer_revision_moves, :pokeviewer_moves, + column: :move_id + end +end -- cgit 1.4.1