Spaces:

Bin29
/

ManimCat

Running

ManimCat / src /infrastructure /database /migrations /005_create_studio_session_events.sql

Sync from main: 5548f84 fix(workflow): preserve reference images across generation and recovery [skip ci]

b1df986 1 day ago

574 Bytes

create table if not exists studio_session_events (
  id text primary key,
  session_id text not null references studio_sessions(id) on delete cascade,
  run_id text references studio_runs(id) on delete set null,
  kind text not null,
  status text not null,
  title text not null,
  summary text not null,
  metadata jsonb,
  created_at timestamptz not null default now(),
  updated_at timestamptz not null default now(),
  consumed_at timestamptz
);

create index if not exists idx_studio_session_events_session_created
  on studio_session_events(session_id, created_at);

	create table if not exists studio_session_events (
	id text primary key,
	session_id text not null references studio_sessions(id) on delete cascade,
	run_id text references studio_runs(id) on delete set null,
	kind text not null,
	status text not null,
	title text not null,
	summary text not null,
	metadata jsonb,
	created_at timestamptz not null default now(),
	updated_at timestamptz not null default now(),
	consumed_at timestamptz
	);

	create index if not exists idx_studio_session_events_session_created
	on studio_session_events(session_id, created_at);