+-- we 'INSERT INTO ... SELECT' (rather than renaming and adding the order
+-- column) here so that we can order by date
+INSERT INTO patchwork_bundlepatch (id, patch_id, bundle_id)
+ SELECT patchwork_bundle_patches.id, patch_id, bundle_id
+ FROM patchwork_bundle_patches
+ INNER JOIN patchwork_patch
+ ON patchwork_patch.id = patchwork_bundle_patches.patch_id
+ ORDER BY bundle_id, patchwork_patch.date;
+COMMIT;
+
+BEGIN;