|
10 | 10 | # |
11 | 11 | # It's strongly recommended that you check this file into your version control system. |
12 | 12 |
|
13 | | -ActiveRecord::Schema.define(version: 20160731182106) do |
| 13 | +ActiveRecord::Schema.define(version: 2016_07_31_182106) do |
14 | 14 |
|
15 | | - create_table "addresses", force: :cascade do |t| |
16 | | - t.string "street" |
17 | | - t.string "city" |
18 | | - t.string "state" |
19 | | - t.string "zip" |
| 15 | + create_table "addresses", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 16 | + t.string "street" |
| 17 | + t.string "city" |
| 18 | + t.string "state" |
| 19 | + t.string "zip" |
20 | 20 | t.datetime "created_at" |
21 | 21 | t.datetime "updated_at" |
22 | 22 | end |
23 | 23 |
|
24 | | - create_table "child_models", force: :cascade do |t| |
25 | | - t.string "child_attribute" |
26 | | - t.integer "test_model_id" |
| 24 | + create_table "bones", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 25 | + t.integer "dog_id" |
27 | 26 | end |
28 | 27 |
|
29 | | - create_table "comments", force: :cascade do |t| |
30 | | - t.text "comment" |
| 28 | + create_table "child_models", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 29 | + t.string "child_attribute" |
| 30 | + t.bigint "test_model_id" |
| 31 | + t.index ["test_model_id"], name: "index_child_models_on_test_model_id" |
| 32 | + end |
| 33 | + |
| 34 | + create_table "comments", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 35 | + t.text "comment" |
31 | 36 | t.datetime "created_at" |
32 | 37 | t.datetime "updated_at" |
33 | | - t.integer "todo_id" |
34 | | - t.integer "author_id" |
35 | | - t.integer "user_id" |
36 | | - t.integer "todo_item_id" |
| 38 | + t.bigint "todo_id" |
| 39 | + t.bigint "author_id" |
| 40 | + t.integer "user_id" |
| 41 | + t.integer "todo_item_id" |
| 42 | + t.index ["author_id"], name: "index_comments_on_author_id" |
| 43 | + t.index ["todo_id"], name: "index_comments_on_todo_id" |
37 | 44 | end |
38 | 45 |
|
39 | | - create_table "hyperstack_connections", force: :cascade do |t| |
40 | | - t.string "channel" |
41 | | - t.string "session" |
| 46 | + create_table "hyperstack_connections", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 47 | + t.string "channel" |
| 48 | + t.string "session" |
42 | 49 | t.datetime "created_at" |
43 | 50 | t.datetime "expires_at" |
44 | 51 | t.datetime "refresh_at" |
45 | 52 | end |
46 | 53 |
|
47 | | - create_table "hyperstack_queued_messages", force: :cascade do |t| |
48 | | - t.text "data" |
| 54 | + create_table "hyperstack_queued_messages", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 55 | + t.text "data" |
49 | 56 | t.integer "connection_id" |
50 | 57 | end |
51 | 58 |
|
52 | | - create_table "test_models", force: :cascade do |t| |
53 | | - t.string "test_attribute" |
54 | | - t.boolean "completed" |
55 | | - t.datetime "created_at", null: false |
56 | | - t.datetime "updated_at", null: false |
| 59 | + create_table "pets", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 60 | + t.integer "owner_id" |
| 61 | + end |
| 62 | + |
| 63 | + create_table "scratching_posts", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 64 | + t.integer "cat_id" |
| 65 | + end |
| 66 | + |
| 67 | + create_table "test_models", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 68 | + t.string "test_attribute" |
| 69 | + t.boolean "completed" |
| 70 | + t.datetime "created_at", null: false |
| 71 | + t.datetime "updated_at", null: false |
57 | 72 | end |
58 | 73 |
|
59 | | - create_table "todo_items", force: :cascade do |t| |
60 | | - t.string "title" |
61 | | - t.text "description" |
62 | | - t.boolean "complete" |
| 74 | + create_table "todo_items", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 75 | + t.string "title" |
| 76 | + t.text "description" |
| 77 | + t.boolean "complete" |
63 | 78 | t.datetime "created_at" |
64 | 79 | t.datetime "updated_at" |
65 | | - t.integer "user_id" |
66 | | - t.integer "comment_id" |
| 80 | + t.integer "user_id" |
| 81 | + t.integer "comment_id" |
67 | 82 | end |
68 | 83 |
|
69 | | - create_table "todos", force: :cascade do |t| |
70 | | - t.string "title" |
71 | | - t.text "description" |
72 | | - t.datetime "created_at", null: false |
73 | | - t.datetime "updated_at", null: false |
74 | | - t.boolean "completed", default: false, null: false |
75 | | - t.integer "created_by_id" |
76 | | - t.integer "owner_id" |
| 84 | + create_table "todos", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 85 | + t.string "title" |
| 86 | + t.text "description" |
| 87 | + t.datetime "created_at", null: false |
| 88 | + t.datetime "updated_at", null: false |
| 89 | + t.boolean "completed", default: false, null: false |
| 90 | + t.bigint "created_by_id" |
| 91 | + t.bigint "owner_id" |
| 92 | + t.index ["created_by_id"], name: "index_todos_on_created_by_id" |
| 93 | + t.index ["owner_id"], name: "index_todos_on_owner_id" |
77 | 94 | end |
78 | 95 |
|
79 | | - create_table "users", force: :cascade do |t| |
80 | | - t.string "role" |
81 | | - t.integer "manager_id" |
82 | | - t.string "first_name" |
83 | | - t.string "last_name" |
84 | | - t.string "email" |
| 96 | + create_table "users", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t| |
| 97 | + t.string "role" |
| 98 | + t.bigint "manager_id" |
| 99 | + t.string "first_name" |
| 100 | + t.string "last_name" |
| 101 | + t.string "email" |
85 | 102 | t.datetime "created_at" |
86 | 103 | t.datetime "updated_at" |
87 | | - t.string "address_street" |
88 | | - t.string "address_city" |
89 | | - t.string "address_state" |
90 | | - t.string "address_zip" |
91 | | - t.integer "address_id" |
92 | | - t.string "address2_street" |
93 | | - t.string "address2_city" |
94 | | - t.string "address2_state" |
95 | | - t.string "address2_zip" |
96 | | - t.string "data_string" |
97 | | - t.integer "data_times" |
98 | | - t.integer "test_enum" |
| 104 | + t.string "address_street" |
| 105 | + t.string "address_city" |
| 106 | + t.string "address_state" |
| 107 | + t.string "address_zip" |
| 108 | + t.integer "address_id" |
| 109 | + t.string "address2_street" |
| 110 | + t.string "address2_city" |
| 111 | + t.string "address2_state" |
| 112 | + t.string "address2_zip" |
| 113 | + t.string "data_string" |
| 114 | + t.integer "data_times" |
| 115 | + t.integer "test_enum" |
| 116 | + t.index ["manager_id"], name: "index_users_on_manager_id" |
99 | 117 | end |
100 | 118 |
|
101 | 119 | end |
0 commit comments