mirror of
https://github.com/hanzoai/calendar.git
synced 2026-10-30 14:46:43 +00:00
e478a46358
* Reserving slot picked up on cache * change memory-cache to database table to block slots while reservation completes * remove memory-cache * update realeaseAt field when same user change te selected Slot * Change default time to book Co-authored-by: alannnc <[email protected]> * remove ip field and renews the session when the user remains in the booking form * Remove duplicate router * types fixes * nit picks * Update turbo.json * Revert unrelated change * Uses constant * Constant already has a fallback * Update slots.ts * Unit test fixes * slot reservation on user level and support seats * types fixes and reserve slots on click * Fix nit var name --------- Co-authored-by: Efraín Rochín <[email protected]> Co-authored-by: zomars <[email protected]> Co-authored-by: Peer Richelsen <[email protected]>
17 lines
571 B
SQL
17 lines
571 B
SQL
-- CreateTable
|
|
CREATE TABLE "SelectedSlots" (
|
|
"id" SERIAL NOT NULL,
|
|
"eventTypeId" INTEGER NOT NULL,
|
|
"userId" INTEGER NOT NULL,
|
|
"slotUtcStartDate" TIMESTAMP(3) NOT NULL,
|
|
"slotUtcEndDate" TIMESTAMP(3) NOT NULL,
|
|
"uid" TEXT NOT NULL,
|
|
"releaseAt" TIMESTAMP(3) NOT NULL,
|
|
"isSeat" BOOLEAN NOT NULL DEFAULT false,
|
|
|
|
CONSTRAINT "SelectedSlots_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "SelectedSlots_userId_slotUtcStartDate_slotUtcEndDate_uid_key" ON "SelectedSlots"("userId", "slotUtcStartDate", "slotUtcEndDate", "uid");
|