migration.sql 410 B

123456789101112
  1. -- Customer mail sent through the platform's own address, per workshop and
  2. -- UTC day, for the daily cap on plans without custom email. A new table with
  3. -- no data to move.
  4. -- CreateTable
  5. CREATE TABLE "platform_mail_usage" (
  6. "organizationId" TEXT NOT NULL,
  7. "day" TEXT NOT NULL,
  8. "count" INTEGER NOT NULL DEFAULT 0,
  9. CONSTRAINT "platform_mail_usage_pkey" PRIMARY KEY ("organizationId","day")
  10. );