README.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

# shoebox

A box for shoes :)

## Setup

### Postgres

```bash
createdb shoebox_db
createuser --interactive shoebox_user
psql shoebox_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
```