Packages

spawn_statestores

0.6.2
2.0.0-RC9 2.0.0-RC8 2.0.0-RC7 2.0.0-RC6 2.0.0-RC5 2.0.0-RC4 2.0.0-RC3 2.0.0-RC2 2.0.0-RC14 2.0.0-RC13 2.0.0-RC12 2.0.0-RC11 2.0.0-RC10 2.0.0-RC1 1.4.3 1.4.2 1.4.1 1.4.0 1.3.3 1.3.2 1.3.1 1.3.0 1.2.2 1.2.1 1.2.0 1.1.1 1.1.0 1.0.1 1.0.0 1.0.0-rc4 1.0.0-rc3 1.0.0-rc2 1.0.0-rc16 1.0.0-rc15 1.0.0-rc14 1.0.0-rc13 1.0.0-rc1 1.0.0-rc.38 1.0.0-rc.37 1.0.0-rc.36 1.0.0-rc.35 1.0.0-rc.34 1.0.0-rc.33 1.0.0-rc.32 1.0.0-rc.31 1.0.0-rc.30 1.0.0-rc.29 1.0.0-rc.28 1.0.0-rc.27 1.0.0-rc.26 1.0.0-rc.25 1.0.0-rc.24 1.0.0-rc.23 1.0.0-rc.22 1.0.0-rc.21 1.0.0-rc.20 1.0.0-rc.19 1.0.0-rc.18 1.0.0-rc.17 1.0.0-beta1 0.6.3 0.6.2 0.6.1 0.6.0 0.5.5 0.5.4 0.5.3 0.5.1 0.5.0 0.5.0-rc.13 0.5.0-rc.12 0.5.0-rc.11 0.5.0-rc.10 0.5.0-rc.9 0.5.0-rc.8 0.5.0-rc.7 0.5.0-rc.6 0.5.0-rc.5 0.5.0-rc.3 0.5.0-alpha.13 0.5.0-alpha.12 0.5.0-alpha.11 0.5.0-alpha.10 0.5.0-alpha.9 0.5.0-alpha.6 0.5.0-alpha.5 0.5.0-alpha.4 0.5.0-alpha.3 0.5.0-alpha.2 0.5.0-alpha.1 0.1.0

Spawn Statestores is the storage lib for the Spawn Actors System

HexDocs

Current section

Files

Jump to
Readme
91 Versions
5 Dependencies
Dependants
Files
Activity
spawn_statestores priv sqlite migrations 20220521162410_create_events_table.exs
Raw

priv/sqlite/migrations/20220521162410_create_events_table.exs 

defmodule Statestores.Adapters.SQLite3.Migrations.CreateEventsTable do

  use Ecto.Migration



  def up do

    # create table(:events, primary_key: false) do

    #   add :actor, :string, primary_key: true

    #   add :system, :string

    #   add :revision, :integer

    #   add :tags, :map

    #   add :data_type, :string

    #   add :data, :binary

    #   timestamps([type: :utc_datetime_usec])

    # end



    execute """

    CREATE TABLE IF NOT EXISTS events (

      actor TEXT PRIMARY KEY,

      system TEXT,

      revision INTEGER DEFAULT 0,

      tags JSON,

      data_type TEXT NOT NULL,

      data BLOB,

      inserted_at TEXT_DATETIME,

      updated_at TEXT_DATETIME

    )

    """

  end



  def down do

    drop table(:events)

  end

end