Sequel.migration do
  change do
    create_table(:webhooks, charset: 'utf8') do
      primary_key :id
      String :uuid, null: false, unique: true, unique_constraint_name: 'uq_webhook_uuid'
      String :method, null: false
      String :url, null: false
      String :body
      Boolean :is_json_request_body
      foreign_key :consumer_id, :pacticipants, null: false, foreign_key_constraint_name: 'fk_webhooks_consumer'
      foreign_key :provider_id, :pacticipants, null: false, foreign_key_constraint_name: 'fk_webhooks_provider'
    end

    create_table(:webhook_headers, charset: 'utf8') do
      String :name, null: false
      String :value
      foreign_key :webhook_id, :webhooks, null: false, foreign_key_constraint_name: 'fk_webhookheaders_webhooks'
      primary_key [:webhook_id, :name], :name=>:webhooks_headers_pk
    end
  end
end