From 49c38f208b8a05cee49400ffababc49dfc431daa Mon Sep 17 00:00:00 2001 From: Philip Arndt Date: Sun, 14 Jul 2013 04:37:18 +1200 Subject: Revert f906ef0 but maintain table name improvements --- db/migrate/20110803223522_create_blog_structure.rb | 39 ++++------------------ .../20110803223523_add_user_id_to_blog_posts.rb | 7 ++++ ...20110803223524_acts_as_taggable_on_migration.rb | 26 +++++++-------- db/migrate/20110803223526_add_cached_slugs.rb | 6 ++++ ...803223527_add_custom_url_field_to_blog_posts.rb | 5 +++ ...223528_add_custom_teaser_field_to_blog_posts.rb | 6 ++++ ...803223529_add_primary_key_to_categorizations.rb | 14 ++++++++ .../20120103055909_add_source_url_to_blog_posts.rb | 7 ++++ .../20120223022021_add_access_count_to_posts.rb | 8 +++++ ...20227022021_add_slug_to_posts_and_categories.rb | 9 +++++ .../20120530102901_create_blog_translations.rb | 17 ++++++++++ db/migrate/20120531113632_delete_cached_slugs.rb | 6 ++++ .../20120601151114_create_category_translations.rb | 14 ++++++++ 13 files changed, 117 insertions(+), 47 deletions(-) create mode 100644 db/migrate/20110803223523_add_user_id_to_blog_posts.rb create mode 100644 db/migrate/20110803223526_add_cached_slugs.rb create mode 100644 db/migrate/20110803223527_add_custom_url_field_to_blog_posts.rb create mode 100644 db/migrate/20110803223528_add_custom_teaser_field_to_blog_posts.rb create mode 100644 db/migrate/20110803223529_add_primary_key_to_categorizations.rb create mode 100644 db/migrate/20120103055909_add_source_url_to_blog_posts.rb create mode 100644 db/migrate/20120223022021_add_access_count_to_posts.rb create mode 100644 db/migrate/20120227022021_add_slug_to_posts_and_categories.rb create mode 100644 db/migrate/20120530102901_create_blog_translations.rb create mode 100644 db/migrate/20120531113632_delete_cached_slugs.rb create mode 100644 db/migrate/20120601151114_create_category_translations.rb diff --git a/db/migrate/20110803223522_create_blog_structure.rb b/db/migrate/20110803223522_create_blog_structure.rb index 3be7eee..37f4bd7 100644 --- a/db/migrate/20110803223522_create_blog_structure.rb +++ b/db/migrate/20110803223522_create_blog_structure.rb @@ -1,26 +1,17 @@ class CreateBlogStructure < ActiveRecord::Migration def up - create_table :refinery_blog_posts do |t| + create_table :refinery_blog_posts, :id => true do |t| t.string :title t.text :body t.boolean :draft t.datetime :published_at - t.integer :user_id - t.string :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.timestamps end add_index :refinery_blog_posts, :id - add_index :refinery_blog_posts, :access_count - add_index :refinery_blog_posts, :slug - create_table :refinery_blog_comments do |t| + create_table :refinery_blog_comments, :id => true do |t| t.integer :blog_post_id t.boolean :spam t.string :name @@ -33,48 +24,30 @@ class CreateBlogStructure < ActiveRecord::Migration add_index :refinery_blog_comments, :id add_index :refinery_blog_comments, :blog_post_id - create_table :refinery_blog_categories do |t| + create_table :refinery_blog_categories, :id => true do |t| t.string :title - t.string :slug t.timestamps end add_index :refinery_blog_categories, :id - add_index :refinery_blog_categories, :slug - create_table :refinery_blog_categories_blog_posts do |t| - t.primary_key :id + create_table :refinery_blog_categories_blog_posts, :id => 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' - - Refinery::Blog::Post.create_translation_table!({ - :body => :text, - :custom_teaser => :text, - :custom_url => :string, - :slug => :string, - :title => :string - }) - Refinery::Blog::Category.create_translation_table!({ - :title => :string, - :slug => :string - }) end def down - Refinery::UserPlugin.destroy_all({:name => "refinerycms_blog"}) + Refinery::UserPlugin.destroy_all({:name => "refinerycms_blog"}) if defined?(Refinery::UserPlugin) - Refinery::Page.delete_all({:link_url => "/blog"}) + Refinery::Page.delete_all({:link_url => "/blog"}) if defined?(Refinery::Page) drop_table :refinery_blog_posts drop_table :refinery_blog_comments drop_table :refinery_blog_categories drop_table :refinery_blog_categories_blog_posts - - Refinery::Blog::Post.drop_translation_table! - Refinery::Blog::Category.drop_translation_table! end end diff --git a/db/migrate/20110803223523_add_user_id_to_blog_posts.rb b/db/migrate/20110803223523_add_user_id_to_blog_posts.rb new file mode 100644 index 0000000..94980b3 --- /dev/null +++ b/db/migrate/20110803223523_add_user_id_to_blog_posts.rb @@ -0,0 +1,7 @@ +class AddUserIdToBlogPosts < ActiveRecord::Migration + + def change + add_column :refinery_blog_posts, :user_id, :integer + end + +end diff --git a/db/migrate/20110803223524_acts_as_taggable_on_migration.rb b/db/migrate/20110803223524_acts_as_taggable_on_migration.rb index 49a6ca2..812daf4 100644 --- a/db/migrate/20110803223524_acts_as_taggable_on_migration.rb +++ b/db/migrate/20110803223524_acts_as_taggable_on_migration.rb @@ -2,25 +2,23 @@ class ActsAsTaggableOnMigration < ActiveRecord::Migration def up create_table :tags do |t| t.string :name - end unless table_exists?(:tags) - - unless table_exists?(:taggings) - create_table :taggings do |t| - t.references :tag + end - # You should make sure that the column created is - # long enough to store the required class names. - t.references :taggable, :polymorphic => true - t.references :tagger, :polymorphic => true + create_table :taggings do |t| + t.references :tag - t.string :context + # You should make sure that the column created is + # long enough to store the required class names. + t.references :taggable, :polymorphic => true + t.references :tagger, :polymorphic => true - t.datetime :created_at - end + t.string :context - add_index :taggings, :tag_id - add_index :taggings, [:taggable_id, :taggable_type, :context] + t.datetime :created_at end + + add_index :taggings, :tag_id + add_index :taggings, [:taggable_id, :taggable_type, :context] end def down diff --git a/db/migrate/20110803223526_add_cached_slugs.rb b/db/migrate/20110803223526_add_cached_slugs.rb new file mode 100644 index 0000000..389f83e --- /dev/null +++ b/db/migrate/20110803223526_add_cached_slugs.rb @@ -0,0 +1,6 @@ +class AddCachedSlugs < ActiveRecord::Migration + def change + add_column :refinery_blog_categories, :cached_slug, :string + add_column :refinery_blog_posts, :cached_slug, :string + end +end diff --git a/db/migrate/20110803223527_add_custom_url_field_to_blog_posts.rb b/db/migrate/20110803223527_add_custom_url_field_to_blog_posts.rb new file mode 100644 index 0000000..518bbb8 --- /dev/null +++ b/db/migrate/20110803223527_add_custom_url_field_to_blog_posts.rb @@ -0,0 +1,5 @@ +class AddCustomUrlFieldToBlogPosts < ActiveRecord::Migration + def change + add_column :refinery_blog_posts, :custom_url, :string + end +end diff --git a/db/migrate/20110803223528_add_custom_teaser_field_to_blog_posts.rb b/db/migrate/20110803223528_add_custom_teaser_field_to_blog_posts.rb new file mode 100644 index 0000000..86d787d --- /dev/null +++ b/db/migrate/20110803223528_add_custom_teaser_field_to_blog_posts.rb @@ -0,0 +1,6 @@ +class AddCustomTeaserFieldToBlogPosts < ActiveRecord::Migration + def change + add_column :refinery_blog_posts, :custom_teaser, :text + end +end + diff --git a/db/migrate/20110803223529_add_primary_key_to_categorizations.rb b/db/migrate/20110803223529_add_primary_key_to_categorizations.rb new file mode 100644 index 0000000..5bbfcf3 --- /dev/null +++ b/db/migrate/20110803223529_add_primary_key_to_categorizations.rb @@ -0,0 +1,14 @@ +class AddPrimaryKeyToCategorizations < ActiveRecord::Migration + def up + unless Refinery::Categorization.column_names.include?("id") + add_column Refinery::Categorization.table_name, :id, :primary_key + end + end + + def down + if Refinery::Categorization.column_names.include?("id") + remove_column Refinery::Categorization.table_name, :id + end + end +end + diff --git a/db/migrate/20120103055909_add_source_url_to_blog_posts.rb b/db/migrate/20120103055909_add_source_url_to_blog_posts.rb new file mode 100644 index 0000000..cd6fd27 --- /dev/null +++ b/db/migrate/20120103055909_add_source_url_to_blog_posts.rb @@ -0,0 +1,7 @@ +class AddSourceUrlToBlogPosts < ActiveRecord::Migration + def change + add_column Refinery::Blog::Post.table_name, :source_url, :string + add_column Refinery::Blog::Post.table_name, :source_url_title, :string + + end +end diff --git a/db/migrate/20120223022021_add_access_count_to_posts.rb b/db/migrate/20120223022021_add_access_count_to_posts.rb new file mode 100644 index 0000000..02cd131 --- /dev/null +++ b/db/migrate/20120223022021_add_access_count_to_posts.rb @@ -0,0 +1,8 @@ +class AddAccessCountToPosts < ActiveRecord::Migration + def change + add_column Refinery::Blog::Post.table_name, :access_count, :integer, :default => 0 + + add_index Refinery::Blog::Post.table_name, :access_count + + end +end \ No newline at end of file diff --git a/db/migrate/20120227022021_add_slug_to_posts_and_categories.rb b/db/migrate/20120227022021_add_slug_to_posts_and_categories.rb new file mode 100644 index 0000000..87d1291 --- /dev/null +++ b/db/migrate/20120227022021_add_slug_to_posts_and_categories.rb @@ -0,0 +1,9 @@ +class AddSlugToPostsAndCategories < ActiveRecord::Migration + def change + add_column Refinery::Blog::Post.table_name, :slug, :string + add_index Refinery::Blog::Post.table_name, :slug + + add_column Refinery::Blog::Category.table_name, :slug, :string + add_index Refinery::Blog::Category.table_name, :slug + end +end \ No newline at end of file diff --git a/db/migrate/20120530102901_create_blog_translations.rb b/db/migrate/20120530102901_create_blog_translations.rb new file mode 100644 index 0000000..c301f42 --- /dev/null +++ b/db/migrate/20120530102901_create_blog_translations.rb @@ -0,0 +1,17 @@ +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/20120531113632_delete_cached_slugs.rb b/db/migrate/20120531113632_delete_cached_slugs.rb new file mode 100644 index 0000000..14c8653 --- /dev/null +++ b/db/migrate/20120531113632_delete_cached_slugs.rb @@ -0,0 +1,6 @@ +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/20120601151114_create_category_translations.rb b/db/migrate/20120601151114_create_category_translations.rb new file mode 100644 index 0000000..a7cb956 --- /dev/null +++ b/db/migrate/20120601151114_create_category_translations.rb @@ -0,0 +1,14 @@ +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 -- cgit v1.2.3 From ccd0f3b7ec1d47dcce017389087ac6d20f709f93 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Ug=CC=A7is=20Ozols?= Date: Sat, 13 Jul 2013 23:08:00 +0300 Subject: Use proper namespace for Refinery::Blog::Categorization. --- db/migrate/20110803223529_add_primary_key_to_categorizations.rb | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/db/migrate/20110803223529_add_primary_key_to_categorizations.rb b/db/migrate/20110803223529_add_primary_key_to_categorizations.rb index 5bbfcf3..dcf1493 100644 --- a/db/migrate/20110803223529_add_primary_key_to_categorizations.rb +++ b/db/migrate/20110803223529_add_primary_key_to_categorizations.rb @@ -1,13 +1,13 @@ class AddPrimaryKeyToCategorizations < ActiveRecord::Migration def up - unless Refinery::Categorization.column_names.include?("id") - add_column Refinery::Categorization.table_name, :id, :primary_key + unless Refinery::Blog::Categorization.column_names.include?("id") + add_column Refinery::Blog::Categorization.table_name, :id, :primary_key end end def down - if Refinery::Categorization.column_names.include?("id") - remove_column Refinery::Categorization.table_name, :id + if Refinery::Blog::Categorization.column_names.include?("id") + remove_column Refinery::Blog::Categorization.table_name, :id end end end -- cgit v1.2.3