]> git.ipfire.org Git - thirdparty/patchwork.git/commit
lib/sql: Update grant script for recent schema changes
authorJeremy Kerr <jk@ozlabs.org>
Tue, 14 Apr 2020 05:57:53 +0000 (13:57 +0800)
committerDaniel Axtens <dja@axtens.net>
Tue, 14 Apr 2020 06:17:57 +0000 (16:17 +1000)
commit9c7bc7f8506dccc4bdc2692ae55401dd898aad97
tree8ec8d6d6831c96dd8d6c4c171888c19bcd62df40
parent2111f726e173b09f607b2a1cc44e4236c0030c69
lib/sql: Update grant script for recent schema changes

This change fixes a few omissions in the grant scripts:

- patchrelation is missing from both mysql and postgres scripts; it's
  only needed for web user access.

- event is missing from the web grants on postgres, and the mail grants
  on mysql.

Tested on postgres only.

Fixes: 27c2acf56c ("models, templates: Add patch relations")
Fixes: 34e3c9c493 ("sql: Update 'grant-all.mysql' script with missing tables")
Fixes: 234bc7c316 ("lib/sql: fix permissions for v2.0.0 on postgres")
Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
Signed-off-by: Daniel Axtens <dja@axtens.net>
lib/sql/grant-all.mysql.sql
lib/sql/grant-all.postgres.sql