require "jobshop/helpers/migration.rb"

class CreateOrganizations < ActiveRecord::Migration[5.1]
  include Jobshop::Helpers::Migration

  def change
    create_table :jobshop_organizations, id: false do |t|
      t.uuid :organization_id, null: false, default: "gen_random_uuid()"
      t.index :organization_id, unique: true,
        name: :idx_jobshop_organizations_pkey

      t.citext :name, index: true
      t.index [ :organization_id, :name ], unique: true

      t.timestamps
    end

    idx_table_name_pkey "jobshop_organizations"
  end
end