16 lines
523 B
MySQL
16 lines
523 B
MySQL
|
-- CreateTable
|
||
|
|
CREATE TABLE "api_keys" (
|
||
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
||
|
|
"name" TEXT NOT NULL,
|
||
|
|
"key_hash" TEXT NOT NULL,
|
||
|
|
"key_prefix" TEXT NOT NULL,
|
||
|
|
"userId" TEXT NOT NULL,
|
||
|
|
"last_used_at" DATETIME,
|
||
|
|
"expires_at" DATETIME,
|
||
|
|
"created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
CONSTRAINT "api_keys_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- CreateIndex
|
||
|
|
CREATE UNIQUE INDEX "api_keys_key_hash_key" ON "api_keys"("key_hash");
|