Packages

diwa_schema

0.1.0
0.1.0

Shared Ecto schemas and migrations for the Diwa ecosystem. Provides Core, Team, and Enterprise tier schemas used by diwa-agent and diwa-cloud.

HexDocs

Current section

Files

Jump to
Readme
1 Version
3 Dependencies
Dependants
Files
Activity
diwa_schema priv repo migrations 20251227042000_create_memory_versions.exs
Raw

priv/repo/migrations/20251227042000_create_memory_versions.exs 

defmodule DiwaSchema.Repo.Migrations.CreateMemoryVersions do

  use Ecto.Migration



  def change do

    create table(:memory_versions, primary_key: false) do

      add :id, :uuid, primary_key: true, default: fragment("uuid_generate_v4()")

      add :memory_id, references(:memories, type: :uuid, on_delete: :delete_all), null: false

      add :content, :text, null: false

      add :tags, {:array, :string}, default: []

      add :metadata, :jsonb, default: "{}"

      add :operation, :string, null: false # "create", "update", "delete"

      add :actor, :string

      add :reason, :text

      add :parent_version_id, :uuid

      

      timestamps()

    end



    create index(:memory_versions, [:memory_id])

    create index(:memory_versions, [:inserted_at])

  end

end