JBMR0F5p

1async def setup_db():
2    # player_id: Player id
3    # server_id: Server id
4    # match_id: Match id
5    await conn.execute('''
6        CREATE TYPE IF NOT EXISTS region AS ENUM(
7            'na',
8            'euw'
9            )
10    ''')
11    await conn.execute('''
12        CREATE TABLE IF NOT EXISTS servers(
13            server_id serial PRIMARY KEY,
14            name text
15            )
16    ''')
17    await conn.execute('''
18        CREATE TABLE IF NOT EXISTS players(
19            player_id serial PRIMARY KEY,
20            name text,
21            ign_na text,
22            ign_euw text
23            )
24    ''')
25    await conn.execute('''
26        CREATE TABLE IF NOT EXISTS stats(
27            id serial PRIMARY KEY,
28            server_id integer REFERENCES servers(server_id),
29            player_id integer REFERENCES players(player_id),
30            region region,
31            elo integer,
32            wins integer,
33            games_played integer,
34            last_play integer,
35            play_by integer
36        )
37    ''')
38    await conn.execute('''
39        CREATE TABLE IF NOT EXISTS banlist(
40            id serial PRIMARY KEY,
41            server_id integer REFERENCES servers(server_id),
42            player_id integer REFERENCES players(player_id),
43            name text,
44            unban_date integer
45            )
46    ''')
47    await conn.execute('''
48        CREATE TABLE IF NOT EXISTS player_list(
49            id serial PRIMARY KEY,
50            team_id integer REFERENCES teams(team_id),
51            player_id integer REFERENCES players(player_id),
52            )
53    ''')
54    await conn.execute('''
55        CREATE TABLE IF NOT EXISTS teams(
56            team_id serial PRIMARY KEY,
57            player_id integer REFERENCES players(player_id),
58            )
59    ''')
60    await conn.execute('''
61        CREATE TABLE IF NOT EXISTS matches(
62            match_id serial PRIMARY KEY,
63            server_id integer REFERENCES servers(server_id),
64            team_1 integer REFERENCES teams(team_id),
65            team_2 integer REFERENCES teams(team_id),
66            region region,
67            match_date integer
68            )
69    ''')