coder/000337_nullable_has_ai_task.down.sql at main - coder - Ahri Cloud Code

synced/coder

mirror of https://github.com/coder/coder.git synced 2025-07-03 16:13:58 +00:00

Files

Hugo Dutka ebc769f328 chore: make has_ai_task fields on workspace builds and template versions nullable (#18403 )

The fields must be nullable because there’s a period of time between
inserting a row into the database and finishing the “plan” provisioner
job when the final value of the field is unknown.

2025-06-17 16:08:34 +02:00

5 lines

284 B

SQL

Raw Permalink Blame History

 ALTER TABLE template_versions ALTER COLUMN has_ai_task SET DEFAULT false;
 ALTER TABLE template_versions ALTER COLUMN has_ai_task SET NOT NULL;
 ALTER TABLE workspace_builds ALTER COLUMN has_ai_task SET DEFAULT false;
 ALTER TABLE workspace_builds ALTER COLUMN has_ai_task SET NOT NULL;