从java文件到SQL查询- Minecraft插件

Question

因为我在一个minecraft服务器上工作，一些插件不会使某个表本身。有兴趣的:https://www.spigotmc.org/resources/craftconomy.2395/

但是在github文件中，我找到了java脚本，它确实生成了所需的表。

public final String createTableMySQL = "CREATE TABLE IF NOT EXISTS " + getPrefix() + TABLE_NAME + " (" +
"  `" + BALANCE_FIELD + "` double DEFAULT NULL," +
"  `" + WORLD_NAME_FIELD + "` varchar(255)," +
"  `username_id` int(11)," +
"  `" + CURRENCY_FIELD + "` varchar(50)," +
"  PRIMARY KEY (" + WORLD_NAME_FIELD + ", username_id, currency_id)," +
"  CONSTRAINT `"+getPrefix()+"fk_balance_account`" +
"    FOREIGN KEY (username_id)" +
"    REFERENCES " + getPrefix() + AccountTable.TABLE_NAME + "(id) ON UPDATE CASCADE ON DELETE CASCADE," +
"  CONSTRAINT `"+getPrefix()+"fk_balance_currency`" +
"    FOREIGN KEY (" + CURRENCY_FIELD + ")" +
"    REFERENCES " + getPrefix() + CurrencyTable.TABLE_NAME +"(name) ON UPDATE CASCADE ON DELETE CASCADE" +
") ENGINE=InnoDB CHARSET=utf8;";

有人能帮我做一个SQL查询出来，这只是可以放入PHPMyadmin?谢谢你的阅读。

Answer 1

我已经自己解决了，没有理由再反应了。