schalli
8c24c1e267
- Create @tessera/module-sdk with TesseraModule, ModuleRoute, ModuleManifest, ModuleCategory types - Add Module and TenantModuleActivation Prisma models with tenant-scoped unique constraint - Apply migration add-module-registry to PostgreSQL - Framework-agnostic ComponentType for lazy-loaded module UIs
39 lines
1.2 KiB
SQL
39 lines
1.2 KiB
SQL
-- CreateTable
|
|
CREATE TABLE "Module" (
|
|
"id" TEXT NOT NULL,
|
|
"slug" TEXT NOT NULL,
|
|
"name" TEXT NOT NULL,
|
|
"version" TEXT NOT NULL,
|
|
"category" TEXT NOT NULL,
|
|
"description" JSONB NOT NULL,
|
|
"icon" TEXT,
|
|
"isSystem" BOOLEAN NOT NULL DEFAULT false,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "Module_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "TenantModuleActivation" (
|
|
"id" TEXT NOT NULL,
|
|
"tenantId" TEXT NOT NULL,
|
|
"moduleId" TEXT NOT NULL,
|
|
"isActive" BOOLEAN NOT NULL DEFAULT true,
|
|
"activatedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
CONSTRAINT "TenantModuleActivation_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "Module_slug_key" ON "Module"("slug");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "TenantModuleActivation_tenantId_idx" ON "TenantModuleActivation"("tenantId");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "TenantModuleActivation_tenantId_moduleId_key" ON "TenantModuleActivation"("tenantId", "moduleId");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "TenantModuleActivation" ADD CONSTRAINT "TenantModuleActivation_moduleId_fkey" FOREIGN KEY ("moduleId") REFERENCES "Module"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|