TCt4pAWn

1    await conn.execute('''
2        CREATE TABLE IF NOT EXISTS servers(
3            id serial PRIMARY KEY,
4            name text
5            )
6    ''')
7    await conn.execute('''
8        CREATE TABLE IF NOT EXISTS players(
9            id serial PRIMARY KEY,
10            name text
11            )
12    ''')
13    await conn.execute('''
14        CREATE TABLE IF NOT EXISTS mod_roles(
15            id serial PRIMARY KEY,
16            server_id integer REFERENCES servers(id),
17            role_id integer
18            )
19    ''')
20    await conn.execute('''
21        CREATE TABLE IF NOT EXISTS admins(
22            id serial PRIMARY KEY,
23            server_id integer REFERENCES servers(id),
24            player_id integer REFERENCES players(id)
25            )
26    ''')
27    await conn.execute('''
28        CREATE TABLE IF NOT EXISTS admin_roles(
29            id serial PRIMARY KEY,
30            server_id integer REFERENCES servers(id),
31            role_id integer
32            )
33    ''')
34    await conn.execute('''
35        CREATE TABLE IF NOT EXISTS igns(
36            id serial PRIMARY KEY,
37            player_id integer REFERENCES players(id),
38            region region_type,
39            ign text
40            )
41    ''')
42    await conn.execute('''
43        CREATE TABLE IF NOT EXISTS stats(
44            id serial PRIMARY KEY,
45            server_id integer REFERENCES servers(id),
46            player_id integer REFERENCES players(id),
47            region region_type,
48            elo integer default 1500,
49            wins integer default 0,
50            games_played integer default 0,
51            last_play timestamp,
52            play_by timestamp
53        )
54    ''')
55    await conn.execute('''
56        CREATE TABLE IF NOT EXISTS banlist(
57            id serial PRIMARY KEY,
58            server_id integer REFERENCES servers(id),
59            player_id integer REFERENCES players(id),
60            name text,
61            unban_date integer
62            )
63    ''')
64    await conn.execute('''
65        CREATE TABLE IF NOT EXISTS teams(
66            id serial PRIMARY KEY,
67            player_id integer REFERENCES players(id)
68            )
69    ''')
70    await conn.execute('''
71        CREATE TABLE IF NOT EXISTS team_players(
72            id serial PRIMARY KEY,
73            team_id integer REFERENCES teams(id),
74            player_id integer REFERENCES players(id)
75            )
76    ''')
77    await conn.execute('''
78        CREATE TABLE IF NOT EXISTS matches(
79            id serial PRIMARY KEY,
80            server_id integer REFERENCES servers(id),
81            team_1 integer REFERENCES teams(id),
82            team_2 integer REFERENCES teams(id),
83            region region_type,
84            match_date timestamp default current_timestamp
85            )
86    ''')