1 files changed, 15 insertions, 0 deletions
diff --git a/drizzle/0001_big_rachel_grey.sql b/drizzle/0001_big_rachel_grey.sql
new file mode 100644
index 0000000..539cad6
--- /dev/null
+++ b/drizzle/0001_big_rachel_grey.sql
@@ -0,0 +1,15 @@
+PRAGMA foreign_keys=OFF;--> statement-breakpoint
+CREATE TABLE `__new_groceries` (
+	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
+	`name` text NOT NULL,
+	`checked` integer DEFAULT false NOT NULL,
+	`created_at` text NOT NULL,
+	`category_id` integer,
+	FOREIGN KEY (`category_id`) REFERENCES `categories`(`id`) ON UPDATE no action ON DELETE set null
+);
+--> statement-breakpoint
+INSERT INTO `__new_groceries`("id", "name", "checked", "created_at", "category_id") SELECT "id", "name", "checked", "created_at", "category_id" FROM `groceries`;--> statement-breakpoint
+DROP TABLE `groceries`;--> statement-breakpoint
+ALTER TABLE `__new_groceries` RENAME TO `groceries`;--> statement-breakpoint
+PRAGMA foreign_keys=ON;--> statement-breakpoint
+CREATE UNIQUE INDEX `groceries_name_unique` ON `groceries` (`name`);
+\ No newline at end of file