aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorHarald Eilertsen <haraldei@andeuin.net>2013-11-24 12:38:35 +0100
committerHarald Eilertsen <haraldei@anduin.net>2015-11-14 12:07:51 +0100
commit9d4f8de011ab8df9c7b3d51bed61d64f8417b6d2 (patch)
tree41064a1477ad83826b141753393886cca375475a /db
parent0d588701cce86c990ab3a0e3f41700f1a125114b (diff)
downloadhmnoweb-9d4f8de011ab8df9c7b3d51bed61d64f8417b6d2.tar.gz
hmnoweb-9d4f8de011ab8df9c7b3d51bed61d64f8417b6d2.tar.bz2
hmnoweb-9d4f8de011ab8df9c7b3d51bed61d64f8417b6d2.zip
Upgrade to refinery 2.1.0
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20131124113008_add_slug_to_refinery_users.refinery_authentication.rb8
-rw-r--r--db/migrate/20131124113021_create_blog_translations.refinery_blog.rb18
-rw-r--r--db/migrate/20131124113022_delete_cached_slugs.refinery_blog.rb7
-rw-r--r--db/migrate/20131124113023_create_category_translations.refinery_blog.rb15
-rw-r--r--db/migrate/20131124113030_remove_image_ext_from_refinery_images.refinery_images.rb10
-rw-r--r--db/migrate/20131124113126_add_slug_to_refinery_settings.refinery_settings.rb6
-rw-r--r--db/migrate/20151113210550_remove_meta_keywords_from_seo_meta.seo_meta_engine.rb29
-rw-r--r--db/schema.rb36
8 files changed, 124 insertions, 5 deletions
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