public void createTables() {
try {
getConn()
.createStatement()
.executeUpdate(
"CREATE TABLE `gpvp-groups` (\n"
+ " `id` INT NOT NULL AUTO_INCREMENT,\n"
+ " `name` VARCHAR(24) NOT NULL,\n"
+ " `owner` VARCHAR(20) NOT NULL,\n"
+ " `locbase` VARCHAR(60) NOT NULL,\n"
+ " PRIMARY KEY (`id`),\n"
+ " UNIQUE INDEX `id_UNIQUE` (`id` ASC),\n"
+ " UNIQUE INDEX `name_UNIQUE` (`name` ASC),\n"
+ " UNIQUE INDEX `owner_UNIQUE` (`owner` ASC));");
getConn()
.createStatement()
.executeUpdate(
"CREATE TABLE `gpvp-players` (\n"
+ " `name` VARCHAR(20) NOT NULL,\n"
+ " `groupid` INT NOT NULL,\n"
+ " PRIMARY KEY (`name`),\n"
+ " UNIQUE INDEX `name_UNIQUE` (`name` ASC));");
try {
if (Double.parseDouble(pl.getDescription().getVersion()) < 0.2D) {
getConn()
.createStatement()
.executeUpdate(
"ALTER TABLE `gpvp-groups` \n"
+ "ADD COLUMN `locbase` VARCHAR(60) NOT NULL AFTER `owner`;");
}
} catch (NumberFormatException e) {
}
} catch (SQLException e) {
pl.getLogger().log(Level.WARNING, "Couldn't create tables");
}
}
