summaryrefslogtreecommitdiff
path: root/server/database
diff options
context:
space:
mode:
authorJoseph Ditton <jditton.atomic@gmail.com>2021-11-23 14:04:12 -0700
committerJoseph Ditton <jditton.atomic@gmail.com>2021-11-23 14:04:12 -0700
commit8d0b32f8dfe45291426e58f6bf20cffac8dab6e7 (patch)
treeec4c1e08e8698d7118641612b67bce940019b3dc /server/database
parent4ae4e874689a71e33cdd7a5799fc0c85c4861367 (diff)
downloadlocchat-8d0b32f8dfe45291426e58f6bf20cffac8dab6e7.tar.gz
locchat-8d0b32f8dfe45291426e58f6bf20cffac8dab6e7.zip
adds api, guard, tailwind
Diffstat (limited to 'server/database')
-rw-r--r--server/database/migrations/1637028716848-AddUser.ts2
-rw-r--r--server/database/migrations/1637631042877-AddRefreshToken.ts38
2 files changed, 39 insertions, 1 deletions
diff --git a/server/database/migrations/1637028716848-AddUser.ts b/server/database/migrations/1637028716848-AddUser.ts
index 2689d49..5cc3b7c 100644
--- a/server/database/migrations/1637028716848-AddUser.ts
+++ b/server/database/migrations/1637028716848-AddUser.ts
@@ -18,7 +18,7 @@ export class AddUser1637028716848 implements MigrationInterface {
isNullable: false,
},
{
- name: 'password_hash',
+ name: 'passwordHash',
type: 'text',
isNullable: false,
},
diff --git a/server/database/migrations/1637631042877-AddRefreshToken.ts b/server/database/migrations/1637631042877-AddRefreshToken.ts
new file mode 100644
index 0000000..257c317
--- /dev/null
+++ b/server/database/migrations/1637631042877-AddRefreshToken.ts
@@ -0,0 +1,38 @@
+import { MigrationInterface, QueryRunner, Table, TableForeignKey } from 'typeorm';
+
+export class AddRefreshToken1637631042877 implements MigrationInterface {
+ public async up(queryRunner: QueryRunner): Promise<void> {
+ await queryRunner.createTable(
+ new Table({
+ name: 'refresh_token',
+ columns: [
+ {
+ name: 'id',
+ type: 'int',
+ isPrimary: true,
+ isGenerated: true,
+ },
+ {
+ name: 'userId',
+ type: 'int',
+ isNullable: false,
+ },
+ ],
+ }),
+ );
+
+ await queryRunner.createForeignKey(
+ 'refresh_token',
+ new TableForeignKey({
+ columnNames: ['userId'],
+ referencedColumnNames: ['id'],
+ referencedTableName: 'user',
+ onDelete: 'CASCADE',
+ }),
+ );
+ }
+
+ public async down(queryRunner: QueryRunner): Promise<void> {
+ await queryRunner.dropTable('refresh_token');
+ }
+}