Packages

presence_ex

0.2.9
0.2.9 0.2.8 0.2.8-6 0.2.8-5 0.2.8-4 0.2.8-3 0.2.8-2 0.2.8-1 0.2.7 0.2.6 0.2.5 0.2.4 0.2.3 0.2.2 0.2.1 0.2.0 0.1.9 0.1.8 0.1.7 0.1.6 0.1.5 0.1.4 0.1.3 0.1.2 0.1.2-dev 0.1.1 0.1.0 0.1.0-1

Presence client in Elixir for new arch

Current section

Files

Jump to
Readme
28 Versions
2 Dependencies
Dependants
Files
Activity
presence_ex priv replica migrations 20240129122556_change_status_subscribe.exs
Raw

priv/replica/migrations/20240129122556_change_status_subscribe.exs 

defmodule PresenceEx.Repo.Replica.Migrations.ChangeStatusSubscribe do

  use Ecto.Migration

  alias PresenceEx.Repo

  alias PresenceEx.Utils



  def change do

    for i <- Utils.all_schema_ids() do

      prefix = "public_#{i}"

      drop_if_exists table(:status_subscribe, prefix: prefix)



      create table(:status_subscribe, prefix: prefix) do

       add :subscriber_token, :string, null: false, primary_key: true

       add :subscriber_resource, :string, null: false, primary_key: true

       add :subscribed_token, :string, null: false, primary_key: true

       add :timestamp, :string, null: false

     end



      create unique_index(:status_subscribe, [:subscriber_token, :subscriber_resource, :subscribed_token], prefix: prefix)

      flush()

    end



  end

end