Contains scripts for sanitising RDS databases.

A folder should be created for each database to be sanitised and the name of the folder should match the RDS database identifier (e.g. `qa-ows-track`).

Each folder can contain multiple scripts and scripts will be run in lexicographical order. All scripts must have a `.sql` extension.

If a database does not require sanitisation scripts (because the corresponding production database 
does not contain any sensitive or PII data) then you should create a README file in the appropriate folder
with a note to that effect.

## PostgreSQL scripts

PostgreSQL has no `USE` statement and a connection can only reference the database it is connected to
(cross-database names like `db.schema.table` are not supported). Every `.sql` script in a PostgreSQL
folder must therefore declare its target *application* database with a directive on the first line:

```sql
-- @database: songwhip_api
```

The sanitisation Lambda parses this header and opens a connection to that database for the script, so
the SQL body can reference tables directly (e.g. `users` or `public.users`). A PostgreSQL script with no
directive fails fast. MySQL folders are unaffected — they switch databases inline with `USE <db>;`.