mirror of
https://github.com/hanzoai/calendar.git
synced 2026-10-30 14:46:43 +00:00
1d8326ed83
* lock users on signup if their email is in blacklist * add to turbo env list * prevent locked user or blocked email domain from using API * Refactored to only run 1 query to find the user * Fixing tests * WIP * WIP * WIP * Discard changes to turbo.json * Fixed tests * Update isLockedOrBlocked.test.ts * Update isAdmin.integration-test.ts * Update tsconfig.json * chore: rename to watchlist Signed-off-by: Omar López <[email protected]> --------- Signed-off-by: Omar López <[email protected]> Co-authored-by: sean-brydon <[email protected]> Co-authored-by: Keith Williams <[email protected]> Co-authored-by: sean-brydon <[email protected]>
32 lines
1.0 KiB
SQL
32 lines
1.0 KiB
SQL
-- CreateEnum
|
|
CREATE TYPE "WatchlistType" AS ENUM ('EMAIL', 'DOMAIN', 'USERNAME');
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "Watchlist" (
|
|
"id" TEXT NOT NULL,
|
|
"type" "WatchlistType" NOT NULL,
|
|
"value" TEXT NOT NULL,
|
|
"description" TEXT,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"createdById" INTEGER NOT NULL,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
"updatedById" INTEGER,
|
|
|
|
CONSTRAINT "Watchlist_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "Watchlist_id_key" ON "Watchlist"("id");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Watchlist_type_value_idx" ON "Watchlist"("type", "value");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "Watchlist_type_value_key" ON "Watchlist"("type", "value");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Watchlist" ADD CONSTRAINT "Watchlist_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Watchlist" ADD CONSTRAINT "Watchlist_updatedById_fkey" FOREIGN KEY ("updatedById") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|