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, 20 insertions, 14 deletions
diff --git a/database/migrations/1696110557648_jwt_tokens.ts b/database/migrations/1696110557648_jwt_tokens.ts
index 7823283..23040e1 100644
--- a/database/migrations/1696110557648_jwt_tokens.ts
+++ b/database/migrations/1696110557648_jwt_tokens.ts
@@ -1,23 +1,29 @@
1import { BaseSchema } from '@adonisjs/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.integer('user_id').unsigned().references('users.id').onDelete('CASCADE') 9 table
10 table.string('name').notNullable() 10 .integer('user_id')
11 table.string('type').notNullable() 11 .unsigned()
12 table.string('token', 64).notNullable().unique() 12 .references('users.id')
13 table.timestamp('expires_at', { useTz: true }).nullable() 13 .onDelete('CASCADE');
14 table.string('refresh_token').notNullable().unique().index() 14 table.string('name').notNullable();
15 table.timestamp('refresh_token_expires_at', { useTz: true }).notNullable() 15 table.string('type').notNullable();
16 table.timestamp('created_at', { useTz: true }).notNullable() 16 table.string('token', 64).notNullable().unique();
17 }) 17 table.timestamp('expires_at', { useTz: true }).nullable();
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 });
18 } 24 }
19 25
20 public async down() { 26 public async down() {
21 this.schema.dropTable(this.tableName) 27 this.schema.dropTable(this.tableName);
22 } 28 }
23} 29}