class CreatePosts < ActiveRecord::Migration[7.0]
  def change
    create_table Post.table_name do |t|
      t.string :title, null: false
      t.integer :category, default: 0
      t.integer :hit_count, default: 0
      t.string :excerpt, null: false, limit: 255, default: ""
      t.text :content, null: false, default: ""
      t.boolean :is_draft, default: true
      t.boolean :is_stick, default: false

      t.datetime :published_at
      t.datetime :deleted_at
      t.belongs_to :user, null: false
      t.belongs_to :post_category, index: true
      t.timestamps

      t.index :deleted_at
    end
  end
end