fix: uppercase sql

coder · DanielleMaywood · Sep 24, 2024 · Sep 17, 2024 · Sep 17, 2024 · Sep 17, 2024
commit 424069cc732dbb56e018425ad90640fbfe77d3c5
diff --git a/coderd/database/migrations/000256_workspace_agent_script_timings.up.sql b/coderd/database/migrations/000256_workspace_agent_script_timings.up.sql
@@ -1,5 +1,5 @@
-ALTER TABLE workspace_agent_scripts ADD COLUMN id uuid unique not null default gen_random_uuid();
-ALTER TABLE workspace_agent_scripts ADD COLUMN display_name text not null default '';
+ALTER TABLE workspace_agent_scripts ADD COLUMN id           uuid UNIQUE NOT NULL DEFAULT gen_random_uuid();
+ALTER TABLE workspace_agent_scripts ADD COLUMN display_name text        NOT NULL DEFAULT '';
 
 CREATE TYPE workspace_agent_script_timing_stage AS ENUM (
     'start',
@@ -9,11 +9,11 @@ CREATE TYPE workspace_agent_script_timing_stage AS ENUM (
 
 CREATE TABLE workspace_agent_script_timings
 (
-    script_id     uuid                                not null references workspace_agent_scripts (id) on delete cascade,
-    display_name  text                                not null,
-    started_at    timestamp with time zone            not null,
-    ended_at      timestamp with time zone            not null,
-    exit_code     int                                 not null,
-    stage         workspace_agent_script_timing_stage not null,
-    timed_out     bool                                not null
+    script_id     uuid                                NOT NULL REFERENCES workspace_agent_scripts (id) ON DELETE CASCADE,
+    display_name  text                                NOT NULL,
+    started_at    timestamp with time zone            NOT NULL,
+    ended_at      timestamp with time zone            NOT NULL,
+    exit_code     int                                 NOT NULL,
+    stage         workspace_agent_script_timing_stage NOT NULL,
+    timed_out     bool                                NOT NULL
 );