migration: reset bundlepatch sequence on setup

Signed-off-by: Jeremy Kerr <jk@ozlabs.org>

diff --git a/lib/sql/migration/005-bundle-patch-ordering.sql b/lib/sql/migration/005-bundle-patch-ordering.sql
index f6e37eb01853513d0c23aa4c3162e686885ed0cd..3f0ad1340dd2cbdc5e7a72f84e07b6763cc9a90b 100644 (file)
--- a/lib/sql/migration/005-bundle-patch-ordering.sql
+++ b/lib/sql/migration/005-bundle-patch-ordering.sql
@@ -23,6 +23,10 @@ BEGIN;
 ALTER TABLE patchwork_bundlepatch
     ALTER COLUMN "order" TYPE INTEGER;
 
+-- initialise the starting number for this sequence
+SELECT setval('patchwork_bundlepatch_id_seq',
+        (SELECT max(id) + 1 FROM patchwork_bundlepatch));
+
 DROP TABLE patchwork_bundle_patches;
 
 -- normalise ordering: order should start with 1 in each bundle