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