19 lines
596 B
MySQL
19 lines
596 B
MySQL
|
-- CreateTable
|
||
|
|
CREATE TABLE "partner_shops" (
|
||
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
||
|
|
"region" TEXT NOT NULL,
|
||
|
|
"name" TEXT NOT NULL,
|
||
|
|
"address" TEXT NOT NULL,
|
||
|
|
"imageUrl" TEXT NOT NULL,
|
||
|
|
"sortOrder" INTEGER NOT NULL DEFAULT 0,
|
||
|
|
"active" BOOLEAN NOT NULL DEFAULT true,
|
||
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
"updatedAt" DATETIME NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
-- CreateIndex
|
||
|
|
CREATE INDEX "partner_shops_active_sortOrder_idx" ON "partner_shops"("active", "sortOrder");
|
||
|
|
|
||
|
|
-- CreateIndex
|
||
|
|
CREATE UNIQUE INDEX "partner_shops_name_region_key" ON "partner_shops"("name", "region");
|