Fix part of the create_outputs migration

It was completely broken, since it would just delete all entries from the
unbuilt outputs table.

1 files changed, 3 insertions, 4 deletions

diff --git a/sqitch/sqlite/deploy/create_outputs.sql b/sqitch/sqlite/deploy/create_outputs.sql
index 03f0b42..082e1ab 100644
--- a/sqitch/sqlite/deploy/create_outputs.sql
+++ b/sqitch/sqlite/deploy/create_outputs.sql
@@ -42,12 +42,11 @@ CREATE TABLE unbuilt_outputs_new (
   output_id INTEGER PRIMARY KEY REFERENCES outputs (id)
 );
 
-UPDATE unbuilt_outputs_new SET output_id = (
-  SELECT id
+INSERT INTO unbuilt_outputs_new
+  SELECT outputs.id
   FROM unbuilt_outputs
   INNER JOIN outputs
-    ON unbuilt_outputs.output = outputs.output
-);
+    ON unbuilt_outputs.output = outputs.output;
 
 DROP TABLE unbuilt_outputs;
 ALTER TABLE unbuilt_outputs_new RENAME TO unbuilt_outputs;