migration: fix whitespace

[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 238e37bcac11cca635bb86c4fd290a73c6a3adad..cd2183a83e3ca8b824b81d11734cd84a04d5add1 100644 (file)
--- a/lib/sql/migration/005-bundle-patch-ordering.sql
+++ b/lib/sql/migration/005-bundle-patch-ordering.sql
@@ -1,5 +1,5 @@
 BEGIN;
-CREATE TABLE "patchwork_bundlepatch" (                                          
+CREATE TABLE "patchwork_bundlepatch" (
     "id" SERIAL NOT NULL PRIMARY KEY,
     "patch_id" INTEGER NOT NULL
         REFERENCES "patchwork_patch" ("id") DEFERRABLE INITIALLY DEFERRED,
@@ -23,10 +23,18 @@ 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
 UPDATE patchwork_bundlepatch SET "order" = 1 + "order" -
        (SELECT min("order") FROM patchwork_bundlepatch AS p2
                WHERE p2.bundle_id = patchwork_bundlepatch.bundle_id);
 
-SELECT * FROM patchwork_bundlepatch;
+GRANT SELECT, INSERT, UPDATE, DELETE ON patchwork_bundlepatch TO "www-data";
+GRANT SELECT, UPDATE ON patchwork_bundlepatch_id_seq TO "www-data";
+
 COMMIT;