Contents

class CreateSofaBlog < ActiveRecord::Migration
  
  def self.up
    create_table :sofa_blog_posts do |t|
      t.string  :title
      t.text    :content
      t.string  :author
      t.boolean :is_published,    :null => false, :default => false
      t.integer :comments_count,  :null => false, :default => 0
      t.integer :approved_comments_count, :null => false, :default => 0
      t.timestamps
    end
    add_index :sofa_blog_posts, :created_at
    add_index :sofa_blog_posts, [:is_published, :created_at]
    
    create_table :sofa_blog_comments do |t|
      t.integer :post_id
      t.string  :name
      t.string  :email
      t.text    :content
      t.boolean :is_approved, :null => false, :default => false
      t.timestamps
    end
    add_index :sofa_blog_comments, [:post_id, :created_at]
    add_index :sofa_blog_comments, [:post_id, :is_approved, :created_at],
      :name => 'index_sofa_blog_comments_on_post_and_approved_and_created_at'
      
    create_table :sofa_blog_tags do |t|
      t.string :name
      t.integer :taggings_count
    end
    add_index :sofa_blog_tags, [:name, :taggings_count], :unique => true
    add_index :sofa_blog_tags, :taggings_count


    create_table :sofa_blog_taggings do |t|
      t.integer :post_id
      t.integer :tag_id
      t.datetime :created_at
    end
    add_index :sofa_blog_taggings, [:post_id, :tag_id, :created_at], :unique => true, :name => 'index_sofa_blog_taggings_on_post_id_tag_id_created_at'
  
  end
  
  def self.down
    drop_table :sofa_blog_posts
    drop_table :sofa_blog_comments
    drop_table :sofa_blog_tags
    drop_table :sofa_blog_taggings
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
sofa_blog-0.1.3	db/migrate/01_create_sofa_blog.rb
sofa_blog-0.1.2	db/migrate/01_create_sofa_blog.rb
sofa_blog-0.1.1	db/migrate/01_create_sofa_blog.rb
sofa_blog-0.1.0	db/migrate/01_create_sofa_blog.rb