> For the complete documentation index, see [llms.txt](https://docs.nzoni.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nzoni.app/nest.js/database-and-migration.md).

# Database and Migration

### All migrations path

<pre><code>├── node_modules
<strong>├── mail-templates
</strong>├── migrations
│   ├── 1661868238821-usersTable.ts              # Users table
│   ├── 1661868315626-subscriptionsTable.ts      # Subscriptions table
│   ├── 1708974949319-BlogpostTable.ts           # Blogposts table
│   ├── 1709027986137-FileUploadTable.ts         # File upload table
</code></pre>

### Set environnements variables in <mark style="background-color:blue;">.env</mark>

```
TYPEORM_HOST=
TYPEORM_PORT=
TYPEORM_USERNAME=
TYPEORM_PASSWORD=
TYPEORM_DATABASE=
```

### Run the migration

```
npx ts-node ./node_modules/.bin/typeorm  migration:run -d ./datasource.ts
```

### Create a migration

```
npx typeorm migration:create migrations/nameOfTable
```