Files
hedgehog/api/2026-06-26_add_igel_stammdaten_fields.sql

10 lines
583 B
SQL

ALTER TABLE `igel`
ADD COLUMN `marking` varchar(255) DEFAULT NULL AFTER `location`,
ADD COLUMN `finder` varchar(255) DEFAULT NULL AFTER `marking`,
ADD COLUMN `phone` varchar(255) DEFAULT NULL AFTER `finder`,
ADD COLUMN `email` varchar(255) DEFAULT NULL AFTER `phone`,
ADD COLUMN `admission_reason` varchar(255) DEFAULT NULL AFTER `email`,
ADD COLUMN `animal_condition` varchar(255) DEFAULT NULL AFTER `admission_reason`,
ADD COLUMN `released_at` date DEFAULT NULL AFTER `animal_condition`,
ADD COLUMN `release_location` varchar(255) DEFAULT NULL AFTER `released_at`;