diff options
| author | Mohamed Bassem <me@mbassem.com> | 2025-07-10 19:34:31 +0000 |
|---|---|---|
| committer | Mohamed Bassem <me@mbassem.com> | 2025-07-10 20:45:45 +0000 |
| commit | 333d1610fad10e70759545f223959503288a02c6 (patch) | |
| tree | 3354a21d4fa3b4dc75d03ba5f940bd3c213078fd /packages/db/drizzle/0056_user_invites.sql | |
| parent | 93049e864ae6d281b60c23dee868bca3f585dd4a (diff) | |
| download | karakeep-333d1610fad10e70759545f223959503288a02c6.tar.zst | |
feat: Add invite user support
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 |