CREATE TABLE Country (
  countryName VARCHAR(50) PRIMARY KEY,
  currency VARCHAR(25),
  visa BOOLEAN
) ENGINE=INNODB;
CREATE TABLE Cities (
  cityName VARCHAR(50) PRIMARY KEY,
  country VARCHAR(50),
  FOREIGN KEY (country) REFERENCES Country(countryName)
) ENGINE=INNODB;
CREATE TABLE Sites (
  siteName VARCHAR(50) PRIMARY KEY,
  city VARCHAR(50),
  category VARCHAR(50),
  FOREIGN KEY (city) REFERENCES Cities(cityName)
) ENGINE=INNODB;
CREATE TABLE Users (
  name VARCHAR(50) PRIMARY KEY,
  email VARCHAR(50)
) ENGINE=INNODB;
CREATE TABLE Visits (
  user_name VARCHAR(50),
  site VARCHAR(50),
  rating INTEGER,
  FOREIGN KEY (site) REFERENCES Sites(siteName),
  FOREIGN KEY (user_name) REFERENCES Users(name)
) ENGINE=INNODB;
INSERT INTO Country VALUES ("Scotland", "Pound (£)", FALSE);
INSERT INTO Country VALUES ("Germany", "Euro (€)", FALSE);
INSERT INTO Country VALUES ("Netherlands", "Euro (€)", FALSE);
INSERT INTO Country VALUES ("Nebraska", "US Dollar ($)", TRUE);
INSERT INTO Country VALUES ("Japan", "Japanese Yen (¥)", TRUE);
INSERT INTO Cities VALUES ("Edinburgh", "Scotland");
INSERT INTO Cities VALUES ("Motherwell", "Scotland");
INSERT INTO Cities VALUES ("Berlin", "Germany");
INSERT INTO Cities VALUES ("Hamburg", "Germany");
INSERT INTO Cities VALUES ("Amsterdam", "Netherlands");
INSERT INTO Cities VALUES ("Haarlem", "Netherlands");
INSERT INTO Cities VALUES ("Lincoln", "Nebraska");
INSERT INTO Cities VALUES ("Omaha", "Nebraska");
INSERT INTO Cities VALUES ("Iga", "Japan");
INSERT INTO Cities VALUES ("Hiroshima", "Japan");
INSERT INTO Sites VALUES ("Edinburgh Science Museum", "Edinburgh", "Museum");
INSERT INTO Sites VALUES ("M&Ds", "Motherwell", "Amusement Park");
INSERT INTO Sites VALUES ("Brandenburg Gate", "Berlin", "Historical Site");
INSERT INTO Sites VALUES ("Parlament Restaurant", "Hamburg", "Food & Drink");
INSERT INTO Sites VALUES ("Anne Frank Museum", "Amsterdam", "Museum");
INSERT INTO Sites VALUES ("Bloemendaal Aan Zee Beach", "Haarlem", "Beach");

INSERT INTO Sites VALUES ("Nebraska State Capitol", "Lincoln", "Political Building");
INSERT INTO Sites VALUES ("Lauritzen Gardens/Kenefick Park", "Omaha", "Park");
INSERT INTO Sites VALUES ("The Mysterious Sonic Statue", "Iga", "Religious Landmark");
INSERT INTO Sites VALUES ("Hiroshima Peace Museum", "Hiroshima", "Museum");
INSERT INTO Users VALUES("Liam Sneddon", "liamsneddon@hotmail.com");
INSERT INTO Users VALUES("Alec Smith", "alecsmith@hotmail.com");
INSERT INTO Users VALUES("Sonic Hedge", "sonic@fast.com");
INSERT INTO Users VALUES("Absolute Legend", "69420@rocketmail.com");
INSERT INTO Users VALUES("Yee Haw", "cowboy@saloon.com");
INSERT INTO Visits VALUES("Liam Sneddon", "The Mysterious Sonic Statue", 5);
INSERT INTO Visits VALUES("Liam Sneddon", "M&Ds", 5);
INSERT INTO Visits VALUES("Liam Sneddon", "Brandenburg Gate", 3);
INSERT INTO Visits VALUES("Liam Sneddon", "Parlament Restaurant", 4);
INSERT INTO Visits VALUES("Alec Smith", "The Mysterious Sonic Statue", 5);
INSERT INTO Visits VALUES("Alec Smith", "Nebraska State Capitol", 2);
INSERT INTO Visits VALUES("Alec Smith", "Edinburgh Science Museum", 4);
INSERT INTO Visits VALUES("Alec Smith", "Bloemendaal Aan Zee Beach", 5);
INSERT INTO Visits VALUES("Sonic Hedge", "The Mysterious Sonic Statue", 5);
INSERT INTO Visits VALUES("Sonic Hedge", "Lauritzen Gardens/Kenefick Park", 2);
INSERT INTO Visits VALUES("Sonic Hedge", "M&Ds", 5);
INSERT INTO Visits VALUES("Sonic Hedge", "Hiroshima Peace Museum", 3);
INSERT INTO Visits VALUES("Absolute Legend", "The Mysterious Sonic Statue", 5);
INSERT INTO Visits VALUES("Absolute Legend", "Brandenburg Gate", 4);
INSERT INTO Visits VALUES("Absolute Legend", "Parlament Restaurant", 5);
INSERT INTO Visits VALUES("Absolute Legend", "Bloemendaal Aan Zee Beach", 5);
INSERT INTO Visits VALUES("Yee Haw", "The Mysterious Sonic Statue", 5);
INSERT INTO Visits VALUES("Yee Haw", "Nebraska State Capitol", 5);
INSERT INTO Visits VALUES("Yee Haw", "Lauritzen Gardens/Kenefick Park", 5);
INSERT INTO Visits VALUES("Yee Haw", "Edinburgh Science Museum", 1);