-- Content audit fields for Hospital (same pattern as Procedure / Article / Category / Doctor)
ALTER TABLE `Hospital` ADD COLUMN `createdById` VARCHAR(191) NULL,
    ADD COLUMN `updatedById` VARCHAR(191) NULL;

ALTER TABLE `Hospital` ADD CONSTRAINT `Hospital_createdById_fkey` FOREIGN KEY (`createdById`) REFERENCES `User`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;

ALTER TABLE `Hospital` ADD CONSTRAINT `Hospital_updatedById_fkey` FOREIGN KEY (`updatedById`) REFERENCES `User`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;

CREATE INDEX `Hospital_createdAt_idx` ON `Hospital`(`createdAt`);
CREATE INDEX `Hospital_updatedAt_idx` ON `Hospital`(`updatedAt`);
CREATE INDEX `Hospital_createdById_idx` ON `Hospital`(`createdById`);
CREATE INDEX `Hospital_updatedById_idx` ON `Hospital`(`updatedById`);
