/*
  Warnings:

  - You are about to drop the column `keyword` on the `Slot` table. All the data in the column will be lost.
  - You are about to drop the column `product` on the `Slot` table. All the data in the column will be lost.
  - You are about to drop the column `product2` on the `Slot` table. All the data in the column will be lost.
  - You are about to drop the column `productName` on the `Slot` table. All the data in the column will be lost.
  - You are about to drop the column `url` on the `Slot` table. All the data in the column will be lost.
  - You are about to drop the column `url2` on the `Slot` table. All the data in the column will be lost.
  - You are about to drop the `Crawl` table. If the table is not empty, all the data it contains will be lost.

*/
-- AlterTable
ALTER TABLE "Log" ADD COLUMN     "campaign" TEXT;

-- AlterTable
ALTER TABLE "Slot" DROP COLUMN "keyword",
DROP COLUMN "product",
DROP COLUMN "product2",
DROP COLUMN "productName",
DROP COLUMN "url",
DROP COLUMN "url2",
ADD COLUMN     "campaign" TEXT,
ADD COLUMN     "days" INTEGER NOT NULL DEFAULT 0,
ADD COLUMN     "mainKeyword" TEXT,
ADD COLUMN     "placeCode" TEXT,
ADD COLUMN     "regKeyword" TEXT,
ADD COLUMN     "storeType" TEXT,
ADD COLUMN     "works" INTEGER NOT NULL DEFAULT 0;

-- DropTable
DROP TABLE "Crawl";
