13 lines
389 B
SQL
13 lines
389 B
SQL
-- CreateTable
|
|
CREATE TABLE IF NOT EXISTS rebreak.game_ratings (
|
|
"id" UUID NOT NULL DEFAULT gen_random_uuid(),
|
|
"user_id" UUID NOT NULL,
|
|
"game_name" TEXT NOT NULL,
|
|
"stars" INTEGER NOT NULL,
|
|
"feedback" TEXT,
|
|
"score" INTEGER NOT NULL DEFAULT 0,
|
|
"created_at" TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
CONSTRAINT "game_ratings_pkey" PRIMARY KEY ("id")
|
|
);
|