-- Menus: extra link type (MAILTO) plus a style preset and a page anchor per menu item. Additive; safe to re-run.
-- Run once against the application database (MariaDB), then run `pnpm prisma generate`.

ALTER TABLE `NavigationItem` MODIFY `kind` ENUM('PAGE','EXTERNAL','PATH','MAILTO') NOT NULL;
ALTER TABLE `NavigationItem` ADD COLUMN IF NOT EXISTS `style` VARCHAR(60) NULL;
ALTER TABLE `NavigationItem` ADD COLUMN IF NOT EXISTS `anchor` VARCHAR(80) NULL;
