49524d5b28
* store to db * no warning in context * warning in frontend * remove log * 100kb + alert * update sqlx * update eeref * Update ee-repo-ref.txt * cleaning --------- Co-authored-by: windmill-internal-app[bot] <windmill-internal-app[bot]@users.noreply.github.com>
17 lines
595 B
SQL
17 lines
595 B
SQL
-- Add up migration script here
|
|
|
|
-- Create ai_agent_memory table for storing AI agent step memory when S3 is unavailable
|
|
CREATE TABLE ai_agent_memory (
|
|
workspace_id VARCHAR(50) NOT NULL,
|
|
conversation_id UUID NOT NULL,
|
|
step_id VARCHAR(255) NOT NULL,
|
|
messages JSONB NOT NULL,
|
|
created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
|
|
updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
|
|
PRIMARY KEY (workspace_id, conversation_id, step_id)
|
|
);
|
|
|
|
-- Grant permissions
|
|
GRANT ALL ON ai_agent_memory TO windmill_admin;
|
|
GRANT ALL ON ai_agent_memory TO windmill_user;
|