8f4fef9804
* feat(backend): job result stream optimization * get offset locally instead of from db * fix: agent worker result stream * update ref * nit * remove foreign key on job * fix build
13 lines
400 B
SQL
13 lines
400 B
SQL
-- Add up migration script here
|
|
CREATE TABLE job_result_stream_v2 (
|
|
job_id UUID NOT NULL,
|
|
workspace_id TEXT NOT NULL,
|
|
stream TEXT NOT NULL,
|
|
idx INT NOT NULL,
|
|
PRIMARY KEY (job_id, idx)
|
|
);
|
|
|
|
GRANT ALL ON TABLE job_result_stream_v2 TO windmill_admin;
|
|
GRANT ALL ON TABLE job_result_stream_v2 TO windmill_user;
|
|
|
|
ALTER TABLE job_result_stream DROP CONSTRAINT fk_job_result_stream_job_id; |