# 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
```