Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/andreijiroh-dev/api-servers. Monorepo for different Cloudflare Workers and Deno Deploy hosted APIs
api-servers cloudflare-workers deno-deploy golinks hackclub-arcade
Something went wrong. Try again.
1.3 kB · 45 lines
SQL
at main
12345678910111213141516171819202122232425262728293031323334353637383940414243444546-- CreateTableCREATE TABLE "SlackBotToken" ( "teamId" TEXT NOT NULL PRIMARY KEY, "enterprise_install" BOOLEAN NOT NULL DEFAULT false, "token" TEXT NOT NULL, "created_on" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_on" DATETIME NOT NULL);
-- CreateTableCREATE TABLE "GitHubOAuthChallenge" ( "id" TEXT NOT NULL PRIMARY KEY, "challenge" TEXT NOT NULL, "code" TEXT, "metadata" TEXT NOT NULL, "username" TEXT, "userId" TEXT);
-- CreateTableCREATE TABLE "ApiToken" ( "id" TEXT NOT NULL PRIMARY KEY, "token" TEXT NOT NULL, "userId" TEXT NOT NULL, CONSTRAINT "ApiToken_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User" ("id") ON DELETE CASCADE ON UPDATE CASCADE);
-- CreateTableCREATE TABLE "User" ( "id" TEXT NOT NULL PRIMARY KEY, "username" TEXT NOT NULL, "email" TEXT, "site_admin" BOOLEAN NOT NULL DEFAULT false, "created_on" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_on" DATETIME NOT NULL);
-- CreateIndexCREATE UNIQUE INDEX "SlackBotToken_teamId_key" ON "SlackBotToken"("teamId");
-- CreateIndexCREATE UNIQUE INDEX "ApiToken_token_key" ON "ApiToken"("token");
-- CreateIndexCREATE UNIQUE INDEX "User_username_key" ON "User"("username");