GZz5x4Uy

1Error---------
2
3[16:47:22 WARN]: java.sql.SQLException: Can't create table `network`.`partys` (errno: 150 "Foreign key constraint is incorrectly formed")
4[16:47:22 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
5[16:47:22 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
6[16:47:22 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
7[16:47:22 WARN]:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
8[16:47:22 WARN]:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
9[16:47:22 WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
10[16:47:22 WARN]:        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
11[16:47:22 WARN]:        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
12[16:47:22 WARN]:        at net.qubik.Database.Database.initDB(Database.java:60)
13[16:47:22 WARN]:        at net.qubik.Database.Database.<init>(Database.java:32)
14[16:47:22 WARN]:        at net.qubik.main.Main.onEnable(Main.java:52)
15[16:47:22 WARN]:        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
16[16:47:22 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332)
17[16:47:22 WARN]:        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:407)
18[16:47:22 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:359)
19[16:47:22 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:318)
20[16:47:22 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.CraftServer.reload(CraftServer.java:769)
21[16:47:22 WARN]:        at org.bukkit.Bukkit.reload(Bukkit.java:556)
22[16:47:22 WARN]:        at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:25)
23[16:47:22 WARN]:        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:146)
24[16:47:22 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:666)
25[16:47:22 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:629)
26[16:47:22 WARN]:        at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:416)
27[16:47:22 WARN]:        at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:379)
28[16:47:22 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:713)
29[16:47:22 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:616)
30[16:47:22 WARN]:        at java.lang.Thread.run(Thread.java:748)
31
32
33SQL---------
34
35CREATE TABLE IF NOT EXISTS playercache(
36    id int unsigned NOT NULL AUTO_INCREMENT,
37    uuid char(36) NOT NULL,
38    name varchar(16) NOT NULL,
39    last_version smallint unsigned DEFAULT 47 NULL,
40
41    PRIMARY KEY (id)
42);
43
44CREATE TABLE IF NOT EXISTS playerstats(
45    id int unsigned NOT NULL,
46    registered boolean DEFAULT 0 NOT NULL,
47    coins bigint unsigned DEFAULT 500 NOT NULL,
48    playtime int unsigned DEFAULT 0 NOT NULL,
49    birthday date NULL,
50
51    PRIMARY KEY (id),
52    FOREIGN KEY (id) REFERENCES playercache(id)
53);
54
55CREATE TABLE IF NOT EXISTS skywarsstats(
56    id int unsigned NOT NULL,
57    kills int unsigned NOT NULL,
58    deaths int unsigned NOT NULL,
59    wins int unsigned NOT NULL,
60
61    PRIMARY KEY (id),
62    FOREIGN KEY (id) REFERENCES playercache(id)
63);
64
65CREATE TABLE IF NOT EXISTS friends(
66    player int unsigned NOT NULL,
67    friend int unsigned NOT NULL,
68
69    FOREIGN KEY (player) REFERENCES playercache(id),
70    FOREIGN KEY (friend) REFERENCES playercache(id)
71);
72
73CREATE TABLE IF NOT EXISTS friend_requests(
74    player int unsigned NOT NULL,
75    request int unsigned NOT NULL,
76
77    FOREIGN KEY (player) REFERENCES playercache(id),
78    FOREIGN KEY (request) REFERENCES playercache(id)
79);
80
81CREATE TABLE IF NOT EXISTS partys(
82    id int unsigned NOT NULL AUTO_INCREMENT,
83    leader varchar(16) NOT NULL,
84    public boolean NOT NULL,
85
86    PRIMARY KEY (id),
87    FOREIGN KEY (leader) REFERENCES playercache(name)
88);
89
90CREATE TABLE IF NOT EXISTS party_members(
91    party int unsigned NOT NULL,
92    player int unsigned NOT NULL,
93    level tinyint DEFAULT 0 NOT NULL,
94
95    FOREIGN KEY (party) REFERENCES partys(id),
96    FOREIGN KEY (player) REFERENCES playercache(id)
97);