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,
PRIMARY KEY ("id")
);

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





INSERT INTO "battle" VALUES ("1", "Battle of Midway");
INSERT INTO "battle" VALUES ("2", "Battle of the Atlantic");
INSERT INTO "battle" VALUES ("3", "Battle of Leyte Gulf");
INSERT INTO "battle" VALUES ("4", "Battle of Tsushima");
INSERT INTO "battle" VALUES ("5", "Battle of Jutland");
INSERT INTO "battle" VALUES ("6", "Battle of Trafalgar");
INSERT INTO "battle" VALUES ("7", "Battle of Coronel");
INSERT INTO "battle" VALUES ("8", "Battle of the River Plate");
INSERT INTO "ship" VALUES ("1", "USS Enterprise", "20000", "Aircraft Carrier", "Pacific Ocean");
INSERT INTO "ship" VALUES ("2", "Bismarck", "41700", "Battleship", "Atlantic Ocean");
INSERT INTO "ship" VALUES ("3", "Yamato", "72800", "Battleship", "Pacific Ocean");
INSERT INTO "ship" VALUES ("4", "HMS Hood", "48400", "Battlecruiser", "Atlantic Ocean");
INSERT INTO "ship" VALUES ("5", "USS Arizona", "32600", "Battleship", "Pacific Ocean");
INSERT INTO "ship" VALUES ("6", "HMS Victory", "3500", "Ship of the Line", "English Channel");
INSERT INTO "ship" VALUES ("7", "SMS Scharnhorst", "11600", "Armored Cruiser", "Pacific Ocean");
INSERT INTO "ship" VALUES ("8", "Admiral Graf Spee", "16000", "Pocket Battleship", "South Atlantic");
INSERT INTO "ship" VALUES ("9", "USS Missouri", "45000", "Battleship", "Pacific Ocean");
INSERT INTO "ship" VALUES ("10", "KMS Tirpitz", "42900", "Battleship", "Arctic Ocean");
INSERT INTO "ship" VALUES ("11", "HMS King George V", "38000", "Battleship", "Atlantic Ocean");
INSERT INTO "ship" VALUES ("12", "IJN Musashi", "72800", "Battleship", "Pacific Ocean");
INSERT INTO "ship" VALUES ("13", "USS Hornet", "20000", "Aircraft Carrier", "Pacific Ocean");
INSERT INTO "ship" VALUES ("14", "HMS Prince of Wales", "38000", "Battleship", "Pacific Ocean");
INSERT INTO "ship" VALUES ("15", "USS Lexington", "36000", "Aircraft Carrier", "Pacific Ocean");