· 7 years ago · Jan 09, 2019, 04:00 AM
1connection.createStatement().execute(
2 "CREATE TABLE IF NOT EXISTS VSkyblock_Player("
3 + "playername VARCHAR(50) NOT NULL,"
4 + "uuid VARCHAR(100) UNIQUE NOT NULL,"
5 + "islandid BIGINT,"
6 + "islandowner BOOLEAN NOT NULL DEFAULT false,"
7 + "owneruuid VARCHAR(100),"
8 + "kicked BOOLEAN NOT NULL DEFAULT false,"
9 + "PRIMARY KEY (playername));");
10 connection.createStatement().execute(
11 "CREATE TABLE IF NOT EXISTS VSkyblock_Island("
12 + "islandid BIGINT AUTO_INCREMENT NOT NULL,"
13 + "island VARCHAR(100) NOT NULL,"
14 + "islandlevel VARCHAR(100) DEFAULT 0,"
15 + "PRIMARY KEY (islandid))");