spec/dummy/db/schema.rb in spina-admin-conferences-blog-0.1.4 vs spec/dummy/db/schema.rb in spina-admin-conferences-blog-0.2.0

- old
+ new

@@ -8,15 +8,43 @@ # 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.define(version: 2019_05_13_103739) do +ActiveRecord::Schema.define(version: 2021_04_04_093002) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" + create_table "active_storage_attachments", force: :cascade do |t| + t.string "name", null: false + t.string "record_type", null: false + t.bigint "record_id", null: false + t.bigint "blob_id", null: false + t.datetime "created_at", null: false + t.index ["blob_id"], name: "index_active_storage_attachments_on_blob_id" + t.index ["record_type", "record_id", "name", "blob_id"], name: "index_active_storage_attachments_uniqueness", unique: true + end + + create_table "active_storage_blobs", force: :cascade do |t| + t.string "key", null: false + t.string "filename", null: false + t.string "content_type" + t.text "metadata" + t.string "service_name", null: false + t.bigint "byte_size", null: false + t.string "checksum", null: false + t.datetime "created_at", null: false + t.index ["key"], name: "index_active_storage_blobs_on_key", unique: true + end + + create_table "active_storage_variant_records", force: :cascade do |t| + t.bigint "blob_id", null: false + t.string "variation_digest", null: false + t.index ["blob_id", "variation_digest"], name: "index_active_storage_variant_records_uniqueness", unique: true + end + create_table "friendly_id_slugs", id: :serial, force: :cascade do |t| t.string "slug", null: false t.integer "sluggable_id", null: false t.string "sluggable_type", limit: 50 t.string "scope" @@ -36,10 +64,11 @@ t.string "email" t.text "preferences" t.datetime "created_at", null: false t.datetime "updated_at", null: false t.boolean "robots_allowed", default: false + t.jsonb "json_attributes" end create_table "spina_attachment_collections", id: :serial, force: :cascade do |t| t.datetime "created_at", null: false t.datetime "updated_at", null: false @@ -180,10 +209,11 @@ t.string "description" t.string "seo_title" t.string "materialized_path" t.datetime "created_at", null: false t.datetime "updated_at", null: false + t.string "url_title" t.index ["locale"], name: "index_spina_page_translations_on_locale" t.index ["spina_page_id"], name: "index_spina_page_translations_on_spina_page_id" end create_table "spina_pages", id: :serial, force: :cascade do |t| @@ -200,10 +230,11 @@ t.string "link_url" t.string "ancestry" t.integer "position" t.boolean "active", default: true t.integer "resource_id" + t.jsonb "json_attributes" t.index ["resource_id"], name: "index_spina_pages_on_resource_id" end create_table "spina_resources", force: :cascade do |t| t.string "name", null: false @@ -211,10 +242,11 @@ t.string "view_template" t.integer "parent_page_id" t.string "order_by" t.datetime "created_at", null: false t.datetime "updated_at", null: false + t.jsonb "slug" t.index ["parent_page_id"], name: "index_spina_resources_on_parent_page_id" end create_table "spina_rewrite_rules", id: :serial, force: :cascade do |t| t.string "old_path" @@ -281,8 +313,10 @@ t.datetime "last_logged_in" t.string "password_reset_token" t.datetime "password_reset_sent_at" end + add_foreign_key "active_storage_attachments", "active_storage_blobs", column: "blob_id" + add_foreign_key "active_storage_variant_records", "active_storage_blobs", column: "blob_id" add_foreign_key "spina_blog_posts", "spina_images", column: "image_id" add_foreign_key "spina_blog_posts", "spina_users", column: "user_id" end