defmodule NotificationDispatcher.Migration do
  use Ecto.Migration

  def create_notification_messages() do
    create table(:notification_messages, primary_key: false) do
      add :id, :uuid, primary_key: true

      add :title, :string
      add :message, :text
      add :notification_type, :integer
      add :channel, :integer
      add :locale, :string
      add :dispatch_offsets, :text

      timestamps()
    end

    create index(:notification_messages, [:locale])
    create index(:notification_messages, [:channel])
    create index(:notification_messages, [:notification_type])
  end

end