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.
768 B · 17 lines
SQL
at main
123456789101112131415161718-- RedefineTablesPRAGMA defer_foreign_keys=ON;PRAGMA foreign_keys=OFF;CREATE TABLE "new_GoLink" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "slug" TEXT NOT NULL, "targetUrl" TEXT NOT NULL DEFAULT 'https://wiki.andreijiroh.xyz/golinks', "is_active" BOOLEAN NOT NULL DEFAULT true, "created_on" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_on" DATETIME NOT NULL);INSERT INTO "new_GoLink" ("created_on", "id", "is_active", "slug", "targetUrl", "updated_on") SELECT "created_on", "id", "is_active", "slug", "targetUrl", "updated_on" FROM "GoLink";DROP TABLE "GoLink";ALTER TABLE "new_GoLink" RENAME TO "GoLink";CREATE UNIQUE INDEX "GoLink_slug_key" ON "GoLink"("slug");PRAGMA foreign_keys=ON;PRAGMA defer_foreign_keys=OFF;