diff options
| -rw-r--r-- | sqitch/sqlite/deploy/create_outputs.sql | 7 |
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; |