36 lines
939 B
SQL
36 lines
939 B
SQL
-- CreateIndex
|
|
CREATE INDEX "Vendor_slug_idx" ON "Vendor"("slug");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_name_idx" ON "Vendor"("name");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_type_idx" ON "Vendor"("type");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_status_idx" ON "Vendor"("status");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_isBooked_idx" ON "Vendor"("isBooked");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_bookedDate_idx" ON "Vendor"("bookedDate");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_finalCost_idx" ON "Vendor"("finalCost");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_createdAt_idx" ON "Vendor"("createdAt");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_type_status_idx" ON "Vendor"("type", "status");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_isBooked_type_idx" ON "Vendor"("isBooked", "type");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_depositDueDate_idx" ON "Vendor"("depositDueDate");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Vendor_finalPaymentDue_idx" ON "Vendor"("finalPaymentDue");
|