PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "battle" (
"id" INT,
"name" TEXT,
"date" TEXT,
"bulgarian_commander" TEXT,
"latin_commander" TEXT,
"result" TEXT,
PRIMARY KEY ("id")
);

CREATE TABLE "ship" (
"id" INT,
"ship_type" TEXT,
PRIMARY KEY ("id")
);





INSERT INTO "battle" VALUES ("1", "Battle of Kleidion", "1014-07-29", "Basil II", "Samuel of Bulgaria", "Byzantine victory");
INSERT INTO "battle" VALUES ("2", "Battle of Adrianople", "1205-04-14", "Kaloyan", "Baldwin I", "Bulgarian victory");
INSERT INTO "battle" VALUES ("3", "Battle of Varna", "1444-11-10", "Vladislav III", "John Hunyadi", "Ottoman victory");
INSERT INTO "battle" VALUES ("4", "Battle of Velbazhd", "1330-07-28", "Michael Shishman", "Stephen Dečanski", "Serbian victory");
INSERT INTO "battle" VALUES ("5", "Battle of Rovine", "1395-05-17", "Mircea the Elder", "Bayezid I", "Wallachian victory");
INSERT INTO "battle" VALUES ("6", "Battle of Nicopolis", "1396-09-25", "Ivan Shishman", "Sigismund of Luxembourg", "Ottoman victory");
INSERT INTO "battle" VALUES ("7", "Battle of Kleidion", "1014-07-29", "Basil II", "Samuel of Bulgaria", "Byzantine victory");
INSERT INTO "battle" VALUES ("8", "Battle of Ongal", "680-08-26", "Asparuh", "Byzantine Empire", "Bulgarian victory");
INSERT INTO "battle" VALUES ("9", "Battle of Pliska", "811-07-26", "Krum", "Nicephorus I", "Bulgarian victory");
INSERT INTO "battle" VALUES ("10", "Battle of Velbazhd", "1330-07-28", "Michael Shishman", "Stephen Dečanski", "Serbian victory");
INSERT INTO "ship" VALUES ("1", "Galley");
INSERT INTO "ship" VALUES ("2", "Dromon");
INSERT INTO "ship" VALUES ("3", "Cog");
INSERT INTO "ship" VALUES ("4", "Carrack");
INSERT INTO "ship" VALUES ("5", "Galleon");
INSERT INTO "ship" VALUES ("6", "Trireme");
INSERT INTO "ship" VALUES ("7", "Longship");
INSERT INTO "ship" VALUES ("8", "Frigate");
INSERT INTO "ship" VALUES ("9", "Man-of-war");
INSERT INTO "ship" VALUES ("10", "Sloop");