]> 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:15:37 +0000 (16:15 +1000)
commitcbc04868c164d2541e01a5de18d568c54f6dcfd1
treef4214ea9bf9f98e9b63ac565d1522294dc2995e2
parente15fc9fef64ba8cfd4f5f5c3c74135caef0ebfa7
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