making a shoebox

1 files changed, 37 insertions, 0 deletions

diff --git a/README.md b/README.md
new file mode 100644
index 0000000..fcf2a8f
--- /dev/null
+++ b/README.md
@@ -0,0 +1,37 @@
+# shoebox
+
+A box for shoes :)
+
+## Setup
+
+### Postgres
+
+```bash
+createdb postgres_db
+createuser --interactive postgres_user
+psql postgres_db
+```
+
+```sql
+CREATE ROLE shoebox_group;
+
+REVOKE ALL ON DATABASE shoebox_db FROM public;
+GRANT CONNECT ON DATABASE shoebox_db TO shoebox_group;
+
+GRANT USAGE ON SCHEMA public TO shoebox_group;
+
+GRANT ALL ON ALL TABLES IN SCHEMA public TO shoebox_group;
+GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO shoebox_group;
+
+ALTER DEFAULT PRIVILEGES FOR ROLE shoebox_user IN SCHEMA public
+  GRANT ALL ON TABLES TO shoebox_group;
+
+ALTER DEFAULT PRIVILEGES FOR ROLE shoebox_user IN SCHEMA public
+  GRANT ALL ON SEQUENCES TO shoebox_group;
+
+GRANT shoebox_group TO shoebox_user;
+```
+
+```bash
+knex migrate:latest
+```