17 lines
623 B
Markdown
17 lines
623 B
Markdown
create table public.users (
|
|
id bigint generated by default as identity not null,
|
|
created_at timestamp with time zone not null default now(),
|
|
username text null,
|
|
email text null,
|
|
password text null,
|
|
ip_address text null,
|
|
cc real null default '0'::real,
|
|
rc real null default '0'::real,
|
|
mmr integer not null default 1000,
|
|
last_logged_at timestamp with time zone null default now(),
|
|
session_id text null,
|
|
last_keepalive_at timestamp with time zone null,
|
|
constraint users_pkey primary key (id)
|
|
) TABLESPACE pg_default;
|
|
|
|
-- Apply: schemas/alter_users_mmr.sql (before updated rpc_settle_match_reward.sql) |