text: /*
    Warnings:
  
    - You are about to drop the column `category` on the `File` table. All the data in the column will be lost.
  
  */
  -- AlterTable
  ALTER TABLE "File" DROP COLUMN "category",
  ADD COLUMN     "categoryId" INTEGER;
  
  -- CreateTable
  CREATE TABLE "Category" (
      "id" SERIAL NOT NULL,
      "name" VARCHAR NOT NULL,
      "type" VARCHAR NOT NULL,
      "expires" BOOLEAN NOT NULL DEFAULT false,
  
      PRIMARY KEY ("id")
  );
  
  -- CreateIndex
  CREATE UNIQUE INDEX "Category_name_type_key" ON "Category"("name", "type");
  
  -- AddForeignKey
  ALTER TABLE "File" ADD FOREIGN KEY ("categoryId") REFERENCES "Category"("id") ON DELETE SET NULL ON UPDATE CASCADE;
  