Sep 10, 2025 · Sep 9, 2025 · Sep 10, 2025
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/foreign_key_constraint.go b/coderd/database/foreign_key_constraint.go
diff --git a/coderd/database/migrations/000366_create_tasks_data_model.down.sql b/coderd/database/migrations/000366_create_tasks_data_model.down.sql
 DROP TABLE task_workspace_apps;
 DROP TABLE tasks;
diff --git a/coderd/database/migrations/000366_create_tasks_data_model.up.sql b/coderd/database/migrations/000366_create_tasks_data_model.up.sql
 CREATE TABLE tasks (
 id                  UUID        NOT NULL PRIMARY KEY,
 organization_id     UUID        NOT NULL REFERENCES organizations     (id) ON DELETE CASCADE,
 owner_id            UUID        NOT NULL REFERENCES users             (id) ON DELETE CASCADE,
 name                TEXT        NOT NULL,
 workspace_id        UUID                 REFERENCES workspaces        (id) ON DELETE CASCADE,
 template_version_id UUID        NOT NULL REFERENCES template_versions (id) ON DELETE CASCADE,
 template_parameters JSONB       NOT NULL DEFAULT '{}'::JSONB,
 prompt              TEXT        NOT NULL,
 created_at          TIMESTAMPTZ NOT NULL,
 deleted_at          TIMESTAMPTZ
 );

 CREATE TABLE task_workspace_apps (
 task_id            UUID NOT NULL REFERENCES tasks            (id) ON DELETE CASCADE,
 workspace_build_id UUID NOT NULL REFERENCES workspace_builds (id) ON DELETE CASCADE,
 workspace_agent_id UUID NOT NULL REFERENCES workspace_agents (id) ON DELETE CASCADE,
 workspace_app_id   UUID NOT NULL REFERENCES workspace_apps   (id) ON DELETE CASCADE
 );
diff --git a/coderd/database/migrations/testdata/fixtures/000366_create_tasks_data_model.up.sql b/coderd/database/migrations/testdata/fixtures/000366_create_tasks_data_model.up.sql
 INSERT INTO public.tasks VALUES (
    'f5a1c3e4-8b2d-4f6a-9d7e-2a8b5c9e1f3d', -- id
    'bb640d07-ca8a-4869-b6bc-ae61ebb2fda1', -- organization_id
    '30095c71-380b-457a-8995-97b8ee6e5307', -- owner_id
    'Test Task 1',                          -- name
    '3a9a1feb-e89d-457c-9d53-ac751b198ebe', -- workspace_id
    '920baba5-4c64-4686-8b7d-d1bef5683eae', -- template_version_id
    '{}'::JSONB,                            -- template_parameters
    'Create a React component for tasks',   -- prompt
    '2024-11-02 13:10:00.000000+02',        -- created_at
    NULL                                    -- deleted_at
 ) ON CONFLICT DO NOTHING;

 INSERT INTO public.task_workspace_apps VALUES (
    'f5a1c3e4-8b2d-4f6a-9d7e-2a8b5c9e1f3d', -- task_id
    'a8c0b8c5-c9a8-4f33-93a4-8142e6858244', -- workspace_build_id
    '8fa17bbd-c48c-44c7-91ae-d4acbc755fad', -- workspace_agent_id
    'a47965a2-0a25-4810-8cc9-d283c86ab34c'  -- workspace_app_id
 ) ON CONFLICT DO NOTHING;
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/unique_constraint.go b/coderd/database/unique_constraint.go
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		DROP TABLE task_workspace_apps;
		DROP TABLE tasks;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,19 @@
		CREATE TABLE tasks (
		id UUID NOT NULL PRIMARY KEY,
		organization_id UUID NOT NULL REFERENCES organizations (id) ON DELETE CASCADE,
		owner_id UUID NOT NULL REFERENCES users (id) ON DELETE CASCADE,
		name TEXT NOT NULL,
		workspace_id UUID REFERENCES workspaces (id) ON DELETE CASCADE,
		template_version_id UUID NOT NULL REFERENCES template_versions (id) ON DELETE CASCADE,
		template_parameters JSONB NOT NULL DEFAULT '{}'::JSONB,
		prompt TEXT NOT NULL,
		created_at TIMESTAMPTZ NOT NULL,
		deleted_at TIMESTAMPTZ
		);

		CREATE TABLE task_workspace_apps (
		task_id UUID NOT NULL REFERENCES tasks (id) ON DELETE CASCADE,
		workspace_build_id UUID NOT NULL REFERENCES workspace_builds (id) ON DELETE CASCADE,
		workspace_agent_id UUID NOT NULL REFERENCES workspace_agents (id) ON DELETE CASCADE,
		workspace_app_id UUID NOT NULL REFERENCES workspace_apps (id) ON DELETE CASCADE
		);
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,19 @@
		INSERT INTO public.tasks VALUES (
		'f5a1c3e4-8b2d-4f6a-9d7e-2a8b5c9e1f3d', -- id
		'bb640d07-ca8a-4869-b6bc-ae61ebb2fda1', -- organization_id
		'30095c71-380b-457a-8995-97b8ee6e5307', -- owner_id
		'Test Task 1', -- name
		'3a9a1feb-e89d-457c-9d53-ac751b198ebe', -- workspace_id
		'920baba5-4c64-4686-8b7d-d1bef5683eae', -- template_version_id
		'{}'::JSONB, -- template_parameters
		'Create a React component for tasks', -- prompt
		'2024-11-02 13:10:00.000000+02', -- created_at
		NULL -- deleted_at
		) ON CONFLICT DO NOTHING;

		INSERT INTO public.task_workspace_apps VALUES (
		'f5a1c3e4-8b2d-4f6a-9d7e-2a8b5c9e1f3d', -- task_id
		'a8c0b8c5-c9a8-4f33-93a4-8142e6858244', -- workspace_build_id
		'8fa17bbd-c48c-44c7-91ae-d4acbc755fad', -- workspace_agent_id
		'a47965a2-0a25-4810-8cc9-d283c86ab34c' -- workspace_app_id
		) ON CONFLICT DO NOTHING;