diff options
author | Logan Hunt <loganhunt@simponic.xyz> | 2022-04-01 14:16:35 -0600 |
---|---|---|
committer | Logan Hunt <loganhunt@simponic.xyz> | 2022-04-01 14:16:35 -0600 |
commit | 1108970a6aeb98a2f113383c6437dd4d862dae10 (patch) | |
tree | 30c5d3f60746d92fe37a3a8dd8f0c4c4cc5e052d /server/database | |
parent | f62854ebaa689c4bf434f213f1f610a1779f8696 (diff) | |
download | locchat-1108970a6aeb98a2f113383c6437dd4d862dae10.tar.gz locchat-1108970a6aeb98a2f113383c6437dd4d862dae10.zip |
Updates
Diffstat (limited to 'server/database')
-rw-r--r-- | server/database/migrations/1648605030863-AddChatRoom.ts | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/server/database/migrations/1648605030863-AddChatRoom.ts b/server/database/migrations/1648605030863-AddChatRoom.ts index 4a6c156..747cdd3 100644 --- a/server/database/migrations/1648605030863-AddChatRoom.ts +++ b/server/database/migrations/1648605030863-AddChatRoom.ts @@ -1,16 +1,22 @@ import { MigrationInterface, QueryRunner, Table, TableForeignKey } from 'typeorm'; +import { uniqueId } from 'lodash'; export class AddChatRoom1648605030863 implements MigrationInterface { public async up(queryRunner: QueryRunner): Promise<void> { + // uuid from https://github.com/typeorm/typeorm/issues/3770 + await queryRunner.query(`CREATE EXTENSION IF NOT EXISTS "uuid-ossp"`); + await queryRunner.createTable( new Table({ name: 'chat_room', columns: [ { name: 'id', - type: 'int', + type: 'text', isPrimary: true, - isGenerated: true, + isUnique: true, + generationStrategy: 'uuid', + default: 'uuid_generate_v4()', }, { name: 'userId', @@ -39,6 +45,7 @@ export class AddChatRoom1648605030863 implements MigrationInterface { }, ], }), + true, ); await queryRunner.createForeignKey( |