2 CREATE TABLE "Player" (
4 "username" TEXT NOT NULL,
5 "password" TEXT NOT NULL,
6 "level" INTEGER NOT NULL DEFAULT 1,
7 "currency" INTEGER NOT NULL DEFAULT 0,
8 "pow" INTEGER NOT NULL,
9 "zest" INTEGER NOT NULL,
10 "woosh" INTEGER NOT NULL,
11 "luck" INTEGER NOT NULL,
12 "aha" INTEGER NOT NULL,
13 "wow" INTEGER NOT NULL,
14 "current_exp" INTEGER NOT NULL DEFAULT 0,
15 "stamina" INTEGER NOT NULL,
16 "hp" INTEGER NOT NULL,
17 "stat_points" INTEGER NOT NULL DEFAULT 0,
19 CONSTRAINT "Player_pkey" PRIMARY KEY ("id")
23 CREATE UNIQUE INDEX "Player_username_key" ON "Player"("username");