diff options
author | Uģis Ozols <ugis@ugisozols.com> | 2013-07-13 13:41:41 -0700 |
---|---|---|
committer | Uģis Ozols <ugis@ugisozols.com> | 2013-07-13 13:41:41 -0700 |
commit | 48950c119297dc6c99edfe8d1c99eb7a77dc9496 (patch) | |
tree | 742dab40d319fea3d0909bce9f56ad36be98ead3 /db/migrate/20110803223522_create_blog_structure.rb | |
parent | 6c14fbc20c8dece121b7569b7a5a0bd3c497fd57 (diff) | |
parent | ccd0f3b7ec1d47dcce017389087ac6d20f709f93 (diff) | |
download | refinerycms-blog-48950c119297dc6c99edfe8d1c99eb7a77dc9496.tar.gz refinerycms-blog-48950c119297dc6c99edfe8d1c99eb7a77dc9496.tar.bz2 refinerycms-blog-48950c119297dc6c99edfe8d1c99eb7a77dc9496.zip |
Merge pull request #339 from refinery/revert_f906ef024ee39c31148edb49c6511f007735ce5a
Revert f906ef0 but maintain table name improvements
Diffstat (limited to 'db/migrate/20110803223522_create_blog_structure.rb')
-rw-r--r-- | db/migrate/20110803223522_create_blog_structure.rb | 39 |
1 files changed, 6 insertions, 33 deletions
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 |