-- AlterTable
ALTER TABLE `cash_session_operations` MODIFY `note` VARCHAR(191) NULL;

-- CreateTable
CREATE TABLE `station_sounds` (
    `id` VARCHAR(191) NOT NULL,
    `station_id` VARCHAR(191) NOT NULL,
    `event` ENUM('PRODUCTION_NEW_ORDER', 'PRODUCTION_ITEM_CANCELLED', 'CASHIER_ITEM_PREPARING', 'CASHIER_ITEM_READY', 'CASHIER_ITEM_DELIVERED') NOT NULL,
    `label` VARCHAR(191) NOT NULL DEFAULT '',
    `file_name` VARCHAR(191) NOT NULL,
    `file_url` VARCHAR(191) NOT NULL,
    `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),

    INDEX `station_sounds_station_id_idx`(`station_id`),
    UNIQUE INDEX `station_sounds_station_id_event_key`(`station_id`, `event`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- AddForeignKey
ALTER TABLE `station_sounds` ADD CONSTRAINT `station_sounds_station_id_fkey` FOREIGN KEY (`station_id`) REFERENCES `stations`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
