Malin
bc9f96cbd4
- Set Spanish as default language with ephemeral/encrypted privacy focus - Translate all user-facing strings and legal pages to Spanish - Replace Norwegian flag with Spanish flag in footer - Remove Hemmelig/terces.cloud links, add cloudhost.es sponsorship - Rewrite PrivacyPage: zero data collection, ephemeral design emphasis - Rewrite TermsPage: Spanish law, RGPD, paste.es/CloudHost.es references - Update PWA manifest, HTML meta tags, package.json branding - Rename webhook headers to X-Paste-Event / X-Paste-Signature - Update API docs title and contact to paste.es / cloudhost.es Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
72 lines
1.9 KiB
SQL
72 lines
1.9 KiB
SQL
-- CreateTable
|
|
CREATE TABLE "secrets" (
|
|
"id" BIGINT NOT NULL PRIMARY KEY,
|
|
"secret" TEXT NOT NULL,
|
|
"title" TEXT,
|
|
"views" INTEGER DEFAULT 1,
|
|
"password" TEXT,
|
|
"is_burnable" BOOLEAN DEFAULT false,
|
|
"created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"expires_at" DATETIME,
|
|
"is_public" BOOLEAN DEFAULT false,
|
|
"ip_range" TEXT DEFAULT ''
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "user" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"name" TEXT NOT NULL,
|
|
"email" TEXT NOT NULL,
|
|
"emailVerified" BOOLEAN NOT NULL,
|
|
"image" TEXT,
|
|
"createdAt" DATETIME NOT NULL,
|
|
"updatedAt" DATETIME NOT NULL
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "session" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"expiresAt" DATETIME NOT NULL,
|
|
"token" TEXT NOT NULL,
|
|
"createdAt" DATETIME NOT NULL,
|
|
"updatedAt" DATETIME NOT NULL,
|
|
"ipAddress" TEXT,
|
|
"userAgent" TEXT,
|
|
"userId" TEXT NOT NULL,
|
|
CONSTRAINT "session_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "account" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"accountId" TEXT NOT NULL,
|
|
"providerId" TEXT NOT NULL,
|
|
"userId" TEXT NOT NULL,
|
|
"accessToken" TEXT,
|
|
"refreshToken" TEXT,
|
|
"idToken" TEXT,
|
|
"accessTokenExpiresAt" DATETIME,
|
|
"refreshTokenExpiresAt" DATETIME,
|
|
"scope" TEXT,
|
|
"password" TEXT,
|
|
"createdAt" DATETIME NOT NULL,
|
|
"updatedAt" DATETIME NOT NULL,
|
|
CONSTRAINT "account_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "verification" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"identifier" TEXT NOT NULL,
|
|
"value" TEXT NOT NULL,
|
|
"expiresAt" DATETIME NOT NULL,
|
|
"createdAt" DATETIME,
|
|
"updatedAt" DATETIME
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "user_email_key" ON "user"("email");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "session_token_key" ON "session"("token");
|