sproxy.sql: updated example

SQL wildcards are no longer supported for HTTP methods

1 files changed, 4 insertions, 1 deletions

diff --git a/sproxy.sql b/sproxy.sql
index bd2a948..0e9f94c 100644
--- a/sproxy.sql
+++ b/sproxy.sql
@@ -166,7 +166,10 @@ CREATE TABLE IF NOT EXISTS group_privilege (
   INSERT INTO group_member ("group", email) VALUES ('dev', '%');
   INSERT INTO privilege (domain, privilege) VALUES ('example.com', 'full');
   INSERT INTO group_privilege ("group", domain, privilege) VALUES ('dev', 'example.com', 'full');
-  INSERT INTO privilege_rule (domain, privilege, path, method) VALUES ('example.com', 'full', '%', '%');
+  INSERT INTO privilege_rule (domain, privilege, path, method) VALUES ('example.com', 'full', '%', 'GET');
+  INSERT INTO privilege_rule (domain, privilege, path, method) VALUES ('example.com', 'full', '%', 'HEAD');
+  INSERT INTO privilege_rule (domain, privilege, path, method) VALUES ('example.com', 'full', '%', 'POST');
+  INSERT INTO privilege_rule (domain, privilege, path, method) VALUES ('example.com', 'full', '%', 'PUT');
 */
 
 END;