/*
  Warnings:

  - You are about to drop the column `customNumberList` on the `campaign` table. All the data in the column will be lost.

*/
-- AlterTable
ALTER TABLE `campaign` DROP COLUMN `customNumberList`;

-- CreateTable
CREATE TABLE `campaign_recipient` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `campaignId` INTEGER NOT NULL,
    `phoneNumber` VARCHAR(20) NOT NULL,
    `name` VARCHAR(255) NULL,
    `param1` VARCHAR(255) NULL,
    `param2` VARCHAR(255) NULL,
    `param3` VARCHAR(255) NULL,
    `param4` VARCHAR(255) NULL,
    `param5` VARCHAR(255) NULL,
    `param6` VARCHAR(255) NULL,
    `param7` VARCHAR(255) NULL,
    `param8` VARCHAR(255) NULL,
    `param9` VARCHAR(255) NULL,
    `param10` VARCHAR(255) NULL,

    INDEX `campaign_recipient_campaignId_idx`(`campaignId`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- AddForeignKey
ALTER TABLE `campaign_recipient` ADD CONSTRAINT `campaign_recipient_campaignId_fkey` FOREIGN KEY (`campaignId`) REFERENCES `campaign`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;