aboutsummaryrefslogtreecommitdiff
path: root/drizzle/0000_youthful_mercury.sql
diff options
context:
space:
mode:
Diffstat (limited to 'drizzle/0000_youthful_mercury.sql')
-rw-r--r--drizzle/0000_youthful_mercury.sql16
1 files changed, 0 insertions, 16 deletions
diff --git a/drizzle/0000_youthful_mercury.sql b/drizzle/0000_youthful_mercury.sql
deleted file mode 100644
index 6dde7ff..0000000
--- a/drizzle/0000_youthful_mercury.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-CREATE TABLE `categories` (
- `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- `name` text NOT NULL
-);
---> statement-breakpoint
-CREATE UNIQUE INDEX `categories_name_unique` ON `categories` (`name`);--> statement-breakpoint
-CREATE TABLE `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 no action
-);
---> statement-breakpoint
-CREATE UNIQUE INDEX `groceries_name_unique` ON `groceries` (`name`); \ No newline at end of file