diff options
Diffstat (limited to 'db/migrate/20110803223522_create_blog_structure.rb')
-rw-r--r-- | db/migrate/20110803223522_create_blog_structure.rb | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/db/migrate/20110803223522_create_blog_structure.rb b/db/migrate/20110803223522_create_blog_structure.rb new file mode 100644 index 0000000..f6f5b2d --- /dev/null +++ b/db/migrate/20110803223522_create_blog_structure.rb @@ -0,0 +1,54 @@ +class CreateBlogStructure < ActiveRecord::Migration + + def up + create_table Refinery::BlogPost.table_name, :id => true do |t| + t.string :title + t.text :body + t.boolean :draft + t.datetime :published_at + t.timestamps + end + + add_index Refinery::BlogPost.table_name, :id + + create_table Refinery::BlogComment.table_name, :id => true do |t| + t.integer :blog_post_id + t.boolean :spam + t.string :name + t.string :email + t.text :body + t.string :state + t.timestamps + end + + add_index Refinery::BlogComment.table_name, :id + + create_table Refinery::BlogCategory.table_name, :id => true do |t| + t.string :title + t.timestamps + end + + add_index Refinery::BlogCategory.table_name, :id + + create_table Refinery::Categorization.table_name, :id => true do |t| + t.integer :blog_category_id + t.integer :blog_post_id + end + + add_index Refinery::Categorization.table_name, [:blog_category_id, :blog_post_id], :name => 'index_blog_categories_blog_posts_on_bc_and_bp' + + load(File.expand_path('../../seeds/refinerycms_blog.rb', __FILE__)) + end + + def down + Refinery::UserPlugin.destroy_all({:name => "refinerycms_blog"}) + + Refinery::Page.delete_all({:link_url => "/blog"}) + + drop_table Refinery::BlogPost.table_name + drop_table Refinery::BlogComment.table_name + drop_table Refinery::Category.table_name + drop_table Refinery::Categorization.table_name + end + +end |