Add invite tokens models

1 files changed, 27 insertions, 0 deletions

diff --git a/migration/src/m0_init_tables.rs b/migration/src/m0_init_tables.rs
index 5bde7cc..ddbc0fb 100644
--- a/migration/src/m0_init_tables.rs
+++ b/migration/src/m0_init_tables.rs
@@ -24,6 +24,14 @@ enum Queues {
 }
 
 #[derive(DeriveIden)]
+enum InviteTokens {
+    Table,
+    Id,
+    Token,
+    QueueId,
+}
+
+#[derive(DeriveIden)]
 enum AccessToQueue {
     Table,
     UserId,
@@ -97,6 +105,25 @@ impl MigrationTrait for Migration {
         manager
             .create_table(
                 Table::create()
+                    .table(InviteTokens::Table)
+                    .if_not_exists()
+                    .col(pk_auto(InviteTokens::Id).big_integer())
+                    .col(uuid(InviteTokens::Token))
+                    .col(big_integer(InviteTokens::QueueId))
+                    .foreign_key(
+                        ForeignKey::create()
+                            .from(InviteTokens::Table, InviteTokens::QueueId)
+                            .to(Queues::Table, Queues::Id)
+                            .on_delete(ForeignKeyAction::Cascade)
+                            .on_update(ForeignKeyAction::Cascade),
+                    )
+                    .to_owned(),
+            )
+            .await?;
+
+        manager
+            .create_table(
+                Table::create()
                     .table(AccessToQueue::Table)
                     .if_not_exists()
                     .col(big_integer(AccessToQueue::UserId))