vGCAc3hE

1/*
2 * Copyright (©) 2019 - all rights reserved by Nick Besier.
3 * This complete file (OnPlayerTable.java/OnPlayerTable) is copyrighted.
4 * This complete project (LobbySystem - LobbySystem) is also copyrighted
5 * Last modified on 1/9/19 11:55 PM by Nick Besier.
6 * See the copyright.txt for further informations.
7 */
8
9package cloud.evaped.lobby.main.EVPD;
10
11import cloud.evaped.core.initialize.database.Database;
12import cloud.evaped.core.initialize.database.connection.MySQL.MySQL;
13import cloud.evaped.core.initialize.database.connection.MySQL.TableCreator;
14import cloud.evaped.core.initialize.utils.Logger;
15
16import java.sql.Connection;
17
18public class OnPlayerTable implements TableCreator {
19
20    /**
21     * Overrides the table creator for table "playerTable".
22     * {@link TableCreator}
23     */
24
25    @Override
26    public void execute() {
27        try {
28            Connection con = MySQL.getInstance().getConnection();
29            con.prepareStatement("CREATE TABLE IF NOT EXISTS playerTable (UUID VARCHAR(40) PRIMARY KEY, name VARCHAR(17), rewards1 VARCHAR(11), rewards2 VARCHAR(11), rewards3 VARCHAR(11), rewards4 VARCHAR(11), tickets INT(10), cases INT(10)" +
30                    ", kills INT(5), death INT(5), chat INT(2), doublejump INT(2), broadcaster INT(2), speed INT(2), terms INT(2), saveInv INT(2), s1 INT(2), s2 INT(2), s3 INT(2), s4 INT(2), s5 INT(2), srtokens INT(10))")
31                    .executeUpdate();
32        } catch (Exception e) {
33            Logger.error("Could not create playerTable");
34        }
35    }
36
37}