about summary refs log tree commit diff stats
path: root/test/dummy/db
diff options
context:
space:
mode:
Diffstat (limited to 'test/dummy/db')
-rw-r--r--test/dummy/db/schema.rb99
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
13ActiveRecord::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
99end