diff options
Diffstat (limited to 'db/schema.rb')
-rw-r--r-- | db/schema.rb | 142 |
1 files changed, 141 insertions, 1 deletions
diff --git a/db/schema.rb b/db/schema.rb index 8afc9c6..b121c20 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,81 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20130125203718) do +ActiveRecord::Schema.define(:version => 20130611193621) do + + create_table "refinery_blog_categories", :force => true do |t| + t.string "title" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + t.string "cached_slug" + t.string "slug" + end + + add_index "refinery_blog_categories", ["id"], :name => "index_refinery_blog_categories_on_id" + add_index "refinery_blog_categories", ["slug"], :name => "index_refinery_blog_categories_on_slug" + + create_table "refinery_blog_categories_blog_posts", :force => true do |t| + t.integer "blog_category_id" + t.integer "blog_post_id" + end + + add_index "refinery_blog_categories_blog_posts", ["blog_category_id", "blog_post_id"], :name => "index_blog_categories_blog_posts_on_bc_and_bp" + + create_table "refinery_blog_comments", :force => true do |t| + t.integer "blog_post_id" + t.boolean "spam" + t.string "name" + t.string "email" + t.text "body" + t.string "state" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + + add_index "refinery_blog_comments", ["id"], :name => "index_refinery_blog_comments_on_id" + + create_table "refinery_blog_posts", :force => true do |t| + t.string "title" + t.text "body" + t.boolean "draft" + t.datetime "published_at" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + t.integer "user_id" + t.string "cached_slug" + t.string "custom_url" + t.text "custom_teaser" + t.string "source_url" + t.string "source_url_title" + t.integer "access_count", :default => 0 + t.string "slug" + end + + add_index "refinery_blog_posts", ["access_count"], :name => "index_refinery_blog_posts_on_access_count" + add_index "refinery_blog_posts", ["id"], :name => "index_refinery_blog_posts_on_id" + add_index "refinery_blog_posts", ["slug"], :name => "index_refinery_blog_posts_on_slug" + + create_table "refinery_image_page_translations", :force => true do |t| + t.integer "refinery_image_page_id" + t.string "locale" + t.text "caption" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + + add_index "refinery_image_page_translations", ["locale"], :name => "index_refinery_image_page_translations_on_locale" + add_index "refinery_image_page_translations", ["refinery_image_page_id"], :name => "index_186c9a170a0ab319c675aa80880ce155d8f47244" + + create_table "refinery_image_pages", :force => true do |t| + t.integer "image_id" + t.integer "page_id" + t.integer "position" + t.text "caption" + t.string "page_type", :default => "page" + end + + add_index "refinery_image_pages", ["image_id"], :name => "index_refinery_image_pages_on_image_id" + add_index "refinery_image_pages", ["page_id"], :name => "index_refinery_image_pages_on_page_id" create_table "refinery_images", :force => true do |t| t.string "image_mime_type" @@ -25,6 +99,18 @@ ActiveRecord::Schema.define(:version => 20130125203718) do t.datetime "updated_at", :null => false end + create_table "refinery_inquiries_inquiries", :force => true do |t| + t.string "name" + t.string "email" + t.string "phone" + t.text "message" + t.boolean "spam", :default => false + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + + add_index "refinery_inquiries_inquiries", ["id"], :name => "index_refinery_inquiries_inquiries_on_id" + create_table "refinery_page_part_translations", :force => true do |t| t.integer "refinery_page_part_id" t.string "locale" @@ -109,6 +195,19 @@ ActiveRecord::Schema.define(:version => 20130125203718) do add_index "refinery_roles_users", ["role_id", "user_id"], :name => "index_refinery_roles_users_on_role_id_and_user_id" add_index "refinery_roles_users", ["user_id", "role_id"], :name => "index_refinery_roles_users_on_user_id_and_role_id" + create_table "refinery_settings", :force => true do |t| + t.string "name" + t.text "value" + t.boolean "destroyable", :default => true + t.string "scoping" + t.boolean "restricted", :default => false + t.string "form_value_type" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + + add_index "refinery_settings", ["name"], :name => "index_refinery_settings_on_name" + create_table "refinery_user_plugins", :force => true do |t| t.integer "user_id" t.string "name" @@ -136,6 +235,30 @@ ActiveRecord::Schema.define(:version => 20130125203718) do add_index "refinery_users", ["id"], :name => "index_refinery_users_on_id" + create_table "refinery_video_files", :force => true do |t| + t.string "file_name" + t.integer "file_size" + t.string "file_ext" + t.string "file_uid" + t.string "file_mime_type" + t.integer "video_id" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + t.string "external_url" + t.boolean "use_external" + end + + create_table "refinery_videos", :force => true do |t| + t.integer "position" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + t.string "config" + t.string "title" + t.integer "poster_id" + t.boolean "use_shared" + t.text "embed_tag" + end + create_table "seo_meta", :force => true do |t| t.integer "seo_meta_id" t.string "seo_meta_type" @@ -159,4 +282,21 @@ ActiveRecord::Schema.define(:version => 20130125203718) do add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id" add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at" + create_table "taggings", :force => true do |t| + t.integer "tag_id" + t.integer "taggable_id" + t.string "taggable_type" + t.integer "tagger_id" + t.string "tagger_type" + t.string "context" + t.datetime "created_at" + end + + add_index "taggings", ["tag_id"], :name => "index_taggings_on_tag_id" + add_index "taggings", ["taggable_id", "taggable_type", "context"], :name => "index_taggings_on_taggable_id_and_taggable_type_and_context" + + create_table "tags", :force => true do |t| + t.string "name" + end + end |