diff options
Diffstat (limited to 'drizzle/0000_youthful_mercury.sql')
| -rw-r--r-- | drizzle/0000_youthful_mercury.sql | 16 |
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 |
