migration.sql 574 B

123456789101112131415
  1. /*
  2. Warnings:
  3. - A unique constraint covering the columns `[id]` on the table `Shortcode` will be added. If there are existing duplicate values, this will fail.
  4. */
  5. -- AlterTable
  6. ALTER TABLE "Shortcode" ADD COLUMN "embedProperties" JSONB,
  7. ADD COLUMN "updatedOn" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP;
  8. -- CreateIndex
  9. CREATE UNIQUE INDEX "Shortcode_id_key" ON "Shortcode"("id");
  10. -- AddForeignKey
  11. ALTER TABLE "Shortcode" ADD CONSTRAINT "Shortcode_creatorUid_fkey" FOREIGN KEY ("creatorUid") REFERENCES "User"("uid") ON DELETE SET NULL ON UPDATE CASCADE;