drizzle/0001_dry_meteorite.sql


1
2
3
4
5
6
7
8
9


CREATE TABLE `references` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`grocery_id` integer NOT NULL,
	`brand` text NOT NULL,
	`price` real,
	`unit` text,
	`quality_score` integer,
	FOREIGN KEY (`grocery_id`) REFERENCES `groceries`(`id`) ON UPDATE no action ON DELETE cascade
);