Add Column
Current Schema
CREATE TABLE `activeIngredient` (
`id` text PRIMARY KEY,
`created_at` integer DEFAULT (CURRENT_TIMESTAMP),
`validated_at` integer,
`duplicates_id` text,
`name` text,
`unit_id` text,
`available_amounts` text,
`popularity` integer,
CONSTRAINT `fk_activeIngredient_duplicates_id_activeIngredient_id_fk` FOREIGN KEY (`duplicates_id`) REFERENCES `activeIngredient`(`id`),
CONSTRAINT `fk_activeIngredient_unit_id_unit_id_fk` FOREIGN KEY (`unit_id`) REFERENCES `unit`(`id`)
)