jasonho1308 / summer-code-jam-2022 Goto Github PK

CREATE TABLE players
(
    name character varying(32) NOT NULL,
    password character varying(73) NOT NULL,
    "max hp" bigint NOT NULL DEFAULT 100,
    "max energy" bigint NOT NULL DEFAULT 25,
    abilities json[],
    "pve cooldown" timestamp without time zone,
    "pvp cooldown" timestamp without time zone,
    PRIMARY KEY (name)
);