diff options
Diffstat (limited to 'packages/db/drizzle/0056_user_invites.sql')
| -rw-r--r-- | packages/db/drizzle/0056_user_invites.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/packages/db/drizzle/0056_user_invites.sql b/packages/db/drizzle/0056_user_invites.sql new file mode 100644 index 00000000..5ea38cca --- /dev/null +++ b/packages/db/drizzle/0056_user_invites.sql @@ -0,0 +1,12 @@ +CREATE TABLE `invites` ( + `id` text PRIMARY KEY NOT NULL, + `email` text NOT NULL, + `token` text NOT NULL, + `createdAt` integer NOT NULL, + `expiresAt` integer NOT NULL, + `usedAt` integer, + `invitedBy` text NOT NULL, + FOREIGN KEY (`invitedBy`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade +); +--> statement-breakpoint +CREATE UNIQUE INDEX `invites_token_unique` ON `invites` (`token`);
\ No newline at end of file |