[PATCH 2/2] sql: Update 'grant-all.mysql' script with missing tables

Stephen Finucane stephen at that.guru
Wed May 30 22:40:40 AEST 2018


These were all introduced in 2.0 and while the postgreSQL script was
fixed in commit 234bc7c3, the MySQL one was not. This suggests either
(a) no one is using this or (b) people are carrying local changes but
for now we just resolve the issues.

Signed-off-by: Stephen Finucane <stephen at that.guru>
---
NOTE: This isn't strictly necessary for 2.1, given that it was broken
since 2.0, but it would be good to get this in all the same. We should
probably figure out how to test these, but do so would require a
production-style deployment which is beyond what can be expected of a CI
job.
---
 lib/sql/grant-all.mysql.sql | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/lib/sql/grant-all.mysql.sql b/lib/sql/grant-all.mysql.sql
index 33974094..ff962195 100644
--- a/lib/sql/grant-all.mysql.sql
+++ b/lib/sql/grant-all.mysql.sql
@@ -7,6 +7,7 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON auth_permission TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON auth_user TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON auth_user_groups TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON auth_user_user_permissions TO 'www-data'@localhost;
+GRANT SELECT, UPDATE, INSERT, DELETE ON authtoken_token TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON django_admin_log TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON django_content_type TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON django_session TO 'www-data'@localhost;
@@ -19,6 +20,7 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_coverletter TO 'www-data'@loca
 GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_delegationrule TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_emailconfirmation TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_emailoptout TO 'www-data'@localhost;
+GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_event TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_patch TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_patchchangenotification TO 'www-data'@localhost;
 GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_patchtag TO 'www-data'@localhost;
-- 
2.17.0



More information about the Patchwork mailing list