X-Git-Url: https://git.ozlabs.org/?a=blobdiff_plain;f=lib%2Fsql%2Fmigration%2F005-bundle-patch-ordering.sql;fp=lib%2Fsql%2Fmigration%2F005-bundle-patch-ordering.sql;h=f6e37eb01853513d0c23aa4c3162e686885ed0cd;hb=17e39712c3f9398f4aa6aae9f368f642af615eab;hp=238e37bcac11cca635bb86c4fd290a73c6a3adad;hpb=6c119273e873bc2c63ac470e7b975a721b9a6826;p=patchwork

diff --git a/lib/sql/migration/005-bundle-patch-ordering.sql b/lib/sql/migration/005-bundle-patch-ordering.sql
index 238e37b..f6e37eb 100644
--- a/lib/sql/migration/005-bundle-patch-ordering.sql
+++ b/lib/sql/migration/005-bundle-patch-ordering.sql
@@ -23,10 +23,14 @@ BEGIN;
 ALTER TABLE patchwork_bundlepatch
     ALTER COLUMN "order" TYPE INTEGER;
 
+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;