# Ruby To-Do List Application - Create Tasks Migration
# Created by: Molla Samser (help@rskworld.in, +91 93305 39277)
# Address: Nutanhat, Mongolkote, Purba Burdwan, West Bengal, India, 713147
# Year: 2026

class CreateTasks < ActiveRecord::Migration[7.1]
  def change
    create_table :tasks do |t|
      t.string :title, null: false
      t.text :description
      t.integer :priority, default: 1 # 1: Low, 2: Medium, 3: High
      t.boolean :completed, default: false
      t.datetime :completed_at
      t.datetime :due_date
      t.references :user, null: false, foreign_key: true

      t.timestamps
    end

    add_index :tasks, [:user_id, :completed]
    add_index :tasks, [:user_id, :priority]
    add_index :tasks, [:user_id, :due_date]
  end
end