-- DropForeignKey
ALTER TABLE `diy_applications` DROP FOREIGN KEY `diy_applications_serviceId_fkey`;

-- DropForeignKey
ALTER TABLE `invoice_items` DROP FOREIGN KEY `invoice_items_serviceId_fkey`;

-- DropForeignKey
ALTER TABLE `quotation_items` DROP FOREIGN KEY `quotation_items_serviceId_fkey`;

-- DropForeignKey
ALTER TABLE `service_documents` DROP FOREIGN KEY `service_documents_serviceId_fkey`;

-- DropForeignKey
ALTER TABLE `tasks` DROP FOREIGN KEY `tasks_serviceId_fkey`;

-- DropIndex
DROP INDEX `diy_applications_serviceId_fkey` ON `diy_applications`;

-- DropIndex
DROP INDEX `invoice_items_serviceId_fkey` ON `invoice_items`;

-- DropIndex
DROP INDEX `quotation_items_serviceId_fkey` ON `quotation_items`;

-- DropIndex
DROP INDEX `tasks_serviceId_fkey` ON `tasks`;

-- AddForeignKey
ALTER TABLE `service_documents` ADD CONSTRAINT `service_documents_serviceId_fkey` FOREIGN KEY (`serviceId`) REFERENCES `services`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `tasks` ADD CONSTRAINT `tasks_serviceId_fkey` FOREIGN KEY (`serviceId`) REFERENCES `services`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `quotation_items` ADD CONSTRAINT `quotation_items_serviceId_fkey` FOREIGN KEY (`serviceId`) REFERENCES `services`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `invoice_items` ADD CONSTRAINT `invoice_items_serviceId_fkey` FOREIGN KEY (`serviceId`) REFERENCES `services`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `diy_applications` ADD CONSTRAINT `diy_applications_serviceId_fkey` FOREIGN KEY (`serviceId`) REFERENCES `services`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
