· 7 years ago · Nov 09, 2018, 11:42 PM
1CREATE TABLE IF NOT EXISTS uhc_stats(uuid VARCHAR(36) NOT NULL PRIMARY KEY, wins INT(100) NOT NULL DEFAULT '0', kills INT(100) NOT NULL DEFAULT '0', deaths INT(100) NOT NULL DEFAULT '0', `coal-mined` INT(100) NOT NULL DEFAULT '0', `iron-mined` INT(100) NOT NULL DEFAULT '0', `gold-mined` INT(100) NOT NULL DEFAULT '0', `lapis-mined` INT(100) NOT NULL DEFAULT '0', `redstone-mined` INT(100) NOT NULL DEFAULT '0', `diamond-mined` INT(100) NOT NULL DEFAULT '0', `emerald-mined` INT(100) NOT NULL DEFAULT '0');