CREATE TABLE "guild_wars" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"enemy_id" INTEGER NOT NULL,
"begin" INTEGER NOT NULL DEFAULT 0,
"end" INTEGER NOT NULL DEFAULT 0,
"frags" INTEGER NOT NULL DEFAULT 0,
"payment" INTEGER NOT NULL DEFAULT 0,
"guild_kills" INTEGER NOT NULL DEFAULT 0,
"enemy_kills" INTEGER NOT NULL DEFAULT 0,
"status" TINYINT(1) NOT NULL DEFAULT 0,
FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE,
FOREIGN KEY ("enemy_id") REFERENCES "guilds"("id") ON DELETE CASCADE
);