bbeandCursor
3bdd01dedf
Add UserRelay API and dashboard relays tab with NIP-65 import, store post naddr for Nostr articles, and ship Prisma migrations for board tables, user relays, and post metadata. Co-authored-by: Cursor <cursoragent@cursor.com>
13 lines
375 B
SQL
13 lines
375 B
SQL
-- CreateTable
|
|
CREATE TABLE "UserRelay" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"pubkey" TEXT NOT NULL,
|
|
"url" TEXT NOT NULL,
|
|
"read" BOOLEAN NOT NULL DEFAULT true,
|
|
"write" BOOLEAN NOT NULL DEFAULT true,
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "UserRelay_pubkey_url_key" ON "UserRelay"("pubkey", "url");
|