From 9d4f8de011ab8df9c7b3d51bed61d64f8417b6d2 Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Sun, 24 Nov 2013 12:38:35 +0100 Subject: Upgrade to refinery 2.1.0 --- ...ug_to_refinery_users.refinery_authentication.rb | 8 +++++ ...13021_create_blog_translations.refinery_blog.rb | 18 +++++++++++ ...1124113022_delete_cached_slugs.refinery_blog.rb | 7 +++++ ...3_create_category_translations.refinery_blog.rb | 15 +++++++++ ...age_ext_from_refinery_images.refinery_images.rb | 10 ++++++ ..._slug_to_refinery_settings.refinery_settings.rb | 6 ++++ ..._meta_keywords_from_seo_meta.seo_meta_engine.rb | 29 +++++++++++++++++ db/schema.rb | 36 +++++++++++++++++++--- 8 files changed, 124 insertions(+), 5 deletions(-) create mode 100644 db/migrate/20131124113008_add_slug_to_refinery_users.refinery_authentication.rb create mode 100644 db/migrate/20131124113021_create_blog_translations.refinery_blog.rb create mode 100644 db/migrate/20131124113022_delete_cached_slugs.refinery_blog.rb create mode 100644 db/migrate/20131124113023_create_category_translations.refinery_blog.rb create mode 100644 db/migrate/20131124113030_remove_image_ext_from_refinery_images.refinery_images.rb create mode 100644 db/migrate/20131124113126_add_slug_to_refinery_settings.refinery_settings.rb create mode 100644 db/migrate/20151113210550_remove_meta_keywords_from_seo_meta.seo_meta_engine.rb (limited to 'db') diff --git a/db/migrate/20131124113008_add_slug_to_refinery_users.refinery_authentication.rb b/db/migrate/20131124113008_add_slug_to_refinery_users.refinery_authentication.rb new file mode 100644 index 0000000..69a3a15 --- /dev/null +++ b/db/migrate/20131124113008_add_slug_to_refinery_users.refinery_authentication.rb @@ -0,0 +1,8 @@ +# This migration comes from refinery_authentication (originally 20120301234455) +class AddSlugToRefineryUsers < ActiveRecord::Migration + def change + add_column :refinery_users, :slug, :string + add_index :refinery_users, :slug + + end +end diff --git a/db/migrate/20131124113021_create_blog_translations.refinery_blog.rb b/db/migrate/20131124113021_create_blog_translations.refinery_blog.rb new file mode 100644 index 0000000..b88aa3c --- /dev/null +++ b/db/migrate/20131124113021_create_blog_translations.refinery_blog.rb @@ -0,0 +1,18 @@ +# This migration comes from refinery_blog (originally 20120530102901) +class CreateBlogTranslations < ActiveRecord::Migration + def up + Refinery::Blog::Post.create_translation_table!({ + :body => :text, + :custom_teaser => :text, + :custom_url => :string, + :slug => :string, + :title => :string + }, { + :migrate_data => true + }) + end + + def down + Refinery::Blog::Post.drop_translation_table! :migrate_data => true + end +end diff --git a/db/migrate/20131124113022_delete_cached_slugs.refinery_blog.rb b/db/migrate/20131124113022_delete_cached_slugs.refinery_blog.rb new file mode 100644 index 0000000..eecb0d6 --- /dev/null +++ b/db/migrate/20131124113022_delete_cached_slugs.refinery_blog.rb @@ -0,0 +1,7 @@ +# This migration comes from refinery_blog (originally 20120531113632) +class DeleteCachedSlugs < ActiveRecord::Migration + def change + remove_column Refinery::Blog::Category.table_name, :cached_slug + remove_column Refinery::Blog::Post.table_name, :cached_slug + end +end diff --git a/db/migrate/20131124113023_create_category_translations.refinery_blog.rb b/db/migrate/20131124113023_create_category_translations.refinery_blog.rb new file mode 100644 index 0000000..57af33f --- /dev/null +++ b/db/migrate/20131124113023_create_category_translations.refinery_blog.rb @@ -0,0 +1,15 @@ +# This migration comes from refinery_blog (originally 20120601151114) +class CreateCategoryTranslations < ActiveRecord::Migration + def up + Refinery::Blog::Category.create_translation_table!({ + :title => :string, + :slug => :string + }, { + :migrate_data => true + }) + end + + def down + Refinery::Blog::Category.drop_translation_table! :migrate_data => true + end +end diff --git a/db/migrate/20131124113030_remove_image_ext_from_refinery_images.refinery_images.rb b/db/migrate/20131124113030_remove_image_ext_from_refinery_images.refinery_images.rb new file mode 100644 index 0000000..8ec2e55 --- /dev/null +++ b/db/migrate/20131124113030_remove_image_ext_from_refinery_images.refinery_images.rb @@ -0,0 +1,10 @@ +# This migration comes from refinery_images (originally 20120625093918) +class RemoveImageExtFromRefineryImages < ActiveRecord::Migration + def up + remove_column :refinery_images, :image_ext + end + + def down + add_column :refinery_images, :image_ext, :string + end +end diff --git a/db/migrate/20131124113126_add_slug_to_refinery_settings.refinery_settings.rb b/db/migrate/20131124113126_add_slug_to_refinery_settings.refinery_settings.rb new file mode 100644 index 0000000..ae7b60f --- /dev/null +++ b/db/migrate/20131124113126_add_slug_to_refinery_settings.refinery_settings.rb @@ -0,0 +1,6 @@ +# This migration comes from refinery_settings (originally 20130414130143) +class AddSlugToRefinerySettings < ActiveRecord::Migration + def change + add_column :refinery_settings, :slug, :string, :unique => true + end +end diff --git a/db/migrate/20151113210550_remove_meta_keywords_from_seo_meta.seo_meta_engine.rb b/db/migrate/20151113210550_remove_meta_keywords_from_seo_meta.seo_meta_engine.rb new file mode 100644 index 0000000..f956379 --- /dev/null +++ b/db/migrate/20151113210550_remove_meta_keywords_from_seo_meta.seo_meta_engine.rb @@ -0,0 +1,29 @@ +# This migration comes from seo_meta_engine (originally 20120518234749) +class RemoveMetaKeywordsFromSeoMeta < ActiveRecord::Migration + def up + c = ActiveRecord::Base.connection_config + if c[:adapter] == 'sqlite3' + remove_index "seo_meta", :name => "index_seo_meta_on_seo_meta_id_and_seo_meta_type" + end + + remove_column :seo_meta, :meta_keywords + + if c[:adapter] == 'sqlite3' + add_index "seo_meta", ["seo_meta_id", "seo_meta_type"], :name => "index_seo_meta_on_seo_meta_id_and_seo_meta_type" + end + end + + def down + c = ActiveRecord::Base.connection_config + if c[:adapter] == 'sqlite3' + remove_index "seo_meta", :name => "index_seo_meta_on_seo_meta_id_and_seo_meta_type" + end + + add_column :seo_meta, :meta_keywords, :string + + if c[:adapter] == 'sqlite3' + add_index "seo_meta", ["seo_meta_id", "seo_meta_type"], :name => "index_seo_meta_on_seo_meta_id_and_seo_meta_type" + end + end +end + diff --git a/db/schema.rb b/db/schema.rb index dfb4893..1fce98c 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20140302204529) do +ActiveRecord::Schema.define(:version => 20151113210550) do create_table "refinery_banners", :force => true do |t| t.string "name" @@ -39,7 +39,6 @@ ActiveRecord::Schema.define(:version => 20140302204529) do t.string "title" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false - t.string "cached_slug" t.string "slug" t.integer "sidebar_position", :default => 0 t.integer "sidebar_items", :default => 5 @@ -55,6 +54,18 @@ ActiveRecord::Schema.define(:version => 20140302204529) do 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_category_translations", :force => true do |t| + t.integer "refinery_blog_category_id" + t.string "locale", :null => false + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + t.string "title" + t.string "slug" + end + + add_index "refinery_blog_category_translations", ["locale"], :name => "index_refinery_blog_category_translations_on_locale" + add_index "refinery_blog_category_translations", ["refinery_blog_category_id"], :name => "index_a0315945e6213bbe0610724da0ee2de681b77c31" + create_table "refinery_blog_comments", :force => true do |t| t.integer "blog_post_id" t.boolean "spam" @@ -68,6 +79,21 @@ ActiveRecord::Schema.define(:version => 20140302204529) do add_index "refinery_blog_comments", ["id"], :name => "index_refinery_blog_comments_on_id" + create_table "refinery_blog_post_translations", :force => true do |t| + t.integer "refinery_blog_post_id" + t.string "locale", :null => false + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + t.text "body" + t.text "custom_teaser" + t.string "custom_url" + t.string "slug" + t.string "title" + end + + add_index "refinery_blog_post_translations", ["locale"], :name => "index_refinery_blog_post_translations_on_locale" + add_index "refinery_blog_post_translations", ["refinery_blog_post_id"], :name => "index_refinery_blog_post_translations_on_refinery_blog_post_id" + create_table "refinery_blog_posts", :force => true do |t| t.string "title" t.text "body" @@ -76,7 +102,6 @@ ActiveRecord::Schema.define(:version => 20140302204529) do 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" @@ -118,7 +143,6 @@ ActiveRecord::Schema.define(:version => 20140302204529) do t.integer "image_width" t.integer "image_height" t.string "image_uid" - t.string "image_ext" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false end @@ -228,6 +252,7 @@ ActiveRecord::Schema.define(:version => 20140302204529) do t.string "form_value_type" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false + t.string "slug" end add_index "refinery_settings", ["name"], :name => "index_refinery_settings_on_name" @@ -255,9 +280,11 @@ ActiveRecord::Schema.define(:version => 20140302204529) do t.datetime "reset_password_sent_at" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false + t.string "slug" end add_index "refinery_users", ["id"], :name => "index_refinery_users_on_id" + add_index "refinery_users", ["slug"], :name => "index_refinery_users_on_slug" create_table "refinery_video_files", :force => true do |t| t.string "file_name" @@ -287,7 +314,6 @@ ActiveRecord::Schema.define(:version => 20140302204529) do t.integer "seo_meta_id" t.string "seo_meta_type" t.string "browser_title" - t.string "meta_keywords" t.text "meta_description" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false -- cgit v1.2.3