ALTER TABLE "guilds"
ADD ( "invited_to" INTEGER NOT NULL,
"invited_by" INTEGER NOT NULL,
"in_war_with" INTEGER NOT NULL,
"kills" INTEGER NOT NULL,
"show" TINYINT NOT NULL,
"war_time" INTEGER NOT NULL);
CREATE TABLE "deaths_in_wars" (
"guild_id" INTEGER NOT NULL,
"player_id" INTEGER NOT NULL,
"killer_guild" INTEGER NOT NULL,
"killer" INTEGER NOT NULL,
"date" INTEGER NOT NULL,
"result1" INTEGER NOT NULL,
"result2" INTEGER NOT NULL
);
UPDATE "guilds" SET "invited_to" = 0, "invited_by" = 0, "in_war_with" = 0, "kills" = 0, "show" = 0, "war_time" = 0 WHERE "id" > 0;