spec/dummy/db/schema.rb in localtower-0.5.0 vs spec/dummy/db/schema.rb in localtower-1.0.0
- old
+ new
@@ -8,22 +8,34 @@
# migrations from scratch. Old migrations may fail to apply correctly if those
# migrations use external dependencies or application code.
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema[7.0].define(version: 2022_11_15_193642) do
+ActiveRecord::Schema[7.0].define(version: 2023_01_19_222106) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
+ create_table "posts", force: :cascade do |t|
+ t.string "title", null: false
+ t.string "content", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.bigint "user_id"
+ t.index ["title"], name: "index_posts_on_title"
+ t.index ["user_id"], name: "index_posts_on_user_id"
+ end
+
create_table "users", force: :cascade do |t|
- t.text "name"
- t.string "reference"
- t.integer "age"
+ t.string "email", null: false
+ t.integer "signin_count", default: 0, null: false
+ t.jsonb "metadata", default: {}, null: false
+ t.string "name"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
- t.string "family"
- t.string "lol"
- t.index ["age"], name: "index_users_on_age"
- t.index ["reference"], name: "index_users_on_reference"
+ t.string "city"
+ t.index ["city"], name: "index_users_on_city"
+ t.index ["email"], name: "index_users_on_email", unique: true
+ t.index ["name"], name: "index_users_on_name"
end
+ add_foreign_key "posts", "users"
end