1 files changed, 22 insertions, 0 deletions

diff --git a/database/migrations/1658076326250_correct_token_relations.ts b/database/migrations/1658076326250_correct_token_relations.ts
new file mode 100644
index 0000000..5486657
--- /dev/null
+++ b/database/migrations/1658076326250_correct_token_relations.ts
@@ -0,0 +1,22 @@
+import BaseSchema from '@ioc:Adonis/Lucid/Schema';
+
+export default class extends BaseSchema {
+  protected tableName = 'tokens';
+
+  public async up(): Promise<void> {
+    await this.db.rawQuery(
+      'DELETE FROM tokens WHERE user_id NOT IN (SELECT id FROM users)',
+    );
+
+    this.schema.alterTable(this.tableName, table => {
+      table.dropForeign('user_id');
+
+      table.foreign('user_id').references('users.id').onDelete('cascade');
+    });
+  }
+
+  public async down(): Promise<void> {
+    // Don't set it back withouth onDelete as the
+    // tests will break.
+  }
+}