[sql] use separate grant-all scripts for postgresql and mysql

Mysql doesn't support granting to multiple tables, and requires a
different username format.

Would be nice to code the permissions somewhere, then generate the
grant statements as required.

Signed-off-by: Jeremy Kerr <jk@ozlabs.org>

1 files changed, 0 insertions, 69 deletions

diff --git a/lib/sql/grant-all.sql b/lib/sql/grant-all.sql
deleted file mode 100644
index 72e1f31..0000000
--- a/lib/sql/grant-all.sql
+++ /dev/null
@@ -1,69 +0,0 @@
-BEGIN;
--- give necessary permissions to the web server. Becuase the admin is all
--- web-based, these need to be quite permissive
-GRANT SELECT, UPDATE, INSERT, DELETE ON
-	auth_message,
-	django_session,
-	django_site,
-	django_admin_log,
-	django_content_type,
-	auth_group_permissions,
-	auth_user,
-	auth_user_groups,
-	auth_group,
-	auth_user_user_permissions,
-	auth_permission,
-	patchwork_userpersonconfirmation,
-	patchwork_state,
-	patchwork_comment,
-	patchwork_person,
-	patchwork_userprofile,
-	patchwork_userprofile_maintainer_projects,
-	patchwork_project,
-	patchwork_bundle,
-	patchwork_bundle_patches,
-	patchwork_patch,
-	registration_registrationprofile
-TO "www-data";
-GRANT SELECT, UPDATE ON
-	auth_group_id_seq,
-	auth_group_permissions_id_seq,
-	auth_message_id_seq,
-	auth_permission_id_seq,
-	auth_user_groups_id_seq,
-	auth_user_id_seq,
-	auth_user_user_permissions_id_seq,
-	django_admin_log_id_seq,
-	django_content_type_id_seq,
-	django_site_id_seq,
-	patchwork_bundle_id_seq,
-	patchwork_bundle_patches_id_seq,
-	patchwork_comment_id_seq,
-	patchwork_patch_id_seq,
-	patchwork_person_id_seq,
-	patchwork_project_id_seq,
-	patchwork_state_id_seq,
-	patchwork_userpersonconfirmation_id_seq,
-	patchwork_userprofile_id_seq,
-	patchwork_userprofile_maintainer_projects_id_seq,
-	registration_registrationprofile_id_seq
-TO "www-data";
-
--- allow the mail user (in this case, 'nobody') to add patches
-GRANT INSERT, SELECT ON
-	patchwork_patch,
-	patchwork_comment,
-	patchwork_person
-TO "nobody";
-GRANT SELECT ON
-	patchwork_project,
-	patchwork_state
-TO "nobody";
-GRANT UPDATE, SELECT ON
-	patchwork_patch_id_seq,
-	patchwork_person_id_seq,
-	patchwork_comment_id_seq
-TO "nobody";
-
-COMMIT;
-