diff options
Diffstat (limited to 'server/database/migrations/1637028716848-AddUser.ts')
-rw-r--r-- | server/database/migrations/1637028716848-AddUser.ts | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/server/database/migrations/1637028716848-AddUser.ts b/server/database/migrations/1637028716848-AddUser.ts new file mode 100644 index 0000000..6241637 --- /dev/null +++ b/server/database/migrations/1637028716848-AddUser.ts @@ -0,0 +1,37 @@ +import { MigrationInterface, QueryRunner, Table } from 'typeorm'; + +export class AddUser1637028716848 implements MigrationInterface { + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.createTable( + new Table({ + name: 'user', + columns: [ + { + name: 'id', + type: 'int', + isPrimary: true, + }, + { + name: 'name', + type: 'text', + isNullable: false, + }, + { + name: 'password_hash', + type: 'text', + isNullable: false, + }, + { + name: 'email', + type: 'text', + isNullable: false, + }, + ], + }), + ); + } + + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.dropTable('user'); + } +} |