· 7 years ago · Nov 09, 2018, 11:40 PM
1"CREATE TABLE IF NOT EXISTS uhc_stats( " +
2 " uuid VARCHAR(36) NOT NULL PRIMARY KEY, " +
3 " wins INT(100) NOT NULL DEFAULT '0', " +
4 " kills INT(100) NOT NULL DEFAULT '0'," +
5 " deaths INT(100) NOT NULL DEFAULT '0'," +
6 "`coal-mined` INT(100) NOT NULL DEFAULT '0'," +
7 " `iron-mined` INT(100) NOT NULL DEFAULT '0'," +
8 " `gold-mined` INT(100) NOT NULL DEFAULT '0'," +
9 " `lapis-mined` INT(100) NOT NULL DEFAULT '0'," +
10 " `redstone-mined` INT(100) NOT NULL DEFAULT '0'," +
11 " `diamond-mined` INT(100) NOT NULL DEFAULT '0'," +
12 " `emerald-mined` INT(100) NOT NULL DEFAULT '0');");