Sha256: 67b69f01a2dc0c7b8ecddf3928d595ee95d05beda01e48fcdda0d02193e0fd12

Contents?: true

Size: 707 Bytes

Versions: 171

Compression:

Stored size: 707 Bytes

Contents

class AddIndexesToDiarySlots < ActiveRecord::Migration[5.1]
  def change
    # This unique index ensures that, for a diary (weekly or master), the same patient can
    # only be added to one station in any period (am pm etc) on any day of the week
    add_index :hd_diary_slots,
              [
                :diary_id,
                :diurnal_period_code_id,
                :day_of_week,
                :patient_id
              ],
              unique: true,
              name: "idx_unique_diaryslot_patients"

    add_column :hd_diary_slots, :archived, :boolean, null: false, default: false
    add_index :hd_diary_slots, :archived
    add_column :hd_diary_slots, :archived_at, :datetime
  end
end

Version data entries

171 entries across 171 versions & 1 rubygems

Version Path
renalware-core-2.0.104 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.103 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.102 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.101 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.100 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.99 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.98 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.97 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.96 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.95 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.94 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.93 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.92 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.91 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.90 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.89 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.88 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.87 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.86 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.85 db/migrate/20170917185426_add_indexes_to_diary_slots.rb