54 lines
1.3 KiB
SQL
54 lines
1.3 KiB
SQL
create table if not exists wynn_guild_members (
|
|
guild_id UUID not null,
|
|
member_id UUID not null,
|
|
rank text not null,
|
|
joined_at timestamptz not null,
|
|
contributed bigint not null,
|
|
primary key (guild_id, member_id),
|
|
unique(member_id)
|
|
);
|
|
create table if not exists wynn_guild_info (
|
|
uid UUID not null,
|
|
name text not null,
|
|
prefix text not null,
|
|
xp bigint not null default 0,
|
|
level bigint,
|
|
xp_percent bigint,
|
|
territories bigint,
|
|
wars bigint,
|
|
created timestamptz,
|
|
primary key (uid)
|
|
);
|
|
|
|
create index if not exists wynn_guild_info_xp on wynn_guild_info (xp);
|
|
|
|
create table if not exists wynn_guild_season_results (
|
|
guild_id UUID not null,
|
|
season text not null,
|
|
rating bigint not null,
|
|
territories bigint not null,
|
|
primary key (guild_id, season)
|
|
);
|
|
create table if not exists minecraft_user (
|
|
uid UUID not null,
|
|
name text not null,
|
|
server text,
|
|
primary key (uid)
|
|
);
|
|
create table if not exists discord_guild_setting(
|
|
discord_guild text not null,
|
|
name text not null,
|
|
value jsonb not null,
|
|
primary key (discord_guild, name)
|
|
);
|
|
|
|
---- create above / drop below ----
|
|
|
|
drop table if exists wynn_guild_members;
|
|
drop table if exists wynn_guild_info;
|
|
drop table if exists wynn_guild_season_results;
|
|
drop table if exists minecraft_user;
|
|
drop table if exists discord_guild_setting;
|
|
|
|
|