82 lines
2.2 KiB
SQL
82 lines
2.2 KiB
SQL
-- CreateTable
|
|
CREATE TABLE "Task" (
|
|
"id" TEXT NOT NULL,
|
|
"title" TEXT NOT NULL,
|
|
"content" TEXT,
|
|
"deadline" TIMESTAMP(3),
|
|
"userId" TEXT NOT NULL,
|
|
|
|
CONSTRAINT "Task_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "Event" (
|
|
"id" TEXT NOT NULL,
|
|
"title" TEXT NOT NULL,
|
|
"content" TEXT,
|
|
"length" INTEGER NOT NULL,
|
|
"start_time" TIMESTAMP(3) NOT NULL,
|
|
"userId" TEXT NOT NULL,
|
|
|
|
CONSTRAINT "Event_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "auth_user" (
|
|
"id" TEXT NOT NULL,
|
|
"name" TEXT NOT NULL,
|
|
"username" TEXT NOT NULL,
|
|
|
|
CONSTRAINT "auth_user_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "auth_session" (
|
|
"id" TEXT NOT NULL,
|
|
"user_id" TEXT NOT NULL,
|
|
"active_expires" BIGINT NOT NULL,
|
|
"idle_expires" BIGINT NOT NULL,
|
|
|
|
CONSTRAINT "auth_session_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "auth_key" (
|
|
"primary_id" TEXT NOT NULL,
|
|
"hashed_password" TEXT,
|
|
"user_id" TEXT NOT NULL,
|
|
"primary" BOOLEAN NOT NULL,
|
|
|
|
CONSTRAINT "auth_key_pkey" PRIMARY KEY ("primary_id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "auth_user_id_key" ON "auth_user"("id");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "auth_user_username_key" ON "auth_user"("username");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "auth_session_id_key" ON "auth_session"("id");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "auth_session_user_id_idx" ON "auth_session"("user_id");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "auth_key_primary_id_key" ON "auth_key"("primary_id");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "auth_key_user_id_idx" ON "auth_key"("user_id");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Task" ADD CONSTRAINT "Task_userId_fkey" FOREIGN KEY ("userId") REFERENCES "auth_user"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Event" ADD CONSTRAINT "Event_userId_fkey" FOREIGN KEY ("userId") REFERENCES "auth_user"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "auth_session" ADD CONSTRAINT "auth_session_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "auth_user"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "auth_key" ADD CONSTRAINT "auth_key_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "auth_user"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|