Contents

require "jobshop/helpers/migration.rb"

class CreateMailmen < ActiveRecord::Migration[5.2]
  include Jobshop::Helpers::Migration

  def change
    create_table :jobshop_mailmen, id: false do |t|
      t.uuid :organization_id, null: false
      t.citext :address, null: false
      t.index %i[ organization_id address ], unique: true,
        name: "idx_jobshop_mailmen_pkey"

      t.string :handler_type, null: false

      t.timestamps
    end

    execute <<~SQL
      ALTER TABLE jobshop_mailmen
        ADD CONSTRAINT valid_handler_type
          CHECK (handler_type IN (
            'Jobshop::RFQHandler'
          ))
    SQL

    idx_table_name_pkey "jobshop_mailmen"
    fk_organization_id "jobshop_mailmen"
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
jobshop-0.0.163	db/migrate/20181118014603_create_mailmen.rb