1 files changed, 29 insertions, 0 deletions

diff --git a/database/migrations/1696110557648_jwt_tokens.ts b/database/migrations/1696110557648_jwt_tokens.ts
new file mode 100644
index 0000000..9400de7
--- /dev/null
+++ b/database/migrations/1696110557648_jwt_tokens.ts
@@ -0,0 +1,29 @@
+import BaseSchema from '@ioc:Adonis/Lucid/Schema';
+
+export default class JwtTokens extends BaseSchema {
+  protected tableName = 'jwt_tokens';
+
+  public async up() {
+    this.schema.createTable(this.tableName, table => {
+      table.increments('id').primary();
+      table
+        .integer('user_id')
+        .unsigned()
+        .references('users.id')
+        .onDelete('CASCADE');
+      table.string('name').notNullable();
+      table.string('type').notNullable();
+      table.string('token', 64).notNullable().unique();
+      table.timestamp('expires_at', { useTz: true }).nullable();
+      table.string('refresh_token').notNullable().unique().index();
+      table
+        .timestamp('refresh_token_expires_at', { useTz: true })
+        .notNullable();
+      table.timestamp('created_at', { useTz: true }).notNullable();
+    });
+  }
+
+  public async down() {
+    this.schema.dropTable(this.tableName);
+  }
+}