﻿  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
> CREATE TABLE `GaleriPhoto` (
      `id` VARCHAR(191) NOT NULL,
      `galeriId` VARCHAR(191) NOT NULL,
      `url` TEXT NOT NULL,
      `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  
      PRIMARY KEY (`id`)
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- CreateTable
  CREATE TABLE `ShortLink` (
  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  
  -- AddForeignKey
> ALTER TABLE `GaleriPhoto` ADD CONSTRAINT `GaleriPhoto_galeriId_fkey` FOREIGN KEY (`galeriId`) REFERENCES `Galeri`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `ShortLink` ADD CONSTRAINT `ShortLink_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `ProgramUnggulan` ADD CONSTRAINT `ProgramUnggulan_kabinetId_fkey` FOREIGN KEY (`kabinetId`) REFERENCES `Kabinet`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;
  
  -- AddForeignKey
  ALTER TABLE `AwardeePH` ADD CONSTRAINT `AwardeePH_pengurusId_fkey` FOREIGN KEY (`pengurusId`) REFERENCES `Pengurus`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
  
