aboutsummaryrefslogtreecommitdiff
path: root/apps/web/migrations
diff options
context:
space:
mode:
authorcodeTorso <[email protected]>2024-08-12 02:15:35 +0530
committercodeTorso <[email protected]>2024-08-12 02:15:35 +0530
commite6ea714b5ce5a23ffb649d5987f4f7df48039595 (patch)
treef244cb07a634af14c459ab68b01f330f8b1796d8 /apps/web/migrations
parentnext fix, how did noone notice this ? (diff)
downloadsupermemory-e6ea714b5ce5a23ffb649d5987f4f7df48039595.tar.xz
supermemory-e6ea714b5ce5a23ffb649d5987f4f7df48039595.zip
why is this novel shit broke
Diffstat (limited to 'apps/web/migrations')
-rw-r--r--apps/web/migrations/0001_Adding_jobs_table.sql19
1 files changed, 0 insertions, 19 deletions
diff --git a/apps/web/migrations/0001_Adding_jobs_table.sql b/apps/web/migrations/0001_Adding_jobs_table.sql
deleted file mode 100644
index 7a687f72..00000000
--- a/apps/web/migrations/0001_Adding_jobs_table.sql
+++ /dev/null
@@ -1,19 +0,0 @@
--- Migration number: 0001 2024-08-05T18:05:16.793Z
-CREATE TABLE `jobs` (
- `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- `userId` text NOT NULL,
- `url` text NOT NULL,
- `status` text NOT NULL,
- `attempts` integer DEFAULT 0 NOT NULL,
- `lastAttemptAt` integer,
- `error` blob,
- `createdAt` integer NOT NULL,
- `updatedAt` integer NOT NULL,
- FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
-);
-
-
-CREATE INDEX `jobs_userId_idx` ON `jobs` (`userId`);--> statement-breakpoint
-CREATE INDEX `jobs_status_idx` ON `jobs` (`status`);--> statement-breakpoint
-CREATE INDEX `jobs_createdAt_idx` ON `jobs` (`createdAt`);--> statement-breakpoint
-CREATE INDEX `jobs_url_idx` ON `jobs` (`url`);--> statement-breakpoint \ No newline at end of file