@refinerycms_blog_tables = [{
  :table_name => 'blog_posts',
  :attributes => [
    Rails::Generators::GeneratedAttribute.new('title', 'string'),
    Rails::Generators::GeneratedAttribute.new('body', 'text'),
    Rails::Generators::GeneratedAttribute.new('draft', 'boolean'),
    Rails::Generators::GeneratedAttribute.new('published_at', 'datetime')
  ], :id => true
},{
  :table_name => 'blog_comments',
  :attributes => [
    Rails::Generators::GeneratedAttribute.new('blog_post_id', 'integer'),
    Rails::Generators::GeneratedAttribute.new('spam', 'boolean'),
    Rails::Generators::GeneratedAttribute.new('name', 'string'),
    Rails::Generators::GeneratedAttribute.new('email', 'string'),
    Rails::Generators::GeneratedAttribute.new('body', 'text'),
    Rails::Generators::GeneratedAttribute.new('state', 'string')
  ], :id => true
},{
  :table_name => 'blog_categories',
  :attributes => [
    Rails::Generators::GeneratedAttribute.new('title', 'string')
  ], :id => true
},{
  :table_name => 'blog_categories_blog_posts',
  :attributes => [
    Rails::Generators::GeneratedAttribute.new('blog_category_id', 'integer'),
    Rails::Generators::GeneratedAttribute.new('blog_post_id', 'integer')
  ], :id => false
}]

class Create<%= singular_name.camelize %> < ActiveRecord::Migration

  def self.up<% @refinerycms_blog_tables.each do |table| %>
    create_table :<%= table[:table_name] %>, :id => <%= table[:id].to_s %> do |t|
<% table[:attributes].each do |attribute| -%>
      t.<%= attribute.type %> :<%= attribute.name %>
<% end -%>
      <%= 't.timestamps' if table[:id] %>
    end

    <%= "add_index :#{table[:table_name]}, :id" if table[:id] %>
<% end -%>
    load(Rails.root.join('db', 'seeds', 'refinerycms_blog.rb').to_s)
  end

  def self.down
    UserPlugin.destroy_all({:name => "refinerycms_blog"})

    Page.delete_all({:link_url => "/blog"})

<% @refinerycms_blog_tables.each do |table| -%>
    drop_table :<%= table[:table_name] %>
<% end -%>
  end

end