inada-s / zdxsv

Gundam vs. Zeta Gundam private game server
https://zdxsv.net
GNU Affero General Public License v3.0
10 stars 6 forks source link

record battle result #28

Closed inada-s closed 4 years ago

inada-s commented 4 years ago

This patch enables:

Before applying this patch, we have to execute following sql:

CREATE TABLE IF NOT EXISTS battle_record (
        battle_code text,
        user_id     text,
        players     integer default 0,
        pos         integer default 0,
        side        integer default 0,
        round       integer default 0,
        win         integer default 0,
        lose        integer default 0,
        kill        integer default 0,
        death       integer default 0,
        frame       integer default 0,
        result      text default '',
        created     timestamp,
        updated     timestamp,
        system      integer default 0,
        PRIMARY KEY (battle_code, user_id)
);
CREATE INDEX BATTLE_RECORD_USER_ID ON battle_record(user_id);
CREATE INDEX BATTLE_RECORD_PLAYERS ON battle_record(players);
CREATE INDEX BATTLE_RECORD_CREATED ON battle_record(created);