61 lines
1.5 KiB
SQL
61 lines
1.5 KiB
SQL
-- Write your migrate up statements here
|
|
create schema if not exists wynn;
|
|
create schema if not exists minecraft;
|
|
create schema if not exists discord;
|
|
|
|
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;
|
|
|
|
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 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 schema if exists wynn cascade;
|
|
drop schema if exists minecraft cascade;
|
|
drop schema if exists discord cascade;
|