20 lines
905 B
SQL
20 lines
905 B
SQL
CREATE TABLE "HomeModule" (
|
|
"id" TEXT NOT NULL,
|
|
"label" TEXT NOT NULL,
|
|
"sortOrder" INTEGER NOT NULL DEFAULT 0,
|
|
"isActive" BOOLEAN NOT NULL DEFAULT true,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "HomeModule_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
INSERT INTO "HomeModule" ("id", "label", "sortOrder", "isActive", "createdAt", "updatedAt")
|
|
VALUES
|
|
('explore', '探索贵州', 0, true, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
|
|
('themes', '主题甄选', 1, true, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
|
|
('deals', '特价优惠', 2, true, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
|
|
('routes', '精选线路', 3, true, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
|
|
('hotels', '特色酒店', 4, true, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
|
|
('vehicles', '万趣用车', 5, true, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
|