class Add2021ColumnsToNcea < ActiveRecord::Migration[6.0]
  def change
    change_table :Catholic_NCEA, bulk: true do |t|
      t.string :other_GovFund_5, limit: 11, null: false, default: ''
      t.string :other_GovFund_6, limit: 11, null: false, default: ''
      t.string :other_GovFund_7, limit: 11, null: false, default: ''
      t.string :other_GovFund_8, limit: 11, null: false, default: ''
      t.string :other_GovFund_9, limit: 11, null: false, default: ''

      t.string :other_Additional_8, limit: 11, null: false, default: ''

      t.integer :staff4_Teachers, null: false, default: 0
      t.integer :staff4_Teachers_Retain, null: false, default: 0

      t.integer :staff_position_President, null: false, default: 0
      t.integer :staff_position_Principal, null: false, default: 0
      t.integer :staff_position_AsstPrincipal, null: false, default: 0
      t.integer :staff_position_Counselor, null: false, default: 0
      t.integer :staff_position_Teacher, null: false, default: 0
      t.integer :staff_position_TA, null: false, default: 0
      t.integer :staff_position_Other, null: false, default: 0
    end
  end
end