aboutsummaryrefslogtreecommitdiffstats
path: root/database/migrations/1696110557648_jwt_tokens.ts
diff options
context:
space:
mode:
Diffstat (limited to 'database/migrations/1696110557648_jwt_tokens.ts')
-rw-r--r--database/migrations/1696110557648_jwt_tokens.ts34
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 @@
1import BaseSchema from '@ioc:Adonis/Lucid/Schema'; 1import { BaseSchema } from '@adonisjs/lucid/schema'
2 2
3export default class JwtTokens extends BaseSchema { 3export 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}