Normalise order numbers in bundle-ordering migration SQL

[patchwork] / lib / sql / migration / 005-bundle-patch-ordering.sql

diff --git a/lib/sql/migration/005-bundle-patch-ordering.sql b/lib/sql/migration/005-bundle-patch-ordering.sql
index e0db398e1ee3add1e2f3fb896a1bd7a8ab6a94ac..1491aa882fc6098c875c9387a35c9661e0282120 100644 (file)
--- a/lib/sql/migration/005-bundle-patch-ordering.sql
+++ b/lib/sql/migration/005-bundle-patch-ordering.sql
@@ -8,4 +8,7 @@ ALTER TABLE patchwork_bundlepatch
 ALTER TABLE patchwork_bundlepatch ALTER COLUMN "order" DROP DEFAULT;
 DROP SEQUENCE bundlepatch_tmp_seq;
 ALTER TABLE patchwork_bundlepatch ADD UNIQUE("bundle_id", "order");
+UPDATE patchwork_bundlepatch SET "order" = 1 + "order" -
+       (SELECT min("order") FROM patchwork_bundlepatch AS p2
+               WHERE p2.bundle_id = patchwork_bundlepatch.bundle_id);
 COMMIT;