Split out dropping columns from old schema

... so that can be skipped to start with.

Reviewed-By: jasplin

1 files changed, 6 insertions, 3 deletions

diff --git a/database/scripts/add-context-table.sql b/database/scripts/add-context-table.sql
index 507a580..eb42227 100644
--- a/database/scripts/add-context-table.sql
+++ b/database/scripts/add-context-table.sql
@@ -36,7 +36,7 @@ CREATE INDEX context_platform_idx ON result (platformId);
 CREATE INDEX context_branch_idx ON result (branchId);
 CREATE INDEX context_sha1_idx ON result (sha1Id);
 
--- Update result table schema -- step 1 of 2
+-- Update result table schema -- step 1 of 3
 ALTER TABLE result ADD COLUMN contextId BIGINT REFERENCES context ON DELETE CASCADE;
 
 UPDATE result
@@ -53,9 +53,12 @@ DROP INDEX result_platform_idx;
 DROP INDEX result_branch_idx;
 DROP INDEX result_sha1_idx;
 
--- Update result table schema -- step 2 of 2
+-- Update result table schema -- step 2 of 3
+ALTER TABLE result
+    ALTER COLUMN contextId SET NOT NULL;
+
+-- Update result table schema -- step 3 of 3
 ALTER TABLE result
-    ALTER COLUMN contextId SET NOT NULL,
     DROP COLUMN hostId,
     DROP COLUMN platformId,
     DROP COLUMN branchId,