diff options
Diffstat (limited to 'test/dummy/db')
-rw-r--r-- | test/dummy/db/schema.rb | 99 |
1 files changed, 99 insertions, 0 deletions
diff --git a/test/dummy/db/schema.rb b/test/dummy/db/schema.rb new file mode 100644 index 0000000..4b5ad80 --- /dev/null +++ b/test/dummy/db/schema.rb | |||
@@ -0,0 +1,99 @@ | |||
1 | # This file is auto-generated from the current state of the database. Instead | ||
2 | # of editing this file, please use the migrations feature of Active Record to | ||
3 | # incrementally modify your database, and then regenerate this schema definition. | ||
4 | # | ||
5 | # Note that this schema.rb definition is the authoritative source for your | ||
6 | # database schema. If you need to create the application database on another | ||
7 | # system, you should be using db:schema:load, not running all the migrations | ||
8 | # from scratch. The latter is a flawed and unsustainable approach (the more migrations | ||
9 | # you'll amass, the slower it'll run and the greater likelihood for issues). | ||
10 | # | ||
11 | # It's strongly recommended that you check this file into your version control system. | ||
12 | |||
13 | ActiveRecord::Schema.define(version: 20170917011258) do | ||
14 | |||
15 | create_table "pokeviewer_moves", force: :cascade do |t| | ||
16 | t.string "name", limit: 191, null: false | ||
17 | t.integer "pp", null: false | ||
18 | t.datetime "created_at", null: false | ||
19 | t.datetime "updated_at", null: false | ||
20 | t.index ["name"], name: "index_pokeviewer_moves_on_name", unique: true | ||
21 | end | ||
22 | |||
23 | create_table "pokeviewer_pokemon", force: :cascade do |t| | ||
24 | t.string "uuid", limit: 191, null: false | ||
25 | t.integer "species_id", null: false | ||
26 | t.integer "trainer_id" | ||
27 | t.string "key", limit: 191 | ||
28 | t.string "ot_name", null: false | ||
29 | t.integer "ot_number", null: false | ||
30 | t.string "met_type", null: false | ||
31 | t.string "met_location" | ||
32 | t.integer "met_level", null: false | ||
33 | t.boolean "shiny", default: false, null: false | ||
34 | t.string "nature", null: false | ||
35 | t.string "gender", null: false | ||
36 | t.boolean "second_ability", null: false | ||
37 | t.string "unown_letter", limit: 1 | ||
38 | t.datetime "created_at", null: false | ||
39 | t.datetime "updated_at", null: false | ||
40 | t.index ["key"], name: "index_pokeviewer_pokemon_on_key", unique: true | ||
41 | t.index ["species_id"], name: "index_pokeviewer_pokemon_on_species_id" | ||
42 | t.index ["trainer_id"], name: "index_pokeviewer_pokemon_on_trainer_id" | ||
43 | t.index ["uuid"], name: "index_pokeviewer_pokemon_on_uuid", unique: true | ||
44 | end | ||
45 | |||
46 | create_table "pokeviewer_revision_moves", force: :cascade do |t| | ||
47 | t.integer "revision_id", null: false | ||
48 | t.integer "move_id", null: false | ||
49 | t.integer "number", null: false | ||
50 | t.integer "pp_bonuses", default: 0, null: false | ||
51 | t.datetime "created_at", null: false | ||
52 | t.datetime "updated_at", null: false | ||
53 | t.index ["move_id"], name: "index_pokeviewer_revision_moves_on_move_id" | ||
54 | t.index ["revision_id", "number"], name: "index_pokeviewer_revision_moves_on_revision_id_and_number", unique: true | ||
55 | t.index ["revision_id"], name: "index_pokeviewer_revision_moves_on_revision_id" | ||
56 | end | ||
57 | |||
58 | create_table "pokeviewer_revisions", force: :cascade do |t| | ||
59 | t.integer "pokemon_id", null: false | ||
60 | t.integer "sequential_id", null: false | ||
61 | t.string "nickname", null: false | ||
62 | t.integer "experience", null: false | ||
63 | t.integer "level", null: false | ||
64 | t.integer "hp", null: false | ||
65 | t.integer "attack", null: false | ||
66 | t.integer "defense", null: false | ||
67 | t.integer "special_attack", null: false | ||
68 | t.integer "special_defense", null: false | ||
69 | t.integer "speed", null: false | ||
70 | t.integer "coolness", null: false | ||
71 | t.integer "beauty", null: false | ||
72 | t.integer "cuteness", null: false | ||
73 | t.integer "smartness", null: false | ||
74 | t.integer "toughness", null: false | ||
75 | t.integer "sheen", null: false | ||
76 | t.integer "hold_item" | ||
77 | t.datetime "created_at", null: false | ||
78 | t.datetime "updated_at", null: false | ||
79 | t.index ["pokemon_id", "sequential_id"], name: "index_pokeviewer_revisions_on_pokemon_id_and_sequential_id", unique: true | ||
80 | t.index ["pokemon_id"], name: "index_pokeviewer_revisions_on_pokemon_id" | ||
81 | end | ||
82 | |||
83 | create_table "pokeviewer_species", force: :cascade do |t| | ||
84 | t.string "name", limit: 191, null: false | ||
85 | t.datetime "created_at", null: false | ||
86 | t.datetime "updated_at", null: false | ||
87 | t.index ["name"], name: "index_pokeviewer_species_on_name", unique: true | ||
88 | end | ||
89 | |||
90 | create_table "pokeviewer_trainers", force: :cascade do |t| | ||
91 | t.string "game", null: false | ||
92 | t.string "name", limit: 191, null: false | ||
93 | t.integer "number", null: false | ||
94 | t.datetime "created_at", null: false | ||
95 | t.datetime "updated_at", null: false | ||
96 | t.index ["name", "number"], name: "index_pokeviewer_trainers_on_name_and_number", unique: true | ||
97 | end | ||
98 | |||
99 | end | ||