Files
devops ff3f819fb6
Deploy Canina / deploy (push) Successful in 2m25s
E2E Playwright Tests / Run Full E2E & Security Suites (push) Failing after 6s
feat(admin): implement 4 admin modules schema, migrations, DTOs and controllers with CSV export
2026-10-13 21:18:19 +00:00

107 lines
3.5 KiB
SQL

-- CreateTable
CREATE TABLE "competitor_price_logs" (
"id" UUID NOT NULL,
"product_id" UUID NOT NULL,
"competitor_name" VARCHAR(100) NOT NULL,
"competitor_price" DECIMAL(15,2) NOT NULL,
"shop_url" TEXT NOT NULL,
"in_stock" BOOLEAN NOT NULL DEFAULT true,
"checked_at" TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "competitor_price_logs_pkey" PRIMARY KEY ("id")
);
-- CreateTable
CREATE TABLE "b2b_leads" (
"id" UUID NOT NULL,
"clinic_name" VARCHAR(200) NOT NULL,
"contact_person" VARCHAR(150) NOT NULL,
"phone" VARCHAR(20) NOT NULL,
"city" VARCHAR(100) NOT NULL,
"district" VARCHAR(100),
"tier" VARCHAR(50) NOT NULL DEFAULT 'STANDARD',
"specialties" TEXT[] DEFAULT ARRAY[]::TEXT[],
"status" VARCHAR(30) NOT NULL DEFAULT 'NEW',
"notes" TEXT,
"created_at" TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updated_at" TIMESTAMPTZ NOT NULL,
CONSTRAINT "b2b_leads_pkey" PRIMARY KEY ("id")
);
-- CreateTable
CREATE TABLE "price_suggestions" (
"id" UUID NOT NULL,
"product_id" UUID NOT NULL,
"suggested_price" DECIMAL(15,2) NOT NULL,
"current_price" DECIMAL(15,2) NOT NULL,
"competitor_benchmark" DECIMAL(15,2),
"rationale" TEXT,
"status" VARCHAR(20) NOT NULL DEFAULT 'pending',
"created_at" TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updated_at" TIMESTAMPTZ NOT NULL,
CONSTRAINT "price_suggestions_pkey" PRIMARY KEY ("id")
);
-- CreateTable
CREATE TABLE "sms_campaigns" (
"id" UUID NOT NULL,
"title" VARCHAR(200) NOT NULL,
"body" TEXT NOT NULL,
"target_segment" VARCHAR(100) NOT NULL,
"estimated_cost" DECIMAL(15,2),
"status" VARCHAR(20) NOT NULL DEFAULT 'draft',
"metrics" JSONB DEFAULT '{}',
"created_at" TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updated_at" TIMESTAMPTZ NOT NULL,
CONSTRAINT "sms_campaigns_pkey" PRIMARY KEY ("id")
);
-- CreateIndex
CREATE INDEX "competitor_price_logs_product_id_idx" ON "competitor_price_logs"("product_id");
-- CreateIndex
CREATE INDEX "competitor_price_logs_competitor_name_idx" ON "competitor_price_logs"("competitor_name");
-- CreateIndex
CREATE INDEX "competitor_price_logs_checked_at_idx" ON "competitor_price_logs"("checked_at");
-- CreateIndex
CREATE INDEX "b2b_leads_status_idx" ON "b2b_leads"("status");
-- CreateIndex
CREATE INDEX "b2b_leads_city_idx" ON "b2b_leads"("city");
-- CreateIndex
CREATE INDEX "b2b_leads_tier_idx" ON "b2b_leads"("tier");
-- CreateIndex
CREATE INDEX "b2b_leads_phone_idx" ON "b2b_leads"("phone");
-- CreateIndex
CREATE INDEX "price_suggestions_product_id_idx" ON "price_suggestions"("product_id");
-- CreateIndex
CREATE INDEX "price_suggestions_status_idx" ON "price_suggestions"("status");
-- CreateIndex
CREATE INDEX "price_suggestions_created_at_idx" ON "price_suggestions"("created_at");
-- CreateIndex
CREATE INDEX "sms_campaigns_status_idx" ON "sms_campaigns"("status");
-- CreateIndex
CREATE INDEX "sms_campaigns_target_segment_idx" ON "sms_campaigns"("target_segment");
-- CreateIndex
CREATE INDEX "sms_campaigns_created_at_idx" ON "sms_campaigns"("created_at");
-- AddForeignKey
ALTER TABLE "competitor_price_logs" ADD CONSTRAINT "competitor_price_logs_product_id_fkey" FOREIGN KEY ("product_id") REFERENCES "products"("id") ON DELETE CASCADE ON UPDATE CASCADE;
-- AddForeignKey
ALTER TABLE "price_suggestions" ADD CONSTRAINT "price_suggestions_product_id_fkey" FOREIGN KEY ("product_id") REFERENCES "products"("id") ON DELETE CASCADE ON UPDATE CASCADE;