admins
b6d555ab3b
Inside-LMS toolbox for registered students: callout-CSS, YAML-frontmatter, theme CSS-variables, Style Settings generators. Auth inherited from (student) route group; no public surface, no email gate. - Pure generators in src/lib/tools/* with Vitest (33 tests) - Shared YAML-safe scalar quoter (_shared/yaml.ts) used by frontmatter + style-settings: unquoted user input was silently breaking YAML (tags '#x' -> null, color default '#7C3AED' -> null, 'a: b' -> parse error) - hex validation in callout (no NaN), date input constrained, clipboard + analytics calls guarded - Prisma ToolUsage model + migration; logToolUsage Server Action (auth-first, 10-min dedup window per user/tool) - Tool index /tools + ToolCard (explicit lucide map, no import *) + header link Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
15 lines
684 B
SQL
15 lines
684 B
SQL
-- Obsidian Toolbox — факт использования генератора участником (аналитика)
|
|
CREATE TABLE "ToolUsage" (
|
|
"id" TEXT NOT NULL,
|
|
"userId" TEXT NOT NULL,
|
|
"tool" TEXT NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
CONSTRAINT "ToolUsage_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
CREATE INDEX "ToolUsage_userId_idx" ON "ToolUsage"("userId");
|
|
CREATE INDEX "ToolUsage_tool_idx" ON "ToolUsage"("tool");
|
|
CREATE INDEX "ToolUsage_createdAt_idx" ON "ToolUsage"("createdAt");
|
|
|
|
ALTER TABLE "ToolUsage" ADD CONSTRAINT "ToolUsage_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|