diff options
Diffstat (limited to 'database/migrations/1696110557648_jwt_tokens.ts')
-rw-r--r-- | database/migrations/1696110557648_jwt_tokens.ts | 34 |
1 files changed, 14 insertions, 20 deletions
diff --git a/database/migrations/1696110557648_jwt_tokens.ts b/database/migrations/1696110557648_jwt_tokens.ts index 9400de7..7823283 100644 --- a/database/migrations/1696110557648_jwt_tokens.ts +++ b/database/migrations/1696110557648_jwt_tokens.ts | |||
@@ -1,29 +1,23 @@ | |||
1 | import BaseSchema from '@ioc:Adonis/Lucid/Schema'; | 1 | import { BaseSchema } from '@adonisjs/lucid/schema' |
2 | 2 | ||
3 | export default class JwtTokens extends BaseSchema { | 3 | export default class JwtTokens extends BaseSchema { |
4 | protected tableName = 'jwt_tokens'; | 4 | protected tableName = 'jwt_tokens' |
5 | 5 | ||
6 | public async up() { | 6 | public async up() { |
7 | this.schema.createTable(this.tableName, table => { | 7 | this.schema.createTable(this.tableName, (table) => { |
8 | table.increments('id').primary(); | 8 | table.increments('id').primary() |
9 | table | 9 | table.integer('user_id').unsigned().references('users.id').onDelete('CASCADE') |
10 | .integer('user_id') | 10 | table.string('name').notNullable() |
11 | .unsigned() | 11 | table.string('type').notNullable() |
12 | .references('users.id') | 12 | table.string('token', 64).notNullable().unique() |
13 | .onDelete('CASCADE'); | 13 | table.timestamp('expires_at', { useTz: true }).nullable() |
14 | table.string('name').notNullable(); | 14 | table.string('refresh_token').notNullable().unique().index() |
15 | table.string('type').notNullable(); | 15 | table.timestamp('refresh_token_expires_at', { useTz: true }).notNullable() |
16 | table.string('token', 64).notNullable().unique(); | 16 | table.timestamp('created_at', { useTz: true }).notNullable() |
17 | table.timestamp('expires_at', { useTz: true }).nullable(); | 17 | }) |
18 | table.string('refresh_token').notNullable().unique().index(); | ||
19 | table | ||
20 | .timestamp('refresh_token_expires_at', { useTz: true }) | ||
21 | .notNullable(); | ||
22 | table.timestamp('created_at', { useTz: true }).notNullable(); | ||
23 | }); | ||
24 | } | 18 | } |
25 | 19 | ||
26 | public async down() { | 20 | public async down() { |
27 | this.schema.dropTable(this.tableName); | 21 | this.schema.dropTable(this.tableName) |
28 | } | 22 | } |
29 | } | 23 | } |