7 lines
299 B
SQL
7 lines
299 B
SQL
CREATE TABLE `plant_views` (
|
|
`plant_id` text PRIMARY KEY NOT NULL,
|
|
`view_count` integer DEFAULT 0 NOT NULL,
|
|
FOREIGN KEY (`plant_id`) REFERENCES `plants`(`id`) ON UPDATE no action ON DELETE no action
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE INDEX `idx_plant_views_count` ON `plant_views` (`view_count`); |